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

[Stefan Hornburg]

On Thu, 17 Feb 2005 09:24:32 +0100
"Stefan Hornburg" <racke at linuxia.de> wrote:

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

Strange, only the administration interface is affected. 
Orders still pouring in, while modifications from the UI
to Postgresql tables are ignored.

Bye
         Racke