Skip site navigation (1) Skip section navigation (2)

pqReadData() error

From: Alex Guryanow <gav(at)nlr(dot)ru>
To: pgsql-general(at)postgreSQL(dot)org
Cc: pgsql-bugs(at)postgreSQL(dot)org
Subject: pqReadData() error
Date: 2000-01-26 10:24:21
Message-ID: 18558.000126@nlr.ru (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-general
Hi,

during execution of block of commands like

BEGIN
INSERT INTO...
INSERT INTO...
.....
INSERT INTO...
COMMIT

sometimes receive the error

pqReadData() -- backend closed the channel unexpectedly.
       This probably means the backend terminated abnormally
       before or while processing the request.   

3 last lines in postmaster's log are:

ERROR:  Cannot insert a duplicate key into a unique index
ERROR:  Cannot insert a duplicate key into a unique index
FATAL 1:  my bits moved right off the end of the world!

Between BEGIN-COMMIT the program (written in C) makes 100 to 50000
INSERTs.
In the database I have two tables, say t1 and t2. Table t1 has an
unique index and two first lines from the error-messages above are
when the program tryis to make INSERT duplicate rows. But the error
pqReadData() I recieve when try to insert into the second table t2. It
hasn't the unique index.

My configurations is: postgresql 6.5.3 , RedHat 6.1 on Intel-based
server, RAM 256 Mb, swap 256 Mb, HDD 2x9Gb.

Best regards,
Alex



pgsql-bugs by date

Next:From: Sarah OfficerDate: 2000-01-26 22:14:08
Subject: psql bug?
Previous:From: Yury DonDate: 2000-01-26 06:05:42
Subject:

pgsql-general by date

Next:From: J. RoeleveldDate: 2000-01-26 10:36:52
Subject: Re: [GENERAL]COPY still running
Previous:From: Arnaud FLORENTDate: 2000-01-26 10:05:03
Subject: Re: [GENERAL]COPY still running

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group