mysql trusty charm on vivid: hook failed: "slave-relation-changed" (Slave is not configured or failed to initialize properly)

[Ryan Beisner]

mysql trusty charm on vivid: hook failed: "slave-relation-changed" (Slave is not configured or failed to initialize properly)

For each of the mysql slave units, the applied server_id values are all 0, instead of being a unique ID as required.

Here are two as an example:

# from mysql-slave/0 unit:
$ mysql --version
mysql Ver 14.14 Distrib 5.6.23, for debian-linux-gnu (x86_64) using EditLine wrapper
$ mysql -u root -p -e "SHOW VARIABLES;"
http://paste.ubuntu.com/10830808/

# from mysql-slave/10 unit:
$ mysql --version
mysql Ver 14.14 Distrib 5.6.23, for debian-linux-gnu (x86_64) using EditLine wrapper
$ mysql -u root -p -e "SHOW VARIABLES;"
http://paste.ubuntu.com/10830812/

$ juju-deployer -B -v -c bundles/dev/mysql-scale.yaml -d vivid
...
2015-04-15 23:57:21 [INFO] deployer.import: Adding relations...
2015-04-15 23:57:21 [INFO] deployer.import: Adding relation mysql-slave:slave <-> mysql:master
2015-04-15 23:57:22 [DEBUG] deployer.import: Waiting for relation convergence 60s
2015-04-15 23:58:22 [ERROR] deployer.env: The following units had errors:
   unit: mysql-slave/16: machine: 19 agent-state: error details: hook failed: "slave-relation-changed"
unit: mysql-slave/7: machine: 10 agent-state: error details: hook failed: "slave-relation-changed"
unit: mysql-slave/2: machine: 5 agent-state: error details: hook failed: "slave-relation-changed"
unit: mysql-slave/17: machine: 20 agent-state: error details: hook failed: "slave-relation-changed"
unit: mysql-slave/5: machine: 8 agent-state: error details: hook failed: "slave-relation-changed"
unit: mysql-slave/8: machine: 11 agent-state: error details: hook failed: "slave-relation-changed"
unit: mysql-slave/11: machine: 14 agent-state: error details: hook failed: "slave-relation-changed"
unit: mysql-slave/6: machine: 9 agent-state: error details: hook failed: "slave-relation-changed"
unit: mysql-slave/4: machine: 7 agent-state: error details: hook failed: "slave-relation-changed"
unit: mysql-slave/14: machine: 17 agent-state: error details: hook failed: "slave-relation-changed"
unit: mysql-slave/15: machine: 18 agent-state: error details: hook failed: "slave-relation-changed"
unit: mysql-slave/0: machine: 3 agent-state: error details: hook failed: "slave-relation-changed"
unit: mysql-slave/13: machine: 16 agent-state: error details: hook failed: "slave-relation-changed"
unit: mysql-slave/10: machine: 13 agent-state: error details: hook failed: "slave-relation-changed"
unit: mysql-slave/3: machine: 6 agent-state: error details: hook failed: "slave-relation-changed"
unit: mysql-slave/12: machine: 15 agent-state: error details: hook failed: "slave-relation-changed"
unit: mysql-slave/9: machine: 12 agent-state: error details: hook failed: "slave-relation-changed"
unit: mysql-slave/18: machine: 21 agent-state: error details: hook failed: "slave-relation-changed"
unit: mysql-slave/1: machine: 4 agent-state: error details: hook failed: "slave-relation-changed"
2015-04-15 23:58:22 [INFO] deployer.cli: Deployment stopped. run time: 352.28

# from mysql-slave/0 unit (same errors on all slave units):
2015-04-15 23:57:41 INFO unit.mysql-slave/0.slave-relation-changed logger.go:40
ERROR 1794 (HY000) at line 1: Slave is not configured or failed to initialize properly. You must at least set --server-id to enable either a master or a slave. Additional error messages can be found in the MySQL error log.
2015-04-15 23:57:41 ERROR juju.worker.uniter.operation runhook.go:89 hook "slave-relation-changed" failed: exit status 1

juju stat: http://paste.ubuntu.com/10830444/
mysql-slave/0 unit log: http://paste.ubuntu.com/10830473/
mysql-slave/0 unit syslog: http://paste.ubuntu.com/10830458/
mysql-slave/0 unit dmesg: http://paste.ubuntu.com/10830460/
mysql-slave/0 unit mysql error.log: http://paste.ubuntu.com/10830464/
mysql-slave/0 unit pkg versions: http://paste.ubuntu.com/10830470/

bundle as tested: http://paste.ubuntu.com/10830500/

bundle on lp: http://bazaar.launchpad.net/~ost-maintainers/openstack-charm-testing/trunk/view/head:/bundles/dev/mysql-scale.yaml

FYI: the -d trusty target does deploy successfully (http://paste.ubuntu.com/10830302/).

[Ryan Beisner (1chb1n)]

Just in case anyone is wondering what the heck I do with such an odd bundle... I use it in place of a full OpenStack deployment bundle for basic undercloud testing, environment validation, and for exercising juju/proposed, juju/devel andjuju-deployer. The OpenStack bundles have a ton of relations and hooks firing off, all of which take time and increase potential for race or other issues. In comparison, the bundle used here is fast and simple, and roughly the same machine footprint.