From: | Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: postgres process got stuck in "notify interrupt waiting" status |
Date: | 2012-09-05 02:09:07 |
Message-ID: | CA+jMWocSn3ApEbdD8nV7jo-cXAynxGfa2vOm6v-ocSy8Y2ZFfQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
BTW, after I signalled TERM, the process status changed from
notify interrupt waiting
to
notify interrupt waiting waiting
which I thought looked kind of odd.
Then I signalled KILL.
Aleksey
On Tue, Sep 4, 2012 at 6:21 PM, Aleksey Tsalolikhin
<atsaloli(dot)tech(at)gmail(dot)com> wrote:
> Hi.
>
> We use LISTEN/NOTIFY quite a bit but today something unusual (bad) happened.
>
> Number of processes waiting for a lock just started to go up up up.
>
> I finally found the object being locked was pg_listener which
> RhodiumToad on IRC kindly informed happens during LISTEN/NOTIFY. The
> process that had the lock (in pg_locks it had granted = t ) was shown
> by ps in status "notify interrupt waiting" and has had the lock for
> over half an hour. (Usually these notifications are very quick.)
>
> the process would not respond to kill, so I kill -9'ed
>
> The only reference I could find to a similar problem was at
> http://archives.postgresql.org/pgsql-performance/2008-02/msg00345.php
> which seemed to indicate a process should not be in this state for
> very long.
>
> We are on postgres 8.4.12.
>
> I'd like to figure out what happened.
>
> There is a web server that talks to this database server (amongst
> other clients), and the client addr and port mapped to this web
> server, but there was no process on the web server matching the port
> number. that's when I decided to kill the postgres process.
>
> Anything I should know or read up on? Any suggestions?
>
> I'd like the system to be able to recover, and for the process to
> terminate if the client is no longer around.
>
> Best,
> Aleksey
--
Upcoming Trainings:
"Editing with vi" 31 Aug 2012 at LinuxCon North America in San Diego,
CA (http://lcna2012.sched.org/speaker/alekseytsalolikhin)
"Time Management for System Administrators" 28 Sep 2012 at Ohio Linux
Fest (http://ohiolinux.org/register)
"Editing with vi" 28 Sep 2012 at Ohio Linux Fest (http://ohiolinux.org/register)
"Automating System Administration with CFEngine 3" 22-25 Oct 2012 in
Palo Alto, CA (http://www.eventbrite.com/event/3388161081)
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Travers | 2012-09-05 02:14:28 | Re: "Too far out of the mainstream" |
Previous Message | David Johnston | 2012-09-05 01:58:40 | Re: regexp_matches question |