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

Re: Postgres transaction error

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: bsilva <bsilva(at)bluestarenergy(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Postgres transaction error
Date: 2009-03-14 02:53:36
Message-ID: 491f66a50903131953x268875eehd25559cd395d5191@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi,

Apparently you are only using one connection.

You must rollback the transaction that caused the error then commands can
resume

Dave

On Fri, Mar 13, 2009 at 7:19 PM, bsilva <bsilva(at)bluestarenergy(dot)com> wrote:

>
> Hi,
>
> I am using postgres database in my application. Today I have saw in
> application's log the following error
>
> ERROR: current transaction is aborted, commands ignored until end of
> transaction block
>
> After this exception all the users lose access to the application.
> If the problem has been generated by a error in my application, I think
> this
> error only must affect the current transaction but no other transactions.
> I am not sure what is the cause of this problem, can you help me?
>
> This is exception's stack trace:
>
>
> 10:45:31,866 ERROR [STDERR] org.postgresql.util.PSQLException: ERROR:
> insert
> or update on table "history" violates foreign key constraint
> "history_enteredby_fkey"
>  Detail: Key (enteredby)=(-1) is not present in table "access".
> 10:45:31,867 ERROR [STDERR]     at
>
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
> 10:45:31,867 ERROR [STDERR]     at
>
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
> 10:45:31,867 ERROR [STDERR]     at
>
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
> 10:45:31,867 ERROR [STDERR]     at
>
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
> 10:45:31,867 ERROR [STDERR]     at
>
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
> 10:45:31,867 ERROR [STDERR]     at
>
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:344)
> 10:45:31,867 ERROR [STDERR]     at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 10:45:31,867 ERROR [STDERR]     at
> java.lang.reflect.Method.invoke(Method.java:597)
> 10:45:31,867 ERROR [STDERR]     at
>
> org.aspcfs.apps.workFlowManager.WorkflowManager.executeComponent(WorkflowManager.java:159)
> 10:45:31,867 ERROR [STDERR]     at
>
> org.aspcfs.apps.workFlowManager.WorkflowManager.execute(WorkflowManager.java:77)
> 10:45:31,867 ERROR [STDERR]     at
> org.aspcfs.controller.objectHookManager.ObjectHook.run(ObjectHook.java:234)
> 10:45:31,937 ERROR [STDERR] org.postgresql.util.PSQLException: ERROR:
> current transaction is aborted, commands ignored until end of transaction
> block
> --
> View this message in context:
> http://www.nabble.com/Postgres-transaction-error-tp22506898p22506898.html
> Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>

In response to

pgsql-jdbc by date

Next:From: decibelDate: 2009-03-14 14:31:31
Subject: Re: Query much slower when run from postgres function
Previous:From: bsilvaDate: 2009-03-13 23:19:31
Subject: Postgres transaction error

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