From: Steven M. Wheeler <swheeler@sabre.com>
To: pgsql-sql@hub.org
Subject: Fatal process interaction
Date: Mon, 24 May 1999 14:41:23 -0500
Message-ID: <3749AB63.44E3463F@sabre.com> (raw)
References: <199905140300.XAA39763@hub.org>
The situation:
In xterm #1: psql running, connected to database pssdb, executing an SQL select
statement.
In xterm #2: A shell script is run that pipes another select statement throug psql.
When the select statement in xterm #2 completes, the select statement being executed
in xterm #1 aborts and the following error message is output:
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.
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.
This problem is very repeatable and does not seem to depend on which UID is running
which session. They can both be postgres, or me (smw) or one of each. The one
common factor appears to be that psql is involved in both. If psql is run in
interactive mode in both windows, then \q is issued in one of the windows, both psql
sessions will terminate.
Any ideas?
--
Steven M. Wheeler
UNIX Engineering
The SABRE Group
(918) 292-4119
(918) 292-4165 FAX
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: swheeler@sabre.com, pgsql-sql@hub.org
Subject: Re: Fatal process interaction
In-Reply-To: <3749AB63.44E3463F@sabre.com>
References: <199905140300.XAA39763@hub.org> <3749AB63.44E3463F@sabre.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox