pgBouncer - got packet 'D' from server when not linked WARNING messages

From: fatih abztn <fatihabztn(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: pgBouncer - got packet 'D' from server when not linked WARNING messages
Date: 2023-04-26 13:28:40
Message-ID: CA+JVnzV8A41tS-Ci0PEm4aSo+6TbckN7GZk8V-pGb3_=HUaTXA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi everyone;

We use pgBouncer for pooling, we see like these messages in pgb logs;

WARNING S-0x118b7c0: db/username(at)dbip:port got packet '2' from server when
not linked
WARNING S-0x118b7c0: db/username(at)dbip:port got packet 'T' from server when
not linked
WARNING S-0x118b7c0: db/username(at)dbip:port got packet 'D' from server when
not linked
WARNING S-0x118b7c0: db/username(at)dbip:port got packet 'C' from server when
not linked
WARNING S-0x118b7c0: db/username(at)dbip:port got packet 'Z' from server when
not linked
WARNING S-0x1170a88: db/username(at)dbip:port got packet '1' from server when
not linked
WARNING S-0x1170a88: db/username(at)dbip:port got packet '2' from server when
not linked
WARNING S-0x1170a88: db/username(at)dbip:port got packet 'T' from server when
not linked
WARNING S-0x1170a88: db/username(at)dbip:port got packet 'D' from server when
not linked
WARNING S-0x1170a88: db/username(at)dbip:port got packet 'C' from server when
not linked
WARNING S-0x1170a88: db/username(at)dbip:port got packet 'Z' from server when
not linked

Actually there are different types messages also but we think all of them
independent. one of them is above.

others like these:
- bla bla pooler error: server conn crashed?
- FIXME: query end, but query_start == 0
FIXME: transaction end, but xact_start == 0

and our environment:

PgBouncer 1.17.0
libevent 2.0.21-stable
adns: evdns2
tls: OpenSSL 1.0.2k-fips 26 Jan 2017
mode is transaction
avr TPS = 20K
postgres version 14.5

Have you encountered this problem before, what causes this and what is the
solution?

Thanks in advance...

Browse pgsql-admin by date

  From Date Subject
Next Message richard coleman 2023-04-26 16:34:21 how to list privileges on the database object itself via SQL?
Previous Message ROHIT SACHDEVA 2023-04-23 17:34:53 Re: Related To Hash Partition