page+ptrack backup #13
Description
Page backup, even failed and deleted afterwards, makes ptrack backup impossible to perform
bash-4.2$ pg_probackup backup -v -B $PWD -D /var/lib/pgsql/ptrack/main/data/ -b page --stream -C -j4 -h /tmp
LOG: (query) SELECT current_setting($1)
LOG: (param:0) = block_size
LOG: (query) SELECT current_setting($1)
LOG: (param:0) = wal_block_size
LOG: ========================================
LOG: backup start
LOG: ----------------------------------------
# configuration
BACKUP_MODE=PAGE
LOG: ----------------------------------------
LOG: backup destination is initialized
LOG: (query) SELECT pg_is_in_recovery()
LOG: database backup start
LOG: (query) SELECT proname FROM pg_proc WHERE proname='pg_ptrack_clear'
LOG: (query) show ptrack_enable
LOG: (query) SELECT datname FROM pg_database
LOG: (query) SELECT pg_ptrack_clear()
LOG: (query) SELECT pg_ptrack_clear()
LOG: (query) SELECT pg_ptrack_clear()
LOG: (query) SELECT pg_start_backup($1, $2)
LOG: (param:0) = 2017-02-10 15:33:10 with pg_probackup
LOG: (param:1) = false
pg_probackup: starting log streaming at 15/B3000000 (timeline 1)
LOG: backup only the page that there was of the update from LSN(13/7B1D2230)
LOG: (query) SET client_min_messages = warning;
LOG: (query) SELECT * FROM pg_switch_xlog()
LOG: wait_for_archive(): tli=1 lsn=15/C3567230
LOG: wait_for_archive() wait for /var/lib/pgsql/ptrack/main/data//pg_xlog/archive_status/0000000100000015000000C3.ready
LOG: (query) SELECT txid_current();
LOG: get_xid():5516769
LOG: wait_for_archive() .ready deleted in 0 try
LOG: extractPageMap
LOG: current_tli:1
LOG: prev_backup->start_lsn: 13/7B1D2230
LOG: current.start_lsn: 15/B3020D90
LOG: opening WAL segment "/var/lib/pgsql/ptrack/backup/wal/00000001000000130000007B"
INFO: could not open WAL segment "/var/lib/pgsql/ptrack/backup/wal/00000001000000130000007B": No such file or directory
ERROR: could not read WAL record at 13/7B1D2230
LOG: backup_label exists, stop backup
LOG: (query) SET client_min_messages = warning;
pg_probackup: finished segment at 15/B4000000 (timeline 1)
LOG: (query) SELECT * FROM pg_stop_backup()
LOG: (query) SELECT txid_current();
LOG: backup is running, update its status to ERROR
bash-4.2$ pg_probackup backup -v -B $PWD -D /var/lib/pgsql/ptrack/main/data/ -b ptrack --stream -C -j4 -h /tmp
LOG: (query) SELECT current_setting($1)
LOG: (param:0) = block_size
LOG: (query) SELECT current_setting($1)
LOG: (param:0) = wal_block_size
LOG: ========================================
LOG: backup start
LOG: ----------------------------------------
# configuration
BACKUP_MODE=PTRACK
LOG: ----------------------------------------
LOG: backup destination is initialized
LOG: (query) SELECT pg_is_in_recovery()
LOG: database backup start
LOG: (query) SELECT proname FROM pg_proc WHERE proname='pg_ptrack_clear'
LOG: (query) show ptrack_enable
LOG: (query) show ptrack_enable
LOG: (query) SELECT pg_start_backup($1, $2)
LOG: (param:0) = 2017-02-10 15:33:23 with pg_probackup
LOG: (param:1) = false
pg_probackup: starting log streaming at 15/F5000000 (timeline 1)
LOG: backup only the page that there was of the update from LSN(13/7B1D2230)
ERROR: Wrong ptrack lsn:15b21225c0 prev:137b1d2230 current:15f58dac30
LOG: backup_label exists, stop backup
LOG: (query) SET client_min_messages = warning;
LOG: (query) SELECT * FROM pg_stop_backup()
LOG: (query) SELECT txid_current();
LOG: backup is running, update its status to ERROR
bash-4.2$ pg_probackup show -B $PWD
=========================================================================================
ID Recovery time Mode Current/Parent TLI Time Data Status
=========================================================================================
OL5S7N 1970-01-01 03:00:00 PTRACK+STREAM 1 / 0 0m 0B ERROR
OL5S7A 2017-02-10 15:33:14 PAGE+STREAM 1 / 0 0m 0B ERROR
OL5RX9 2017-02-10 15:27:19 PTRACK+STREAM 1 / 0 0m 787MB OK
OL5RVW 2017-02-10 15:26:28 PTRACK+STREAM 1 / 0 0m 1067MB OK
OL5ROH 2017-02-10 15:22:01 PTRACK+STREAM 1 / 0 0m 1099MB OK
OL5RIV 2017-02-10 15:18:38 PTRACK+STREAM 1 / 0 0m 999MB OK
OL5RFZ 2017-02-10 15:16:55 PTRACK+STREAM 1 / 0 0m 1118MB OK
OL5RBO 2017-02-10 15:14:36 FULL+STREAM 1 / 0 0m 16GB OK
bash-4.2$ pg_probackup -B $PWD delete --wal OL5S7N
INFO: delete: OL5S7N 2017-02-10 15:33:23
bash-4.2$ pg_probackup -B $PWD delete --wal OL5S7A
INFO: delete: OL5S7A 2017-02-10 15:33:10
bash-4.2$ pg_probackup backup -v -B $PWD -D /var/lib/pgsql/ptrack/main/data/ -b ptrack --stream -C -j4 -h /tmp
LOG: (query) SELECT current_setting($1)
LOG: (param:0) = block_size
LOG: (query) SELECT current_setting($1)
LOG: (param:0) = wal_block_size
LOG: ========================================
LOG: backup start
LOG: ----------------------------------------
# configuration
BACKUP_MODE=PTRACK
LOG: ----------------------------------------
LOG: backup destination is initialized
LOG: (query) SELECT pg_is_in_recovery()
LOG: database backup start
LOG: (query) SELECT proname FROM pg_proc WHERE proname='pg_ptrack_clear'
LOG: (query) show ptrack_enable
LOG: (query) show ptrack_enable
LOG: (query) SELECT pg_start_backup($1, $2)
LOG: (param:0) = 2017-02-10 15:37:39 with pg_probackup
LOG: (param:1) = false
pg_probackup: starting log streaming at 1A/50000000 (timeline 1)
LOG: backup only the page that there was of the update from LSN(13/7B1D2230)
ERROR: Wrong ptrack lsn:15b21225c0 prev:137b1d2230 current:1a5023d3e0
LOG: backup_label exists, stop backup
LOG: (query) SET client_min_messages = warning;
LOG: (query) SELECT * FROM pg_stop_backup()
LOG: (query) SELECT txid_current();
LOG: backup is running, update its status to ERROR