pg_listener entries deleted under heavy NOTIFY loadonly on Windows
in [PgSql]
|
Prev: pgsql: In HS, Startup process sets SIGALRM whenwaiting for buffer pin.
Next: pg_listener entries deleted under heavy NOTIFY load only on Windows
From: Craig Ringer on 25 Jan 2010 05:42 On 23/01/2010 5:30 AM, Radu Ilie wrote: > On a Windows server under heavy load of NOTIFY events, entries in > pg_listener table for some events are deleted. It is like UNLISTEN was > called. This has been reported on -general, then -bugs, now -hackers, and seems to just get ignored. The poster has done a fair bit of research and has documented the issue, and fix, in a fair bit of depth. I don't have the access rights to do anything about it. Is someone who does going to look at it, or will it remain a lurking bug? (If this has since made it into cvs without any ML activity, then sorry - but I'm worried it'll get missed again and want to make sure it doesn't.) -- Craig Ringer -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Stefan Kaltenbrunner on 25 Jan 2010 07:37
Craig Ringer wrote: > On 23/01/2010 5:30 AM, Radu Ilie wrote: >> On a Windows server under heavy load of NOTIFY events, entries in >> pg_listener table for some events are deleted. It is like UNLISTEN was >> called. > > This has been reported on -general, then -bugs, now -hackers, and seems > to just get ignored. The poster has done a fair bit of research and has > documented the issue, and fix, in a fair bit of depth. > > I don't have the access rights to do anything about it. Is someone who > does going to look at it, or will it remain a lurking bug? > > (If this has since made it into cvs without any ML activity, then sorry > - but I'm worried it'll get missed again and want to make sure it doesn't.) well it is on the Open Items list for a while now: http://wiki.postgresql.org/wiki/PostgreSQL_8.5_Open_Items so I won't be forgotten... Stefan -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |