Mysql die after deployment and can not be recovered near 40 minutes, that leads to 500 error from different services
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Fuel for OpenStack |
Fix Released
|
High
|
Sergii Golovatiuk | ||
| 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 | ||
Bug Description
Problem appears om next test:
Deploy cluster in ha multirole mode with Ceilometer
Scenario:
1. Create cluster. Set install Ceilometer option
2. Add 3 node with controller and mongo roles
3. Add 1 nodes with compute role
4. Add 1 nodes with cinder
5. Deploy the cluster
6. Verify ceilometer api is running
7. Run OSTF
Expected Result:
All OSTF tests are passed
Actual:
Smoke, sanity, ha -tests are passed, but Ceilometer tests failed with 50x errors from neutron:
http://
in neutron log we can see that there is no connection to mysql
http://
in mysql/error log there was failure:
http://
VERSION:
feature_groups:
- mirantis
production: "docker"
release: "8.0"
api: "1.0"
build_number: "523"
build_id: "523"
fuel-nailgun_sha: "9cfaee884d5a2a
python-
fuel-agent_sha: "658be72c4b42d3
fuel-
astute_sha: "b81577a5b7857c
fuel-library_sha: "71d3a7f43effd4
fuel-ostf_sha: "7bcddf18020f2d
fuel-mirror_sha: "c25d8931e30322
fuelmenu_sha: "e071216cb214e3
shotgun_sha: "63645dea384a37
network-
fuel-upgrade_sha: "616a7490ec7199
fuelmain_sha: "a365f05b903368
| Sergii Golovatiuk (sgolovatiuk) wrote | #1 |
| Changed in fuel: | |
| assignee: | Fuel Library Team (fuel-library) → Sergii Golovatiuk (sgolovatiuk) |
| Tatyanka (tatyana-leontovich) wrote | #2 |
| Changed in fuel: | |
| status: | New → Confirmed |
| tags: | added: team-bugfix |
| Dmitry Pyzhov (dpyzhov) wrote | #3 |
| Changed in fuel: | |
| milestone: | 8.0 → 9.0 |
| Vladimir Kuklin (vkuklin) wrote | #4 |
| OpenStack Infra (hudson-openstack) wrote Fix proposed to fuel-library (master) | #5 |
| Changed in fuel: | |
| status: | Confirmed → In Progress |
| OpenStack Infra (hudson-openstack) wrote Fix merged to fuel-library (master) | #6 |
| Changed in fuel: | |
| status: | In Progress → Fix Committed |
| tags: | added: on-verification |
| ElenaRossokhina (esolomina) wrote | #7 |
| Changed in fuel: | |
| status: | Fix Committed → Fix Released |
| tags: | removed: on-verification |
| OpenStack Infra (hudson-openstack) wrote Fix proposed to fuel-library (stable/6.1) | #8 |
| OpenStack Infra (hudson-openstack) wrote Fix proposed to fuel-library (stable/7.0) | #9 |
| OpenStack Infra (hudson-openstack) wrote Fix proposed to fuel-library (stable/8.0) | #10 |
| OpenStack Infra (hudson-openstack) wrote Change abandoned on fuel-library (stable/8.0) | #11 |
| OpenStack Infra (hudson-openstack) wrote Change abandoned on fuel-library (stable/7.0) | #12 |
| OpenStack Infra (hudson-openstack) wrote Change abandoned on fuel-library (stable/6.1) | #13 |
| Vitaly Sedelnik (vsedelnik) wrote | #14 |
| OpenStack Infra (hudson-openstack) wrote Fix proposed to fuel-library (stable/7.0) | #15 |
| OpenStack Infra (hudson-openstack) wrote Fix merged to fuel-library (stable/7.0) | #16 |
| OpenStack Infra (hudson-openstack) wrote Fix proposed to fuel-library (stable/8.0) | #17 |
| OpenStack Infra (hudson-openstack) wrote Fix merged to fuel-library (stable/8.0) | #18 |
As stated in https:/
There is a bug in MySQL OCF stop function. It doesn't kill the process in normal amount of time. However, this bug leads to issues only with one controller as in 3 controller environment haproxy will switch traffic to 'working' instance of mysql on different controller.