pxc cluster charm on Vivid and Wily point to old mysql datadir /var/lib/mysql

[Ryan Beisner]

pxc server 5.6 on Vivid & Wily does not create /var/lib/mysql

# From juju unit log:
00:25:46.630 2015-08-04 12:59:14 INFO worker.uniter.jujuc server.go:158 running hook tool "juju-log" ["Making dir /etc/mysql root:root 755"]
00:25:46.630 2015-08-04 12:59:14 INFO juju-log Making dir /etc/mysql root:root 755
00:25:46.630 2015-08-04 12:59:14 INFO worker.uniter.jujuc server.go:158 running hook tool "juju-log" ["Writing file /etc/mysql/my.cnf root:root 444"]
00:25:46.630 2015-08-04 12:59:14 INFO juju-log Writing file /etc/mysql/my.cnf root:root 444
00:25:46.630 2015-08-04 12:59:14 INFO config-changed df: '/var/lib/mysql/.': No such file or directory

# Package version info
ubuntu@1ea-vivid202230:~$ apt-cache policy percona-xtradb-cluster-server-5.6
percona-xtradb-cluster-server-5.6:
  Installed: 5.6.21-25.8-0ubuntu2
  Candidate: 5.6.21-25.8-0ubuntu2
  Version table:
 *** 5.6.21-25.8-0ubuntu2 0
        500 http://nova.clouds.archive.ubuntu.com/ubuntu/ vivid-updates/universe amd64 Packages
        100 /var/lib/dpkg/status
     5.6.21-25.8-0ubuntu1 0
        500 http://nova.clouds.archive.ubuntu.com/ubuntu/ vivid/universe amd64 Packages

[Ryan Beisner (1chb1n)]

FYI, I've manually installed the package on a fresh Vivid instance, without a charm, to confirm that the dir indeed is not created. Appears to be a packaging issue.

[Ryan Beisner (1chb1n)]

Confirmed that this also impacts Wily:

ubuntu@1ea-wily214622:~$ apt-cache policy percona-xtradb-cluster-server-5.6
percona-xtradb-cluster-server-5.6:
  Installed: 5.6.21-25.8-0ubuntu2
  Candidate: 5.6.21-25.8-0ubuntu2
  Version table:
 *** 5.6.21-25.8-0ubuntu2 0
        500 http://nova.clouds.archive.ubuntu.com/ubuntu/ wily/universe amd64 Packages
        100 /var/lib/dpkg/status

ubuntu@1ea-wily214622:~$ ls /var/lib/mysql
ls: cannot access /var/lib/mysql: No such file or directory

ubuntu@1ea-wily214622:~$ uname -a
Linux 1ea-wily214622 4.1.0-3-generic #3-Ubuntu SMP Tue Jul 28 12:25:10 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux

ubuntu@1ea-wily214622:~$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu Wily Werewolf (development branch)
Release: 15.10
Codename: wily

[Ryan Beisner (1chb1n)]

Vivid-Kilo with percona-cluster is still failing:
http://paste.ubuntu.com/12605065/

[Ryan Beisner (1chb1n)]

Also, Wily-Liberty percona-cluster unit log trace, fyi:

2015-09-28 20:14:51 INFO config-changed Traceback (most recent call last):
2015-09-28 20:14:51 INFO config-changed File "/var/lib/juju/agents/unit-mysql-0/charm/hooks/config-changed", line 630, in <module>
2015-09-28 20:14:51 INFO config-changed main()
2015-09-28 20:14:51 INFO config-changed File "/var/lib/juju/agents/unit-mysql-0/charm/hooks/config-changed", line 624, in main
2015-09-28 20:14:51 INFO config-changed hooks.execute(sys.argv)
2015-09-28 20:14:51 INFO config-changed File "/var/lib/juju/agents/unit-mysql-0/charm/hooks/charmhelpers/core/hookenv.py", line 672, in execute
2015-09-28 20:14:51 INFO config-changed self._hooks[hook_name]()
2015-09-28 20:14:51 INFO config-changed File "/var/lib/juju/agents/unit-mysql-0/charm/hooks/config-changed", line 248, in config_changed
2015-09-28 20:14:51 INFO config-changed bootstrap=not bootstrapped)
2015-09-28 20:14:51 INFO config-changed File "/var/lib/juju/agents/unit-mysql-0/charm/hooks/config-changed", line 191, in render_config_restart_on_changed
2015-09-28 20:14:51 INFO config-changed mark_seeded()
2015-09-28 20:14:51 INFO config-changed File "/var/lib/juju/agents/unit-mysql-0/charm/hooks/percona_utils.py", line 77, in mark_seeded
2015-09-28 20:14:51 INFO config-changed with open(SEEDED_MARKER, 'w') as seeded:
2015-09-28 20:14:51 INFO config-changed IOError: [Errno 2] No such file or directory: '/var/lib/mysql/seeded'

[Liam Young (gnuoy)]

On a system that uses the charm to install percona-cluster on vivid the config is pointing at the wrong data dir.

charm install on vivd:

/usr/sbin/mysqld --print-defaults | grep -Eoh 'datadir.*' | awk '{print $1}'
datadir=/var/lib/mysql

pkg install withoutcharm on vivid:

/usr/sbin/mysqld --print-defaults | grep -Eoh 'datadir.*' | awk '{print $1}'
datadir=/var/lib/percona-xtradb-cluster