[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