Skip site navigation (1) Skip section navigation (2)

Re: Unable to commit: transaction marked for rollback

From: David Kerr <dmk(at)mr-paradox(dot)net>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Unable to commit: transaction marked for rollback
Date: 2010-07-01 21:20:04
Message-ID: 4C2D0684.9040307@mr-paradox.net (view raw or flat)
Thread:
Lists: pgsql-jdbc
On 7/1/2010 2:08 PM, Kevin Grittner wrote:
> David Kerr<dmk(at)mr-paradox(dot)net>  wrote:
>
>>> Have you checked the PostgreSQL log file for clues?  If you're
>>> not seeing what you need, you could tweak the logging to show
>>> more.
>>
>> We're trying that, it's (of course) intermittent and happens after
>> like 5 hours. so huge logfiles, etc as usual. With
>> log_statements=none turned on PG logs database errors. so it seems
>> like whatever's happening isn't being considered an "error". more
>> of a natural database transaction (like a lock) or something. does
>> that sound about right?
>
> Hmmm....  I was just guessing at the cause.  With default logging,
> if I do this:
>
> test=# begin;
> BEGIN
> test=# select foo;
> ERROR:  column "foo" does not exist
> LINE 1: select foo;
>                 ^
> test=# select 'foo';
> ERROR:  current transaction is aborted, commands ignored until end
> of transaction block
> test=# commit;
> ROLLBACK
>
> I see this in the log:
>
> ERROR:  column "foo" does not exist at character 8
> STATEMENT:  select foo;
> ERROR:  current transaction is aborted, commands ignored until end
> of transaction block
> STATEMENT:  select 'foo';
>
> If you aren't seeing something like that, I'm probably off-base in
> my guess at the cause.  Nothing else leaps to mind, unfortunately.
> :-(
>
> -Kevin
>

Yeah nothing at all in the logs (literally, zero log events while the 
process runs with default logging). that's why i'm leaning towards 
something in the app. or maybe the XA driver.

thanks!

Dave

In response to

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2010-07-02 01:15:23
Subject: Re: 9.0 and pg_stat_activity.application_name
Previous:From: Kevin GrittnerDate: 2010-07-01 21:08:02
Subject: Re: Unable to commit: transaction marked for rollback

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group