Re: Postgres transaction error - Mailing list pgsql-jdbc
From | Dave Cramer |
---|---|
Subject | Re: Postgres transaction error |
Date | |
Msg-id | 491f66a50903131953x268875eehd25559cd395d5191@mail.gmail.com Whole thread Raw |
In response to | Postgres transaction error (bsilva <bsilva@bluestarenergy.com>) |
List | pgsql-jdbc |
Hi,
Apparently you are only using one connection.
You must rollback the transaction that caused the error then commands can resume
Dave
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@bluestarenergy.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
pgsql-jdbc by date: