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.
