Mysql resource is unable to start after failover due to permission change on '/var/lib/mysql' directory.
Issue
- Permission of mount point of mysql data directory gets changed.
-
Mysql resource
is unable to start in the other node after failover from first node.Sep 2 16:23:57 node A rgmanager[144383]: [fs] mounting /dev/dm-4 on /var/lib/mysql Sep 2 16:23:57 node A kernel: EXT4-fs (dm-4): mounted filesystem with ordered data mode. Opts: Sep 2 16:23:57 node A rgmanager[144527]: [mysql] Checking Existence Of File /var/run/cluster/mysql/mysql:DB_name.pid [mysql:DB_name] > Failed Sep 2 16:23:57 node A rgmanager[144549]: [mysql] Monitoring Service mysql:DB_name > Service Is Not Running Sep 2 16:23:57 node A rgmanager[144571]: [mysql] Starting Service mysql:DB_name Sep 2 16:24:27 node A rgmanager[145724]: [mysql] Starting Service mysql:DB_name > Failed - Timeout Error Sep 2 16:24:27 node A rgmanager[4142]: start on mysql "DB_name" returned 1 (generic error)
Environment
- Red Hat Enterprise Linux Server 6 (with the High Availability and Resilient Storage Add Ons)
- MySQL
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.