BUG #15949: pg_basebackup failed(PG-12-Beta3)

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: 1726002692(at)qq(dot)com
Subject: BUG #15949: pg_basebackup failed(PG-12-Beta3)
Date: 2019-08-12 10:31:12
Message-ID: 15949-0de04ed5e6b0d57e@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: 15949
Logged by: 强 魏
Email address: 1726002692(at)qq(dot)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(at)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"

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sandeep Thakkar 2019-08-12 10:55:36 Re: BUG #15945: error while installing
Previous Message James Inform 2019-08-12 09:57:00 Re: BUG #15948: TRGM gin index is not be taken into account when using like all (array)