Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

page+ptrack backup #13

Closed
Closed
Labels
@gsmolk

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions

        AltStyle によって変換されたページ (->オリジナル) /