Re: PostgreSQL crashes with Qmail-SQL

Stephan Szabo <sszabo@megazone23.bigpanda.com>

From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Michael Devogelaere <michael@digibel.be>
Cc: Justin Clift <justin@postgresql.org>, PostgreSQL Hackers Mailing List <pgsql-hackers@postgresql.org>
Date: 2002-01-25T16:50:56Z
Lists: pgsql-hackers
On Fri, 25 Jan 2002, Michael Devogelaere wrote:

> Hello again,
>
> I've rerun the tests and got:
> 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.
>
> Nothing showed up in the logs however. This time i aborted the test after the
> first errormessages and could reconnect to the database ! I don't know if this
> has to do with the number of <defunct> postmasters: there only showed up 2 now
> and not a few screens as in the first crash. When typing 'ps aux' a few minutes
> later they were all gone !

Hmm, did you get any core files in the database directory?
And since I don't know what the test does and I'm not sure if locale is
enabled in the default red hat package, as a low probability thing, you do
have a version of glibc >= 2.2.3?

As a side question, how far do you need to install qmail to use the test?
I'd gotten the test files to run against a 7.1 server I set up, but didn't
feel comfortable doing a full install of qmail if possible.