Fuel for OpenStack

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

Asked by yexian

issue :/usr/lib/ocf/resource.d/fuel/mysql-wss start
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: ERROR: MySQL is not running
ocf-mysql-wss: INFO: GTID OK: 00000000-0000-0000-0000-000000000000:-1
ocf-mysql-wss: INFO: Galera GTID: 00000000-0000-0000-0000-000000000000:-1
Resource 'default' not found: No such device or address
Error performing operation: No such device or address
ocf-mysql-wss: INFO: Checking if Primary Component
ocf-mysql-wss: INFO: GTID OK: ab930efd-be75-11e5-be4d-6eb22e354d46:4823164
ocf-mysql-wss: INFO: Galera GTID: ab930efd-be75-11e5-be4d-6eb22e354d46:4823164
ocf-mysql-wss: INFO: No GTID for node-15.domain.tld
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: Possible masters: node-14.domain.tld
ocf-mysql-wss: INFO: Choosed master: node-14.domain.tld
Resource 'default' not found: No such device or address
Error performing operation: No such device or address
ocf-mysql-wss: INFO: Waiting for master. 290 seconds left
ocf-mysql-wss: INFO: GTID OK: ab930efd-be75-11e5-be4d-6eb22e354d46:4823917
ocf-mysql-wss: INFO: Galera GTID: ab930efd-be75-11e5-be4d-6eb22e354d46:4823917
ocf-mysql-wss: INFO: No GTID for node-15.domain.tld
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: Possible masters: node-14.domain.tld
ocf-mysql-wss: INFO: Choosed master: node-14.domain.tld
Resource 'default' not found: No such device or address
Error performing operation: No such device or address
ocf-mysql-wss: INFO: Waiting for master. 280 seconds left
ocf-mysql-wss: INFO: GTID OK: ab930efd-be75-11e5-be4d-6eb22e354d46:4823917
ocf-mysql-wss: INFO: Galera GTID: ab930efd-be75-11e5-be4d-6eb22e354d46:4823917
ocf-mysql-wss: INFO: No GTID for node-15.domain.tld
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: Possible masters: node-14.domain.tld
ocf-mysql-wss: INFO: Choosed master: node-14.domain.tld
Resource 'default' not found: No such device or address
Error performing operation: No such device or address
ocf-mysql-wss: INFO: Waiting for master. 270 seconds left
ocf-mysql-wss: INFO: GTID OK: ab930efd-be75-11e5-be4d-6eb22e354d46:4823917
ocf-mysql-wss: INFO: Galera GTID: ab930efd-be75-11e5-be4d-6eb22e354d46:4823917
ocf-mysql-wss: INFO: No GTID for node-15.domain.tld
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: Possible masters: node-14.domain.tld
ocf-mysql-wss: INFO: Choosed master: node-14.domain.tld
Resource 'default' not found: No such device or address
Error performing operation: No such device or address
ocf-mysql-wss: INFO: Waiting for master. 260 seconds left
ocf-mysql-wss: INFO: GTID OK: ab930efd-be75-11e5-be4d-6eb22e354d46:4823917
ocf-mysql-wss: INFO: Galera GTID: ab930efd-be75-11e5-be4d-6eb22e354d46:4823917
ocf-mysql-wss: INFO: No GTID for node-15.domain.tld
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: Possible masters: node-14.domain.tld
ocf-mysql-wss: INFO: Choosed master: node-14.domain.tld
Resource 'default' not found: No such device or address
Error performing operation: No such device or address

Question information

Language:
English Edit question
Status:
Expired
For:
Fuel for OpenStack Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Fabrizio Soppelsa (fsoppelsa) said : 		#1

Greetings Yexlan

you should not start/restart mysql resources on a MOS cluster by using OCF scripts, rather by using pcs. However, I imagine you were attempting some recovery after some pcs failure.

Here it seems that node-14 is identified by Galera successfully as the master, but that MySQL can't start there. Ensure on node-14 you have free space available in /var/lib/mysql, check the mysql logs there if there is unsynced data.

Please attach the MOS version too.

Revision history for this message
yexian (yexianwolail) said : 		#2

MOS version is 7.0
According to the way you said I have a try, now I am learning pacemaker high availability

Revision history for this message
Launchpad Janitor (janitor) said : 		#3

This question was expired because it remained in the 'Open' state without activity for the last 15 days.