hook failed install _mysql_exceptions.OperationalError: (1047, 'Unknown command')
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
galera-cluster (Juju Charms Collection) |
Fix Released
|
Critical
|
Larry Michel |
Bug Description
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 some builds:
+ . ./pipeline_
++ export OPENSTACK_
++ OPENSTACK_
++ export COMPUTE=nova-lxc
++ COMPUTE=nova-lxc
++ export BLOCK_STORAGE=
++ BLOCK_STORAGE=
++ export IMAGE_STORAGE=
++ IMAGE_STORAGE=
++ export PIPELINE_
++ PIPELINE_
++ export MYSQL=galera-
++ MYSQL=galera-
++ export NETWORKING=
++ NETWORKING=
++ export UBUNTU_
++ UBUNTU_
From juju_status.yaml:
galera-cluster:
charm: local:trusty/
exposed: false
relations:
cluster:
- galera-cluster
service-status:
current: error
message: 'hook failed: "install"'
since: 11 Sep 2015 21:32:51Z
units:
galera-
current: idle
since: 11 Sep 2015 21:32:51Z
version: 1.24.5
machine: '1'
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-
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/
2015-09-11 21:32:50 DEBUG worker.uniter.jujuc server.go:159 hook context id "galera-
2015-09-11 21:32:50 DEBUG juju-log Using existing password file '/var/lib/
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-
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/
2015-09-11 21:32:51 INFO install main()
2015-09-11 21:32:51 INFO install File "/var/lib/
2015-09-11 21:32:51 INFO install hooks.execute(
2015-09-11 21:32:51 INFO install File "/var/lib/
2015-09-11 21:32:51 INFO install self._hooks[
2015-09-11 21:32:51 INFO install File "/var/lib/
2015-09-11 21:32:51 INFO install configure_
2015-09-11 21:32:51 INFO install File "/var/lib/
2015-09-11 21:32:51 INFO install m_helper.
2015-09-11 21:32:51 INFO install File "/var/lib/
2015-09-11 21:32:51 INFO install cursor.execute(sql)
2015-09-11 21:32:51 INFO install File "/usr/lib/
2015-09-11 21:32:51 INFO install self.errorhandl
2015-09-11 21:32:51 INFO install File "/usr/lib/
2015-09-11 21:32:51 INFO install raise errorclass, errorvalue
2015-09-11 21:32:51 INFO install _mysql_
2015-09-11 21:32:51 INFO juju.worker.
2015-09-11 21:32:51 ERROR juju.worker.
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.
Related branches
- Adam Israel (community): Approve
- Tim Van Steenburgh (community): Needs Information
-
Diff: 67 lines (+27/-5)2 files modifiedconfig.yaml (+9/-1)
hooks/galera_hooks.py (+18/-4)
Changed in galera-cluster (Juju Charms Collection): | |
status: | New → In Progress |
Changed in galera-cluster (Juju Charms Collection): | |
importance: | Undecided → Critical |
assignee: | nobody → Larry Michel (lmic) |
Changed in galera-cluster (Juju Charms Collection): | |
status: | In Progress → Fix Committed |
Changed in galera-cluster (Juju Charms Collection): | |
status: | Fix Committed → Fix Released |
We also hit it this morning with icehouse and trusty:
2015-09-17 12:57:30 INFO install Setting up galera-3 (25.3.12-1trusty) ... template- perl (2.95-1) ... leadership tracker.go:138 galera-cluster/0 renewing lease for galera-cluster leadership leadership tracker.go:165 checking galera-cluster/0 for galera-cluster leadership leadership tracker.go:180 galera-cluster/0 confirmed for galera-cluster leadership until 2015-09-17 12:58:39.535692631 +0000 UTC leadership tracker.go:182 galera-cluster/0 will renew galera-cluster leadership at 2015-09-17 12:58:09.535692631 +0000 UTC charm/galera- cluster/ mysql.passwd' "] cluster/ 0-install- 773090687129084 5817"; dir "/var/lib/ juju/agents/ unit-galera- cluster- 0/charm" charm/galera- cluster/ mysql.passwd' cluster/ 0-install- 773090687129084 5817"; dir "/var/lib/ juju/agents/ unit-galera- cluster- 0/charm" juju/agents/ unit-galera- cluster- 0/charm/ hooks/install" , line 444, in <module> juju/agents/ unit-galera- cluster- 0/charm/ hooks/install" , line 438, in main sys.argv) juju/agents/ unit-galera- cluster- 0/charm/ hooks/charmhelp ers/core/ hookenv. py", line 544, in execute hook_name] () juju/agents/ unit-galera- cluster- 0/charm/ hooks/install" , line 99, in install sstuser( mysql_password) juju/agents/ unit-galera- cluster- 0/charm/ hooks/galera_ utils.py" , line 158, in configure_sstuser execute( SQL_SST_ USER_SETUP. format( sst_password) ) juju/agents/ unit-galera- cluster- 0/charm/ hooks/charmhelp ers/contrib/ database/ mysql.. ..
2015-09-17 12:57:30 INFO install Setting up libhtml-
2015-09-17 12:57:30 INFO install Processing triggers for libc-bin (2.19-0ubuntu6.6) ...
2015-09-17 12:57:30 INFO install Processing triggers for ureadahead (0.100.0-16) ...
2015-09-17 12:57:32 INFO install * MySQL server PID file could not be found!
2015-09-17 12:57:32 INFO install Starting MySQL
2015-09-17 12:57:39 DEBUG juju.worker.
2015-09-17 12:57:39 DEBUG juju.worker.
2015-09-17 12:57:39 DEBUG juju.worker.
2015-09-17 12:57:39 INFO juju.worker.
2015-09-17 12:57:42 INFO install .......... *
2015-09-17 12:57:42 INFO worker.uniter.jujuc server.go:158 running hook tool "juju-log" ["-l" "DEBUG" "Using existing password file '/var/lib/
2015-09-17 12:57:43 DEBUG worker.uniter.jujuc server.go:159 hook context id "galera-
2015-09-17 12:57:43 DEBUG juju-log Using existing password file '/var/lib/
2015-09-17 12:57:44 INFO worker.uniter.jujuc server.go:158 running hook tool "juju-log" ["-l" "DEBUG" "Opening db connection for root@localhost"]
2015-09-17 12:57:44 DEBUG worker.uniter.jujuc server.go:159 hook context id "galera-
2015-09-17 12:57:44 DEBUG juju-log Opening db connection for root@localhost
2015-09-17 12:57:44 INFO install Traceback (most recent call last):
2015-09-17 12:57:44 INFO install File "/var/lib/
2015-09-17 12:57:44 INFO install main()
2015-09-17 12:57:44 INFO install File "/var/lib/
2015-09-17 12:57:44 INFO install hooks.execute(
2015-09-17 12:57:44 INFO install File "/var/lib/
2015-09-17 12:57:44 INFO install self._hooks[
2015-09-17 12:57:44 INFO install File "/var/lib/
2015-09-17 12:57:44 INFO install configure_
2015-09-17 12:57:44 INFO install File "/var/lib/
2015-09-17 12:57:44 INFO install m_helper.
2015-09-17 12:57:44 INFO install File "/var/lib/