From: Tom Lane <tgl@sss.pgh.pa.us>
To: 66666666nikita@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17179: EOF detected
Date: Fri, 03 Sep 2021 09:34:25 -0400
Message-ID: <2481802.1630676065@sss.pgh.pa.us> (raw)
In-Reply-To: <17179-100f778969bdc589@postgresql.org>
References: <17179-100f778969bdc589@postgresql.org>
PG Bug reporting form <noreply@postgresql.org> writes:
> Query running for more than 30 minutes are disconnected
> SELECT pg_sleep(1820)
> SSL SYSCALL error: EOF detected
Ideally, you'd fix your broken network infrastructure. However,
if you can't ...
> Increased timeouts tcp_user_timeout, tcp_keepalives_interval didn't help.
... that's exactly backwards about how to work around it. You need
to *reduce* the interval at which keepalives are sent. Try setting
tcp_keepalives_idle to 10min or so. (At least on my Linux box,
it seems to default to 7200s = 2 hours, so that it's no surprise that a
router that drops connections after 30 minutes would cause problems.)
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, 66666666nikita@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17179: EOF detected
In-Reply-To: <2481802.1630676065@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox