PostgreSQL resource fails to start with "My data may be inconsistent"
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
resource-agents (Ubuntu) |
Triaged
|
Undecided
|
Unassigned | ||
Focal |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
After setting up a PostgreSQL resource in a 2-node Focal cluster and trying to switch the Master and Slave, I got the following failure:
Failed Resource Actions:
* postgresql_start_0 on focal01 'error' (1): call=78, status='complete', exitreason='My data may be inconsistent. You have to remove /var/lib/
This is a known issue described here:
https:/
The workaround is to remove the /var/lib/
As reference this is my CIB:
node 1: focal01
node 2: focal02
primitive postgresql pgsql \
params pgctl="
op monitor timeout=30 interval=2
primitive vip_public IPaddr2 \
params ip=192.168.3.4 cidr_netmask=24 \
op monitor interval=10s
primitive vip_replica IPaddr2 \
params ip=192.168.3.3 cidr_netmask=24 \
op monitor interval=10s
ms master_postgresql postgresql \
meta notify=true master-max=1 master-node-max=1 clone-max=2 clone-node-max=1 target-role=Master
location cli-ban-
order order-vip_
colocation psql_master_
property cib-bootstrap-
have-watchdog=
dc-version=
cluster-
cluster-
stonith-
last-lrm-
rsc_defaults rsc-options: \
resource-
Changed in resource-agents (Ubuntu Focal): | |
status: | New → Confirmed |
Changed in resource-agents (Ubuntu): | |
status: | New → Triaged |
This is the upstream issue:
https:/ /github. com/ClusterLabs /resource- agents/ issues/ 699