Geo replication can't be resumed after paused
Summary
!4331 (merged) introduced pause/resume for the Geo replication, however replication fails when resuming the DB replication because of a syntax error.
Steps to reproduce
Run:
gitlab-ctl geo-replication-pause
gitlab-ctl geo-replication-resume
root@geo-secondary:~# gitlab-ctl geo-replication-resume
* Resume replication
Postgres encountered an error: Unable to resume postgres replication
What is the current bug behavior?
Replication doesn't resume.
What is the expected correct behavior?
Replication should resume.
Relevant logs
Relevant logs
From
/var/log/gitlab/postgresql/current2020-07-30_09:44:22.96260 ERROR: syntax error at or near "pg_wal_replay_resume" at character 1 2020-07-30_09:44:22.96263 STATEMENT: pg_wal_replay_resume();
Details of package version
Provide the package version installation details
v13.2.1-ee
Configuration details
Provide the relevant sections of `/etc/gitlab/gitlab.rb`
Basic Geo secondary
Noted by Premium customer in ZD (internal only)
Workaround
Current workaround is to run the resuming manually using:
sudo gitlab-psql -c 'SELECT pg_wal_replay_resume();'
sudo gitlab-rake geo:replication:resume
Edited by Catalin Irimie