Re: Relation 0 does not exist

On Wed, Sep 25, 2002 at 06:46:27PM -0400, Tom Lane wrote:
...
> 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?

(gdb) print ShutdownPID
$1 = 0
(gdb) print CheckPointPID
$2 = 0
(gdb) print Shutdown
$3 = 2
(gdb) print FatalError
$4 = 0 '\000'

> Are there any remaining child
> processes of the postmaster?

# ps ax | grep post
10828 p3 S+ 0:00.04 postmaster -o -W 15 -d4 (postgres)
10829 p3 S+ 0:00.00 postmaster: stats buffer process (postgres)
10831 p3 S+ 0:00.01 postmaster: stats collector process (postgres)
11387 p5 D+ 0:00.00 grep post
11360 p9 SW+ 0:00.00 vi postmaster.c

> 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?

? Nothing else was going on... Now I'm hammering the box looking for the
constraint in the 3.3Gb dump file, so swap is a bit low.

Cheers,

Patrick