[ic] Issue with Postgres (current transaction is aborted)
Ethan Rowe
ethan at endpoint.com
Wed Feb 16 12:07:10 EST 2005
Stefan Hornburg wrote:
>Hello, list !
>
>RPO Vienna encounters a peculiar error with Interchange and Postgres.
>Suddenly, PostgreSQL doesn't accept any database modifications through
>Interchange for any catalogs running on this server.
>
>Sometimes an error message can be found:
>
>iro /cgi-bin/iro/process Runtime error: DBD::Pg::st execute failed: ERROR: current transaction is aborted, queries ignored until end of transaction block at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1
>446.
>
>
>
>A restart "fixes" this problem.
>
>System setup:
>Red Hat Enterprise Linux ES release 3 (Taroon Update 4)
>Interchange 5.2.0
>Perl 5.8.6, compiled from source without threads
>Postgres 7.3.8
>DBI 1.46
>DBD::Pg 1.32
>
>Any hints are welcome.
>
>Bye
> Racke
>
>
Are you playing with transactions or the DBI auto_commit setting
anywhere in this catalog? I'm assuming you have transactions going on
within the order routes...
--
Ethan Rowe
End Point Corporation
ethan at endpoint.com
More information about the interchange-users
mailing list