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 <[email protected]> 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 > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
