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-----
