> I've applied the patch yesterday as well, and indeed this does seem to > help a lot. > I'm only seeing about 35 connections now (with 25 clients), no more > hanging queries either. > > So in general with that patch connection counts look better however I'm still seeing connections as IDLE in transaction with hanging open transactions even if the server didn't outright fall over this time...
So it looks like there's still some underlying issue even if this mitigates some of it. Here's my current pg_stat_activity for IDLE in transaction connections: datid | datname | procpid | usesysid | usename | current_query | waiting | xact_start | query_start | backend_start | client_addr | client_port -------+-------------+---------+----------+-----------+-----------------------+---------+-------------------------------+-------------------------------+-------------------------------+-------------+------------- 16384 | spaceschema | 17267 | 16388 | spaceuser | <IDLE> in transaction | f | 2012-12-07 16:23:51.178637+00 | 2012-12-07 16:23:51.178966+00 | 2012-12-07 16:12:34.620533+00 | 127.0.0.1 | 45196 16384 | spaceschema | 16102 | 16388 | spaceuser | <IDLE> in transaction | f | 2012-12-07 16:13:19.062683+00 | 2012-12-07 16:13:19.063373+00 | 2012-12-07 16:08:49.622536+00 | 127.0.0.1 | 44779 16384 | spaceschema | 12847 | 16388 | spaceuser | <IDLE> in transaction | f | 2012-12-07 16:23:51.141108+00 | 2012-12-07 16:23:51.14131+00 | 2012-12-07 15:57:34.622143+00 | 127.0.0.1 | 43979 16384 | spaceschema | 17468 | 16388 | spaceuser | <IDLE> in transaction | f | 2012-12-07 16:13:19.225653+00 | 2012-12-07 16:13:19.226371+00 | 2012-12-07 16:13:19.123346+00 | 127.0.0.1 | 45215 16384 | spaceschema | 17471 | 16388 | spaceuser | <IDLE> in transaction | f | 2012-12-07 16:23:51.260104+00 | 2012-12-07 16:23:51.260277+00 | 2012-12-07 16:13:19.340865+00 | 127.0.0.1 | 45218 Checking the locks table shows that these all have locks on something ....
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
