Обсуждение: pqReadData() -- backend closed on COPY

Поиск
Список
Период
Сортировка

pqReadData() -- backend closed on COPY

От
"Clinton James"
Дата:
I decided we needed to change from a P100Mz to a nice P3 800 Mz running RH
7.1. Compiled 7.1.2 with g++ version 2.96 and all the regression tests came
out fine.

When trying to copy data I get the following message.

pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

Can anyone point me in the direction for fixing this? I'm not even sure what
is causing this.

Clinton
Following is the table, COPY statement and the file.

create table ldTraffic (
  billmonth CHAR(4),
  cust_num  CHAR(8),
  location  CHAR(4),
  date      TIMESTAMP,
  orignum   CHAR(10),
  destnum   CHAR(10),
  destcity  CHAR(10),
  deststate CHAR(2),
  duration  NUMERIC(8,1),
  callcode  CHAR(9),
  cost      NUMERIC(10,4)
);

COPY ldTraffic FROM '/usr/local/apps/callDetail/import.head';

-----start import.head-----
0105    10102806    0001    20010328 12:25    0000841001    0001234567    SACRAMENTO    CA    0.6
000000000        0.0500
0105    10102806    0001    20010411 17:27    0000841001    0001234567    MT VIEW       CA    0.7
000000000        0.0500
0105    10102806    0001    20010402 13:41    0000841287    0001234567    MT VIEW       CA    0.7
000000000        0.0500
0105    10102806    0001    20010402 13:43    0000841287    0001234567    DENVER        CO    0.9
000000000        0.0700
0105    10102806    0001    20010403 11:00    0000841287    0001234567    PLEASANTON    CA    1.0
000000000        0.0700
0105    10102806    0001    20010411 16:48    0000841287    0001234567    ROCKVL CTR    NY    1.1
000000000        0.0800
0105    10102806    0001    20010411 16:51    0000841287    0001234567    ATLANTA       GA    0.7
000000000        0.0500
0105    10102806    0001    20010411 16:53    0000841287    0001234567    KENOSHA       WI    0.4
000000000        0.0300
0105    10102806    0001    20010411 16:55    0000841287    0001234567    LEAGUECITY    TX    0.8
000000000        0.0600
0105    10102806    0001    20010411 16:57    0000841287    0001234567    GREEN BAY     WI    0.8
000000000        0.0600
-----end import.head-----

RE: pqReadData() -- backend closed on COPY

От
"Clinton James"
Дата:
It looks like the tabs were changed as I sent the file.  Either think of
each | as a tab, or use the DELIMITERS '|' on the COPY command.

Clinton
-----start import.head-----
0105|10102806|0001|20010328|12:25|0000841001|0001234567|SACRAMENTO|CA|0.6|00
0000000|0.0500
0105|10102806|0001|20010411|17:27|0000841001|0001234567|MT
VIEW|CA|0.7|000000000|0.0500
0105|10102806|0001|20010402|13:41|0000841287|0001234567|MT
VIEW|CA|0.7|000000000|0.0500
0105|10102806|0001|20010402|13:43|0000841287|0001234567|DENVER|CO|0.9|000000
000|0.0700
0105|10102806|0001|20010403|11:00|0000841287|0001234567|PLEASANTON|CA|1.0|00
0000000|0.0700
0105|10102806|0001|20010411|16:48|0000841287|0001234567|ROCKVL
CTR|NY|1.1|000000000|0.0800
0105|10102806|0001|20010411|16:51|0000841287|0001234567|ATLANTA|GA|0.7|00000
0000|0.0500
0105|10102806|0001|20010411|16:53|0000841287|0001234567|KENOSHA|WI|0.4|00000
0000|0.0300
0105|10102806|0001|20010411|16:55|0000841287|0001234567|LEAGUECITY|TX|0.8|00
0000000|0.0600
0105|10102806|0001|20010411|16:57|0000841287|0001234567|GREEN
BAY|WI|0.8|000000000|0.0600
-----end import.head-----

Re: pqReadData() -- backend closed on COPY

От
Tom Lane
Дата:
"Clinton James" <cjames@callone.net> writes:
> When trying to copy data I get the following message.
> pqReadData() -- backend closed the channel unexpectedly.

> Can anyone point me in the direction for fixing this?

A debugger backtrace from the backend core dump would be a good start.
You might have to compile with -g to get a useful backtrace.

            regards, tom lane