Skip to content

retention WAL purge #69

Closed
Closed
@gsmolk

Description

@gsmolk

Setup

            /-------B1------            timeline b
A1----------------A2----                timeline a

If we run pg_probackup delete -i A1 --wal then timeline b will be wiped out.

Test:

======================================================================
ERROR: test_delete_wal_between_multiple_timelines (tests.delete.DeleteTest)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "tests/delete.py", line 296, in test_delete_wal_between_multiple_timelines
    self.validate_pb(backup_dir)
  File "tests/helpers/ptrack_helpers.py", line 930, in validate_pb
    return self.run_pb(cmd_list + options, old_binary=old_binary, gdb=gdb)
  File "tests/helpers/ptrack_helpers.py", line 650, in run_pb
    raise ProbackupException(e.output.decode('utf-8'), self.cmd)
ProbackupException: 
 ERROR: u'INFO: Validate backups of the instance \'node\'\nINFO: Validating backup PRPIF7\nINFO: Backup PRPIF7 data files are valid\nWARNING: Thread [1]: Could not read WAL record at 0/7000028\nERROR: Thread [1]: WAL segment "/home/gsmol/git/postgres/contrib/pg_probackup/tests/tmp_dirs/delete/test_delete_wal_between_multiple_timelines/backup/wal/node/000000020000000000000007" is absent\nWARNING: There are not enough WAL records to consistenly restore backup PRPIF7 from START LSN: 0/7000028 to STOP LSN: 0/7000160\nWARNING: Backup PRPIF7 WAL segments are corrupted\nINFO: Validating backup PRPIF1\nINFO: Backup PRPIF1 data files are valid\nINFO: Backup PRPIF1 WAL segments are valid\nWARNING: Some backups are not valid\n'
 CMD: ['/home/gsmol/git/postgres/contrib/pg_probackup/pg_probackup validate -B /home/gsmol/git/postgres/contrib/pg_probackup/tests/tmp_dirs/delete/test_delete_wal_between_multiple_timelines/backup']

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions