Activity log for bug #1444756

Date Who What changed Old value New value Message
2015-04-16 00:26:56 Ryan Beisner bug added bug
2015-04-16 00:29:48 Ryan Beisner branch linked lp:charms/trusty/mysql
2015-04-16 02:38:52 Ryan Beisner description mysql trusty charm on vivid: hook failed: "slave-relation-changed" (Slave is not configured or failed to initialize properly) $ 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/). 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/).