After maintenance updates fuel-7.0-mu-3, using the CRM or ocf restart mysql can't start

Bug #1593028 reported by yexian
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Fuel for OpenStack
Triaged
High
Denis Puchkin

Bug Description

After maintenance updates fuel-7.0-mu-3, using the CRM or ocf restart mysql can't start,
Even though,The fix adds the SST state to mysql_monitor not to terminate the mysql process while SST is in progress.https://bugs.launchpad.net/fuel/+bug/1478310
problems still exist,but,maintenance updates fuel-7.0-mu-2 Solved the problem: https://bugs.launchpad.net/fuel/+bug/1505735

After maintenance updates fuel-7.0-mu-3,Instead,New problems have appeared, and the MySQL OCF script that caused startup failures of MySQL Pacemaker resource

After maintenance updates fuel-7.0-mu-3:
1. command:
   crm resource cleanup p_mysql
   crm resource restart p_mysql
   pcs status

observed result:Invalid, without any change

2.command:
  /bin/bash /usr/lib/ocf/resource.d/fuel/mysql-wss start

observed result:"SST is in progress",In fact, there is no running mysql

3.command:
  rm -rf /var/lib/mysql/sst_in_progress
  /bin/bash /usr/lib/ocf/resource.d/fuel/mysql-wss start

 show:

ocf-mysql-wss: INFO: Waiting for master. 10 seconds left
ocf-mysql-wss: INFO: GTID OK: 00000000-0000-0000-0000-000000000000:-1
ocf-mysql-wss: INFO: Galera GTID: 00000000-0000-0000-0000-000000000000:-1
ocf-mysql-wss: INFO: GTID OK: 00000000-0000-0000-0000-000000000000:-1
ocf-mysql-wss: INFO: Galera GTID: 00000000-0000-0000-0000-000000000000:-1
ocf-mysql-wss: INFO: GTID OK: f9570f6f-057e-11e6-9587-d221783d0d35:56045431
ocf-mysql-wss: INFO: Galera GTID: f9570f6f-057e-11e6-9587-d221783d0d35:56045431
ocf-mysql-wss: INFO: Possible masters: node-29.domain.tld
ocf-mysql-wss: INFO: Choosed master: node-29.domain.tld
ocf-mysql-wss: INFO: Waiting for master. 0 seconds left
ocf-mysql-wss: INFO: node-28.domain.tld is not Primary Component
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
.......

Tags: area-library
yexian (yexianwolail)
summary: After maintenance updates fuel-7.0-mu-3, using the CRM or ocf restart
- mysql can't star
+ mysql can't start
Revision history for this message
Bogdan Dobrelya (bogdando) wrote :
Changed in fuel:
status: New → Triaged
milestone: none → 7.0-updates
assignee: nobody → MOS Maintenance (mos-maintenance)
importance: Undecided → High
Dmitry Klenov (dklenov)
tags: added: area-library
Changed in fuel:
milestone: 7.0-updates → 7.0-mu-6
Denis Puchkin (dpuchkin)
Changed in fuel:
assignee: MOS Maintenance (mos-maintenance) → Denis Puchkin (dpuchkin)
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.