# HI EVERYONE! i have a problem wwhen i restart my system ( i have 2 node of Percona XtraDB Cluster 5.7, rehl 7.9 enterprise). i can't start mysql again **URL:** \ **Category:** Percona XtraDB Cluster 5.x\ **Tags:** community, troubleshooting, mysql, percona\ **Created:** [September 15, 2021, 4:10am UTC](https://forums.percona.com/t/hi-everyone-i-have-a-problem-wwhen-i-restart-my-system-i-have-2-node-of-percona-xtradb-cluster-5-7-rehl-7-9-enterprise-i-cant-start-mysql-again/12165 "2021-09-15T04:10:05Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Th\_ng\_D\_ng\_Van](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/th_ng_d_ng_van/32/4499_2.png) [@Th\_ng\_D\_ng\_Van](https://forums.percona.com/u/Th_ng_D_ng_Van)\ **Post date:** [September 15, 2021, 4:10am UTC](https://forums.percona.com/t/hi-everyone-i-have-a-problem-wwhen-i-restart-my-system-i-have-2-node-of-percona-xtradb-cluster-5-7-rehl-7-9-enterprise-i-cant-start-mysql-again/12165/1 "2021-09-15T04:10:05Z")
here is my config of my.cnf ```auto ============================= # !includedir /etc/my.cnf.d/ !includedir /etc/percona-xtradb-cluster.conf.d/ [mysqld] wait_timeout = 31536000 max_allowed_packet=1024M lower_case_table_names=1 wsrep_provider=/usr/lib64/galera3/libgalera_smm.so wsrep_cluster_name=democluster wsrep_cluster_address=gcomm://192.168.149.186,192.168.149.182 wsrep_node_name=DB1 wsrep_node_address=192.168.149.186 wsrep_sst_method=xtrabackup-v2 wsrep_sst_auth=admin:Admin@123 pxc_strict_mode=ENFORCING binlog_format=ROW default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 [mysqldump] max_allowed_packet=1024M [client] socket = /var/run/mysql/mysql.sock ~ ~ and this is log check. ========================== Sep 14 19:57:06 localhost.localdomain mysql-systemd[9171]: State transfer in progress, setting sleep higher Sep 14 19:57:07 localhost.localdomain mysqld_safe[9170]: 2021-09-15T02:57:07.261459Z mysqld_safe Logging to '/var/log/mysqld.log'. Sep 14 19:57:07 localhost.localdomain mysqld_safe[9170]: 2021-09-15T02:57:07.264735Z mysqld_safe Logging to '/var/log/mysqld.log'. Sep 14 19:57:07 localhost.localdomain mysqld_safe[9170]: 2021-09-15T02:57:07.295892Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Sep 14 19:57:07 localhost.localdomain mysqld_safe[9170]: 2021-09-15T02:57:07.306857Z mysqld_safe Skipping wsrep-recover for a1da470f-153d-11ec-834a-b7075e945411:1777 pair Sep 14 19:57:07 localhost.localdomain mysqld_safe[9170]: 2021-09-15T02:57:07.308612Z mysqld_safe Assigning a1da470f-153d-11ec-834a-b7075e945411:1777 to wsrep_start_position Sep 14 19:57:12 localhost.localdomain systemd[1]: mysql@bootstrap.service: main process exited, code=exited, status=1/FAILURE Sep 14 19:57:16 localhost.localdomain mysql-systemd[9171]: /usr/bin/mysql-systemd: line 140: kill: (9170) - No such process Sep 14 19:57:16 localhost.localdomain mysql-systemd[9171]: ERROR! mysqld_safe with PID 9170 has already exited: FAILURE Sep 14 19:57:16 localhost.localdomain systemd[1]: mysql@bootstrap.service: control process exited, code=exited status=1 Sep 14 19:57:16 localhost.localdomain mysql-systemd[9781]: WARNING: mysql pid file /var/run/mysqld/mysqld.pid empty or not readable Sep 14 19:57:16 localhost.localdomain mysql-systemd[9781]: ERROR! mysql already dead Sep 14 19:57:16 localhost.localdomain systemd[1]: mysql@bootstrap.service: control process exited, code=exited status=2 Sep 14 19:57:16 localhost.localdomain mysql-systemd[9811]: WARNING: mysql pid file /var/run/mysqld/mysqld.pid empty or not readable Sep 14 19:57:16 localhost.localdomain mysql-systemd[9811]: WARNING: mysql may be already dead Sep 14 19:57:16 localhost.localdomain systemd[1]: Failed to start Percona XtraDB Cluster with config /etc/sysconfig/mysql.bootstrap. -- Subject: Unit mysql@bootstrap.service has failed -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysql@bootstrap.service has failed. -- -- The result is failed. Sep 14 19:57:16 localhost.localdomain systemd[1]: Unit mysql@bootstrap.service entered failed state. Sep 14 19:57:16 localhost.localdomain systemd[1]: mysql@bootstrap.service failed. Sep 14 19:57:16 localhost.localdomain polkitd[692]: Unregistered Authentication Agent for unix-process:9122:230282 (system bus name :1.44, object path /org/freedesktop/PolicyKit1 ================================== ``` ANYONE have any idea for this proplem? THANK ALL! ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [September 15, 2021, 2:49pm UTC](https://forums.percona.com/t/hi-everyone-i-have-a-problem-wwhen-i-restart-my-system-i-have-2-node-of-percona-xtradb-cluster-5-7-rehl-7-9-enterprise-i-cant-start-mysql-again/12165/2 "2021-09-15T14:49:00Z")
Hello, Need to see your error logs. ---
**Author:** ![Eduardo](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/eduardo/32/2416_2.png) [@Eduardo](https://forums.percona.com/u/Eduardo)\ **Post date:** [September 15, 2021, 6:17pm UTC](https://forums.percona.com/t/hi-everyone-i-have-a-problem-wwhen-i-restart-my-system-i-have-2-node-of-percona-xtradb-cluster-5-7-rehl-7-9-enterprise-i-cant-start-mysql-again/12165/3 "2021-09-15T18:17:38Z")
Hello, Could you check the permissions of the `/var/run/mysqld/` directory and the `mysqld.pid` file? ```auto ls -ltra /var/run/mysqld/ ``` If the file exists and its owner is NOT mysql, delete `mysqld.pid` and try to startup again the db service. If that doesn’t work send us the file `/var/log/mysqld.log`, as Matthew said. Be careful, the my.cnf file also loads the contents of ```auto !includedir /etc/my.cnf.d/ !includedir /etc/percona-xtradb-cluster.conf.d/ ``` These directories may have other configuration files that you are not considering. For example by changing the content of the pid\_file variable. Best. E.