Обсуждение: Immediate shutdown causes the assertion failure in 9.4dev

Hi,

I encountered the following assertion failure when I executed
an immediate shutdown.

LOG:  received immediate shutdown request
WARNING:  terminating connection because of crash of another server process
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.
HINT:  In a moment you should be able to reconnect to the database and
repeat your command.
TRAP: FailedAssertion("!(CheckpointerPID == 0)", File: "postmaster.c",
Line: 3440)

The cause of this problem seems to be that PostmasterStateMachine()
may fail to wait for the checkpointer to exit. Attached patch fixes this.

Regards,

--
Fujii Masao

On Wed, Jul 31, 2013 at 1:26 PM, Fujii Masao <masao.fujii@gmail.com> wrote:
> I encountered the following assertion failure when I executed
> an immediate shutdown.
>
> LOG:  received immediate shutdown request
> WARNING:  terminating connection because of crash of another server process
> 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.
> HINT:  In a moment you should be able to reconnect to the database and
> repeat your command.
> TRAP: FailedAssertion("!(CheckpointerPID == 0)", File: "postmaster.c",
> Line: 3440)
>
> The cause of this problem seems to be that PostmasterStateMachine()
> may fail to wait for the checkpointer to exit. Attached patch fixes this.

What commit broke this?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Robert Haas escribió:
> On Wed, Jul 31, 2013 at 1:26 PM, Fujii Masao <masao.fujii@gmail.com> wrote:
> > I encountered the following assertion failure when I executed
> > an immediate shutdown.
> >
> > LOG:  received immediate shutdown request
> > WARNING:  terminating connection because of crash of another server process
> > 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.
> > HINT:  In a moment you should be able to reconnect to the database and
> > repeat your command.
> > TRAP: FailedAssertion("!(CheckpointerPID == 0)", File: "postmaster.c",
> > Line: 3440)
> >
> > The cause of this problem seems to be that PostmasterStateMachine()
> > may fail to wait for the checkpointer to exit. Attached patch fixes this.
> 
> What commit broke this?

The one that introduced SIGKILL in immediate-mode stop.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

On Thu, Aug 1, 2013 at 2:26 AM, Fujii Masao <masao.fujii@gmail.com> wrote:
> Hi,
>
> I encountered the following assertion failure when I executed
> an immediate shutdown.
>
> LOG:  received immediate shutdown request
> WARNING:  terminating connection because of crash of another server process
> 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.
> HINT:  In a moment you should be able to reconnect to the database and
> repeat your command.
> TRAP: FailedAssertion("!(CheckpointerPID == 0)", File: "postmaster.c",
> Line: 3440)
>
> The cause of this problem seems to be that PostmasterStateMachine()
> may fail to wait for the checkpointer to exit. Attached patch fixes this.

Committed.

Regards,

-- 
Fujii Masao

Fujii Masao escribió:
> On Thu, Aug 1, 2013 at 2:26 AM, Fujii Masao <masao.fujii@gmail.com> wrote:

> > TRAP: FailedAssertion("!(CheckpointerPID == 0)", File: "postmaster.c",
> > Line: 3440)
> >
> > The cause of this problem seems to be that PostmasterStateMachine()
> > may fail to wait for the checkpointer to exit. Attached patch fixes this.
> 
> Committed.

Thanks.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services