暂无图片
gs_probackup保留策略及删除策略疑问
我来答
分享
Martin Meng
2023-10-07
gs_probackup保留策略及删除策略疑问

[omm@opengaussdb3 ~]$ gs_probackup show -B /opengauss/backup --instance=6001
===================================================================================================================================
Instance Version ID Recovery Time Mode WAL Mode TLI Time Data WAL Zratio Start LSN Stop LSN Status
===================================================================================================================================
6001 9.2 S20SCL 2023-10-05 03:48:43+08 FULL STREAM 1/0 1m:24s 637MB 16MB 1.00 0/62966D8 0/6296758 OK
6001 9.2 S20KGS 2023-10-05 00:58:07+08 FULL STREAM 1/0 1m:4s 637MB 16MB 1.00 0/628BEA8 0/628BF28 OK
6001 9.2 S20KDG 2023-10-05 00:56:07+08 FULL STREAM 1/0 1m:4s 637MB 16MB 1.00 0/628BC68 0/628BCE8 OK
6001 9.2 S20KBC 2023-10-05 00:54:50+08 FULL STREAM 1/0 1m:4s 637MB 16MB 1.00 0/628BB48 0/628BBC8 OK
6001 9.2 S20K85 2023-10-05 00:53:02+08 FULL STREAM 1/0 1m:11s 637MB 16MB 1.00 0/628B908 0/628B988 OK
[omm@opengaussdb3 ~]$ gs_probackup backup -B /opengauss/backup --delete-expired --instance=6001 -b full
INFO: Backup start, gs_probackup version: 2.4.2, instance: 6001, backup ID: S25ITW, backup mode: FULL, wal mode: STREAM, remote: false, compress-algorithm: none, compress-level: 1
LOG: Backup destination is initialized
LOG: This openGauss instance was initialized with data block checksums. Data block corruption will be detected
INFO: Backup S25ITW is going to be taken from standby
LOG: Database backup start
LOG: started streaming WAL at 0/6000000 (timeline 1)
[2023-10-07 17:10:44]: check identify system success
[2023-10-07 17:10:44]: send START_REPLICATION 0/6000000 success
[2023-10-07 17:10:44]: keepalive message is received
[2023-10-07 17:10:44]: keepalive message is received
INFO: Cannot parse path "base"
INFO: PGDATA size: 637MB
INFO: Start transferring data files
LOG: Creating page header map "/opengauss/backup/backups/6001/S25ITW/page_header_map"
[2023-10-07 17:10:49]: keepalive message is received
INFO: Data files are transferred, time elapsed: 10s
[2023-10-07 17:10:54]: keepalive message is received
INFO: wait for pg_stop_backup()
INFO: pg_stop backup() successfully executed
LOG: stop_lsn: 0/62A2F28
LOG: Looking for LSN 0/62A2F28 in segment: 000000010000000000000006
INFO: Wait for LSN 0/62A2F28 in streamed WAL segment /opengauss/backup/backups/6001/S25ITW/database/pg_xlog/000000010000000000000006
LOG: finished streaming WAL at 0/62A2F28 (timeline 1)
LOG: Found WAL segment: /opengauss/backup/backups/6001/S25ITW/database/pg_xlog/000000010000000000000006
INFO: Wait a few minutes to get the target LSN or the last valid record prior to the target LSN
LOG: Record 0/62A2E88 has endpoint 0/62A2F28 which is equal or greater than requested LSN 0/62A2F28
LOG: Found prior LSN: 0/62A2E88
LOG: Getting the Recovery Time from WAL
LOG: Failed to find Recovery Time in WAL, forced to trust current_timestamp
LOG: Current minRecPoint 0/62A2F28
LOG: Setting minRecPoint to 0/62A2E88
INFO: Syncing backup files to disk
INFO: Backup files are synced, time elapsed: 0
INFO: Validating backup S25ITW
INFO: Backup S25ITW data files are valid
INFO: Backup S25ITW resident size: 653MB
INFO: Backup S25ITW completed
LOG: REDUNDANCY=2
LOG: WINDOW=2
INFO: Evaluate backups by retention
INFO: Backup S25ITW, mode: FULL, status: OK. Redundancy: 1/2, Time Window: 0d/2d. Active
INFO: Backup S20SCL, mode: FULL, status: OK. Redundancy: 2/2, Time Window: 2d/2d. Active
==REDUNDANCY=2 WINDOW=2 保留2天内的,保留2份,超过2份的都删除掉了
INFO: Backup S20KGS, mode: FULL, status: OK. Redundancy: 3/2, Time Window: 2d/2d. Expired #
INFO: Backup S20KDG, mode: FULL, status: OK. Redundancy: 4/2, Time Window: 2d/2d. Expired
INFO: Backup S20KBC, mode: FULL, status: OK. Redundancy: 5/2, Time Window: 2d/2d. Expired
INFO: Backup S20K85, mode: FULL, status: OK. Redundancy: 6/2, Time Window: 2d/2d. Expired
LOG: Consider backup S20KGS for purge
WARNING: Process 25524 which used backup S20KGS no longer exists
INFO: Delete: S20KGS 2023-10-05 00:58:07+08
LOG: Consider backup S20KDG for purge
WARNING: Process 24440 which used backup S20KDG no longer exists
INFO: Delete: S20KDG 2023-10-05 00:56:07+08
LOG: Consider backup S20KBC for purge
WARNING: Process 23292 which used backup S20KBC no longer exists
INFO: Delete: S20KBC 2023-10-05 00:54:50+08
LOG: Consider backup S20K85 for purge
WARNING: Process 22401 which used backup S20K85 no longer exists
INFO: Delete: S20K85 2023-10-05 00:53:02+08
INFO: There are no backups to merge by retention policy
INFO: Purging finished
INFO: There is no WAL to purge by retention policy
[omm@opengaussdb3 ~]$ gs_probackup show -B /opengauss/backup --instance=6001
===================================================================================================================================
Instance Version ID Recovery Time Mode WAL Mode TLI Time Data WAL Zratio Start LSN Stop LSN Status
===================================================================================================================================
6001 9.2 S25ITW 2023-10-07 17:10:54+08 FULL STREAM 1/0 1m:12s 637MB 16MB 1.00 0/62A2E08 0/62A2E88 OK
6001 9.2 S20SCL 2023-10-05 03:48:43+08 FULL STREAM 1/0 1m:24s 637MB 16MB 1.00 0/62966D8 0/6296758 OK
[omm@opengaussdb3 ~]$

