Pgbouncer
Hi,
I am not sure if this is the right place to ask this question. If not,
please point me to it.
I am trying out the new pgbouncer (latest git). "SHOW SERVERS" is
telling me 2 connections in "active" state. Both show
connect_time=2015-11-30 18:58:30. Request_time is 19:01:35 and 20:56:36.
Both use pool_mode=transaction.
Server_lifetime=600. And now is 21:38:55.
Shouldn't those connections have been closed long ago?
I also checked on the backend. The backend processes are there, are idle
and query_start and state_change times match the request_times above.
Also, since pool_mode=transaction, why are these connections "active"?
Thanks,
Torsten
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Do you have any clients connected that are idle in transaction?
Cheers,
Steve
On Mon, Nov 30, 2015 at 1:46 PM, Torsten Förtsch <torsten.foertsch@gmx.net>
wrote:
Show quoted text
Hi,
I am not sure if this is the right place to ask this question. If not,
please point me to it.I am trying out the new pgbouncer (latest git). "SHOW SERVERS" is
telling me 2 connections in "active" state. Both show
connect_time=2015-11-30 18:58:30. Request_time is 19:01:35 and 20:56:36.
Both use pool_mode=transaction.Server_lifetime=600. And now is 21:38:55.
Shouldn't those connections have been closed long ago?
I also checked on the backend. The backend processes are there, are idle
and query_start and state_change times match the request_times above.Also, since pool_mode=transaction, why are these connections "active"?
Thanks,
Torsten--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 30/11/15 22:50, Steve Crawford wrote:
Do you have any clients connected that are idle in transaction?
No, the backend database is a streaming replica. Also, as I said, the
backend process is in "idle" state not "idle in transaction".
backend_start | 2015-11-30 18:58:30.639962+00
xact_start | <NULL>
query_start | 2015-11-30 20:56:36.479003+00
state_change | 2015-11-30 20:56:36.480199+00
waiting | f
state | idle
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general