Re: Postgres transaction error

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
>