my.cnf not symlinked to /etc/mysql/percona-xtradb-cluster.cnf after upgrading to bionic
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Percona Cluster Charm |
New
|
Undecided
|
Unassigned |
Bug Description
I have upgraded a percona 3-node cluster from trusty to xenial and from xenial to bionic.
The first upgrade appeared to complete successfully, while the one to bionic failed completely.
These are the symptoms I have observed:
* the post-series-upgrade hook hit bug 1838041. I worked around it by simply commenting out the subprocess call to mysql_upgrade:
441 # Execute the upgrade process
442 log("Running mysql_upgrade")
443 cmd = ['mysql_upgrade']
444 if _release == "xenial":
445 cmd.append(
446 #subprocess.
* the update-alternatives entry for my.cnf was making /etc/mysql/my.cnf point to /etc/mysql/
The update-alternatives setup is performed in the post-series-upgrade hook when upgrading to xenial:
458 if _release == "xenial":
459 # Point at the correct my.cnf
460 cmd = ["update-
461 "/etc/mysql/
462 subprocess.
I do not know if this wasn't run when I transitioned from trusty to xenial, or if it got undone when upgrading to bionic, but it surely made the upgrade process very difficult to debug.
Charm version used: 291