Ocata to Pike upgrade fails for mysql init tasks

[Marios Andreou]

As seen in [0] docker-puppet for the mysql_init_tasks fails like:

Nov 4 00:16:58 centos-7-infracloud-vanilla-0000715575 os-collect-config: "2017-11-04 00:16:57,593 ERROR: 181964 -- Failed running docker-puppet.py for mysql_init_tasks" ...
Nov 4 00:16:58 centos-7-infracloud-vanilla-0000715575 os-collect-config: "Error: Execution of '/usr/bin/mysql --defaults-extra-file=/root/.my.cnf -NBe alter database `cinder` CHARACTER SET utf8' returned 1: ERROR 1 (HY000) at line 1: Can't create/write to file './cinder/db.opt' (Errcode: 13 \"Permission denied\")",

And this causes the upgrades job to fail.

[0] http://logs.openstack.org/25/500625/20/check/legacy-tripleo-ci-centos-7-containers-multinode-upgrades/f5f3e33/logs/subnode-2/var/log/messages.txt.gz#_Nov__4_00_16_58

[OpenStack Infra (hudson-openstack)]

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

[Jiří Stránský (jistr)]

The bug is probably best fixed by making the upgrade pacemaker-to-pacemaker via this commit:

https://review.openstack.org/#/c/512305/

But sofer's patch looks good as well. We don't CI non-pacemakerized containerized mysql anymore AFAIK, except for the upgrade CI job broken by this, which only CI'd it sorta "by accident".

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/517909
Committed: https://git.openstack.org/cgit/openstack/tripleo-heat-templates/commit/?id=0d65e380caf89d8c486e8ea87571298a6687b680
Submitter: Zuul
Branch: master

commit 0d65e380caf89d8c486e8ea87571298a6687b680
Author: Sofer Athlan-Guyot <email address hidden>
Date: Mon Nov 6 11:45:20 2017 +0100

    Fix wrong permission on database during mysql_init tasks.

    During mysql initialization, mysql needs to be able to write in the
    database directory.

    Change-Id: I82c2e46f66ab01021cb910eb7e0d17c81b00fa09
    Closes-bug: #1730349

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/pike
Review: https://review.openstack.org/518513

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/518513
Committed: https://git.openstack.org/cgit/openstack/tripleo-heat-templates/commit/?id=211149c31496789c71c777f20d90685959270aa7
Submitter: Zuul
Branch: stable/pike

commit 211149c31496789c71c777f20d90685959270aa7
Author: Sofer Athlan-Guyot <email address hidden>
Date: Mon Nov 6 11:45:20 2017 +0100

    Fix wrong permission on database during mysql_init tasks.

    During mysql initialization, mysql needs to be able to write in the
    database directory.

    Change-Id: I82c2e46f66ab01021cb910eb7e0d17c81b00fa09
    Closes-bug: #1730349
    (cherry picked from commit 0d65e380caf89d8c486e8ea87571298a6687b680)

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/tripleo-heat-templates 7.0.4 release.

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/tripleo-heat-templates 8.0.0.0b2 development milestone.