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 mms_mysql] (promotable):
    * Stopped:  FRSDPRECENTHADB03 FRSDPRECENTHADB04 FRSDPRECENTHAFE01 FRSDPRECENTHAFE02 ]
  * vip_mysql   (ocf:IPaddr2):        Started FRSDPRECENTHADB03
  * Clone Set: php-clone php]:
    * Started: p FRSDPRECENTHAFE01 FRSDPRECENTHAFE02 ]
    * Stopped: E FRSDPRECENTHADB03 FRSDPRECENTHADB04 ]
  * Clone Set: cbd_rrd-clone  cbd_rrd]:
    * Started: b FRSDPRECENTHAFE01 FRSDPRECENTHAFE02 ]
    * Stopped: N FRSDPRECENTHADB03 FRSDPRECENTHADB04 ]
  * Resource Group: centreon:
    * vip       (ocf: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
 

 

croot@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