On Thu, 2 Jun 2005 10:03:50 -0500 Mike Heins <suppressed> wrote: > Quoting Stefan Hornburg (Racke) (suppressed): > > 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. > > Restart of what? IC, or postgres? IC. > > > --- 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. > > > > I have never heard of this problem before, but unless we get more > information surrounding the issue there will be no chance to fix > it. Forgot this link: http://mail.pm.org/pipermail/spug-list/2004-December/006143.html > > I have to some extent lost patience with Postgres and DBD::Pg, as > it seems to have constant little problems that change from version > to version of each. Hehe. I also feel that Postgres more cumbersome to deal with for web apps. 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.