HA: R3.1-build-18-mysql service not up after rebooting one of the cfgm
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Juniper Openstack | Status tracked in Trunk | |||||
R3.1 |
Fix Committed
|
High
|
Ranjeet R | |||
R3.2 |
Fix Committed
|
High
|
Ranjeet R | |||
Trunk |
Fix Committed
|
High
|
Ranjeet R |
Bug Description
my sql service down after rebooting a cfgm node on HA setup. Before restart all the nodes are in sync and sql was running.
before restarting 10.84.13.38 :
=======
root@a6s32:
+------
| Variable_name | Value |
+------
| wsrep_local_
| wsrep_protocol_
| wsrep_last_
| wsrep_replicated | 76221 |
| wsrep_replicate
| wsrep_received | 19834 |
| wsrep_received_
| wsrep_local_commits | 75692 |
| wsrep_local_
| wsrep_local_replays | 0 |
| wsrep_local_
| wsrep_local_
| wsrep_local_
| wsrep_local_
| wsrep_flow_
| wsrep_flow_
| wsrep_flow_
| wsrep_cert_
| wsrep_apply_oooe | 0.000000 |
| wsrep_apply_oool | 0.000000 |
| wsrep_apply_window | 0.000000 |
| wsrep_commit_oooe | 0.000000 |
| wsrep_commit_oool | 0.000000 |
| wsrep_commit_window | 0.000000 |
| wsrep_local_state | 4 |
| wsrep_local_
| wsrep_cert_
| wsrep_causal_reads | 2244236 |
| wsrep_incoming_
| wsrep_cluster_
| wsrep_cluster_size | 3 |
| wsrep_cluster_
| wsrep_cluster_
| wsrep_connected | ON |
| wsrep_local_
| wsrep_local_index | 1 |
| wsrep_provider_name | Galera |
| wsrep_provider_
| wsrep_provider_
| wsrep_ready | ON |
=====
sql/error.log
=====
160809 16:52:34 [Note] Event Scheduler: Purging the queue. 1 events
160809 16:52:34 [Note] WSREP: dtor state: CLOSED
160809 16:52:34 [Note] WSREP: apply mon: entered 0
160809 16:52:34 [Note] WSREP: apply mon: entered 0
160809 16:52:34 [Note] WSREP: mon: entered 36 oooe fraction 0 oool fraction 0.0277778
160809 16:52:34 [Note] WSREP: cert index usage at exit 41
160809 16:52:34 [Note] WSREP: cert trx map usage at exit 31
160809 16:52:34 [Note] WSREP: deps set usage at exit 0
160809 16:52:34 [Note] WSREP: avg deps dist 12.0323
160809 16:52:34 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0
160809 16:52:34 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: 96466)
160809 16:52:34 [Note] WSREP: Flushing memory map to disk...
160809 16:52:34 InnoDB: Starting shutdown...
160809 16:52:35 InnoDB: Shutdown completed; log sequence number 354370014
160809 16:52:35 [Note] /usr/sbin/mysqld: Shutdown complete
160809 16:52:35 mysqld_safe mysqld from pid file /var/run/
work around: service mysql restart
summary: |
- HA: mysql service not up after rebooting one of the cfgm + HA: R3.1-build-18-mysql service not up after rebooting one of the cfgm |
information type: | Proprietary → Public |
tags: | added: blocker |
Reasonable workaround available.