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

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

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

PG Bug reporting form
The following bug has been logged on the website:

Bug reference:      15949
Logged by:          强 魏
Email address:      [hidden email]
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"

Reply | Threaded
Open this post in threaded view
|

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

Jeff Janes
On Mon, Aug 12, 2019 at 6:32 AM PG Bug reporting form <[hidden email]> wrote:
The following bug has been logged on the website:

Bug reference:      15949
Logged by:          强 魏
Email address:      [hidden email]
PostgreSQL version: 12beta3

Did it work in other versions, or is this the only one you tested?
 
Here are the configuration parameters:wal_sender_timeout=0
wal_receiver_timeout

The above looks like an incomplete copy and paste.

Cheers,

Jeff
Reply | Threaded
Open this post in threaded view
|

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

两个孩子的爹
Hi :
I only tested PG-12-Beta 3. 
Backup completed normally, but did not seem to end correctly。
Backup files are generated during the backup process, but nothing is left at the end of the backup process.

[postgres@pg-master ~]$ 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"
WARNING:  skipping special file "./.s.PGSQL.5432"
16904672/16904672 kB (100%), 1/1 tablespace
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/"


Log:
2019-08-13 09:04:02.622 CST [10695] DEBUG:  snapshot of 0+0 running transaction ids (lsn 8/D40000D8 oldest xid 23729 latest complete 23728 next xid 23729)
2019-08-13 09:04:15.815 CST [10691] DEBUG:  forked new backend, pid=10706 socket=10
2019-08-13 09:04:15.822 CST [10706] DEBUG:  postgres child[10706]: starting with (
2019-08-13 09:04:15.822 CST [10706] DEBUG:  postgres
2019-08-13 09:04:15.822 CST [10706] DEBUG:  )
2019-08-13 09:04:15.823 CST [10706] DEBUG:  InitPostgres
2019-08-13 09:04:15.823 CST [10706] DEBUG:  my backend ID is 3
2019-08-13 09:04:15.823 CST [10706] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:15.824 CST [10706] DEBUG:  received password packet
2019-08-13 09:04:15.824 CST [10706] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:15.825 CST [10706] DEBUG:  received replication command: SHOW data_directory_mode
2019-08-13 09:04:15.825 CST [10706] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:15.825 CST [10706] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:15.825 CST [10706] DEBUG:  received replication command: SHOW wal_segment_size
2019-08-13 09:04:15.825 CST [10706] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:15.825 CST [10706] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:15.825 CST [10706] DEBUG:  received replication command: IDENTIFY_SYSTEM
2019-08-13 09:04:15.826 CST [10706] DEBUG:  received replication command: BASE_BACKUP LABEL 'pg_basebackup base backup' PROGRESS  FAST NOWAIT  TABLESPACE_MAP 
2019-08-13 09:04:15.916 CST [10698] DEBUG:  executing archive command "/bin/date"
2019-08-13 09:04:15.917 CST [10694] LOG:  checkpoint starting: immediate force wait
2019-08-13 09:04:15.920 CST [10694] DEBUG:  performing replication slot checkpoint
Tue Aug 13 09:04:15 CST 2019
2019-08-13 09:04:15.922 CST [10698] DEBUG:  archived write-ahead log file "000000010000000800000035"
2019-08-13 09:04:15.934 CST [10694] DEBUG:  snapshot of 0+0 running transaction ids (lsn 8/D8000060 oldest xid 23729 latest complete 23728 next xid 23729)
2019-08-13 09:04:15.934 CST [10694] DEBUG:  creating and filling new WAL file
2019-08-13 09:04:16.656 CST [10694] DEBUG:  done creating and filling new WAL file
2019-08-13 09:04:16.659 CST [10694] DEBUG:  attempting to remove WAL segments older than log file 000000000000000400000035
2019-08-13 09:04:16.659 CST [10694] DEBUG:  SlruScanDirectory invoking callback on pg_subtrans/0000
2019-08-13 09:04:16.659 CST [10694] LOG:  checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.011 s, sync=0.000 s, total=0.741 s; sync files=0, longest=0.000 s, average=0.000 s; distance=65536 kB, estimate=65536 kB
2019-08-13 09:04:16.663 CST [10706] DEBUG:  file "pg_internal.init" excluded from backup
2019-08-13 09:04:16.663 CST [10706] DEBUG:  contents of directory "pg_dynshmem" excluded from backup
2019-08-13 09:04:16.663 CST [10706] DEBUG:  contents of directory "pg_notify" excluded from backup
2019-08-13 09:04:16.663 CST [10706] DEBUG:  contents of directory "pg_serial" excluded from backup
2019-08-13 09:04:16.663 CST [10706] DEBUG:  contents of directory "pg_snapshots" excluded from backup
2019-08-13 09:04:16.663 CST [10706] DEBUG:  contents of directory "pg_subtrans" excluded from backup
2019-08-13 09:04:16.689 CST [10706] DEBUG:  file "pg_internal.init" excluded from backup
2019-08-13 09:04:16.703 CST [10706] DEBUG:  file "pg_internal.init" excluded from backup
2019-08-13 09:04:16.703 CST [10706] DEBUG:  contents of directory "pg_replslot" excluded from backup
2019-08-13 09:04:16.703 CST [10706] DEBUG:  contents of directory "pg_stat_tmp" excluded from backup
2019-08-13 09:04:16.703 CST [10706] DEBUG:  file "postmaster.opts" excluded from backup
2019-08-13 09:04:16.703 CST [10706] DEBUG:  file "postmaster.pid" excluded from backup
2019-08-13 09:04:16.703 CST [10706] WARNING:  skipping special file "./.s.PGSQL.5432"
2019-08-13 09:04:16.705 CST [10691] DEBUG:  forked new backend, pid=10708 socket=10
2019-08-13 09:04:16.708 CST [10708] DEBUG:  postgres child[10708]: starting with (
2019-08-13 09:04:16.708 CST [10708] DEBUG:  postgres
2019-08-13 09:04:16.708 CST [10708] DEBUG:  )
2019-08-13 09:04:16.709 CST [10708] DEBUG:  InitPostgres
2019-08-13 09:04:16.709 CST [10708] DEBUG:  my backend ID is 4
2019-08-13 09:04:16.714 CST [10708] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:16.715 CST [10708] DEBUG:  received password packet
2019-08-13 09:04:16.716 CST [10708] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:16.718 CST [10708] DEBUG:  received replication command: SHOW data_directory_mode
2019-08-13 09:04:16.718 CST [10708] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:16.718 CST [10708] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:16.718 CST [10708] DEBUG:  received replication command: CREATE_REPLICATION_SLOT "pg_basebackup_10708" TEMPORARY PHYSICAL RESERVE_WAL
2019-08-13 09:04:16.723 CST [10708] DEBUG:  received replication command: IDENTIFY_SYSTEM
2019-08-13 09:04:16.723 CST [10708] DEBUG:  received replication command: START_REPLICATION SLOT "pg_basebackup_10708" 8/D8000000 TIMELINE 1
2019-08-13 09:04:16.723 CST [10708] DEBUG:  "pg_basebackup" has now caught up with upstream server
2019-08-13 09:04:16.724 CST [10708] DEBUG:  write 8/D8000000 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:04:16.724102+08
2019-08-13 09:04:16.753 CST [10706] DEBUG:  file "pg_internal.init" excluded from backup
2019-08-13 09:04:16.757 CST [10706] DEBUG:  contents of directory "pg_dynshmem" excluded from backup
2019-08-13 09:04:16.757 CST [10706] DEBUG:  contents of directory "pg_notify" excluded from backup
2019-08-13 09:04:16.757 CST [10706] DEBUG:  contents of directory "pg_serial" excluded from backup
2019-08-13 09:04:16.757 CST [10706] DEBUG:  contents of directory "pg_snapshots" excluded from backup
2019-08-13 09:04:16.757 CST [10706] DEBUG:  contents of directory "pg_subtrans" excluded from backup
2019-08-13 09:04:17.635 CST [10695] DEBUG:  snapshot of 0+0 running transaction ids (lsn 8/D8000110 oldest xid 23729 latest complete 23728 next xid 23729)
2019-08-13 09:04:17.678 CST [10697] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:17.679 CST [10697] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:17.679 CST [10699] DEBUG:  received inquiry for database 0
2019-08-13 09:04:17.679 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:04:17.680 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:04:17.691 CST [10710] DEBUG:  InitPostgres
2019-08-13 09:04:17.691 CST [10710] DEBUG:  my backend ID is 5
2019-08-13 09:04:17.696 CST [10710] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:17.704 CST [10710] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:17.704 CST [10710] DEBUG:  autovacuum: processing database "transfer_tb"
2019-08-13 09:04:17.704 CST [10699] DEBUG:  received inquiry for database 16511
2019-08-13 09:04:17.704 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:04:17.704 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_16511.stat"
2019-08-13 09:04:17.704 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:04:17.715 CST [10710] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:17.716 CST [10710] DEBUG:  pg_statistic: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:17.716 CST [10710] DEBUG:  pg_authid: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:17.716 CST [10710] DEBUG:  pg_attribute: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:17.716 CST [10710] DEBUG:  pg_proc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:17.716 CST [10710] DEBUG:  pg_class: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:17.716 CST [10710] DEBUG:  pg_index: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:17.716 CST [10710] DEBUG:  pg_operator: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:17.716 CST [10710] DEBUG:  pg_opclass: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:17.716 CST [10710] DEBUG:  pg_am: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:17.716 CST [10710] DEBUG:  pg_amop: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:17.716 CST [10710] DEBUG:  pg_amproc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:17.716 CST [10710] DEBUG:  pg_rewrite: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:17.716 CST [10710] DEBUG:  pg_cast: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:17.716 CST [10710] DEBUG:  pg_namespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:17.717 CST [10710] DEBUG:  pg_database: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:17.717 CST [10710] DEBUG:  pg_tablespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:17.717 CST [10710] DEBUG:  pg_type: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:17.717 CST [10710] DEBUG:  galloans_all_tables: vac: 0 (threshold 1000), anl: 1 (threshold 1000)
2019-08-13 09:04:17.717 CST [10710] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:17.717 CST [10710] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2019-08-13 09:04:17.717 CST [10710] DEBUG:  shmem_exit(0): 7 on_shmem_exit callbacks to make
2019-08-13 09:04:17.717 CST [10710] DEBUG:  proc_exit(0): 2 callbacks to make
2019-08-13 09:04:17.717 CST [10710] DEBUG:  exit(0)
2019-08-13 09:04:17.717 CST [10710] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2019-08-13 09:04:17.717 CST [10710] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2019-08-13 09:04:17.717 CST [10710] DEBUG:  proc_exit(-1): 0 callbacks to make
2019-08-13 09:04:17.723 CST [10691] DEBUG:  reaping dead processes
2019-08-13 09:04:17.723 CST [10691] DEBUG:  server process (PID 10710) exited with exit code 0
2019-08-13 09:04:26.731 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:04:26.731102+08
2019-08-13 09:04:36.740 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:04:36.740063+08
2019-08-13 09:04:47.678 CST [10697] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:47.678 CST [10697] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:47.678 CST [10699] DEBUG:  received inquiry for database 0
2019-08-13 09:04:47.678 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:04:47.678 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:04:47.691 CST [10711] DEBUG:  InitPostgres
2019-08-13 09:04:47.692 CST [10711] DEBUG:  my backend ID is 5
2019-08-13 09:04:47.696 CST [10711] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:47.703 CST [10711] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:47.703 CST [10711] DEBUG:  autovacuum: processing database "postgres"
2019-08-13 09:04:47.703 CST [10699] DEBUG:  received inquiry for database 16404
2019-08-13 09:04:47.703 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:04:47.703 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_16404.stat"
2019-08-13 09:04:47.703 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:04:47.715 CST [10711] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:47.716 CST [10711] DEBUG:  pg_statistic: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:47.716 CST [10711] DEBUG:  pg_authid: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:47.716 CST [10711] DEBUG:  pg_attribute: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:47.716 CST [10711] DEBUG:  pg_proc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:47.716 CST [10711] DEBUG:  pg_class: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:47.716 CST [10711] DEBUG:  pg_index: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:47.716 CST [10711] DEBUG:  pg_operator: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:47.716 CST [10711] DEBUG:  pg_opclass: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:47.716 CST [10711] DEBUG:  pg_am: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:47.716 CST [10711] DEBUG:  pg_amop: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:47.716 CST [10711] DEBUG:  pg_amproc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:47.716 CST [10711] DEBUG:  pg_aggregate: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:47.716 CST [10711] DEBUG:  pg_rewrite: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:47.716 CST [10711] DEBUG:  pg_cast: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:47.716 CST [10711] DEBUG:  pg_namespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:47.716 CST [10711] DEBUG:  pg_database: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:47.716 CST [10711] DEBUG:  pg_tablespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:47.716 CST [10711] DEBUG:  pg_type: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:47.716 CST [10711] DEBUG:  pg_collation: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:04:47.717 CST [10711] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:04:47.717 CST [10711] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2019-08-13 09:04:47.717 CST [10711] DEBUG:  shmem_exit(0): 7 on_shmem_exit callbacks to make
2019-08-13 09:04:47.717 CST [10711] DEBUG:  proc_exit(0): 2 callbacks to make
2019-08-13 09:04:47.717 CST [10711] DEBUG:  exit(0)
2019-08-13 09:04:47.717 CST [10711] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2019-08-13 09:04:47.717 CST [10711] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2019-08-13 09:04:47.717 CST [10711] DEBUG:  proc_exit(-1): 0 callbacks to make
2019-08-13 09:04:47.722 CST [10691] DEBUG:  reaping dead processes
2019-08-13 09:04:47.722 CST [10691] DEBUG:  server process (PID 10711) exited with exit code 0
2019-08-13 09:04:47.741 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:04:47.741059+08
2019-08-13 09:04:57.749 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:04:57.749741+08
2019-08-13 09:05:07.759 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:05:07.759138+08
2019-08-13 09:05:17.679 CST [10697] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:05:17.679 CST [10697] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:05:17.679 CST [10699] DEBUG:  received inquiry for database 0
2019-08-13 09:05:17.679 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:05:17.679 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:05:17.693 CST [10712] DEBUG:  InitPostgres
2019-08-13 09:05:17.693 CST [10712] DEBUG:  my backend ID is 5
2019-08-13 09:05:17.698 CST [10712] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:05:17.704 CST [10712] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:05:17.704 CST [10712] DEBUG:  autovacuum: processing database "transfer_tb"
2019-08-13 09:05:17.704 CST [10699] DEBUG:  received inquiry for database 16511
2019-08-13 09:05:17.704 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:05:17.704 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_16511.stat"
2019-08-13 09:05:17.705 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:05:17.716 CST [10712] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:05:17.717 CST [10712] DEBUG:  pg_statistic: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:17.717 CST [10712] DEBUG:  pg_authid: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:17.717 CST [10712] DEBUG:  pg_attribute: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:17.717 CST [10712] DEBUG:  pg_proc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:17.717 CST [10712] DEBUG:  pg_class: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:17.717 CST [10712] DEBUG:  pg_index: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:17.717 CST [10712] DEBUG:  pg_operator: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:17.717 CST [10712] DEBUG:  pg_opclass: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:17.717 CST [10712] DEBUG:  pg_am: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:17.717 CST [10712] DEBUG:  pg_amop: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:17.717 CST [10712] DEBUG:  pg_amproc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:17.717 CST [10712] DEBUG:  pg_rewrite: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:17.717 CST [10712] DEBUG:  pg_cast: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:17.717 CST [10712] DEBUG:  pg_namespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:17.717 CST [10712] DEBUG:  pg_database: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:17.717 CST [10712] DEBUG:  pg_tablespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:17.717 CST [10712] DEBUG:  pg_type: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:17.717 CST [10712] DEBUG:  galloans_all_tables: vac: 0 (threshold 1000), anl: 1 (threshold 1000)
2019-08-13 09:05:17.718 CST [10712] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:05:17.718 CST [10712] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2019-08-13 09:05:17.718 CST [10712] DEBUG:  shmem_exit(0): 7 on_shmem_exit callbacks to make
2019-08-13 09:05:17.718 CST [10712] DEBUG:  proc_exit(0): 2 callbacks to make
2019-08-13 09:05:17.718 CST [10712] DEBUG:  exit(0)
2019-08-13 09:05:17.718 CST [10712] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2019-08-13 09:05:17.718 CST [10712] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2019-08-13 09:05:17.718 CST [10712] DEBUG:  proc_exit(-1): 0 callbacks to make
2019-08-13 09:05:17.723 CST [10691] DEBUG:  reaping dead processes
2019-08-13 09:05:17.723 CST [10691] DEBUG:  server process (PID 10712) exited with exit code 0
2019-08-13 09:05:17.767 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:05:17.767855+08
2019-08-13 09:05:27.777 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:05:27.777122+08
2019-08-13 09:05:37.786 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:05:37.7864+08
2019-08-13 09:05:47.707 CST [10697] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:05:47.707 CST [10697] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:05:47.708 CST [10699] DEBUG:  received inquiry for database 0
2019-08-13 09:05:47.708 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:05:47.708 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:05:47.720 CST [10713] DEBUG:  InitPostgres
2019-08-13 09:05:47.720 CST [10713] DEBUG:  my backend ID is 5
2019-08-13 09:05:47.724 CST [10713] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:05:47.730 CST [10713] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:05:47.730 CST [10713] DEBUG:  autovacuum: processing database "postgres"
2019-08-13 09:05:47.731 CST [10699] DEBUG:  received inquiry for database 16404
2019-08-13 09:05:47.731 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:05:47.731 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_16404.stat"
2019-08-13 09:05:47.731 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:05:47.742 CST [10713] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:05:47.743 CST [10713] DEBUG:  pg_statistic: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:47.743 CST [10713] DEBUG:  pg_authid: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:47.743 CST [10713] DEBUG:  pg_attribute: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:47.743 CST [10713] DEBUG:  pg_proc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:47.743 CST [10713] DEBUG:  pg_class: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:47.743 CST [10713] DEBUG:  pg_index: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:47.743 CST [10713] DEBUG:  pg_operator: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:47.743 CST [10713] DEBUG:  pg_opclass: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:47.743 CST [10713] DEBUG:  pg_am: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:47.743 CST [10713] DEBUG:  pg_amop: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:47.743 CST [10713] DEBUG:  pg_amproc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:47.743 CST [10713] DEBUG:  pg_aggregate: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:47.743 CST [10713] DEBUG:  pg_rewrite: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:47.743 CST [10713] DEBUG:  pg_cast: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:47.743 CST [10713] DEBUG:  pg_namespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:47.743 CST [10713] DEBUG:  pg_database: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:47.743 CST [10713] DEBUG:  pg_tablespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:47.743 CST [10713] DEBUG:  pg_type: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:47.743 CST [10713] DEBUG:  pg_collation: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:05:47.744 CST [10713] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:05:47.744 CST [10713] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2019-08-13 09:05:47.744 CST [10713] DEBUG:  shmem_exit(0): 7 on_shmem_exit callbacks to make
2019-08-13 09:05:47.744 CST [10713] DEBUG:  proc_exit(0): 2 callbacks to make
2019-08-13 09:05:47.744 CST [10713] DEBUG:  exit(0)
2019-08-13 09:05:47.744 CST [10713] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2019-08-13 09:05:47.744 CST [10713] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2019-08-13 09:05:47.744 CST [10713] DEBUG:  proc_exit(-1): 0 callbacks to make
2019-08-13 09:05:47.749 CST [10691] DEBUG:  reaping dead processes
2019-08-13 09:05:47.749 CST [10691] DEBUG:  server process (PID 10713) exited with exit code 0
2019-08-13 09:05:47.795 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:05:47.795653+08
2019-08-13 09:05:57.805 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:05:57.804988+08
2019-08-13 09:06:05.531 CST [10706] DEBUG:  file "pg_internal.init" excluded from backup
2019-08-13 09:06:07.812 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:06:07.812315+08
2019-08-13 09:06:17.708 CST [10697] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:06:17.708 CST [10697] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:06:17.709 CST [10699] DEBUG:  received inquiry for database 0
2019-08-13 09:06:17.709 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:06:17.709 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:06:17.722 CST [10716] DEBUG:  InitPostgres
2019-08-13 09:06:17.722 CST [10716] DEBUG:  my backend ID is 5
2019-08-13 09:06:17.728 CST [10716] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:06:17.735 CST [10716] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:06:17.735 CST [10716] DEBUG:  autovacuum: processing database "transfer_tb"
2019-08-13 09:06:17.735 CST [10699] DEBUG:  received inquiry for database 16511
2019-08-13 09:06:17.735 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:06:17.735 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_16511.stat"
2019-08-13 09:06:17.736 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:06:17.747 CST [10716] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:06:17.748 CST [10716] DEBUG:  pg_statistic: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:17.748 CST [10716] DEBUG:  pg_authid: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:17.748 CST [10716] DEBUG:  pg_attribute: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:17.748 CST [10716] DEBUG:  pg_proc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:17.748 CST [10716] DEBUG:  pg_class: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:17.748 CST [10716] DEBUG:  pg_index: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:17.748 CST [10716] DEBUG:  pg_operator: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:17.748 CST [10716] DEBUG:  pg_opclass: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:17.748 CST [10716] DEBUG:  pg_am: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:17.748 CST [10716] DEBUG:  pg_amop: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:17.748 CST [10716] DEBUG:  pg_amproc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:17.748 CST [10716] DEBUG:  pg_rewrite: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:17.748 CST [10716] DEBUG:  pg_cast: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:17.748 CST [10716] DEBUG:  pg_namespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:17.748 CST [10716] DEBUG:  pg_database: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:17.748 CST [10716] DEBUG:  pg_tablespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:17.748 CST [10716] DEBUG:  pg_type: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:17.749 CST [10716] DEBUG:  galloans_all_tables: vac: 0 (threshold 1000), anl: 1 (threshold 1000)
2019-08-13 09:06:17.749 CST [10716] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:06:17.749 CST [10716] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2019-08-13 09:06:17.749 CST [10716] DEBUG:  shmem_exit(0): 7 on_shmem_exit callbacks to make
2019-08-13 09:06:17.749 CST [10716] DEBUG:  proc_exit(0): 2 callbacks to make
2019-08-13 09:06:17.749 CST [10716] DEBUG:  exit(0)
2019-08-13 09:06:17.749 CST [10716] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2019-08-13 09:06:17.749 CST [10716] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2019-08-13 09:06:17.749 CST [10716] DEBUG:  proc_exit(-1): 0 callbacks to make
2019-08-13 09:06:17.756 CST [10691] DEBUG:  reaping dead processes
2019-08-13 09:06:17.756 CST [10691] DEBUG:  server process (PID 10716) exited with exit code 0
2019-08-13 09:06:17.820 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:06:17.820776+08
2019-08-13 09:06:27.829 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:06:27.829775+08
2019-08-13 09:06:37.839 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:06:37.839116+08
2019-08-13 09:06:47.737 CST [10697] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:06:47.738 CST [10697] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:06:47.738 CST [10699] DEBUG:  received inquiry for database 0
2019-08-13 09:06:47.738 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:06:47.738 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:06:47.739 CST [10701] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:06:47.739 CST [10701] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:06:47.751 CST [10718] DEBUG:  InitPostgres
2019-08-13 09:06:47.751 CST [10718] DEBUG:  my backend ID is 5
2019-08-13 09:06:47.756 CST [10718] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:06:47.763 CST [10718] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:06:47.764 CST [10718] DEBUG:  autovacuum: processing database "postgres"
2019-08-13 09:06:47.764 CST [10699] DEBUG:  received inquiry for database 16404
2019-08-13 09:06:47.764 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:06:47.764 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_16404.stat"
2019-08-13 09:06:47.764 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:06:47.776 CST [10718] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:06:47.777 CST [10718] DEBUG:  pg_statistic: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:47.777 CST [10718] DEBUG:  pg_authid: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:47.777 CST [10718] DEBUG:  pg_attribute: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:47.777 CST [10718] DEBUG:  pg_proc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:47.777 CST [10718] DEBUG:  pg_class: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:47.777 CST [10718] DEBUG:  pg_index: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:47.777 CST [10718] DEBUG:  pg_operator: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:47.777 CST [10718] DEBUG:  pg_opclass: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:47.777 CST [10718] DEBUG:  pg_am: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:47.777 CST [10718] DEBUG:  pg_amop: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:47.777 CST [10718] DEBUG:  pg_amproc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:47.777 CST [10718] DEBUG:  pg_aggregate: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:47.777 CST [10718] DEBUG:  pg_rewrite: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:47.777 CST [10718] DEBUG:  pg_cast: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:47.777 CST [10718] DEBUG:  pg_namespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:47.777 CST [10718] DEBUG:  pg_database: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:47.777 CST [10718] DEBUG:  pg_tablespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:47.777 CST [10718] DEBUG:  pg_type: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:47.777 CST [10718] DEBUG:  pg_collation: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:06:47.778 CST [10718] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:06:47.778 CST [10718] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2019-08-13 09:06:47.778 CST [10718] DEBUG:  shmem_exit(0): 7 on_shmem_exit callbacks to make
2019-08-13 09:06:47.778 CST [10718] DEBUG:  proc_exit(0): 2 callbacks to make
2019-08-13 09:06:47.778 CST [10718] DEBUG:  exit(0)
2019-08-13 09:06:47.778 CST [10718] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2019-08-13 09:06:47.778 CST [10718] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2019-08-13 09:06:47.778 CST [10718] DEBUG:  proc_exit(-1): 0 callbacks to make
2019-08-13 09:06:47.783 CST [10691] DEBUG:  reaping dead processes
2019-08-13 09:06:47.784 CST [10691] DEBUG:  server process (PID 10718) exited with exit code 0
2019-08-13 09:06:47.848 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:06:47.848379+08
2019-08-13 09:06:57.857 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:06:57.857699+08
2019-08-13 09:07:07.867 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:07:07.866963+08
2019-08-13 09:07:17.738 CST [10697] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:07:17.738 CST [10697] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:07:17.739 CST [10699] DEBUG:  received inquiry for database 0
2019-08-13 09:07:17.739 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:07:17.739 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:07:17.752 CST [10719] DEBUG:  InitPostgres
2019-08-13 09:07:17.752 CST [10719] DEBUG:  my backend ID is 5
2019-08-13 09:07:17.757 CST [10719] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:07:17.763 CST [10719] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:07:17.763 CST [10719] DEBUG:  autovacuum: processing database "transfer_tb"
2019-08-13 09:07:17.763 CST [10699] DEBUG:  received inquiry for database 16511
2019-08-13 09:07:17.763 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:07:17.763 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_16511.stat"
2019-08-13 09:07:17.764 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:07:17.775 CST [10719] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:07:17.776 CST [10719] DEBUG:  pg_statistic: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:17.776 CST [10719] DEBUG:  pg_authid: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:17.776 CST [10719] DEBUG:  pg_attribute: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:17.776 CST [10719] DEBUG:  pg_proc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:17.776 CST [10719] DEBUG:  pg_class: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:17.776 CST [10719] DEBUG:  pg_index: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:17.776 CST [10719] DEBUG:  pg_operator: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:17.776 CST [10719] DEBUG:  pg_opclass: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:17.776 CST [10719] DEBUG:  pg_am: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:17.776 CST [10719] DEBUG:  pg_amop: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:17.776 CST [10719] DEBUG:  pg_amproc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:17.776 CST [10719] DEBUG:  pg_rewrite: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:17.776 CST [10719] DEBUG:  pg_cast: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:17.776 CST [10719] DEBUG:  pg_namespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:17.776 CST [10719] DEBUG:  pg_database: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:17.776 CST [10719] DEBUG:  pg_tablespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:17.776 CST [10719] DEBUG:  pg_type: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:17.776 CST [10719] DEBUG:  galloans_all_tables: vac: 0 (threshold 1000), anl: 1 (threshold 1000)
2019-08-13 09:07:17.776 CST [10719] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:07:17.776 CST [10719] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2019-08-13 09:07:17.776 CST [10719] DEBUG:  shmem_exit(0): 7 on_shmem_exit callbacks to make
2019-08-13 09:07:17.777 CST [10719] DEBUG:  proc_exit(0): 2 callbacks to make
2019-08-13 09:07:17.777 CST [10719] DEBUG:  exit(0)
2019-08-13 09:07:17.777 CST [10719] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2019-08-13 09:07:17.777 CST [10719] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2019-08-13 09:07:17.777 CST [10719] DEBUG:  proc_exit(-1): 0 callbacks to make
2019-08-13 09:07:17.782 CST [10691] DEBUG:  reaping dead processes
2019-08-13 09:07:17.782 CST [10691] DEBUG:  server process (PID 10719) exited with exit code 0
2019-08-13 09:07:17.876 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:07:17.876262+08
2019-08-13 09:07:27.884 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:07:27.884735+08
2019-08-13 09:07:37.894 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:07:37.894296+08
2019-08-13 09:07:47.767 CST [10697] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:07:47.767 CST [10697] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:07:47.767 CST [10699] DEBUG:  received inquiry for database 0
2019-08-13 09:07:47.767 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:07:47.768 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:07:47.780 CST [10720] DEBUG:  InitPostgres
2019-08-13 09:07:47.780 CST [10720] DEBUG:  my backend ID is 5
2019-08-13 09:07:47.782 CST [10720] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:07:47.790 CST [10720] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:07:47.790 CST [10720] DEBUG:  autovacuum: processing database "postgres"
2019-08-13 09:07:47.791 CST [10699] DEBUG:  received inquiry for database 16404
2019-08-13 09:07:47.791 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:07:47.791 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_16404.stat"
2019-08-13 09:07:47.792 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:07:47.801 CST [10720] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:07:47.802 CST [10720] DEBUG:  pg_statistic: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:47.802 CST [10720] DEBUG:  pg_authid: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:47.803 CST [10720] DEBUG:  pg_attribute: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:47.803 CST [10720] DEBUG:  pg_proc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:47.803 CST [10720] DEBUG:  pg_class: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:47.803 CST [10720] DEBUG:  pg_index: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:47.803 CST [10720] DEBUG:  pg_operator: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:47.803 CST [10720] DEBUG:  pg_opclass: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:47.803 CST [10720] DEBUG:  pg_am: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:47.803 CST [10720] DEBUG:  pg_amop: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:47.803 CST [10720] DEBUG:  pg_amproc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:47.803 CST [10720] DEBUG:  pg_aggregate: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:47.803 CST [10720] DEBUG:  pg_rewrite: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:47.803 CST [10720] DEBUG:  pg_cast: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:47.803 CST [10720] DEBUG:  pg_namespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:47.803 CST [10720] DEBUG:  pg_database: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:47.803 CST [10720] DEBUG:  pg_tablespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:47.803 CST [10720] DEBUG:  pg_type: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:47.803 CST [10720] DEBUG:  pg_collation: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:07:47.803 CST [10720] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:07:47.804 CST [10720] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2019-08-13 09:07:47.804 CST [10720] DEBUG:  shmem_exit(0): 7 on_shmem_exit callbacks to make
2019-08-13 09:07:47.804 CST [10720] DEBUG:  proc_exit(0): 2 callbacks to make
2019-08-13 09:07:47.804 CST [10720] DEBUG:  exit(0)
2019-08-13 09:07:47.804 CST [10720] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2019-08-13 09:07:47.804 CST [10720] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2019-08-13 09:07:47.804 CST [10720] DEBUG:  proc_exit(-1): 0 callbacks to make
2019-08-13 09:07:47.809 CST [10691] DEBUG:  reaping dead processes
2019-08-13 09:07:47.809 CST [10691] DEBUG:  server process (PID 10720) exited with exit code 0
2019-08-13 09:07:47.896 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:07:47.89665+08
2019-08-13 09:07:57.906 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:07:57.90601+08
2019-08-13 09:08:07.915 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:08:07.914967+08
2019-08-13 09:08:17.769 CST [10697] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:08:17.769 CST [10697] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:08:17.769 CST [10699] DEBUG:  received inquiry for database 0
2019-08-13 09:08:17.769 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:08:17.769 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:08:17.781 CST [10721] DEBUG:  InitPostgres
2019-08-13 09:08:17.781 CST [10721] DEBUG:  my backend ID is 5
2019-08-13 09:08:17.784 CST [10721] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:08:17.791 CST [10721] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:08:17.791 CST [10721] DEBUG:  autovacuum: processing database "transfer_tb"
2019-08-13 09:08:17.792 CST [10699] DEBUG:  received inquiry for database 16511
2019-08-13 09:08:17.792 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:08:17.792 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_16511.stat"
2019-08-13 09:08:17.792 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:08:17.803 CST [10721] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:08:17.803 CST [10721] DEBUG:  pg_statistic: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:17.804 CST [10721] DEBUG:  pg_authid: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:17.804 CST [10721] DEBUG:  pg_attribute: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:17.804 CST [10721] DEBUG:  pg_proc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:17.804 CST [10721] DEBUG:  pg_class: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:17.804 CST [10721] DEBUG:  pg_index: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:17.804 CST [10721] DEBUG:  pg_operator: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:17.804 CST [10721] DEBUG:  pg_opclass: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:17.804 CST [10721] DEBUG:  pg_am: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:17.804 CST [10721] DEBUG:  pg_amop: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:17.804 CST [10721] DEBUG:  pg_amproc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:17.804 CST [10721] DEBUG:  pg_rewrite: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:17.804 CST [10721] DEBUG:  pg_cast: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:17.804 CST [10721] DEBUG:  pg_namespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:17.804 CST [10721] DEBUG:  pg_database: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:17.804 CST [10721] DEBUG:  pg_tablespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:17.804 CST [10721] DEBUG:  pg_type: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:17.804 CST [10721] DEBUG:  galloans_all_tables: vac: 0 (threshold 1000), anl: 1 (threshold 1000)
2019-08-13 09:08:17.804 CST [10721] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:08:17.804 CST [10721] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2019-08-13 09:08:17.804 CST [10721] DEBUG:  shmem_exit(0): 7 on_shmem_exit callbacks to make
2019-08-13 09:08:17.804 CST [10721] DEBUG:  proc_exit(0): 2 callbacks to make
2019-08-13 09:08:17.804 CST [10721] DEBUG:  exit(0)
2019-08-13 09:08:17.804 CST [10721] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2019-08-13 09:08:17.804 CST [10721] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2019-08-13 09:08:17.804 CST [10721] DEBUG:  proc_exit(-1): 0 callbacks to make
2019-08-13 09:08:17.809 CST [10691] DEBUG:  reaping dead processes
2019-08-13 09:08:17.809 CST [10691] DEBUG:  server process (PID 10721) exited with exit code 0
2019-08-13 09:08:17.924 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:08:17.924634+08
2019-08-13 09:08:27.934 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:08:27.933774+08
2019-08-13 09:08:37.943 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:08:37.943172+08
2019-08-13 09:08:47.797 CST [10697] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:08:47.797 CST [10697] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:08:47.797 CST [10699] DEBUG:  received inquiry for database 0
2019-08-13 09:08:47.797 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:08:47.797 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:08:47.810 CST [10722] DEBUG:  InitPostgres
2019-08-13 09:08:47.810 CST [10722] DEBUG:  my backend ID is 5
2019-08-13 09:08:47.815 CST [10722] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:08:47.822 CST [10722] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:08:47.822 CST [10722] DEBUG:  autovacuum: processing database "postgres"
2019-08-13 09:08:47.823 CST [10699] DEBUG:  received inquiry for database 16404
2019-08-13 09:08:47.823 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:08:47.823 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_16404.stat"
2019-08-13 09:08:47.823 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:08:47.835 CST [10722] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:08:47.836 CST [10722] DEBUG:  pg_statistic: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:47.836 CST [10722] DEBUG:  pg_authid: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:47.836 CST [10722] DEBUG:  pg_attribute: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:47.836 CST [10722] DEBUG:  pg_proc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:47.836 CST [10722] DEBUG:  pg_class: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:47.836 CST [10722] DEBUG:  pg_index: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:47.836 CST [10722] DEBUG:  pg_operator: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:47.836 CST [10722] DEBUG:  pg_opclass: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:47.836 CST [10722] DEBUG:  pg_am: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:47.836 CST [10722] DEBUG:  pg_amop: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:47.836 CST [10722] DEBUG:  pg_amproc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:47.836 CST [10722] DEBUG:  pg_aggregate: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:47.836 CST [10722] DEBUG:  pg_rewrite: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:47.836 CST [10722] DEBUG:  pg_cast: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:47.836 CST [10722] DEBUG:  pg_namespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:47.836 CST [10722] DEBUG:  pg_database: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:47.836 CST [10722] DEBUG:  pg_tablespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:47.836 CST [10722] DEBUG:  pg_type: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:47.836 CST [10722] DEBUG:  pg_collation: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:08:47.837 CST [10722] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:08:47.837 CST [10722] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2019-08-13 09:08:47.837 CST [10722] DEBUG:  shmem_exit(0): 7 on_shmem_exit callbacks to make
2019-08-13 09:08:47.837 CST [10722] DEBUG:  proc_exit(0): 2 callbacks to make
2019-08-13 09:08:47.837 CST [10722] DEBUG:  exit(0)
2019-08-13 09:08:47.837 CST [10722] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2019-08-13 09:08:47.837 CST [10722] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2019-08-13 09:08:47.837 CST [10722] DEBUG:  proc_exit(-1): 0 callbacks to make
2019-08-13 09:08:47.843 CST [10691] DEBUG:  reaping dead processes
2019-08-13 09:08:47.843 CST [10691] DEBUG:  server process (PID 10722) exited with exit code 0
2019-08-13 09:08:47.952 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:08:47.952529+08
2019-08-13 09:08:57.960 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:08:57.959913+08
2019-08-13 09:09:07.960 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:09:07.959962+08
2019-08-13 09:09:17.798 CST [10697] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:09:17.798 CST [10697] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:09:17.798 CST [10699] DEBUG:  received inquiry for database 0
2019-08-13 09:09:17.799 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:09:17.799 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:09:17.812 CST [10723] DEBUG:  InitPostgres
2019-08-13 09:09:17.812 CST [10723] DEBUG:  my backend ID is 5
2019-08-13 09:09:17.816 CST [10723] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:09:17.821 CST [10723] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:09:17.821 CST [10723] DEBUG:  autovacuum: processing database "transfer_tb"
2019-08-13 09:09:17.821 CST [10699] DEBUG:  received inquiry for database 16511
2019-08-13 09:09:17.821 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:09:17.821 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_16511.stat"
2019-08-13 09:09:17.821 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:09:17.832 CST [10723] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:09:17.833 CST [10723] DEBUG:  pg_statistic: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:17.833 CST [10723] DEBUG:  pg_authid: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:17.833 CST [10723] DEBUG:  pg_attribute: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:17.833 CST [10723] DEBUG:  pg_proc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:17.833 CST [10723] DEBUG:  pg_class: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:17.833 CST [10723] DEBUG:  pg_index: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:17.833 CST [10723] DEBUG:  pg_operator: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:17.833 CST [10723] DEBUG:  pg_opclass: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:17.833 CST [10723] DEBUG:  pg_am: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:17.833 CST [10723] DEBUG:  pg_amop: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:17.833 CST [10723] DEBUG:  pg_amproc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:17.833 CST [10723] DEBUG:  pg_rewrite: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:17.833 CST [10723] DEBUG:  pg_cast: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:17.833 CST [10723] DEBUG:  pg_namespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:17.833 CST [10723] DEBUG:  pg_database: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:17.833 CST [10723] DEBUG:  pg_tablespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:17.833 CST [10723] DEBUG:  pg_type: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:17.833 CST [10723] DEBUG:  galloans_all_tables: vac: 0 (threshold 1000), anl: 1 (threshold 1000)
2019-08-13 09:09:17.834 CST [10723] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:09:17.834 CST [10723] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2019-08-13 09:09:17.834 CST [10723] DEBUG:  shmem_exit(0): 7 on_shmem_exit callbacks to make
2019-08-13 09:09:17.834 CST [10723] DEBUG:  proc_exit(0): 2 callbacks to make
2019-08-13 09:09:17.834 CST [10723] DEBUG:  exit(0)
2019-08-13 09:09:17.834 CST [10723] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2019-08-13 09:09:17.834 CST [10723] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2019-08-13 09:09:17.834 CST [10723] DEBUG:  proc_exit(-1): 0 callbacks to make
2019-08-13 09:09:17.839 CST [10691] DEBUG:  reaping dead processes
2019-08-13 09:09:17.839 CST [10691] DEBUG:  server process (PID 10723) exited with exit code 0
2019-08-13 09:09:17.969 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:09:17.969253+08
2019-08-13 09:09:27.978 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:09:27.978488+08
2019-08-13 09:09:37.987 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:09:37.987803+08
2019-08-13 09:09:47.801 CST [10701] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:09:47.801 CST [10701] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:09:47.805 CST [10697] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:09:47.805 CST [10697] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:09:47.805 CST [10699] DEBUG:  received inquiry for database 0
2019-08-13 09:09:47.805 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:09:47.805 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:09:47.819 CST [10724] DEBUG:  InitPostgres
2019-08-13 09:09:47.819 CST [10724] DEBUG:  my backend ID is 5
2019-08-13 09:09:47.824 CST [10724] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:09:47.830 CST [10724] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:09:47.830 CST [10724] DEBUG:  autovacuum: processing database "postgres"
2019-08-13 09:09:47.830 CST [10699] DEBUG:  received inquiry for database 16404
2019-08-13 09:09:47.830 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:09:47.830 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_16404.stat"
2019-08-13 09:09:47.831 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:09:47.842 CST [10724] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:09:47.843 CST [10724] DEBUG:  pg_statistic: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:47.843 CST [10724] DEBUG:  pg_authid: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:47.843 CST [10724] DEBUG:  pg_attribute: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:47.843 CST [10724] DEBUG:  pg_proc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:47.843 CST [10724] DEBUG:  pg_class: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:47.843 CST [10724] DEBUG:  pg_index: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:47.843 CST [10724] DEBUG:  pg_operator: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:47.843 CST [10724] DEBUG:  pg_opclass: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:47.843 CST [10724] DEBUG:  pg_am: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:47.843 CST [10724] DEBUG:  pg_amop: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:47.843 CST [10724] DEBUG:  pg_amproc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:47.843 CST [10724] DEBUG:  pg_aggregate: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:47.843 CST [10724] DEBUG:  pg_rewrite: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:47.843 CST [10724] DEBUG:  pg_cast: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:47.843 CST [10724] DEBUG:  pg_namespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:47.843 CST [10724] DEBUG:  pg_database: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:47.843 CST [10724] DEBUG:  pg_tablespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:47.843 CST [10724] DEBUG:  pg_type: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:47.843 CST [10724] DEBUG:  pg_collation: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:09:47.844 CST [10724] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:09:47.844 CST [10724] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2019-08-13 09:09:47.844 CST [10724] DEBUG:  shmem_exit(0): 7 on_shmem_exit callbacks to make
2019-08-13 09:09:47.844 CST [10724] DEBUG:  proc_exit(0): 2 callbacks to make
2019-08-13 09:09:47.844 CST [10724] DEBUG:  exit(0)
2019-08-13 09:09:47.844 CST [10724] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2019-08-13 09:09:47.844 CST [10724] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2019-08-13 09:09:47.844 CST [10724] DEBUG:  proc_exit(-1): 0 callbacks to make
2019-08-13 09:09:47.849 CST [10691] DEBUG:  reaping dead processes
2019-08-13 09:09:47.849 CST [10691] DEBUG:  server process (PID 10724) exited with exit code 0
2019-08-13 09:09:47.997 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:09:47.997071+08
2019-08-13 09:09:58.006 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:09:58.006298+08
2019-08-13 09:10:08.015 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:10:08.01528+08
2019-08-13 09:10:17.820 CST [10697] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:10:17.820 CST [10697] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:10:17.820 CST [10699] DEBUG:  received inquiry for database 0
2019-08-13 09:10:17.820 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:10:17.820 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:10:17.835 CST [10754] DEBUG:  InitPostgres
2019-08-13 09:10:17.835 CST [10754] DEBUG:  my backend ID is 5
2019-08-13 09:10:17.844 CST [10754] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:10:17.854 CST [10754] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:10:17.854 CST [10754] DEBUG:  autovacuum: processing database "transfer_tb"
2019-08-13 09:10:17.854 CST [10699] DEBUG:  received inquiry for database 16511
2019-08-13 09:10:17.855 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:10:17.855 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_16511.stat"
2019-08-13 09:10:17.856 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:10:17.866 CST [10754] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:10:17.867 CST [10754] DEBUG:  pg_statistic: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:17.868 CST [10754] DEBUG:  pg_authid: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:17.868 CST [10754] DEBUG:  pg_attribute: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:17.868 CST [10754] DEBUG:  pg_proc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:17.868 CST [10754] DEBUG:  pg_class: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:17.868 CST [10754] DEBUG:  pg_index: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:17.868 CST [10754] DEBUG:  pg_operator: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:17.868 CST [10754] DEBUG:  pg_opclass: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:17.868 CST [10754] DEBUG:  pg_am: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:17.868 CST [10754] DEBUG:  pg_amop: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:17.868 CST [10754] DEBUG:  pg_amproc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:17.868 CST [10754] DEBUG:  pg_rewrite: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:17.868 CST [10754] DEBUG:  pg_cast: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:17.868 CST [10754] DEBUG:  pg_namespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:17.868 CST [10754] DEBUG:  pg_database: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:17.868 CST [10754] DEBUG:  pg_tablespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:17.868 CST [10754] DEBUG:  pg_type: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:17.868 CST [10754] DEBUG:  galloans_all_tables: vac: 0 (threshold 1000), anl: 1 (threshold 1000)
2019-08-13 09:10:17.868 CST [10754] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:10:17.868 CST [10754] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2019-08-13 09:10:17.868 CST [10754] DEBUG:  shmem_exit(0): 7 on_shmem_exit callbacks to make
2019-08-13 09:10:17.868 CST [10754] DEBUG:  proc_exit(0): 2 callbacks to make
2019-08-13 09:10:17.868 CST [10754] DEBUG:  exit(0)
2019-08-13 09:10:17.868 CST [10754] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2019-08-13 09:10:17.868 CST [10754] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2019-08-13 09:10:17.868 CST [10754] DEBUG:  proc_exit(-1): 0 callbacks to make
2019-08-13 09:10:17.875 CST [10691] DEBUG:  reaping dead processes
2019-08-13 09:10:17.875 CST [10691] DEBUG:  server process (PID 10754) exited with exit code 0
2019-08-13 09:10:18.023 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:10:18.023704+08
2019-08-13 09:10:28.024 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:10:28.024112+08
2019-08-13 09:10:38.033 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:10:38.033276+08
2019-08-13 09:10:47.816 CST [10697] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:10:47.817 CST [10697] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:10:47.817 CST [10699] DEBUG:  received inquiry for database 0
2019-08-13 09:10:47.817 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:10:47.817 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:10:47.845 CST [10755] DEBUG:  InitPostgres
2019-08-13 09:10:47.845 CST [10755] DEBUG:  my backend ID is 5
2019-08-13 09:10:47.849 CST [10755] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:10:47.859 CST [10755] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:10:47.859 CST [10755] DEBUG:  autovacuum: processing database "postgres"
2019-08-13 09:10:47.859 CST [10699] DEBUG:  received inquiry for database 16404
2019-08-13 09:10:47.859 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:10:47.859 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_16404.stat"
2019-08-13 09:10:47.860 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:10:47.872 CST [10755] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:10:47.873 CST [10755] DEBUG:  pg_statistic: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:47.873 CST [10755] DEBUG:  pg_authid: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:47.873 CST [10755] DEBUG:  pg_attribute: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:47.873 CST [10755] DEBUG:  pg_proc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:47.873 CST [10755] DEBUG:  pg_class: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:47.873 CST [10755] DEBUG:  pg_index: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:47.873 CST [10755] DEBUG:  pg_operator: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:47.873 CST [10755] DEBUG:  pg_opclass: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:47.873 CST [10755] DEBUG:  pg_am: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:47.873 CST [10755] DEBUG:  pg_amop: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:47.873 CST [10755] DEBUG:  pg_amproc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:47.873 CST [10755] DEBUG:  pg_aggregate: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:47.873 CST [10755] DEBUG:  pg_rewrite: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:47.873 CST [10755] DEBUG:  pg_cast: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:47.873 CST [10755] DEBUG:  pg_namespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:47.873 CST [10755] DEBUG:  pg_database: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:47.873 CST [10755] DEBUG:  pg_tablespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:47.873 CST [10755] DEBUG:  pg_type: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:47.873 CST [10755] DEBUG:  pg_collation: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:10:47.874 CST [10755] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:10:47.874 CST [10755] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2019-08-13 09:10:47.874 CST [10755] DEBUG:  shmem_exit(0): 7 on_shmem_exit callbacks to make
2019-08-13 09:10:47.874 CST [10755] DEBUG:  proc_exit(0): 2 callbacks to make
2019-08-13 09:10:47.874 CST [10755] DEBUG:  exit(0)
2019-08-13 09:10:47.874 CST [10755] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2019-08-13 09:10:47.874 CST [10755] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2019-08-13 09:10:47.874 CST [10755] DEBUG:  proc_exit(-1): 0 callbacks to make
2019-08-13 09:10:47.880 CST [10691] DEBUG:  reaping dead processes
2019-08-13 09:10:47.880 CST [10691] DEBUG:  server process (PID 10755) exited with exit code 0
2019-08-13 09:10:48.042 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:10:48.041876+08
2019-08-13 09:10:59.042 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:10:59.042162+08
2019-08-13 09:11:09.068 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:11:09.06873+08
2019-08-13 09:11:17.848 CST [10697] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:11:17.848 CST [10697] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:11:17.849 CST [10699] DEBUG:  received inquiry for database 0
2019-08-13 09:11:17.849 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:11:17.849 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:11:17.866 CST [10757] DEBUG:  InitPostgres
2019-08-13 09:11:17.866 CST [10757] DEBUG:  my backend ID is 5
2019-08-13 09:11:17.875 CST [10757] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:11:17.884 CST [10757] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:11:17.884 CST [10757] DEBUG:  autovacuum: processing database "transfer_tb"
2019-08-13 09:11:17.884 CST [10699] DEBUG:  received inquiry for database 16511
2019-08-13 09:11:17.884 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:11:17.884 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_16511.stat"
2019-08-13 09:11:17.885 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:11:17.896 CST [10757] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:11:17.897 CST [10757] DEBUG:  pg_statistic: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:17.897 CST [10757] DEBUG:  pg_authid: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:17.897 CST [10757] DEBUG:  pg_attribute: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:17.897 CST [10757] DEBUG:  pg_proc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:17.897 CST [10757] DEBUG:  pg_class: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:17.897 CST [10757] DEBUG:  pg_index: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:17.897 CST [10757] DEBUG:  pg_operator: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:17.897 CST [10757] DEBUG:  pg_opclass: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:17.897 CST [10757] DEBUG:  pg_am: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:17.898 CST [10757] DEBUG:  pg_amop: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:17.898 CST [10757] DEBUG:  pg_amproc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:17.898 CST [10757] DEBUG:  pg_rewrite: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:17.898 CST [10757] DEBUG:  pg_cast: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:17.898 CST [10757] DEBUG:  pg_namespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:17.898 CST [10757] DEBUG:  pg_database: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:17.898 CST [10757] DEBUG:  pg_tablespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:17.898 CST [10757] DEBUG:  pg_type: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:17.898 CST [10757] DEBUG:  galloans_all_tables: vac: 0 (threshold 1000), anl: 1 (threshold 1000)
2019-08-13 09:11:17.898 CST [10757] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:11:17.898 CST [10757] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2019-08-13 09:11:17.898 CST [10757] DEBUG:  shmem_exit(0): 7 on_shmem_exit callbacks to make
2019-08-13 09:11:17.898 CST [10757] DEBUG:  proc_exit(0): 2 callbacks to make
2019-08-13 09:11:17.898 CST [10757] DEBUG:  exit(0)
2019-08-13 09:11:17.898 CST [10757] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2019-08-13 09:11:17.898 CST [10757] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2019-08-13 09:11:17.898 CST [10757] DEBUG:  proc_exit(-1): 0 callbacks to make
2019-08-13 09:11:17.906 CST [10691] DEBUG:  reaping dead processes
2019-08-13 09:11:17.906 CST [10691] DEBUG:  server process (PID 10757) exited with exit code 0
2019-08-13 09:11:19.080 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:11:19.080392+08
2019-08-13 09:11:29.086 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:11:29.080999+08
2019-08-13 09:11:39.090 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:11:39.09012+08
2019-08-13 09:11:47.846 CST [10697] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:11:47.846 CST [10697] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:11:47.847 CST [10699] DEBUG:  received inquiry for database 0
2019-08-13 09:11:47.847 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:11:47.847 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:11:47.861 CST [10760] DEBUG:  InitPostgres
2019-08-13 09:11:47.862 CST [10760] DEBUG:  my backend ID is 5
2019-08-13 09:11:47.870 CST [10760] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:11:47.880 CST [10760] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:11:47.880 CST [10760] DEBUG:  autovacuum: processing database "postgres"
2019-08-13 09:11:47.881 CST [10699] DEBUG:  received inquiry for database 16404
2019-08-13 09:11:47.881 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:11:47.881 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_16404.stat"
2019-08-13 09:11:47.883 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:11:47.892 CST [10760] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:11:47.893 CST [10760] DEBUG:  pg_statistic: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:47.893 CST [10760] DEBUG:  pg_authid: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:47.893 CST [10760] DEBUG:  pg_attribute: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:47.893 CST [10760] DEBUG:  pg_proc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:47.893 CST [10760] DEBUG:  pg_class: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:47.893 CST [10760] DEBUG:  pg_index: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:47.893 CST [10760] DEBUG:  pg_operator: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:47.893 CST [10760] DEBUG:  pg_opclass: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:47.893 CST [10760] DEBUG:  pg_am: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:47.893 CST [10760] DEBUG:  pg_amop: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:47.893 CST [10760] DEBUG:  pg_amproc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:47.893 CST [10760] DEBUG:  pg_aggregate: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:47.893 CST [10760] DEBUG:  pg_rewrite: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:47.893 CST [10760] DEBUG:  pg_cast: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:47.893 CST [10760] DEBUG:  pg_namespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:47.893 CST [10760] DEBUG:  pg_database: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:47.893 CST [10760] DEBUG:  pg_tablespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:47.894 CST [10760] DEBUG:  pg_type: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:47.894 CST [10760] DEBUG:  pg_collation: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:11:47.894 CST [10760] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:11:47.894 CST [10760] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2019-08-13 09:11:47.894 CST [10760] DEBUG:  shmem_exit(0): 7 on_shmem_exit callbacks to make
2019-08-13 09:11:47.894 CST [10760] DEBUG:  proc_exit(0): 2 callbacks to make
2019-08-13 09:11:47.894 CST [10760] DEBUG:  exit(0)
2019-08-13 09:11:47.894 CST [10760] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2019-08-13 09:11:47.894 CST [10760] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2019-08-13 09:11:47.894 CST [10760] DEBUG:  proc_exit(-1): 0 callbacks to make
2019-08-13 09:11:47.901 CST [10691] DEBUG:  reaping dead processes
2019-08-13 09:11:47.901 CST [10691] DEBUG:  server process (PID 10760) exited with exit code 0
2019-08-13 09:11:49.098 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:11:49.098799+08
2019-08-13 09:11:59.100 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:11:59.100366+08
2019-08-13 09:12:09.109 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:12:09.109705+08
2019-08-13 09:12:17.878 CST [10697] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:12:17.878 CST [10697] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:12:17.879 CST [10699] DEBUG:  received inquiry for database 0
2019-08-13 09:12:17.879 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:12:17.879 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:12:17.895 CST [10761] DEBUG:  InitPostgres
2019-08-13 09:12:17.896 CST [10761] DEBUG:  my backend ID is 5
2019-08-13 09:12:17.902 CST [10761] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:12:17.911 CST [10761] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:12:17.911 CST [10761] DEBUG:  autovacuum: processing database "transfer_tb"
2019-08-13 09:12:17.911 CST [10699] DEBUG:  received inquiry for database 16511
2019-08-13 09:12:17.911 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:12:17.911 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_16511.stat"
2019-08-13 09:12:17.911 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:12:17.922 CST [10761] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:12:17.923 CST [10761] DEBUG:  pg_statistic: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:17.923 CST [10761] DEBUG:  pg_authid: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:17.923 CST [10761] DEBUG:  pg_attribute: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:17.923 CST [10761] DEBUG:  pg_proc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:17.924 CST [10761] DEBUG:  pg_class: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:17.924 CST [10761] DEBUG:  pg_index: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:17.924 CST [10761] DEBUG:  pg_operator: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:17.924 CST [10761] DEBUG:  pg_opclass: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:17.924 CST [10761] DEBUG:  pg_am: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:17.924 CST [10761] DEBUG:  pg_amop: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:17.924 CST [10761] DEBUG:  pg_amproc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:17.924 CST [10761] DEBUG:  pg_rewrite: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:17.924 CST [10761] DEBUG:  pg_cast: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:17.924 CST [10761] DEBUG:  pg_namespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:17.924 CST [10761] DEBUG:  pg_database: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:17.924 CST [10761] DEBUG:  pg_tablespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:17.924 CST [10761] DEBUG:  pg_type: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:17.924 CST [10761] DEBUG:  galloans_all_tables: vac: 0 (threshold 1000), anl: 1 (threshold 1000)
2019-08-13 09:12:17.924 CST [10761] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:12:17.924 CST [10761] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2019-08-13 09:12:17.924 CST [10761] DEBUG:  shmem_exit(0): 7 on_shmem_exit callbacks to make
2019-08-13 09:12:17.924 CST [10761] DEBUG:  proc_exit(0): 2 callbacks to make
2019-08-13 09:12:17.924 CST [10761] DEBUG:  exit(0)
2019-08-13 09:12:17.924 CST [10761] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2019-08-13 09:12:17.924 CST [10761] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2019-08-13 09:12:17.924 CST [10761] DEBUG:  proc_exit(-1): 0 callbacks to make
2019-08-13 09:12:17.930 CST [10691] DEBUG:  reaping dead processes
2019-08-13 09:12:17.930 CST [10691] DEBUG:  server process (PID 10761) exited with exit code 0
2019-08-13 09:12:19.114 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:12:19.114212+08
2019-08-13 09:12:29.123 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:12:29.123723+08
2019-08-13 09:12:39.133 CST [10708] DEBUG:  write 8/D8000110 flush 8/D8000000 apply 0/0 reply_time 2019-08-13 09:12:39.132983+08
2019-08-13 09:12:41.287 CST [10706] DEBUG:  file "pg_internal.init" excluded from backup
2019-08-13 09:12:41.287 CST [10706] DEBUG:  contents of directory "pg_replslot" excluded from backup
2019-08-13 09:12:41.287 CST [10706] DEBUG:  contents of directory "pg_stat_tmp" excluded from backup
2019-08-13 09:12:41.287 CST [10706] DEBUG:  file "postmaster.opts" excluded from backup
2019-08-13 09:12:41.291 CST [10706] DEBUG:  file "postmaster.pid" excluded from backup
2019-08-13 09:12:41.291 CST [10706] WARNING:  skipping special file "./.s.PGSQL.5432"
2019-08-13 09:12:41.411 CST [10698] DEBUG:  executing archive command "/bin/date"
2019-08-13 09:12:41.411 CST [10706] DEBUG:  removing WAL backup history file "000000010000000800000032.00000060.backup"
Tue Aug 13 09:12:41 CST 2019
2019-08-13 09:12:41.425 CST [10698] DEBUG:  archived write-ahead log file "000000010000000800000036"
2019-08-13 09:12:41.429 CST [10698] DEBUG:  executing archive command "/bin/date"
Tue Aug 13 09:12:41 CST 2019
2019-08-13 09:12:41.443 CST [10698] DEBUG:  archived write-ahead log file "000000010000000800000036.00000028.backup"
2019-08-13 09:12:41.548 CST [10695] DEBUG:  snapshot of 0+0 running transaction ids (lsn 8/DC000060 oldest xid 23729 latest complete 23728 next xid 23729)
2019-08-13 09:12:41.548 CST [10696] DEBUG:  creating and filling new WAL file
2019-08-13 09:12:42.041 CST [10708] LOG:  could not receive data from client: 连接超时
2019-08-13 09:12:42.041 CST [10708] LOG:  unexpected EOF on standby connection
2019-08-13 09:12:42.041 CST [10708] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2019-08-13 09:12:42.041 CST [10708] DEBUG:  shmem_exit(0): 7 on_shmem_exit callbacks to make
2019-08-13 09:12:42.042 CST [10708] DEBUG:  proc_exit(0): 3 callbacks to make
2019-08-13 09:12:42.042 CST [10708] DEBUG:  exit(0)
2019-08-13 09:12:42.042 CST [10708] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2019-08-13 09:12:42.042 CST [10708] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2019-08-13 09:12:42.042 CST [10708] DEBUG:  proc_exit(-1): 0 callbacks to make
2019-08-13 09:12:42.049 CST [10691] DEBUG:  reaping dead processes
2019-08-13 09:12:42.049 CST [10691] DEBUG:  server process (PID 10708) exited with exit code 0
2019-08-13 09:12:42.071 CST [10706] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2019-08-13 09:12:42.072 CST [10706] DEBUG:  shmem_exit(0): 7 on_shmem_exit callbacks to make
2019-08-13 09:12:42.072 CST [10706] DEBUG:  proc_exit(0): 3 callbacks to make
2019-08-13 09:12:42.072 CST [10706] DEBUG:  exit(0)
2019-08-13 09:12:42.072 CST [10706] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2019-08-13 09:12:42.072 CST [10706] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2019-08-13 09:12:42.072 CST [10706] DEBUG:  proc_exit(-1): 0 callbacks to make
2019-08-13 09:12:42.081 CST [10691] DEBUG:  reaping dead processes
2019-08-13 09:12:42.081 CST [10691] DEBUG:  server process (PID 10706) exited with exit code 0
2019-08-13 09:12:42.184 CST [10696] DEBUG:  done creating and filling new WAL file
2019-08-13 09:12:47.833 CST [10701] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:12:47.833 CST [10701] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:12:47.877 CST [10697] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:12:47.877 CST [10697] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:12:47.877 CST [10699] DEBUG:  received inquiry for database 0
2019-08-13 09:12:47.877 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:12:47.877 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:12:47.890 CST [10764] DEBUG:  InitPostgres
2019-08-13 09:12:47.890 CST [10764] DEBUG:  my backend ID is 3
2019-08-13 09:12:47.890 CST [10764] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:12:47.892 CST [10764] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:12:47.892 CST [10764] DEBUG:  autovacuum: processing database "postgres"
2019-08-13 09:12:47.892 CST [10699] DEBUG:  received inquiry for database 16404
2019-08-13 09:12:47.892 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:12:47.892 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_16404.stat"
2019-08-13 09:12:47.892 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:12:47.902 CST [10764] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:12:47.903 CST [10764] DEBUG:  pg_statistic: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:47.903 CST [10764] DEBUG:  pg_authid: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:47.903 CST [10764] DEBUG:  pg_attribute: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:47.903 CST [10764] DEBUG:  pg_proc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:47.903 CST [10764] DEBUG:  pg_class: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:47.903 CST [10764] DEBUG:  pg_index: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:47.903 CST [10764] DEBUG:  pg_operator: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:47.903 CST [10764] DEBUG:  pg_opclass: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:47.903 CST [10764] DEBUG:  pg_am: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:47.903 CST [10764] DEBUG:  pg_amop: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:47.903 CST [10764] DEBUG:  pg_amproc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:47.903 CST [10764] DEBUG:  pg_aggregate: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:47.903 CST [10764] DEBUG:  pg_rewrite: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:47.903 CST [10764] DEBUG:  pg_cast: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:47.903 CST [10764] DEBUG:  pg_namespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:47.903 CST [10764] DEBUG:  pg_database: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:47.903 CST [10764] DEBUG:  pg_tablespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:47.903 CST [10764] DEBUG:  pg_type: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:47.903 CST [10764] DEBUG:  pg_collation: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:12:47.903 CST [10764] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:12:47.903 CST [10764] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2019-08-13 09:12:47.903 CST [10764] DEBUG:  shmem_exit(0): 7 on_shmem_exit callbacks to make
2019-08-13 09:12:47.904 CST [10764] DEBUG:  proc_exit(0): 2 callbacks to make
2019-08-13 09:12:47.904 CST [10764] DEBUG:  exit(0)
2019-08-13 09:12:47.904 CST [10764] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2019-08-13 09:12:47.904 CST [10764] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2019-08-13 09:12:47.904 CST [10764] DEBUG:  proc_exit(-1): 0 callbacks to make
2019-08-13 09:12:47.905 CST [10691] DEBUG:  reaping dead processes
2019-08-13 09:12:47.905 CST [10691] DEBUG:  server process (PID 10764) exited with exit code 0
2019-08-13 09:13:17.908 CST [10697] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:13:17.908 CST [10697] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:13:17.908 CST [10699] DEBUG:  received inquiry for database 0
2019-08-13 09:13:17.908 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:13:17.908 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:13:17.920 CST [10792] DEBUG:  InitPostgres
2019-08-13 09:13:17.920 CST [10792] DEBUG:  my backend ID is 3
2019-08-13 09:13:17.921 CST [10792] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:13:17.922 CST [10792] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:13:17.922 CST [10792] DEBUG:  autovacuum: processing database "transfer_tb"
2019-08-13 09:13:17.922 CST [10699] DEBUG:  received inquiry for database 16511
2019-08-13 09:13:17.922 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2019-08-13 09:13:17.923 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_16511.stat"
2019-08-13 09:13:17.923 CST [10699] DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2019-08-13 09:13:17.933 CST [10792] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:13:17.934 CST [10792] DEBUG:  pg_statistic: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:13:17.934 CST [10792] DEBUG:  pg_authid: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:13:17.934 CST [10792] DEBUG:  pg_attribute: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:13:17.934 CST [10792] DEBUG:  pg_proc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:13:17.934 CST [10792] DEBUG:  pg_class: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:13:17.934 CST [10792] DEBUG:  pg_index: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:13:17.934 CST [10792] DEBUG:  pg_operator: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:13:17.934 CST [10792] DEBUG:  pg_opclass: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:13:17.934 CST [10792] DEBUG:  pg_am: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:13:17.934 CST [10792] DEBUG:  pg_amop: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:13:17.934 CST [10792] DEBUG:  pg_amproc: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:13:17.934 CST [10792] DEBUG:  pg_rewrite: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:13:17.934 CST [10792] DEBUG:  pg_cast: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:13:17.934 CST [10792] DEBUG:  pg_namespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:13:17.934 CST [10792] DEBUG:  pg_database: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:13:17.934 CST [10792] DEBUG:  pg_tablespace: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:13:17.934 CST [10792] DEBUG:  pg_type: vac: 0 (threshold 1000), anl: 0 (threshold 1000)
2019-08-13 09:13:17.934 CST [10792] DEBUG:  galloans_all_tables: vac: 0 (threshold 1000), anl: 1 (threshold 1000)
2019-08-13 09:13:17.934 CST [10792] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2019-08-13 09:13:17.934 CST [10792] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2019-08-13 09:13:17.934 CST [10792] DEBUG:  shmem_exit(0): 7 on_shmem_exit callbacks to make
2019-08-13 09:13:17.934 CST [10792] DEBUG:  proc_exit(0): 2 callbacks to make
2019-08-13 09:13:17.934 CST [10792] DEBUG:  exit(0)
2019-08-13 09:13:17.934 CST [10792] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2019-08-13 09:13:17.934 CST [10792] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2019-08-13 09:13:17.934 CST [10792] DEBUG:  proc_exit(-1): 0 callbacks to make
2019-08-13 09:13:17.936 CST [10691] DEBUG:  reaping dead processes
2019-08-13 09:13:17.936 CST [10691] DEBUG:  server process (PID 10792) exited with exit code 0



