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: l...@pcorp.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
