Re: Unable to commit: transaction marked for rollback

On 7/1/2010 2:08 PM, Kevin Grittner wrote:
> David Kerr<dmk@mr-paradox.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