Thread: 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

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