Re: Notify system doesn't recover from "No space" error
Kevin Grittner <kevin.grittner@wicourts.gov>
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: <pgsql-hackers@postgresql.org>
Date: 2012-02-09T18:43:37Z
Lists: pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> wrote: > In continued digging through logs I found something to indicate > the transaction on which COMMIT failed for 2528 of the failures. > In all cases the transaction made a change which would have fired > a NOTIFY at commit (in a deferred trigger). Arg. Sorry, I got confused there. No deferred trigger involved in the triggered change notification; that is only in the replication code. I haven't seen anything to suggest that the replication trigger is contributing to this, but I guess I couldn't rule it out, either. -Kevin