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

Stefan Hornburg racke at linuxia.de
Thu Jun 2 09:57:50 EDT 2005


from my original message:

--- SNIP ---
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.
--- SNAP ---

We don't need transactions, so 

DatabaseDefault HAS_TRANSACTIONS 0

can be used as workaround.

However, I think IC has to address this issue in order to avoid serious and unexpected 
data loss.


LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team

More information about the interchange-users mailing list