[ic] Issue with Postgres (current transaction is aborted)
racke at linuxia.de
Thu Feb 17 03:25:41 EST 2005
On Wed, 16 Feb 2005 12:07:10 -0500
"Ethan Rowe" <ethan at endpoint.com> wrote:
> Stefan Hornburg wrote:
> >Hello, list !
> >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
> >Any hints are welcome.
> > Racke
> Are you playing with transactions or the DBI auto_commit setting
> anywhere in this catalog?
Not that I know of.
> I'm assuming you have transactions going on
> within the order routes...
No, these are 4.8 catalogs we just migrated to 5.2 in December.
We try to collect more information about the problem.
More information about the interchange-users