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

Stefan Hornburg racke at linuxia.de
Thu Jun 2 11:48:16 EDT 2005


On Thu, 2 Jun 2005 10:03:50 -0500
Mike Heins <mike at perusion.com> wrote:

> Quoting Stefan Hornburg (Racke) (racke at linuxia.de):
> > 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



More information about the interchange-users mailing list