[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