An statement causes postmaster to die - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject An statement causes postmaster to die
Date
Msg-id 200104221525.f3MFP8s99614@hub.org
Whole thread Raw
Responses Re: An statement causes postmaster to die
List pgsql-bugs
Sean Kelly (lists@shortestpath.org) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
An statement causes postmaster to die

Long Description
I am having a problem trying to run an update on my database. The SQL that causes the problem is listed below, as is
somedata from the tables used. 

The message I see is one of the following.  It's either:

Server process (pid 22322) exited with status 11 at Sun Apr 22 16:14:15 2001
Terminating any active server processes...
Server processes were terminated at Sun Apr 22 16:14:15 2001
Reinitializing shared memory and semaphores
DEBUG:  Data Base System is starting up at Sun Apr 22 16:14:15 2001
DEBUG:  Data Base System was interrupted being in production at Sun Apr 22 16:14:06 2001
DEBUG:  Data Base System is in production state at Sun Apr 22 16:14:15 2001

or

Server process (pid 22408) exited with status 11 at Sun Apr 22 16:18:05 2001
Terminating any active server processes...
NOTICE:  Message from PostgreSQL backend:
        The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.
        I have rolled back the current transaction and am going to terminate your database system connection and exit.
        Please reconnect to the database system and repeat your query.
NOTICE:  Message from PostgreSQL backend:
        The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.
        I have rolled back the current transaction and am going to terminate your database system connection and exit.
        Please reconnect to the database system and repeat your query.
Server processes were terminated at Sun Apr 22 16:18:05 2001
Reinitializing shared memory and semaphores
DEBUG:  Data Base System is starting up at Sun Apr 22 16:18:05 2001
DEBUG:  Data Base System was interrupted being in production at Sun Apr 22 16:14:15 2001
DEBUG:  Data Base System is in production state at Sun Apr 22 16:18:05 2001

I am running PostgreSQL 7.0.2 on Linux 2.2.16 using an Intel Celeron 333 and 128Mb RAM.

Sample Code
isp=> \d domain_tbl
         Table "domain_tbl"
 Attribute |    Type     | Modifier
-----------+-------------+----------
 domain    | varchar(80) | not null
 ident     | varchar(5)  | not null
 max_email | integer     | not null
 username  | varchar(10) | not null
 added     | timestamp   |
Indices: domain_tbl_ident_key,
         domain_tbl_pkey

isp=> SELECT * from domain_tbl where domain='test.domain';
   domain    | ident | max_email | username |         added
-------------+-------+-----------+----------+------------------------
 test.domain | test  |        10 | sean     | 2001-04-22 16:17:22+01
(1 row)

isp=> update domain_tbl set max_email='15' where domain='test.domain';
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.
!>

No file was uploaded with this report

pgsql-bugs by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: TCL error with rserv on Solaris
Next
From: Tom Lane
Date:
Subject: Re: An statement causes postmaster to die