pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: 66666666nikita@gmail.com
Subject: BUG #17179: EOF detected
Date: Fri, 03 Sep 2021 05:47:15 +0000
Message-ID: <17179-100f778969bdc589@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      17179
Logged by:          Никита Шумилов
Email address:      66666666nikita@gmail.com
PostgreSQL version: 12.6
Operating system:   Ubuntu
Description:        

Query running for more than 30 minutes are disconnected
SELECT pg_sleep(1820)
SSL SYSCALL error: EOF detected

Increased timeouts tcp_user_timeout, tcp_keepalives_interval didn't help.

Configuration:
autovacuum_naptime	60	s
timezone_abbreviations	Default	
client_encoding	UNICODE	
vacuum_freeze_min_age	50000000	
search_path	"$user", public	
password_encryption	md5	
ssl_passphrase_command		
ssl_key_file	/etc/ssl/private/ssl-cert-snakeoil.key	
allow_system_table_mods	off	
ident_file	/etc/postgresql/12/main/pg_ident.conf	
segment_size	131072	8kB
wal_block_size	8192	
debug_assertions	off	
data_directory_mode	700	
cluster_name	pgsql	
geqo_selection_bias	2	
geqo_seed	0	
geqo_effort	5	
constraint_exclusion	partition	
cpu_tuple_cost	0.01	
enable_mergejoin	on	
synchronous_standby_names		
wal_keep_segments	8	
max_wal_senders	5	
wal_sender_timeout	60000	ms
max_replication_slots	5	
max_standby_archive_delay	30000	ms
recovery_min_apply_delay	0	ms
vacuum_cost_page_miss	10	
vacuum_cost_page_dirty	20	
max_files_per_process	1000	
log_planner_stats	off	
log_executor_stats	off	
track_counts	on	
stats_temp_directory	pg_stat_tmp	
array_nulls	on	
backslash_quote	safe_encoding	
operator_precedence_warning	off	
recovery_target_lsn		
wal_log_hints	on	
wal_init_zero	on



view thread (2+ messages)  latest in thread

Message-ID: <17179-100f778969bdc589@postgresql.org>
Permalink:  ../17179-100f778969bdc589@postgresql.org/
Also on:    postgresql.org/message-id/17179-100f778969bdc589@postgresql.org

 · 

reply
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: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, 66666666nikita@gmail.com
  Subject: Re: BUG #17179: EOF detected
  In-Reply-To: <17179-100f778969bdc589@postgresql.org>

* 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