[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
>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.
>          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