[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


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
_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.