PostgreSQL Bugs - Re: BUG #2033: Assertion Failure: File: "procarray.c",

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: BUG #2033: Assertion Failure: File: "procarray.c",

Joel Stevenson

2005-11-09, 8:24 pm

At 4:09 PM -0500 11/9/05, Tom Lane wrote:
>Joel Stevenson <joelstevenson@mac.com> writes:
>
>BTW, I imagine that the apparent correlation to NOWAIT is occurring
>because your client-side code was not checking to see if the NOWAIT
>query had failed before trying to launch another query in the same
>transaction.

That is indeed what the code was doing. I'd added NOWAIT to the
SELECT statement and was catching the error that was being thrown
from the NOWAIT behavior, but didn't think that the error would
invalidate the current transaction (which was not a prepared
transaction.) The fact that it does kill the transaction makes
perfect sense. I'd been thinking of NOWAIT all wrong: as a "return
on block", but it's an "error on block".

Thanks again, Tom.

-Joel

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Sponsored Links