BUG #15949: pg_basebackup failed(PG-12-Beta3) - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15949: pg_basebackup failed(PG-12-Beta3)
Date
Msg-id 15949-0de04ed5e6b0d57e@postgresql.org
Whole thread Raw
Responses Re: BUG #15949: pg_basebackup failed(PG-12-Beta3)  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15949
Logged by:          强 魏
Email address:      1726002692@qq.com
PostgreSQL version: 12beta3
Operating system:   CentOS Linux release 7.6.1810 (Core)
Description:

When using pg_basebackup for compressed backup, it always fails. When not
using compressed backup, the backup succeeds.
Here are the configuration parameters:wal_sender_timeout=0
wal_receiver_timeout

[postgres@pg-master pg1203]$ pg_basebackup  -D /data/backup/ -F t -R -X
stream -c fast -z -Z 5 -U postgres -d 'host=192.168.200.128 port=5432
password=root dbname=postgres'-P
WARNING:  skipping special file "./.s.PGSQL.5432"
pg_basebackup: error: could not receive data from WAL stream: server closed
the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.
pg_basebackup: error: child process exited with exit code 1
pg_basebackup: removing contents of data directory "/data/backup/"


The error log is as follows:
2019-08-12 18:06:35.481 CST [11436] DEBUG:  archived write-ahead log file
"00000001000000080000002A"
2019-08-12 18:06:35.723 CST [11432] LOG:  checkpoint complete: wrote 0
buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.027 s,
sync=0.000 s, total=0.252 s; sync files=0, longest=0.000 s, average=0.000 s;
distance=65536 kB, estimate=65536 kB
2019-08-12 18:06:35.734 CST [11444] DEBUG:  file "pg_internal.init" excluded
from backup
2019-08-12 18:06:35.736 CST [11446] DEBUG:  received replication command:
SHOW data_directory_mode
2019-08-12 18:06:35.740 CST [11446] DEBUG:  received replication command:
CREATE_REPLICATION_SLOT "pg_basebackup_11446" TEMPORARY PHYSICAL
RESERVE_WAL
2019-08-12 18:06:35.749 CST [11446] DEBUG:  received replication command:
IDENTIFY_SYSTEM
2019-08-12 18:06:35.750 CST [11444] DEBUG:  contents of directory
"pg_dynshmem" excluded from backup
2019-08-12 18:06:35.750 CST [11444] DEBUG:  contents of directory
"pg_notify" excluded from backup
2019-08-12 18:06:35.750 CST [11444] DEBUG:  contents of directory
"pg_serial" excluded from backup
2019-08-12 18:06:35.750 CST [11444] DEBUG:  contents of directory
"pg_snapshots" excluded from backup
2019-08-12 18:06:35.750 CST [11444] DEBUG:  contents of directory
"pg_subtrans" excluded from backup
2019-08-12 18:06:35.751 CST [11446] DEBUG:  received replication command:
START_REPLICATION SLOT "pg_basebackup_11446" 8/AC000000 TIMELINE 1
2019-08-12 18:06:35.751 CST [11446] DEBUG:  "pg_basebackup" has now caught
up with upstream server
2019-08-12 18:06:57.246 CST [11448] DEBUG:  autovacuum: processing database
"transfer_tb"
2019-08-12 18:07:27.244 CST [11450] DEBUG:  autovacuum: processing database
"postgres"
2019-08-12 18:07:57.276 CST [11451] DEBUG:  autovacuum: processing database
"transfer_tb"
2019-08-12 18:08:27.261 CST [11479] DEBUG:  autovacuum: processing database
"postgres"
2019-08-12 18:08:57.289 CST [11481] DEBUG:  autovacuum: processing database
"transfer_tb"
2019-08-12 18:09:27.290 CST [11482] DEBUG:  autovacuum: processing database
"postgres"
2019-08-12 18:09:56.149 CST [11444] DEBUG:  file "pg_internal.init" excluded
from backup
2019-08-12 18:09:57.315 CST [11483] DEBUG:  autovacuum: processing database
"transfer_tb"
2019-08-12 18:10:27.320 CST [11489] DEBUG:  autovacuum: processing database
"postgres"
2019-08-12 18:10:57.341 CST [11490] DEBUG:  autovacuum: processing database
"transfer_tb"
2019-08-12 18:11:27.352 CST [11491] DEBUG:  autovacuum: processing database
"postgres"
2019-08-12 18:11:57.361 CST [11492] DEBUG:  autovacuum: processing database
"transfer_tb"
2019-08-12 18:12:27.380 CST [11493] DEBUG:  autovacuum: processing database
"postgres"
2019-08-12 18:12:57.363 CST [11495] DEBUG:  autovacuum: processing database
"transfer_tb"
2019-08-12 18:13:27.392 CST [11496] DEBUG:  autovacuum: processing database
"postgres"
2019-08-12 18:13:57.393 CST [11499] DEBUG:  autovacuum: processing database
"transfer_tb"
2019-08-12 18:14:27.406 CST [11500] DEBUG:  autovacuum: processing database
"postgres"
2019-08-12 18:14:57.398 CST [11506] DEBUG:  autovacuum: processing database
"transfer_tb"
2019-08-12 18:15:27.413 CST [11507] DEBUG:  autovacuum: processing database
"postgres"
2019-08-12 18:15:57.406 CST [11508] DEBUG:  autovacuum: processing database
"transfer_tb"
2019-08-12 18:16:27.430 CST [11509] DEBUG:  autovacuum: processing database
"postgres"
2019-08-12 18:16:57.414 CST [11510] DEBUG:  autovacuum: processing database
"transfer_tb"
2019-08-12 18:17:27.440 CST [11521] DEBUG:  autovacuum: processing database
"postgres"
2019-08-12 18:17:57.442 CST [11522] DEBUG:  autovacuum: processing database
"transfer_tb"
2019-08-12 18:18:27.450 CST [11523] DEBUG:  autovacuum: processing database
"postgres"
2019-08-12 18:18:57.476 CST [11527] DEBUG:  autovacuum: processing database
"transfer_tb"
2019-08-12 18:19:27.465 CST [11529] DEBUG:  autovacuum: processing database
"postgres"
2019-08-12 18:19:57.484 CST [11530] DEBUG:  autovacuum: processing database
"transfer_tb"
2019-08-12 18:20:02.551 CST [11444] DEBUG:  file "pg_internal.init" excluded
from backup
2019-08-12 18:20:02.551 CST [11444] DEBUG:  contents of directory
"pg_replslot" excluded from backup
2019-08-12 18:20:02.551 CST [11444] DEBUG:  contents of directory
"pg_stat_tmp" excluded from backup
2019-08-12 18:20:02.551 CST [11444] DEBUG:  file "postmaster.opts" excluded
from backup
2019-08-12 18:20:02.552 CST [11444] DEBUG:  file "postmaster.pid" excluded
from backup
2019-08-12 18:20:02.552 CST [11444] WARNING:  skipping special file
"./.s.PGSQL.5432"
Mon Aug 12 18:20:02 CST 2019
2019-08-12 18:20:02.761 CST [11436] DEBUG:  archived write-ahead log file
"00000001000000080000002B"
Mon Aug 12 18:20:02 CST 2019
2019-08-12 18:20:02.779 CST [11436] DEBUG:  archived write-ahead log file
"00000001000000080000002B.00000028.backup"
2019-08-12 18:20:03.417 CST [11446] LOG:  could not receive data from
client: connect timeout
2019-08-12 18:20:03.417 CST [11446] LOG:  unexpected EOF on standby
connection
2019-08-12 18:20:27.488 CST [11539] DEBUG:  autovacuum: processing database
"postgres"
2019-08-12 18:20:57.497 CST [11541] DEBUG:  autovacuum: processing database
"transfer_tb"
2019-08-12 18:21:27.497 CST [11542] DEBUG:  autovacuum: processing database
"postgres"
2019-08-12 18:21:57.527 CST [11543] DEBUG:  autovacuum: processing database
"transfer_tb"
2019-08-12 18:22:27.499 CST [11544] DEBUG:  autovacuum: processing database
"postgres"
2019-08-12 18:22:57.557 CST [11545] DEBUG:  autovacuum: processing database
"transfer_tb"
2019-08-12 18:23:27.529 CST [11573] DEBUG:  autovacuum: processing database
"postgres"


pgsql-bugs by date:

Previous
From: Arthur Zakirov
Date:
Subject: Re: BUG #15892: URGENT: Using an ICU collation in a primary keycolumn breaks ILIKE query
Next
From: Sandeep Thakkar
Date:
Subject: Re: BUG #15945: error while installing