Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] pg_basebackup: error: backup failed: ERROR: requested WAL segment 00000002000001960000002A has already been removed failed with exit code 1 #8917

Closed
JashBook opened this issue Feb 13, 2025 · 1 comment
Assignees
Labels
kind/bug Something isn't working
Milestone

Comments

@JashBook
Copy link
Collaborator

Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:

  1. create cluster
  2. load 500G data
  3. loading 500G data and backup
kbcli cluster backup pg-cluster --method pg-basebackup   
  1. see error
kubectl get pod 
NAME                                                              READY   STATUS      RESTARTS   AGE
dp-backup-0-backup-default-pg-cluster-20250213110918-4af495427n   2/2     Running     0          33m
dp-backup-0-backup-default-pg-cluster-20250213110918-4af49959kz   0/2     Error       0          3h30m

logs error pod

kubectl logs dp-backup-0-backup-default-pg-cluster-20250213110918-4af49959kz 
Defaulted container "backupdata" out of: backupdata, manager, dp-copy-datasafed (init)
Password: 
pg_basebackup: initiating base backup, waiting for checkpoint to complete
pg_basebackup: checkpoint completed
pg_basebackup: write-ahead log start point: 196/2A0000D0 on timeline 2
       84/595897141 kB (0%), 0/1 tablespace (-                                  )
2025/02/13 03:09:41 NOTICE: S3 bucket kbcli-test: Streaming uploads using chunk size 50Mi will have maximum file size of 488.281Gi
    49426/595897141 kB (0%), 0/1 tablespace (-                                  )
   114099/595897141 kB (0%), 0/1 tablespace (-                                  )
   175283/595897141 kB (0%), 0/1 tablespace (-                                  )
   234163/595897141 kB (0%), 0/1 tablespace (-                                  )
   288563/595897141 kB (0%), 0/1 tablespace (-                                  )
   347827/595897141 kB (0%), 0/1 tablespace (-                                  )
   409779/595897141 kB (0%), 0/1 tablespace (-                                  )
   468787/595897141 kB (0%), 0/1 tablespace (-                                  )
   528972/595897141 kB (0%), 0/1 tablespace (-                                  )
   596318/595897141 kB (0%), 0/1 tablespace (-                                  )
   658168/595897141 kB (0%), 0/1 tablespace (-                                  )
....
613763043/613763043 kB (100%), 0/1 tablespace (-                                  )
613843939/613843939 kB (100%), 0/1 tablespace (-                                  )
613933301/613933301 kB (100%), 0/1 tablespace (-                                  )
613933301/613933301 kB (100%), 1/1 tablespace                                         
pg_basebackup: error: backup failed: ERROR:  requested WAL segment 00000002000001960000002A has already been removed
failed with exit code 1

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

  • OS: [e.g. iOS]
  • Browser [e.g. chrome, safari]
  • Version [e.g. 22]

Additional context
Add any other context about the problem here.

@JashBook JashBook added the kind/bug Something isn't working label Feb 13, 2025
@wangyelei
Copy link
Contributor

wangyelei commented Feb 13, 2025

instead of wal-g. If using streaming backup as a replacement, it is necessary to back up to the data PVC first. Subsequent user demands need to be supported thereafter.

@github-actions github-actions bot added this to the Release 0.9.3 milestone Feb 13, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
kind/bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants