Обсуждение: 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