[omm@opengaussdb3 ~]$ gs_probackup show -B /opengauss/backup --instance=6001
===================================================================================================================================
Instance Version ID Recovery Time Mode WAL Mode TLI Time Data WAL Zratio Start LSN Stop LSN Status
===================================================================================================================================
6001 9.2 S25ITW 2023-10-07 17:10:54+08 FULL STREAM 1/0 1m:12s 637MB 16MB 1.00 0/62A2E08 0/62A2E88 OK
6001 9.2 S20SCL 2023-10-05 03:48:43+08 FULL STREAM 1/0 1m:24s 637MB 16MB 1.00 0/62966D8 0/6296758 OK
[omm@opengaussdb3 ~]$ gs_probackup backup -B /opengauss/backup --delete-expired --instance=6001 -b full
INFO: Backup start, gs_probackup version: 2.4.2, instance: 6001, backup ID: S25J9F, backup mode: FULL, wal mode: STREAM, remote: false, compress-algorithm: none, compress-level: 1
LOG: Backup destination is initialized
LOG: This openGauss instance was initialized with data block checksums. Data block corruption will be detected
INFO: Backup S25J9F is going to be taken from standby
LOG: Database backup start
LOG: started streaming WAL at 0/6000000 (timeline 1)
[2023-10-07 17:20:03]: check identify system success
[2023-10-07 17:20:03]: send START_REPLICATION 0/6000000 success
[2023-10-07 17:20:03]: keepalive message is received
INFO: Cannot parse path "base"
[2023-10-07 17:20:03]: keepalive message is received
INFO: PGDATA size: 637MB
INFO: Start transferring data files
LOG: Creating page header map "/opengauss/backup/backups/6001/S25J9F/page_header_map"
INFO: Data files are transferred, time elapsed: 2s
INFO: wait for pg_stop_backup()
INFO: pg_stop backup() successfully executed
LOG: stop_lsn: 0/62A3948
LOG: Looking for LSN 0/62A3948 in segment: 000000010000000000000006
INFO: Wait for LSN 0/62A3948 in streamed WAL segment /opengauss/backup/backups/6001/S25J9F/database/pg_xlog/000000010000000000000006
LOG: finished streaming WAL at 0/62A3948 (timeline 1)
LOG: Found WAL segment: /opengauss/backup/backups/6001/S25J9F/database/pg_xlog/000000010000000000000006
INFO: Wait a few minutes to get the target LSN or the last valid record prior to the target LSN
LOG: Record 0/62A38A8 has endpoint 0/62A3948 which is equal or greater than requested LSN 0/62A3948
LOG: Found prior LSN: 0/62A38A8
LOG: Getting the Recovery Time from WAL
LOG: Failed to find Recovery Time in WAL, forced to trust current_timestamp
LOG: Current minRecPoint 0/62A3948
LOG: Setting minRecPoint to 0/62A38A8
INFO: Syncing backup files to disk
INFO: Backup files are synced, time elapsed: 0
INFO: Validating backup S25J9F
INFO: Backup S25J9F data files are valid
INFO: Backup S25J9F resident size: 653MB
INFO: Backup S25J9F completed
LOG: REDUNDANCY=2
LOG: WINDOW=2
INFO: Evaluate backups by retention
INFO: Backup S25J9F, mode: FULL, status: OK. Redundancy: 1/2, Time Window: 0d/2d. Active
INFO: Backup S25ITW, mode: FULL, status: OK. Redundancy: 2/2, Time Window: 0d/2d. Active
INFO: Backup S20SCL, mode: FULL, status: OK. Redundancy: 3/2, Time Window: 2d/2d. Expired
LOG: Consider backup S20SCL for purge
WARNING: Process 124674 which used backup S20SCL no longer exists
INFO: Delete: S20SCL 2023-10-05 03:48:43+08
INFO: There are no backups to merge by retention policy
INFO: Purging finished
INFO: There is no WAL to purge by retention policy
[omm@opengaussdb3 ~]$ gs_probackup show -B /opengauss/backup --instance=6001
===================================================================================================================================
Instance Version ID Recovery Time Mode WAL Mode TLI Time Data WAL Zratio Start LSN Stop LSN Status
===================================================================================================================================
6001 9.2 S25J9F 2023-10-07 17:20:06+08 FULL STREAM 1/0 1m:4s 637MB 16MB 1.00 0/62A3828 0/62A38A8 OK
6001 9.2 S25ITW 2023-10-07 17:10:54+08 FULL STREAM 1/0 1m:12s 637MB 16MB 1.00 0/62A2E08 0/62A2E88 OK

