Fuel7.0 three controller in a high availability environment, restart clone_p_mysql resources, only one controller node can start, and two control nodes can't start!

Asked by yexian on 2016-03-25

pcs status

Clone Set: clone_p_mysql [p_mysql]
     Started: [ node-15.domain.tld ]
     Stopped: [ node-13.domain.tld node-14.domain.tld ]

Log in mysql ,Prompt:

ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0

Start the msyql OCF script:
 /usr/lib/ocf/resource.d/fuel/mysql-wss start

ocf-mysql-wss: ERROR: MySQL is not running
ocf-mysql-wss: INFO: GTID OK: 53046878-e9bf-11e5-8d23-768a6d8bafa7:10239529
ocf-mysql-wss: INFO: Galera GTID: 53046878-e9bf-11e5-8d23-768a6d8bafa7:10239529
ocf-mysql-wss: INFO: Starting MySQL
ocf-mysql-wss: INFO: PIDFile /var/run/resource-agents/mysql-wss/mysql-wss.pid of MySQL server not found. Sleeping for 5 seconds. 0 retries left
ocf-mysql-wss: INFO: MySQL is not running
ocf-mysql-wss: INFO: PIDFile /var/run/resource-agents/mysql-wss/mysql-wss.pid of MySQL server not found. Sleeping for 5 seconds. 0 retries left
ocf-mysql-wss: INFO: MySQL is not running
ocf-mysql-wss: INFO: PIDFile /var/run/resource-agents/mysql-wss/mysql-wss.pid of MySQL server not found. Sleeping for 5 seconds. 0 retries left
ocf-mysql-wss: INFO: MySQL is not running
ocf-mysql-wss: INFO: PIDFile /var/run/resource-agents/mysql-wss/mysql-wss.pid of MySQL server not found. Sleeping for 5 seconds. 0 retries left
ocf-mysql-wss: INFO: MySQL is not running
ocf-mysql-wss: INFO: PIDFile /var/run/resource-agents/mysql-wss/mysql-wss.pid of MySQL server not found. Sleeping for 5 seconds. 0 retries left
ocf-mysql-wss: INFO: MySQL is not running

with the command 'crm resource cleanup clone_p_mysql' and 'crm resource restart clone_p_mysql' After the restart as not.

Question information

Language:
English Edit question
Status:
Solved
For:
Fuel for OpenStack Edit question
Assignee:
No assignee Edit question
Solved by:
yexian
Solved:
2016-04-07
Last query:
2016-04-07
Last reply:
yexian (yexianwolail) said : #1

Maintenance Update 2 - resolved issues

https://bugs.launchpad.net/fuel/+bug/1505735