Re: 'startup waiting' status message - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 'startup waiting' status message
Date
Msg-id 9384.1154922823@sss.pgh.pa.us
Whole thread Raw
In response to 'startup waiting' status message  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-hackers
"Jim C. Nasby" <jnasby@pervasive.com> writes:
> postgres  2038  0.0  0.2 19628 3328 ?        S    15:04   0:00 postgres:
> aspadmin test 192.168.100.7(34223) startup waiting

> I've grepped through the source code (grep -ri startup src|grep -i
> waiting) and can't find this anywhere...

You wouldn't, because that's a composite of two messages: we are waiting
for some lock while still in startup mode.  A reasonable bet is that
someone's got a more-or-less-exclusive lock on one of the system
catalogs that startup needs to read.  The contents of pg_locks would
help, if this state persists long enough to investigate ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: LWLock statistics collector
Next
From: ITAGAKI Takahiro
Date:
Subject: Re: CSStorm occurred again by postgreSQL8.2