The following bug has been logged online:

Bug reference:      5628
Logged by:          Itagaki Takahiro
Email address:      itagaki.takah...@gmail.com
PostgreSQL version: 9.0b4 (32bit)
Operating system:   Windows 7 (64bit)
Description:        9.0beta4 failed automatic crash recovery
Details: 

9.0beta4 seems to fail automatic crash recovery after
some of backend processes crashed, though 8.2 succeeded
to recover. This is a rare error case, but some logic
for shared memory might be broken between versions.

I crashed a backend as a test manually with "pg_ctl kill":
  pg_ctl kill QUIT <backend-pid>

9.0 server has gone with the following logs:
----
WARNING:  terminating connection because of crash of another server process
...
LOG:  all server processes terminated; reinitializing
FATAL:  pre-existing shared memory block is still in use
HINT:  Check if there are any old server processes still running, and
terminate them.
----

But 8.2 can recover as expected:
----
WARNING:  terminating connection because of crash of another server process
...
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted at <timestamp>
----

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to