PGBouncer logs explanation required

From: Shubham Mittal <mittalshubham30(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: PGBouncer logs explanation required
Date: 2021-12-19 11:50:21
Message-ID: CA+ERcR8_fA5Y8JRZsOye1DXDf9bqL+SUuFw=2b+NVoE4OtTCYg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Team,

I get below logs in pgbouncer.. when I configure query timeout in spring
boot application as below:

SessionImplementor session = entityManager.unwrap(SessionImplementor.class);
Connection connection = session.connection();
connection.createStatement().execute("SET LOCAL statement_timeout TO "
+ queryTimeOut);

2021-11-25 14:45:45.244 IST [18307] LOG C-0x6ae270: sit/postgres(at)abcdlogin
attempt: db=sit user=postgres tls=no
2021-11-25 14:45:45.299 IST [18307] LOG S-0x6b4f48: sit/postgres(at)abcd new
connection to server (from abcd)
2021-11-25 14:46:17.843 IST [18307] LOG S-0x6b4d10: sit/postgres(at)abcd *closing
because: query timeout (age=185s)*
2021-11-25 14:46:17.843 IST [18307] LOG C-0x6ae038: sit/postgres(at)abcd *closing
because: query timeout (age=185s)*
2021-11-25 14:46:17.843 IST [18307] WARNING C-0x6ae038: sit/postgres(at)*abcd
pooler error: query timeout*
2021-11-25 14:46:25.763 IST [18307] LOG stats: 0 xacts/s, 0 queries/s, in
30 B/s, out 141 B/s, xact 3660 us, query 4362 us, wait 152 us

Does this log mean that connection is closed and returned to the pool and
can be reused again?? Or something else?? Please help.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Zahir Lalani 2021-12-19 14:24:48 RE: Best Strategy for Large Number of Images
Previous Message Bryn Llewellyn 2021-12-17 23:53:11 Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL