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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2010-07-02 01:15:23 | Re: 9.0 and pg_stat_activity.application_name |
Previous Message | Kevin Grittner | 2010-07-01 21:08:02 | Re: Unable to commit: transaction marked for rollback |