Comment 0 for bug 1494981

While deploying OpenStack with galera-cluster, I am running into hook installation failure. It's not happening for every deployment but seems to be an issue with one of the builds:

+ . ./pipeline_parameters
++ export OPENSTACK_RELEASE=kilo
++ OPENSTACK_RELEASE=kilo
++ export COMPUTE=nova-lxc
++ COMPUTE=nova-lxc
++ export BLOCK_STORAGE=cinder-vnx
++ BLOCK_STORAGE=cinder-vnx
++ export IMAGE_STORAGE=glance-ceph
++ IMAGE_STORAGE=glance-ceph
++ export PIPELINE_ID=ac0e1835-1709-4db6-8c72-a57133e61453
++ PIPELINE_ID=ac0e1835-1709-4db6-8c72-a57133e61453
++ export MYSQL=galera-cluster
++ MYSQL=galera-cluster
++ export NETWORKING=nova-network-flatdhcp
++ NETWORKING=nova-network-flatdhcp
++ export UBUNTU_RELEASE=trusty
++ UBUNTU_RELEASE=trusty

From juju_status.yaml:

galera-cluster:
    charm: local:trusty/galera-cluster-45
    exposed: false
    relations:
      cluster:
      - galera-cluster
    service-status:
      current: error
      message: 'hook failed: "install"'
      since: 11 Sep 2015 21:32:51Z
    units:
      galera-cluster/0:
        agent-state: error
        agent-state-info: 'hook failed: "install"'
        agent-status:
          current: idle
          since: 11 Sep 2015 21:32:51Z
          version: 1.24.5
        agent-version: 1.24.5
        machine: '1'
        public-address: hayward-40.oil
        workload-status:
          current: error
          message: 'hook failed: "install"'
          since: 11 Sep 2015 21:32:51Z

From unit log:

2015-09-11 21:32:33 INFO install Setting up galera-3 (25.3.12-1trusty) ...
2015-09-11 21:32:45 INFO install Setting up libhtml-template-perl (2.95-1) ...
2015-09-11 21:32:45 INFO install Processing triggers for libc-bin (2.19-0ubuntu6.6) ...
2015-09-11 21:32:45 INFO install Processing triggers for ureadahead (0.100.0-16) ...
2015-09-11 21:32:46 INFO install * MySQL server PID file could not be found!
2015-09-11 21:32:46 INFO install Starting MySQL
2015-09-11 21:32:50 INFO install .... *
2015-09-11 21:32:50 INFO worker.uniter.jujuc server.go:158 running hook tool "juju-log" ["-l" "DEBUG" "Using existing password file '/var/lib/charm/galera-cluster/mysql.passwd'"]
2015-09-11 21:32:50 DEBUG worker.uniter.jujuc server.go:159 hook context id "galera-cluster/0-install-646729208580310464"; dir "/var/lib/juju/agents/unit-galera-cluster-0/charm"
2015-09-11 21:32:50 DEBUG juju-log Using existing password file '/var/lib/charm/galera-cluster/mysql.passwd'
2015-09-11 21:32:50 INFO worker.uniter.jujuc server.go:158 running hook tool "juju-log" ["-l" "DEBUG" "Opening db connection for root@localhost"]
2015-09-11 21:32:50 DEBUG worker.uniter.jujuc server.go:159 hook context id "galera-cluster/0-install-646729208580310464"; dir "/var/lib/juju/agents/unit-galera-cluster-0/charm"
2015-09-11 21:32:50 DEBUG juju-log Opening db connection for root@localhost
2015-09-11 21:32:51 INFO install Traceback (most recent call last):
2015-09-11 21:32:51 INFO install File "/var/lib/juju/agents/unit-galera-cluster-0/charm/hooks/install", line 444, in <module>
2015-09-11 21:32:51 INFO install main()
2015-09-11 21:32:51 INFO install File "/var/lib/juju/agents/unit-galera-cluster-0/charm/hooks/install", line 438, in main
2015-09-11 21:32:51 INFO install hooks.execute(sys.argv)
2015-09-11 21:32:51 INFO install File "/var/lib/juju/agents/unit-galera-cluster-0/charm/hooks/charmhelpers/core/hookenv.py", line 544, in execute
2015-09-11 21:32:51 INFO install self._hooks[hook_name]()
2015-09-11 21:32:51 INFO install File "/var/lib/juju/agents/unit-galera-cluster-0/charm/hooks/install", line 99, in install
2015-09-11 21:32:51 INFO install configure_sstuser(mysql_password)
2015-09-11 21:32:51 INFO install File "/var/lib/juju/agents/unit-galera-cluster-0/charm/hooks/galera_utils.py", line 158, in configure_sstuser
2015-09-11 21:32:51 INFO install m_helper.execute(SQL_SST_USER_SETUP.format(sst_password))
2015-09-11 21:32:51 INFO install File "/var/lib/juju/agents/unit-galera-cluster-0/charm/hooks/charmhelpers/contrib/database/mysql.py", line 134, in execute
2015-09-11 21:32:51 INFO install cursor.execute(sql)
2015-09-11 21:32:51 INFO install File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
2015-09-11 21:32:51 INFO install self.errorhandler(self, exc, value)
2015-09-11 21:32:51 INFO install File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2015-09-11 21:32:51 INFO install raise errorclass, errorvalue
2015-09-11 21:32:51 INFO install _mysql_exceptions.OperationalError: (1047, 'Unknown command')
2015-09-11 21:32:51 INFO juju.worker.uniter.context context.go:543 handling reboot
2015-09-11 21:32:51 ERROR juju.worker.uniter.operation runhook.go:103 hook "install" failed: exit status 1
2015-09-11 21:32:51 DEBUG juju.worker.uniter modes.go:31 [AGENT-STATUS] failed: run install hook
2015-09-11 21:32:51 INFO juju.worker.uniter modes.go:543 ModeContinue exiting
2015-09-11 21:32:51 INFO juju.worker.uniter modes.go:541 ModeHookError starting

I am attaching the unit log.