pgbouncer recipe attempts to set password when DB is in read-only mode
On the GPRD database nodes, apt-get
is failing because reconfigure
is attempting to set the password for the pgbouncer user on a read-only database:
* file[/opt/gitlab/embedded/service/gitlab-rails/ee/db/geo/schema.rb] action create (up to date)
Recipe: gitlab-ee::pgbouncer_user
* postgresql_user[pgbouncer] action create
* execute[create pgbouncer postgresql user] action run (skipped due to not_if)
* execute[set password for pgbouncer postgresql user] action run
[execute] ERROR: cannot execute ALTER ROLE in a read-only transaction
[execute] ERROR: cannot execute ALTER ROLE in a read-only transaction
[execute] ERROR: cannot execute ALTER ROLE in a read-only transaction
[execute] ERROR: cannot execute ALTER ROLE in a read-only transaction
Edited by Stan Hu