Skip site navigation (1) Skip section navigation (2)

Re: BUG #3504: Some listening sessions never return from writing, problems ensue

From: "Peter Koczan" <pjkoczan(at)gmail(dot)com>
To: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
Cc: tomas(at)tuxteam(dot)de, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3504: Some listening sessions never return from writing, problems ensue
Date: 2007-08-27 22:16:05
Message-ID: 4544e0330708271516k4e200a97hfaead1b12d37818d@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
> Please share the ending with us, I'm really curious after following this
> thread :).

It turns out that it was part DBD::Pg and part our app (a big part). A
plugin for the app creates a separate db handle which listens, but
never does anything with the notifications. Apparently, the recv-q
cleared whenever a request was made via this plugin (which is rare for
most people who use this), but nothing was processed, so notifications
would build up. If they're left running for that long, then they get
into the bad state.

We fixed our app to not have the plugin's db handle listen (it was
pointless to have it listen anyway) and all seems well.

While it may technically be a bug that a database handle will get into
this state after ~800 unprocessed notifications, I'd say that's much
more the fault of the application programmers.

Anyway, thanks for all your help.

Peter

In response to

pgsql-bugs by date

Next:From: VovaDate: 2007-08-28 13:26:54
Subject: BUG #3583: IMPORT/EXPORT into PostgreSQL
Previous:From: Tom LaneDate: 2007-08-27 22:13:43
Subject: Re: BUG #3582: CREATE USER via ODBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group