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

Re: BUG #5628: 9.0beta4 failed automatic crash recovery

From: Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5628: 9.0beta4 failed automatic crash recovery
Date: 2010-08-24 09:01:45
Message-ID: AANLkTinAN9enZskx0ix12qRkmMQ-M=m2s6YS4oZM_x4K@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Tue, Aug 24, 2010 at 5:25 PM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>> There might be issues to detach/reattach shared memory on Windows.
> We've seen this on and off before. Are you saying it's fully reproducible?
>
> I don't recall if we did any specific changes around this for 9.0, did we?

Yes, it is reproducible. I tested 8.3 and 8.4, and found 8.3 and newer
versions failed to recover.
  * 8.2,17 => OK
  * 8.3.11, 8.4.4, 9.0b4 => FAILED

Same error messages were logged on failed cases:
  FATAL:  pre-existing shared memory block is still in use
  HINT:  Check if there are any old server processes still running,
and terminate them.

Changes for the issue might be introduced between 8.2 and 8.3,
or in bugfixes only applied to 8.3 or newer versions.

-- 
Itagaki Takahiro

In response to

Responses

pgsql-bugs by date

Next:From: Magnus HaganderDate: 2010-08-24 09:08:48
Subject: Re: BUG #5628: 9.0beta4 failed automatic crash recovery
Previous:From: Magnus HaganderDate: 2010-08-24 08:25:52
Subject: Re: BUG #5628: 9.0beta4 failed automatic crash recovery

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