[ic] Issue with Postgres (current transaction is aborted)

Jon Jensen jon at endpoint.com
Wed Feb 16 23:06:57 EST 2005

On Wed, 16 Feb 2005, Stefan Hornburg wrote:

> 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

Are you using PreFork mode? I wonder if some of your database handles are 
getting stuck in an aborted transaction. But if you're not using PreFork 
mode, I'm not sure how that could happen.


Jon Jensen
End Point Corporation
Software development with Interchange, Perl, PostgreSQL, Apache, Linux, ...

More information about the interchange-users mailing list