BUG #17179: EOF detected

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: 66666666nikita(at)gmail(dot)com
Subject: BUG #17179: EOF detected
Date: 2021-09-03 05:47:15
Message-ID: 17179-100f778969bdc589@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17179
Logged by: Никита Шумилов
Email address: 66666666nikita(at)gmail(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kyotaro Horiguchi 2021-09-03 11:34:11 Re: BUG #17177: Secondary fails to start after upgrade from 13.3
Previous Message Kevin Burke 2021-09-03 05:01:32 Re: BUG #17178: probes.h: No such file or directory when running 'make install'