Hello Tomas,
Thanks for reaching out! For more details, users connect directly to
PostgreSQL using the DBeaver tool. Please review the attached error
messages in the PostgreSQL server logs, and the timeout error on the
EDWDBPRDL01A server. We have another dev server in Windows, which works
absolutely fine without this issue, as you can review. Please let me know
if any more specific details are required.
Thanks,
Sri.
On Wed, May 27, 2026 at 5:37 PM Tomas Vondra <[email protected]> wrote:
> On 5/27/26 22:27, Srinivas Kumar wrote:
> > Hello,
> >
> > My company has a new Linux production server of Postgresql 18. While
> > connecting to it in DBeaver, users are experiencing timeouts with broken
> > pipe
> > errors in logs. It connects randomly, 1 in every 3-4 attempts. Since
> this is
> > new servers in high available fashion with another standby server, there
> is
> > very little traffic and max connections are set to 300. How do we find
> > RCA for
> > this? Let me know if any additional details are required. I have checked
> all
> > security information and telnet, and it works just fine in CMD or a
> > terminal.
> >
> > Looking forward to hearing from you.
> >
>
> There not much information, so it's hard to give you good advice. We
> don't even know how the users connect - is it directly or through a
> pool/proxy of some sorts, or what? What logs have messages about broken
> pipes - is that the Postgres server log or some other log?
>
> You'll have to do the usual thing people do during RCA analysis, i.e. go
> step by step over all the components on the connection (between the
> client and the server), figure out where exactly it fails and why.
>
> My guess is something is dropping the connection for whatever reason
> (might be a proxy, might be a VPN, ... who knows?).
>
>
> regards
>
> --
> Tomas Vondra
>
>
2026-05-21 18:55:10.545
EDT,"snerusu","EDW",1994928,"10.3.34.252:51560",6a0f8cca.1e70b0,2,"authentication",2026-05-21
18:52:58 EDT,255/3,0,LOG,00000,"connection authenticated:
identity=""CN=Srinivasa Nerusu,OU=Users,OU=Consultants,OU=BHE,DC=bhe,DC=local""
method=ldap (/var/lib/pgsql/18/data/pg_hba.conf:122)",,,,,,,,,"","client
backend",,0 2026-05-21 18:55:10.545
EDT,"snerusu","EDW",1994928,"10.3.34.252:51560",6a0f8cca.1e70b0,3,"authentication",2026-05-21
18:52:58 EDT,255/3,0,LOG,00000,"connection authorized: user=snerusu
database=EDW SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384,
bits=256)",,,,,,,,,"","client backend",,0 2026-05-21 18:55:10.603
EDT,"snerusu","EDW",1994928,"10.3.34.252:51560",6a0f8cca.1e70b0,4,"SET",2026-05-21
18:52:58 EDT,255/4,0,LOG,00000,"execute <unnamed>: SET extra_float_digits =
3",,,,,,,,,"","client backend",,4334172717689147919 2026-05-21 18:55:10.658
EDT,"snerusu","EDW",1994928,"10.3.34.252:51560",6a0f8cca.1e70b0,5,"SET",2026-05-21
18:52:58 EDT,255/5,0,LOG,00000,"execute <unnamed>: SET application_name =
'PostgreSQL JDBC Driver'",,,,,,,,,"","client backend",,-6638236131011848862
2026-05-21 18:55:10.713
EDT,"snerusu","EDW",1994928,"10.3.34.252:51560",6a0f8cca.1e70b0,6,"idle",2026-05-21
18:52:58 EDT,,0,LOG,00000,"disconnection: session time: 0:02:11.846
user=snerusu database=EDW host=10.3.34.252 port=51560",,,,,,,,,"PostgreSQL JDBC
Driver","client backend",,0 2026-05-21 18:55:51.495
EDT,"snerusu","RAW",1994900,"10.3.34.252:55034",6a0f8c71.1e7094,2,"authentication",2026-05-21
18:51:29 EDT,239/3,0,LOG,00000,"connection authenticated:
identity=""CN=Srinivasa Nerusu,OU=Users,OU=Consultants,OU=BHE,DC=bhe,DC=local""
method=ldap (/var/lib/pgsql/18/data/pg_hba.conf:122)",,,,,,,,,"","client
backend",,0 2026-05-21 18:55:51.495
EDT,"snerusu","RAW",1994900,"10.3.34.252:55034",6a0f8c71.1e7094,3,"authentication",2026-05-21
18:51:29 EDT,239/3,0,LOG,00000,"connection authorized: user=snerusu
database=RAW SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384,
bits=256)",,,,,,,,,"","client backend",,0 2026-05-21 18:55:51.553
EDT,"snerusu","RAW",1994900,"10.3.34.252:55034",6a0f8c71.1e7094,4,"SET",2026-05-21
18:51:29 EDT,239/4,0,LOG,00000,"execute <unnamed>: SET extra_float_digits =
3",,,,,,,,,"","client backend",,4334172717689147919 2026-05-21 18:55:51.608
EDT,"snerusu","RAW",1994900,"10.3.34.252:55034",6a0f8c71.1e7094,5,"SET",2026-05-21
18:51:29 EDT,239/5,0,LOG,00000,"execute <unnamed>: SET application_name =
'PostgreSQL JDBC Driver'",,,,,,,,,"","client backend",,-6638236131011848862
2026-05-21 18:55:51.662
EDT,"snerusu","RAW",1994900,"10.3.34.252:55034",6a0f8c71.1e7094,6,"idle",2026-05-21
18:51:29 EDT,,0,LOG,00000,"disconnection: session time: 0:04:22.425
user=snerusu database=RAW host=10.3.34.252 port=55034",,,,,,,,,"PostgreSQL JDBC
Driver","client backend",,0 2026-05-21 18:56:11.978
EDT,"snerusu","EDW",1994906,"10.3.34.252:55637",6a0f8c86.1e709a,2,"authentication",2026-05-21
18:51:50 EDT,242/3,0,LOG,00000,"connection authenticated:
identity=""CN=Srinivasa Nerusu,OU=Users,OU=Consultants,OU=BHE,DC=bhe,DC=local""
method=ldap (/var/lib/pgsql/18/data/pg_hba.conf:122)",,,,,,,,,"","client
backend",,0 2026-05-21 18:56:11.978
EDT,"snerusu","EDW",1994906,"10.3.34.252:55637",6a0f8c86.1e709a,3,"authentication",2026-05-21
18:51:50 EDT,242/3,0,LOG,00000,"connection authorized: user=snerusu
database=EDW application_name=pgAdmin 4 - DB:EDW SSL enabled (protocol=TLSv1.3,
cipher=TLS_AES_256_GCM_SHA384, bits=256)",,,,,,,,,"","client backend",,0
2026-05-21 18:56:11.981
EDT,"snerusu","EDW",1994906,"10.3.34.252:55637",6a0f8c86.1e709a,4,"idle",2026-05-21
18:51:50 EDT,242/0,0,LOG,08006,"could not send data to client: Broken
pipe",,,,,,,,,"pgAdmin 4 - DB:EDW","client backend",,0 2026-05-21 18:56:11.981
EDT,"snerusu","EDW",1994906,"10.3.34.252:55637",6a0f8c86.1e709a,5,"idle",2026-05-21
18:51:50 EDT,242/0,0,FATAL,08006,"connection to client lost",,,,,,,,,"pgAdmin
4 - DB:EDW","client backend",,0 2026-05-21 18:56:11.981
EDT,"snerusu","EDW",1994906,"10.3.34.252:55637",6a0f8c86.1e709a,6,"idle",2026-05-21
18:51:50 EDT,,0,LOG,00000,"disconnection: session time: 0:04:20.996
user=snerusu database=EDW host=10.3.34.252 port=55637",,,,,,,,,"pgAdmin 4 -
DB:EDW","client backend",,0 2026-05-21 18:56:16.063
EDT,"snerusu","RAW",1994911,"10.3.34.252:51601",6a0f8c8b.1e709f,2,"authentication",2026-05-21
18:51:55 EDT,247/3,0,LOG,00000,"connection authenticated:
identity=""CN=Srinivasa Nerusu,OU=Users,OU=Consultants,OU=BHE,DC=bhe,DC=local""
method=ldap (/var/lib/pgsql/18/data/pg_hba.conf:122)",,,,,,,,,"","client
backend",,0 2026-05-21 18:56:16.063
EDT,"snerusu","RAW",1994911,"10.3.34.252:51601",6a0f8c8b.1e709f,3,"authentication",2026-05-21
18:51:55 EDT,247/3,0,LOG,00000,"connection authorized: user=snerusu
database=RAW application_name=pgAdmin 4 - DB:RAW SSL enabled (protocol=TLSv1.3,
cipher=TLS_AES_256_GCM_SHA384, bits=256)",,,,,,,,,"","client backend",,0
2026-05-21 18:56:16.068
EDT,"snerusu","postgres",1994912,"10.3.34.252:58473",6a0f8c8b.1e70a0,2,"authentication",2026-05-21
18:51:55 EDT,248/3,0,LOG,00000,"connection authenticated:
identity=""CN=Srinivasa Nerusu,OU=Users,OU=Consultants,OU=BHE,DC=bhe,DC=local""
method=ldap (/var/lib/pgsql/18/data/pg_hba.conf:122)",,,,,,,,,"","client
backend",,0 2026-05-21 18:56:16.068
EDT,"snerusu","postgres",1994912,"10.3.34.252:58473",6a0f8c8b.1e70a0,3,"authentication",2026-05-21
18:51:55 EDT,248/3,0,LOG,00000,"connection authorized: user=snerusu
database=postgres application_name=pgAdmin 4 - DB:postgres SSL enabled
(protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256)",,,,,,,,,"","client
backend",,0 2026-05-21 18:56:16.077
EDT,"snerusu","postgres",1994910,"10.3.34.252:51600",6a0f8c8b.1e709e,2,"authentication",2026-05-21
18:51:55 EDT,246/3,0,LOG,00000,"connection authenticated:
identity=""CN=Srinivasa Nerusu,OU=Users,OU=Consultants,OU=BHE,DC=bhe,DC=local""
method=ldap (/var/lib/pgsql/18/data/pg_hba.conf:122)",,,,,,,,,"","client
backend",,0 2026-05-21 18:56:16.077
EDT,"snerusu","postgres",1994910,"10.3.34.252:51600",6a0f8c8b.1e709e,3,"authentication",2026-05-21
18:51:55 EDT,246/3,0,LOG,00000,"connection authorized: user=snerusu
database=postgres application_name=pgAdmin 4 - DB:postgres SSL enabled
(protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256)",,,,,,,,,"","client
backend",,0 2026-05-21 18:56:16.142
EDT,"snerusu","postgres",1994910,"10.3.34.252:51600",6a0f8c8b.1e709e,4,"idle",2026-05-21
18:51:55 EDT,246/4,0,LOG,00000,"statement: SET DateStyle=ISO; SET
client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM
pg_show_all_settings() WHERE name = 'bytea_output'; SET
client_encoding='utf-8';",,,,,,,,,"pgAdmin 4 - DB:postgres","client backend",,0
2026-05-21 18:56:16.142
EDT,"snerusu","RAW",1994911,"10.3.34.252:51601",6a0f8c8b.1e709f,4,"idle",2026-05-21
18:51:55 EDT,247/4,0,LOG,00000,"statement: SET DateStyle=ISO; SET
client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM
pg_show_all_settings() WHERE name = 'bytea_output'; SET
client_encoding='utf-8';",,,,,,,,,"pgAdmin 4 - DB:RAW","client backend",,0
2026-05-21 18:56:16.142
EDT,"snerusu","postgres",1994912,"10.3.34.252:58473",6a0f8c8b.1e70a0,4,"idle",2026-05-21
18:51:55 EDT,248/4,0,LOG,00000,"statement: SET DateStyle=ISO; SET
client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM
pg_show_all_settings() WHERE name = 'bytea_output'; SET
client_encoding='utf-8';",,,,,,,,,"pgAdmin 4 - DB:postgres","client backend",,0
2026-05-21 18:56:16.142
EDT,"snerusu","RAW",1994909,"10.3.34.252:51599",6a0f8c8b.1e709d,9,"idle",2026-05-21
18:51:55 EDT,,0,LOG,00000,"disconnection: session time: 0:04:21.044
user=snerusu database=RAW host=10.3.34.252 port=51599",,,,,,,,,"pgAdmin 4 -
DB:RAW","client backend",,0 2026-05-21 18:56:16.194
EDT,"snerusu","postgres",1994912,"10.3.34.252:58473",6a0f8c8b.1e70a0,5,"idle",2026-05-21
18:51:55 EDT,248/5,0,LOG,00000,"statement: SELECT version()",,,,,,,,,"pgAdmin
4 - DB:postgres","client backend",,0 2026-05-21 18:56:16.194
EDT,"snerusu","RAW",1994911,"10.3.34.252:51601",6a0f8c8b.1e709f,5,"idle",2026-05-21
18:51:55 EDT,247/5,0,LOG,00000,"statement: SELECT version()",,,,,,,,,"pgAdmin
4 - DB:RAW","client backend",,0 2026-05-21 18:56:16.194
EDT,"snerusu","postgres",1994910,"10.3.34.252:51600",6a0f8c8b.1e709e,5,"idle",2026-05-21
18:51:55 EDT,246/5,0,LOG,00000,"statement: SELECT version()",,,,,,,,,"pgAdmin
4 - DB:postgres","client backend",,0 2026-05-21 18:56:16.251
EDT,"snerusu","postgres",1994912,"10.3.34.252:58473",6a0f8c8b.1e70a0,6,"idle",2026-05-21
18:51:55 EDT,248/6,0,LOG,00000,"statement: this is logs i experinced timeout
in dbeaver
