backend dies suddenly after a lot of error messages

From: Mirko Kaffka <mirko(at)interface-business(dot)de>
To: pgsql-general(at)postgreSQL(dot)org
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgreSQL(dot)org>
Subject: backend dies suddenly after a lot of error messages
Date: 1999-05-12 10:48:29
Message-ID: Pine.GSO.3.96.990512124217.12545A-100000@taifun.interface-business.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi,

We have problems with backend processes that close the channel because of
palloc() failures. When an INSERT statement fails, the backend reports an
error (e.g. `Cannot insert a duplicate key into a unique index') and
allocates a few bytes more memory. The next SQL statement that fails
causes the backend to allocate more memory again, etc. until we have no
more virtual memory left. Is this a bug?
We are using postgres 6.4.2 on FreeBSD 2.2.8.

It also works with psql:

toy=> create table mytable (i integer unique);
NOTICE: CREATE TABLE/UNIQUE will create implicit index mytable_i_key for
table mytable
CREATE
toy=> \q

~ $ # now do a lot of inserts that cause error messages:
~ $ while true; do echo "INSERT INTO mytable VALUES (1);"; done | psql toy
INSERT INTO mytable VALUES (1);
ERROR: Cannot insert a duplicate key into a unique index
...quite a lot of these messages
INSERT INTO mytable VALUES (1);
ERROR: Cannot insert a duplicate key into a unique index
INSERT INTO mytable VALUES (1);

pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally before or
while processing the request.
We have lost the connection to the backend, so further processing is
impossible. Terminating.

Hmm, why does the backend allocate more and more memory with each failed
INSERT ?
Any clues?

Thanks,
Mirko

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Reinke 1999-05-12 11:28:17 Re: [GENERAL] backend dies suddenly after a lot of error messages
Previous Message Blake Starkenburg 1999-05-12 04:44:00

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 1999-05-12 11:13:08 Re: [HACKERS] More on GROUP BY
Previous Message Jan Wieck 1999-05-12 10:37:24 Re: [HACKERS] Re: [SQL] plpgsql error