Re: Relation 0 does not exist - Mailing list pgsql-general

From Tom Lane
Subject Re: Relation 0 does not exist
Date
Msg-id 28871.1032993987@sss.pgh.pa.us
Whole thread Raw
In response to Re: Relation 0 does not exist  (Patrick Welche <prlw1@newn.cam.ac.uk>)
Responses Re: Relation 0 does not exist  (Patrick Welche <prlw1@newn.cam.ac.uk>)
List pgsql-general
Patrick Welche <prlw1@newn.cam.ac.uk> writes:
>> (Now postmaster won't shutdown pg_ctl: postmaster does not shut down)

> It's stuck in ServerLoop () at postmaster.c:949
> (gdb) print rmask
> $1 = {fds_bits = {8, 0, 0, 0, 0, 0, 0, 0}}
> (gdb) print wmask
> $2 = {fds_bits = {0, 0, 0, 0, 0, 0, 0, 0}}
> (gdb) print timeout
> $3 = {tv_sec = 60, tv_usec = 0}

That's about what I'd expect it to be doing.  The final decision to exit
would normally be made when we see the shutdown process exit (about
line 1587 in postmaster.c).  What are the contents of ShutdownPID,
CheckPointPID, Shutdown, and FatalError?  Are there any remaining child
processes of the postmaster?

> Remembers Tip 1: Don't kill -9 the postmaster... Hmm 2 and 15 don't do anything..

That tip is pretty obsolete, but before you pull the trigger it would be
nice to try to learn more.  I wonder if you have hit some obscure race
condition that prevents the postmaster from realizing it's done?

            regards, tom lane

pgsql-general by date:

Previous
From: Patrick Welche
Date:
Subject: Re: Relation 0 does not exist
Next
From: Patrick Welche
Date:
Subject: Re: Relation 0 does not exist