[Spacewalk-list] spacewalk eats up all connections to postgres

[Paul Robert Marino]

I was the first one to point out the jdbc driver
it does help significantly but i never could find any thing in the
change log to explain why it fixes the issue
its not a 100% fix but you will notice a 95% reduction in idle
connections and it will be relatively stable give or take 5 idle
connections.


On Wed, Dec 12, 2012 at 10:37 AM, James Hogarth <james.hogarth at gmail.com> wrote:
>
>
>
>> I second this. same fixes (except tcp_keepalive_time, never touched it)
>> helped me too.
>> 6 days passed - no restarts needed, no issues, about 50 idle connections.
>> rhel 6.3, spacewalk-1.8 with stock postgresql-8.4.13
>>
>
> I changed over the postgresql jdbc jar today (in addition to the referenced
> patch) and so far my monitoring hasn't alerted me to any idle in transaction
> situations...
>
> The key test will be tonight when the nightly diffs run (and leaving it over
> the weekend).... fingers crossed!
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list