------------------ 原始邮件 ------------------
发件人: "Jeff Janes"<[hidden email]>;
发送时间: 2019年8月12日(星期一) 晚上11:11
收件人: "两个孩子的爹"<[hidden email]>;"pgsql-bugs"<[hidden email]>;
主题: Re: BUG #15949: pg_basebackup failed(PG-12-Beta3)

On Mon, Aug 12, 2019 at 6:32 AM PG Bug reporting form <[hidden email]> wrote:
The following bug has been logged on the website:

Bug reference:      15949
Logged by:          强 魏
Email address:      [hidden email]
PostgreSQL version: 12beta3

Did it work in other versions, or is this the only one you tested?
 
Here are the configuration parameters:wal_sender_timeout=0
wal_receiver_timeout

The above looks like an incomplete copy and paste.

Cheers,

Jeff
Reply | Threaded
Open this post in threaded view
|

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

Michael Paquier-2
On Tue, Aug 13, 2019 at 09:18:36AM +0800, 两个孩子的爹 wrote:
> I only tested PG-12-Beta 3.
> Backup completed normally, but did not seem to end correctly。
> Backup files are generated during the backup process, but nothing is
> left at the end of the backup process.

I have done a couple of tests with a couple of configurations:
- Instance with multiple tablespaces.
- wal_receiver_timeout and wal_sender_timeout set at 0
- Compression enabled with pg_basebackup, same as you at level 5
(worked even at higher levels).
- Tar format used.

