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

Re: BUG #5007: could not reattach to shared memory

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Regina <lr(at)pcorp(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5007: could not reattach to shared memory
Date: 2009-08-25 05:55:40
Message-ID: 1251179740.28403.4.camel@wallace.localnet (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
On Tue, 2009-08-25 at 05:44 +0000, Regina wrote:
> The following bug has been logged online:
> Bug reference:      5007
> Logged by:          Regina
> Email address:      lr(at)pcorp(dot)us
> PostgreSQL version: 8.3.6
> Operating system:   Windows 2008 Server Standard
> Description:        could not reattach to shared memory
> Details: 
> One of our clients is getting the following error in their PostgreSQL 8.3.6
> logs in their ASP.NET application.  This only happens if their application
> runs a long query (which they dump out to disk and disk size (ESRI
> shapefiles) is generally above 70 mb or more) when this fails.
> The error is below:
> FATAL:  could not reattach to shared memory (key=232, addr=01DF0000): 487
> %t WARNING:  worker took too long to start; cancelled

Search the -general mailing list archives for "reattach to shared
memory". The issue has been around for a while but until recently nobody
could reproduce it well enough to isolate it and test possible fixed.
You'll see some recent discussion and a proposed patch.

Try upgrading to the latest version in the 8.3 series. If you still see
the problem please follow up here, or try the patch for the issuye
proposed on the pgsql-general list.

> In these cases their .NET app returns this error
> Exception of type 'System.OutOfMemoryException' was thrown

That's probably a bug in their application caused by failure to properly
handle a connection problem.

Craig Ringer

In response to


pgsql-bugs by date

Next:From: Jalaj NegiDate: 2009-08-25 06:11:45
Subject: BUG #5008: Server Startup Problem - When server is configured for SSL
Previous:From: ReginaDate: 2009-08-25 05:44:16
Subject: BUG #5007: could not reattach to shared memory

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