Re: Notify system doesn't recover from "No space" error - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Notify system doesn't recover from "No space" error
Date
Msg-id 13247.1328811767@sss.pgh.pa.us
Whole thread Raw
In response to Re: Notify system doesn't recover from "No space" error  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Notify system doesn't recover from "No space" error  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> The application LISTENs on channel tcn and a trigger function is
> attached to most permanent tables to NOTIFY for DML on that channel.
> ...
> The report to us was that testers were unable to start the
> application.  I believe that the above error on COMMIT kept the
> application from getting past initial tests that the connection was
> good.

OK, so it was issuing a LISTEN and the LISTEN was failing at commit?
(It's a bit hard to believe that you'd be triggering one of the NOTIFYs
during "initial connection tests".)
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Notify system doesn't recover from "No space" error
Next
From: Alvaro Herrera
Date:
Subject: Re: [COMMITTERS] pgsql: Add new keywords SNAPSHOT and TYPES to the keyword list in gram.