mariadb - bootstraping happens before the socket is accessible

Bug #1536633 reported by Michal Rostecki on 2016-01-21
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
kolla
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

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

Changed in kolla:
status: Confirmed → In Progress

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

Sam Yaple (s8m) on 2016-02-05
Changed in kolla:
assignee: Michal Rostecki (mrostecki) → Sam Yaple (s8m)

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  Edit
Everyone can see this information.

Other bug subscribers