Unfortunately I have no traces of failures in my own tests, and the
format of each tablespace tarballs was correct.
--
Michael

signature.asc (849 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

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

Jeff Janes
In reply to this post by 两个孩子的爹
On Mon, Aug 12, 2019 at 9:18 PM 两个孩子的爹 <[hidden email]> wrote:
Hi :
I only tested PG-12-Beta 3.

Could you try testing a released version (like 11.5), between the same two machine?  It could help rule some possibilities in or out.

Also, what are all your timeout settings?  And your keep alive?  And your unix_socket_directories?

select name,setting from pg_settings where name like '%keep%' or name like '%timeout%' or name like '%socket_direct%'; 

I suspect that something in your network (firewall, gateway, etc.) is interfering with the connection.  Turning on compression just slows down the client (pg_basebackup) enough that it gives this interference time to happen.
 
Backup completed normally, but did not seem to end correctly.

In your first email, the server did think something went wrong:

"2019-08-12 18:20:03.417 CST [11446] LOG:  could not receive data from
client: connect timeout"

I think the "connection timeout" part of this message is generated by your OS, and PostgreSQL just passes it along.  It doesn't seem to be a timeout which PostgreSQL is expecting to happen, which makes me think the problem is in your network rather than in PostgreSQL itself.

In the log in your most recent email, it does look like the server believes everything completed normally, while only the client senses an error.  Again, it seems to me that something in your network is injecting itself between the two ends of the connection.

Cheers,

Jeff