From: | "George Pavlov" <gpavlov(at)mynewplace(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Postgres General" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [QUARANTINE] Re: PG service restart failure (start getting ahead of stop?) |
Date: | 2007-04-24 22:03:12 |
Message-ID: | 8C5B026B51B6854CBE88121DBF097A86B1EF3D@ehost010-33.exch010.intermedia.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Well, that makes sense: if the shutdown took more than a
> minute then the
> "stop" script action would give up waiting, and then the
> "start" action
> would see the postmaster running and go away happy. (It's a bit odd
> that "service start" actions are supposed to treat "already running"
> as OK, but I've been told that that's required by the Linux Standards
> Base and I can't change it.)
thanks, that's good to know. i never realized that's how it behaves.
> The real question here is why'd it take so long to stop? It should be
> using "mode fast" which'd kick out active queries.
indeed a mystery -- from looking at the query log there didn't seem to
be ANY active queries at the time. seems that > 85% of the session IDs
(84 total) for which i got lines like "2007-04-23 03:05:48 PDT [26987]
FATAL: the database system is shutting down" did not even have any
preceding query activity. hard to debug retroactively -- it's just
annoying that i don't understand what was different about this restart.
and, yes, i confirmed that it is using fast mode:
212 $SU -l postgres -c "$PGENGINE/pg_ctl stop -D '$PGDATA' -s -m
fast" > /dev/null 2>&1 < /dev/null
george
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Goldner | 2007-04-24 22:21:33 | Additional debugging of idle sessions? |
Previous Message | finecur | 2007-04-24 21:19:05 | query from a list of ids |