Re: how can i bugfix "idle in transaction" lockups ? - Mailing list pgsql-general

From Merlin Moncure
Subject Re: how can i bugfix "idle in transaction" lockups ?
Date
Msg-id AANLkTinRsMndHXbczP5oUiRgUF_EXi+mhgK+4kqEoMAS@mail.gmail.com
Whole thread Raw
In response to Re: how can i bugfix "idle in transaction" lockups ?  (Jonathan Vanasco <postgres@2xlp.com>)
List pgsql-general
On Fri, Dec 3, 2010 at 12:31 AM, Jonathan Vanasco <postgres@2xlp.com> wrote:
> begin w/o commit or rollback?
>
> and thanks. you've been very helpful!
>
> On Nov 30, 2010, at 2:21 PM, Merlin Moncure wrote:
>
>> Begin w/o commit is a grave application error and you should
>> consider reworking your code base so that it doesn't happen (ever).

meaning, you opened a transaction (with 'begin') and didn't close it
with 'commit' (or 'start/end' etc).  You opened a transaction but
didn't close it.  Don't ever do this, and don't ever leave a
transaction open waiting on indeterminate events, like user input.

merlin

pgsql-general by date:

Previous
From: Brar Piening
Date:
Subject: Re: "could not accept SSPI security context"
Next
From: "James B. Byrne"
Date:
Subject: Re: PG84 and SELinux