On Wed, Feb 26, 2014 at 12:49:02PM +0800, Mathieu Bridon wrote:
On Tue, 2014-02-25 at 14:11 -0700, Luke Macken wrote:
> On Tue, Feb 25, 2014 at 05:04:14PM +0800, Mathieu Bridon wrote:
> > Hi,
> >
> > In the default /etc/bodhi/bodhi.cfg, I just saw this:
> >
> > # Right now bodhi requires that you disable transactions.
> > #sqlobject.dburi="notrans_postgres://bodhi:B0dh1@localhost/bodhi"
> >
> > Is that really the case that Bodhi requires we disable transactions?
> >
> > That makes me wonder...
> >
> > I'm having weird issues with stale connections to the PostgreSQL
> > database (they stay forever "IDLE in transaction" and just keep
piling
> > up) from my Bodhi instance at $dayjob.
> >
> > Could that be related?
>
> Hmm, it actually could be.
>
> We had a bunch of problems with SQLObject transactions + TG1 very
> early on, and have just disabled them ever since.
>
>
http://www.redhat.com/archives/fedora-infrastructure-list/2007-November/m...
>
> As Toshio mentions in that thread, smolt would sometimes make a mess of
> things if transactions fail, so it could be a similar issue that you are
> hitting.
I'm not seeing the problem you're describing in that email:
It's briefly mentioned in the top quote of the mail.
> Modifications don't seem to go through; I'm not sure if
they
> hit the DB or not.
But I'll try out the notrans_ for a few days and see if that makes
things better. :)
Cool, I'm interested to see if that solves your problem.
luke