MySQL OCF RA may fail to find possible masters
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Fuel for OpenStack |
Fix Committed
|
High
|
Bogdan Dobrelya | ||
6.1.x |
Won't Fix
|
High
|
MOS Maintenance | ||
7.0.x |
Won't Fix
|
High
|
MOS Maintenance | ||
8.0.x |
Won't Fix
|
High
|
MOS Maintenance | ||
Mitaka |
Fix Released
|
High
|
Bogdan Dobrelya | ||
Newton |
Fix Committed
|
High
|
Bogdan Dobrelya |
Bug Description
There is a flaw in chose_master() and get_possible_
By design, it shall:
- Find the most seen GTID among the online nodes. Ignore its SEQNO position for now.
- Filter nodes with the most seen GTID as possible masters.
- From those, pick the one with the latest commit (from GTID:SEQNO values) and chose it as a master to Join to.
But it works another way and may throw errors and behave in unexpected way.
Steps to reproduce were given in the Galera reliability testing https:/
There is also a way to reproduce it on a Fuel env given that the node-1, node-2, node-3 deployed as controller nodes:
1) https:/
2) PURGE=true ./vagrant_
3) docker exec -it jepsen bash -c "TESTPROC=mysqld lein test :only jepsen.
Changed in fuel: | |
importance: | Undecided → High |
tags: | added: area-library galera tech-debt |
description: | updated |
description: | updated |
Changed in fuel: | |
assignee: | Bogdan Dobrelya (bogdando) → Sergii Golovatiuk (sgolovatiuk) |
description: | updated |
description: | updated |
description: | updated |
description: | updated |
tags: | added: on-verification |
Fix proposed to branch: master /review. openstack. org/308410
Review: https:/