Postmaster crashes periodically

From: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
To: PostgreSQL-general <pgsql-general(at)postgresql(dot)org>
Subject: Postmaster crashes periodically
Date: 2000-10-11 01:28:00
Message-ID: 3.0.5.32.20001011112800.02963ba0@mail.rhyme.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Probably once per week or so I get a message like:

Server process (pid 12243) exited with status 11 at Tue Oct 10 01:20:01
2000
Terminating any active server processes...

Followed by one of these for each backend:

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.

I'd be interested in any hints as to how to track this down since I can't
seem to find any core files etc. This is under Linux 2.2.10 & PG 7.0.2. I'm
tempted to start using one postmaster per database (with different ports)
just so I can insulate each database from the others and see if there is a
specific database causing the problem.

----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Haberlach 2000-10-11 02:06:47 Re: Re: [HACKERS] My new job
Previous Message Lamar Owen 2000-10-11 01:05:34 Re: Re: [HACKERS] My new job