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

BUG #1184: listeners not cleaned on crash

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1184: listeners not cleaned on crash
Date: 2004-06-27 15:40:50
Message-ID: 20040627154050.A3C53CF4D10@www.postgresql.com (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1184
Logged by:          Radim Kolar

Email address:      hsn(at)netmag(dot)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 



Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-06-27 22:07:44
Subject: Re: BUG #1184: listeners not cleaned on crash
Previous:From: Michael MeskesDate: 2004-06-27 12:30:18
Subject: Re: ECPG doesn't return the correct length for an empty

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