[ic] Issue with Postgres (current transaction is aborted), followup
Stefan Hornburg
racke at linuxia.de
Thu Jun 2 09:57:50 EDT 2005
Hello,
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
446.
>
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.
Bye
Racke
--
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