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

jeff at hisgirlfridays.com jeff at hisgirlfridays.com
Thu Jun 2 10:15:09 EDT 2005


On Thu, Jun 02, 2005 at 03:57:50PM +0200, 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.

If I remember DBI right, if a "manual" transaction fails, DBI's
autocommit has to be turned back on.  I don't know if this is or isn't
happening here but perhaps the info will save some debugging time.

Jeff


More information about the interchange-users mailing list