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)
|
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: