[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