Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group