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

database backup through bbr feature fails randomly with concourse 7.2 #154

Open
JCL38-ORANGE opened this issue Jun 11, 2021 · 1 comment

Comments

@JCL38-ORANGE
Copy link

Bug Report

  • Concourse version: 7.2.0
  • Deployment type (BOSH/Docker/binary): BOSH
  • Infrastructure/IaaS: Openstack and vSphere
  • It was working everytime with concourse 6

We have a backup configured with BBR (Bosh Backup Restore).
Randomly it fails with the message :
pg_dump: [archiver (db)] query failed: ERROR: relation "public.build_event_id_seq_15739788" does not exist
LINE 1: SELECT last_value, is_called FROM public.build_event_id_seq_...
^
pg_dump: [archiver (db)] query was: SELECT last_value, is_called FROM public.build_event_id_seq_15739788
2021/06/08 02:15:19 You may need to delete the artifact-file that was created before re-running.

@alexnguyen91
Copy link
Contributor

While #145 provide the retry feature, unfortunately it's broken because 'set -e' and '((ticks++))' don't work well together
#157 should fix the retry process. Until it get merged, you could modify the backup script to be the same with that PR #

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants