[Spacewalk-list] Spacewalk 1.6 Database problem

[John Hodrien]

On Thu, 5 Jan 2012, John Hodrien wrote:

> I've upgrade from 1.5 to 1.6 Postgresql and nominally things look passable.
> No errors during upgrade.  Database is on a physically different server.
>
> Web interface works, and almost everything within the ui works as expected.
>
>> From a clean start of the services, I visit the overview, systems, then
> channels.  I've done nothing else.  After about a minute or two I start getting
> stuck SQL queries.  Over time these build up until I run out of connections to
> postgres.

<snip>

> Some form of locking problem?
>
> Database is postgresql-8.4.9-1.el6_1.1.x86_64
>
> Thanks for any pointers,

I'd thought that turning off osa-dispatcher was sufficient to avoid hitting
this problem, but apparently not.  Overnight I find this all knots up again.
Is it really only me that's seeing this?

After a day this leaves me with a pretty much unusable spacewalk server.

jh