Movatterモバイル変換


[0]ホーム

URL:


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

'ERROR: Not going to purge WAL because LSN is invalid' when there is backup with ERROR state #103

Closed
Labels
Milestone
@alexign

Description

@alexign

Got some strange behavior when by error make DELTA backup before any FULL in stream remote mode

root@backupserver:~/backup-tools# pg_probackup-10 show -B /backup/postgresql/backup --instance database============================================================================================================== Instance  Version  ID  Recovery Time  Mode  WAL  Current/Parent TLI  Time  Data  Start LSN  Stop LSN  Status==============================================================================================================root@backupserver:~/backup-tools#backupserver:~/backup-tools# pg_probackup-10 \>         backup \>         -B \>         /backup/postgresql/backup \>         --stream \>         -j \>         1 \>         --retention-redundancy=14 \>         --delete-expired \>         --delete-wal \>         --instance \>         database \>         --remote-host \>         databaseserver \>         --remote-user \>         postgres \>         -U \>         probackup \>         -d \>         pg_probackup \>         --log-level-file=verbose \>         --log-filename=database-20190726T182724.log \>         --log-directory=/backup/postgresql/backup/log/database \>         --log-rotation-age=0 \>         --ssh-options='-o UserKnownHostsFile=/dev/null -o StrictHostKeyChecking=no -o ServerAliveInterval=60 -o ServerAliveCountMax=5' \>         --compress \>         --compress-level \>         1 \>         --backup-mode=DELTAINFO: Backup start, pg_probackup version: 2.1.3, backup ID: PV9J42, backup mode: delta, instance: database, stream: true, remote trueERROR: Valid backup on current timeline is not found. Create new FULL backup before an incremental one.WARNING: Backup PV9J42 is running, setting its status to ERRORbackupserver:~/backup-tools# pg_probackup-10 show -B /backup/postgresql/backup --instance database======================================================================================================================= Instance   Version  ID      Recovery Time  Mode   WAL     Current/Parent TLI  Time  Data  Start LSN  Stop LSN  Status======================================================================================================================= database  10       PV9J42  ----           DELTA  STREAM  1 / 0                 0s    0B        0/0       0/0  ERRORbackupserver:~/backup-tools# pg_probackup-10 \>         backup \>         -B \>         /backup/postgresql/backup \>         --stream \>         -j \>         1 \>         --retention-redundancy=14 \>         --delete-expired \>         --delete-wal \>         --instance \>         database \>         --remote-host \>         databaseserver \>         --remote-user \>         postgres \>         -U \>         probackup \>         -d \>         pg_probackup \>         --log-level-file=verbose \>         --log-filename=database-20190726T182724.log \>         --log-directory=/backup/postgresql/backup/log/database \>         --log-rotation-age=0 \>         --ssh-options='-o UserKnownHostsFile=/dev/null -o StrictHostKeyChecking=no -o ServerAliveInterval=60 -o ServerAliveCountMax=5' \>         --compress \>         --compress-level \>         1 \>         --backup-mode=FULLINFO: Backup start, pg_probackup version: 2.1.3, backup ID: PV9J61, backup mode: full, instance: database, stream: true, remote trueINFO: Start transfering data filesINFO: Data files are transferedINFO: wait for pg_stop_backup()INFO: pg_stop backup() successfully executedINFO: Validating backup PV9J61INFO: Backup PV9J61 data files are validINFO: Backup PV9J61 completedINFO: Evaluate backups by retentionINFO: Backup PV9J61, mode: FULL, status: OK. Redundancy: 1/14, Time Window: 0.00d/0d. ActiveINFO: Backup PV9J42, mode: DELTA, status: ERROR. Redundancy: 2/14, Time Window: 0.00d/0d. ActiveERROR: Not going to purge WAL because LSN is invalidbackupserver:~/backup-tools# echo $?1root@backupserver:~/backup-tools# pg_probackup-10 show -B /backup/postgresql/backup --instance database==================================================================================================================================== Instance   Version  ID      Recovery Time           Mode   WAL     Current/Parent TLI  Time   Data   Start LSN    Stop LSN  Status==================================================================================================================================== database  10       PV9J61  2019-07-26 18:54:46+00  FULL   STREAM  1 / 0                50s  296MB  4/1B000028  4/1B00BD50  OK database  10       PV9J42  ----                    DELTA  STREAM  1 / 0                 0s     0B         0/0         0/0  ERROR

so FULL backup end with return code <> 0

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions


      [8]ページ先頭

      ©2009-2025 Movatter.jp