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

Stefan Hornburg 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
> >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
> >
> >Any hints are welcome.
> >
> >Bye
> >          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.

Bye
        Racke


More information about the interchange-users mailing list