mariadb - bootstraping happens before the socket is accessible

Bug #1536633 reported by Michal Rostecki
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
kolla
Fix Released
High
Sam Yaple

Bug Description

Reproduceable in kolla-mesos.

Sometimes this part of bootstrap happens before the socket to mysql is available: https://github.com/openstack/kolla/blob/master/docker/mariadb/extend_start.sh#L15-L18

There are no logs for that, because that failure is silent. However, the proof of that is inability to log in to mariadb deployed in kolla-mesos, i.e. in Ansible tasks trying to log in to MariaDB:

localhost | FAILED! => {
    "changed": false,
    "failed": true,
    "invocation": {
        "module_args": {
            "login_host": "172.28.128.81",
            "login_password": "password",
            "login_port": "3306",
            "login_user": "root",
            "variable": "sync_binlog"
        },
        "module_name": "mysql_variables"
    },
    "msg": "unable to connect to database, check login_user and login_password are correct or ~/.my.cnf has the credentials (ERROR: 1045 Access denied for user 'root'@'operator.local' (using password: YES))"
}

Changed in kolla:
importance: Undecided → High
milestone: none → mitaka-3
assignee: nobody → Michal Rostecki (mrostecki)
status: New → Confirmed
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to kolla (master)

Fix proposed to branch: master
Review: https://review.openstack.org/270810

Changed in kolla:
status: Confirmed → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Change abandoned on kolla (master)

Change abandoned by Michal Rostecki (<email address hidden>) on branch: master
Review: https://review.openstack.org/270810

Sam Yaple (s8m)
Changed in kolla:
assignee: Michal Rostecki (mrostecki) → Sam Yaple (s8m)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to kolla (master)

Fix proposed to branch: master
Review: https://review.openstack.org/276851

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to kolla (master)

Reviewed: https://review.openstack.org/276851
Committed: https://git.openstack.org/cgit/openstack/kolla/commit/?id=bf6b75da3f5ac928c2ff14e5585c6b2574155381
Submitter: Jenkins
Branch: master

commit bf6b75da3f5ac928c2ff14e5585c6b2574155381
Author: SamYaple <email address hidden>
Date: Fri Feb 5 17:41:21 2016 +0000

    Make a final check to validate mysql works

    This ensures mysql works through whatever the vip is

    Change-Id: Iaeb17240b90ae2f0fef081b42d4ba140dcecd972
    Closes-Bug: #1536633

Changed in kolla:
status: In Progress → Fix Released
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.