[ic] Issue with Postgres (current transaction is aborted)
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
> 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.
End Point Corporation
Software development with Interchange, Perl, PostgreSQL, Apache, Linux, ...
More information about the interchange-users