批注 2022-08-03 094310.png - ConcourseSuite Support image

ConcourseSuite Support

Support
http://concursive.com/help/en_us/
Corporate
PUBLIC PROFILE

Back to topics

General Discussion

Postgres transaction error

You need to be logged in to post messages

This question is unanswered

Postgres transaction error

3/13/2009 7:43 PM EDT
Default user photo

By Bernardo Silva

Hi,

I am using centric CRM. 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

1. 3/25/2009 9:55 AM EDT
Default user photo

By Joshua Fielek

Hi Bernardo;

It looks like there was an unfilled data field for the insertion. It happened during the execution of the business rules for the installation. Can you provide me the following information:

The versions of the following components:
Postgres
Tomcat
Java
CentricCRM/Concourse Suite

Also, if possible, it would be useful to know what action was associated with the error, in as much detail as possible.

Thanks,
J

1 result found