[ic] Issue with Postgres (current transaction is aborted)
racke at linuxia.de
Thu Feb 17 03:24:32 EST 2005
On Thu, 17 Feb 2005 04:06:57 +0000 (UTC)
"Jon Jensen" <jon at endpoint.com> wrote:
> 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.
Ha, so we need to trace the problem down somehow :-(.
More information about the interchange-users