Thread: BUG #1184: listeners not cleaned on crash

BUG #1184: listeners not cleaned on crash

From
"PostgreSQL Bugs List"
Date:
The following bug has been logged online:

Bug reference:      1184
Logged by:          Radim Kolar

Email address:      hsn@netmag.cz

PostgreSQL version: 7.4

Operating system:   Freebsd 5.2.1

Description:        listeners not cleaned on crash

Details:

When postgres sql 7.4.1
 * crashes
 * shutdown immediate
 * kernel panics

After recovery, there are stalled entries in system catalogs which must
be removed by
delete from pg_catalog.pg_listener;

This is a very annoying bug if you are running slony1 replication system.

Radim Kolar

Re: BUG #1184: listeners not cleaned on crash

From
Tom Lane
Date:
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> Description:        listeners not cleaned on crash

This is a deficiency, without doubt, but it's always seemed like a
mighty low-priority one to me.  There already is a provision for
deleting entries when they are found not to refer to any existing
process, so the odds of actually sending a mistaken notify seem low.

> This is a very annoying bug if you are running slony1 replication system.

If slony reacts badly to an extra notification then I think that's a
slony problem more than anything else.  It shouldn't be that fragile.

            regards, tom lane