Hi Guys
I am having the below problems with my 22.04 cluster .
I cannot restart database resource and when I switch the frontend the database are stopping on both nodes
Cluster name: centreon_cluster
Cluster Summary:
* Stack: corosync (Pacemaker is running)
* Current DC: FRSDPRECENTHAFE02 (version 2.1.6-9.1.el8_9-6fdc9deea29) - partition with quorum
* Last updated: Wed May 8 05:38:41 2024 on FRSDPRECENTHAFE01
* Last change: Wed May 8 05:21:17 2024 by hacluster via crmd on FRSDPRECENTHADB03
* 4 nodes configured
* 21 resource instances configured
Node List:
* Online: [ FRSDPRECENTHADB03 FRSDPRECENTHADB04 FRSDPRECENTHAFE01 FRSDPRECENTHAFE02 ]
Full List of Resources:
* Clone Set: ms_mysql-clone [ms_mysql] (promotable):
* Stopped: [ FRSDPRECENTHADB03 FRSDPRECENTHADB04 FRSDPRECENTHAFE01 FRSDPRECENTHAFE02 ]
* vip_mysql (ocf::heartbeat:IPaddr2): Started FRSDPRECENTHADB03
* Clone Set: php-clone [php]:
* Started: [ FRSDPRECENTHAFE01 FRSDPRECENTHAFE02 ]
* Stopped: [ FRSDPRECENTHADB03 FRSDPRECENTHADB04 ]
* Clone Set: cbd_rrd-clone [cbd_rrd]:
* Started: [ FRSDPRECENTHAFE01 FRSDPRECENTHAFE02 ]
* Stopped: [ FRSDPRECENTHADB03 FRSDPRECENTHADB04 ]
* Resource Group: centreon:
* vip (ocf::heartbeat:IPaddr2): Started FRSDPRECENTHAFE01
* http (systemd:httpd): Started FRSDPRECENTHAFE01
* gorgone (systemd:gorgoned): Started FRSDPRECENTHAFE01
* centreon_central_sync (systemd:centreon-central-sync): Started FRSDPRECENTHAFE01
* cbd_central_broker (systemd:cbd-sql): Started FRSDPRECENTHAFE01
* centengine (systemd:centengine): Started FRSDPRECENTHAFE01
* centreontrapd (systemd:centreontrapd): Started FRSDPRECENTHAFE01
* snmptrapd (systemd:snmptrapd): Started FRSDPRECENTHAFE01
Failed Resource Actions:
* ms_mysql_start_0 on FRSDPRECENTHADB03 'error' (1): call=186, status='complete', exitreason='Failed initial monitor action', last-rc-change='Wed May 8 05:21:17 2024', queued=0ms, exec=2577ms
* ms_mysql_start_0 on FRSDPRECENTHADB04 'error' (1): call=183, status='complete', exitreason='Failed initial monitor action', last-rc-change='Wed May 8 05:21:19 2024', queued=0ms, exec=2550ms
Daemon Status:
corosync: active/enabled
pacemaker: active/enabled
pcsd: active/enabled
[root@FRSDPRECENTHAFE01 ~]# pcs resource restart ms_mysql-clone
Error: ms_mysql-clone is not running anywhere and so cannot be restarted
crm_resource: Error performing operation: No such object