The following bug has been logged on the website:
Bug reference: 7597
Logged by: Bo T Jensen
Email address: bo@budget123.dk
PostgreSQL version: 9.1.6
Operating system: windows 7 home premium 64
Description: =
Ive managed to boil this down to a repeatable example on a test setup, but
it was found originally on windows server 2008 (64 bit).
pg_log:
2012-10-11 11:29:49 CEST LOG: server process (PID 4400) was terminated by
exception 0xC0000005
2012-10-11 11:29:49 CEST HINT: See C include file "ntstatus.h" for a
description of the hexadecimal value.
2012-10-11 11:29:49 CEST LOG: terminating any other active server
processes
2012-10-11 11:29:49 CEST WARNING: terminating connection because of crash
of another server process
2012-10-11 11:29:49 CEST DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2012-10-11 11:29:49 CEST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2012-10-11 11:29:49 CEST WARNING: terminating connection because of crash
of another server process
2012-10-11 11:29:49 CEST DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2012-10-11 11:29:49 CEST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2012-10-11 11:29:49 CEST LOG: all server processes terminated;
reinitializing
2012-10-11 11:29:59 CEST FATAL: pre-existing shared memory block is still
in use
2012-10-11 11:29:59 CEST HINT: Check if there are any old server processes
still running, and terminate them.
Offending sql looks like this:
select 1 from reference
where username =3D 'user1'
and (refid, '127.0.0.1', 'manager1') not in (select refid, ip, manager from
loguser);
Kind regards
Bo T Jensen