[ic] Issue with Postgres (current transaction is aborted)
racke at linuxia.de
Fri Feb 18 03:43:37 EST 2005
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?
> > 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.
More information about the interchange-users