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

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


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

_______________________________________________
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.