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

[Jon Jensen]

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


-- 
Jon Jensen
End Point Corporation
http://www.endpoint.com/
Software development with Interchange, Perl, PostgreSQL, Apache, Linux, ...