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 %t LOG: could not receive data from client: Unknown winsock error 10061 %t LOG: unexpected EOF on client connection In these cases their .NET app returns this error Exception of type 'System.OutOfMemoryException' was thrown I've seen errors like this in the PostgreSQL threads and some suggestion that this may be a bug and that there is a patch for it. I was thinking of upgrading them to 8.3.7 but don't see any mention of this in the release notes to know if 8.3.7 will fix this. I'm going to test their queries outside of their application to rule out the application and their query as culprits. Thanks, Regina -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
