BUG #2419: could not reattach to shared memory

From: "Andy Male" <andy(at)ubic(dot)co(dot)uk>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2419: could not reattach to shared memory
Date: 2006-05-03 08:41:41
Message-ID: 200605030841.k438ffH2070103@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2419
Logged by: Andy Male
Email address: andy(at)ubic(dot)co(dot)uk
PostgreSQL version: 8.1
Operating system: Windows 2003 Server (standard) SP1
Description: could not reattach to shared memory
Details:

FULL ERROR IN WINDOWS EVENT LOG -

The description for Event ID ( 0 ) in Source ( PostgreSQL ) cannot be found.
The local computer may not have the necessary registry information or
message DLL files to display messages from a remote computer. You may be
able to use the /AUXSOURCE= flag to retrieve this description; see Help and
Support for details. The following information is part of the event: FATAL:
could not reattach to shared memory (key=5432001, addr=01960000): Invalid
argument

There is no correspondng error in pg_log.

Once the error happens the database become unreponsive, current connections
stop responding and you cannot make new connections. Stopping and starting
the database removes the error and normal operation can continue.

The error happens intermittently (three or four times a day) and doesn't
seem to have a specific cause. The database is not heavily used and is
processing around 100 transactions per minute.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Warren Seltzer 2006-05-03 14:18:01 Insert failure on serial
Previous Message Bruno Wolff III 2006-05-03 00:11:00 Re: BUG #2418: number & date & time