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

[Stefan Hornburg]

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?

No.

> 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 :-(.

Bye
        Racke