[omm@opengaussdb3 ~]$ gs_probackup show -B /opengauss/backup --instance=6001
===================================================================================================================================
Instance Version ID Recovery Time Mode WAL Mode TLI Time Data WAL Zratio Start LSN Stop LSN Status
===================================================================================================================================
6001 9.2 S25J9F 2023-10-07 17:20:06+08 FULL STREAM 1/0 1m:4s 637MB 16MB 1.00 0/62A3828 0/62A38A8 OK
6001 9.2 S25ITW 2023-10-07 17:10:54+08 FULL STREAM 1/0 1m:12s 637MB 16MB 1.00 0/62A2E08 0/62A2E88 OK
[omm@opengaussdb3 ~]$ gs_probackup backup -B /opengauss/backup --delete-expired --instance=6001 -b full
INFO: Backup start, gs_probackup version: 2.4.2, instance: 6001, backup ID: S25JCU, backup mode: FULL, wal mode: STREAM, remote: false, compress-algorithm: none, compress-level: 1
LOG: Backup destination is initialized
LOG: This openGauss instance was initialized with data block checksums. Data block corruption will be detected
INFO: Backup S25JCU is going to be taken from standby
LOG: Database backup start
LOG: started streaming WAL at 0/6000000 (timeline 1)
[2023-10-07 17:22:07]: check identify system success
[2023-10-07 17:22:07]: send START_REPLICATION 0/6000000 success
[2023-10-07 17:22:07]: keepalive message is received
[2023-10-07 17:22:07]: keepalive message is received
INFO: Cannot parse path "base"
INFO: PGDATA size: 637MB
INFO: Start transferring data files
LOG: Creating page header map "/opengauss/backup/backups/6001/S25JCU/page_header_map"
INFO: Data files are transferred, time elapsed: 2s
INFO: wait for pg_stop_backup()
INFO: pg_stop backup() successfully executed
LOG: stop_lsn: 0/62A3B88
LOG: Looking for LSN 0/62A3B88 in segment: 000000010000000000000006
INFO: Wait for LSN 0/62A3B88 in streamed WAL segment /opengauss/backup/backups/6001/S25JCU/database/pg_xlog/000000010000000000000006
LOG: finished streaming WAL at 0/62A3B88 (timeline 1)
LOG: Found WAL segment: /opengauss/backup/backups/6001/S25JCU/database/pg_xlog/000000010000000000000006
INFO: Wait a few minutes to get the target LSN or the last valid record prior to the target LSN
LOG: Record 0/62A3AE8 has endpoint 0/62A3B88 which is equal or greater than requested LSN 0/62A3B88
LOG: Found prior LSN: 0/62A3AE8
LOG: Getting the Recovery Time from WAL
LOG: Failed to find Recovery Time in WAL, forced to trust current_timestamp
LOG: Current minRecPoint 0/62A3B88
LOG: Setting minRecPoint to 0/62A3AE8
INFO: Syncing backup files to disk
INFO: Backup files are synced, time elapsed: 0
INFO: Validating backup S25JCU
INFO: Backup S25JCU data files are valid
INFO: Backup S25JCU resident size: 653MB
INFO: Backup S25JCU completed
LOG: REDUNDANCY=2
LOG: WINDOW=2
INFO: Evaluate backups by retention
INFO: Backup S25JCU, mode: FULL, status: OK. Redundancy: 1/2, Time Window: 0d/2d. Active
INFO: Backup S25J9F, mode: FULL, status: OK. Redundancy: 2/2, Time Window: 0d/2d. Active
--这里S25ITW为什么没有被删除
INFO: Backup S25ITW, mode: FULL, status: OK. Redundancy: 3/2, Time Window: 0d/2d. Active
INFO: There are no backups to merge by retention policy
INFO: There are no backups to delete by retention policy
INFO: There is no WAL to purge by retention policy
[omm@opengaussdb3 ~]$ gs_probackup show -B /opengauss/backup --instance=6001
===================================================================================================================================
Instance Version ID Recovery Time Mode WAL Mode TLI Time Data WAL Zratio Start LSN Stop LSN Status
===================================================================================================================================
6001 9.2 S25JCU 2023-10-07 17:22:09+08 FULL STREAM 1/0 1m:5s 637MB 16MB 1.00 0/62A3A68 0/62A3AE8 OK
6001 9.2 S25J9F 2023-10-07 17:20:06+08 FULL STREAM 1/0 1m:4s 637MB 16MB 1.00 0/62A3828 0/62A38A8 OK
6001 9.2 S25ITW 2023-10-07 17:10:54+08 FULL STREAM 1/0 1m:12s 637MB 16MB 1.00 0/62A2E08 0/62A2E88 OK
疑惑的点:REDUNDANCY=2和WINDOW=2之间有什么优先级关系吗?为什么第一次备份超过2个的都删掉了,第二次也删掉了,但是第三次备份时S25ITW没有被删除?

我来答
添加附件
收藏
分享
问题补充
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