2023-03-07: Patroni Main WALG push not working or delayed
Current Status
We had a temporary delay on walg uploads from 16:59 UTC to 17:29 UTC. This has since recovered on it's own.
While troubleshooting, we saw the wal-g process actively uploading files, and there wasn't any errors on the postgres logs regarding wal archives:
mchacon@patroni-main-2004-04-db-gprd.c.gitlab-production.internal:~$ sudo tail /var/log/wal-g/wal-g.log
INFO: 2023/03/07 17:25:17.241278 FILE PATH: 0000000B000AD6BD0000005E.br
INFO: 2023/03/07 17:25:17.252773 FILE PATH: 0000000B000AD6BD00000064.br
INFO: 2023/03/07 17:25:17.276335 FILE PATH: 0000000B000AD6BD00000060.br
INFO: 2023/03/07 17:25:17.300653 FILE PATH: 0000000B000AD6BD00000065.br
INFO: 2023/03/07 17:25:17.344755 FILE PATH: 0000000B000AD6BD00000066.br
INFO: 2023/03/07 17:25:17.478877 FILE PATH: 0000000B000AD6BD00000067.br
INFO: 2023/03/07 17:25:17.795801 FILE PATH: 0000000B000AD6BD00000069.br
INFO: 2023/03/07 17:25:17.796946 FILE PATH: 0000000B000AD6BD00000068.br
INFO: 2023/03/07 17:25:17.983823 FILE PATH: 0000000B000AD6BD0000006A.br
INFO: 2023/03/07 17:25:18.166636 FILE PATH: 0000000B000AD6BD0000006B.br
mchacon@patroni-main-2004-04-db-gprd.c.gitlab-production.internal:~$ sudo grep "wal-g" /var/log/gitlab/postgresql/postgresql.csv
mchacon@patroni-main-2004-04-db-gprd.c.gitlab-production.internal:~$ sudo ps aux |grep wal-g
root 1955290 5.3 0.0 3322748 277156 ? Sl Mar02 390:06 /opt/prometheus/mtail/mtail -progs /opt/prometheus/mtail/progs -logs /var/log/apt/term.log,/var/log/syslog,/var/log/td-agent/td-agent.log,/var/log/gitlab/pgbouncer/pgbouncer.log,/var/log/gitlab/postgresql/postgresql.csv,/var/log/wal-g/wal-g.log,/var/log/wal-g/wal-g_backup_push.log,/var/log/gitlab/patroni/*.log -logtostderr
gitlab-+ 3585482 0.0 0.0 2616 528 ? S 17:28 0:00 sh -c /opt/wal-g/bin/archive-walg.sh pg_wal/0000000B000AD6C00000007E
gitlab-+ 3585485 0.0 0.0 6900 3268 ? S 17:28 0:00 /bin/bash /opt/wal-g/bin/archive-walg.sh pg_wal/0000000B000AD6C00000007E
gitlab-+ 3585487 289 0.0 2880264 332688 ? Sl 17:28 0:02 /opt/wal-g/bin/wal-g wal-push pg_wal/0000000B000AD6C00000007E
mchacon 3585520 0.0 0.0 6440 2432 pts/0 S+ 17:28 0:00 grep wal-gWe verified archive files were being uploaded successfully to GCS.
The alert has now cleared.
More information will be added as we investigate the issue. For customers believed to be affected by this incident, please subscribe to this issue or monitor our status page for further updates.
📚 References and helpful links
Recent Events (available internally only):
- Feature Flag Log - Chatops to toggle Feature Flags Documentation
- Infrastructure Configurations
- GCP Events (e.g. host failure)
Deployment Guidance
- Deployments Log | Gitlab.com Latest Updates
- Reach out to Release Managers for S1/S2 incidents to discuss Rollbacks and/or Hot Patching | Rollback Runbook | Hot Patch Runbook
Use the following links to create related issues to this incident if additional work needs to be completed after it is resolved:
- Corrective action ❙ Infradev
- Incident Review ❙ Infra investigation followup
- Confidential Support contact ❙ QA investigation
Note: In some cases we need to redact information from public view. We only do this in a limited number of documented cases. This might include the summary, timeline or any other bits of information, laid out in out handbook page. Any of this confidential data will be in a linked issue, only visible internally. By default, all information we can share, will be public, in accordance to our transparency value.