Comment 0 for bug 1916672

2021-02-24 01:17:39 [INFO] Deploying bundle '/tmp/charm-nrpe/tests/functional/tests/bundles/xenial.yaml' on to 'zaza-2428033b2384' model
2021-02-24 01:17:39 [INFO] Rendered template '<Template 'local-charm-overlay.yaml.j2'>' to file '/tmp/tmpqdt1vrd6/local-charm-overlay.yaml'
2021-02-24 01:17:40 [INFO] Deploying overlay '/tmp/tmpqdt1vrd6/local-charm-overlay.yaml' on to 'zaza-2428033b2384' model
2021-02-24 01:17:40 [INFO] Resolving charm: cs:percona-cluster
2021-02-24 01:17:40 [INFO] Resolving charm: cs:nagios
2021-02-24 01:17:40 [INFO] Executing changes:
2021-02-24 01:17:40 [INFO] - upload charm cs:percona-cluster-295 for series xenial
2021-02-24 01:17:40 [INFO] - deploy application mysql on xenial using cs:percona-cluster-295
2021-02-24 01:17:41 [INFO] - upload charm cs:nagios-42 for series xenial
2021-02-24 01:17:41 [INFO] - deploy application nagios on xenial using cs:nagios-42
2021-02-24 01:17:41 [INFO] - upload charm /tmp/charm-nrpe/.build/nrpe for series xenial
2021-02-24 01:17:42 [INFO] - deploy application nrpe on xenial using /tmp/charm-nrpe/.build/nrpe
2021-02-24 01:17:42 [INFO] - add relation mysql:nrpe-external-master - nrpe:nrpe-external-master
2021-02-24 01:17:42 [INFO] - add relation nrpe:monitors - nagios:monitors
2021-02-24 01:17:42 [INFO] - add unit mysql/0 to new machine 0
2021-02-24 01:17:42 [INFO] - add unit nagios/0 to new machine 1
2021-02-24 01:17:42 [INFO] Deploy of bundle completed.
2021-02-24 01:17:42 [INFO] Waiting for environment to settle
2021-02-24 01:17:42 [INFO] Timeout for deployment to settle set to: 3600
2021-02-24 01:17:42 [INFO] Waiting for a unit to appear
2021-02-24 01:17:42 [INFO] Waiting for all units to be idle
2021-02-24 01:20:19 [ERROR] {'default_alias': 'zaza-2428033b2384'}
2021-02-24 01:20:19 [ERROR] Model default_alias (zaza-2428033b2384)
2021-02-24 01:20:19 [ERROR] Applications in error state: mysql
2021-02-24 01:20:19 [ERROR] Units in error state: mysql/0
2021-02-24 01:20:19 [ERROR] Juju log for mysql/0
2021-02-24 01:20:20 [ERROR] unit-mysql-0.log: 2021-02-24 01:20:16 WARNING nrpe-external-master-relation-joined File "/var/lib/juju/agents/unit-mysql-0/charm/hooks/percona_utils.py", line 1832, in create_nagios_user
2021-02-24 01:20:20 [ERROR] unit-mysql-0.log: 2021-02-24 01:20:16 WARNING nrpe-external-master-relation-joined "'{passwd}';".format(passwd=nagios_password()))
2021-02-24 01:20:20 [ERROR] unit-mysql-0.log: 2021-02-24 01:20:16 WARNING nrpe-external-master-relation-joined File "/var/lib/juju/agents/unit-mysql-0/charm/charmhelpers/contrib/database/mysql.py", line 193, in execute
2021-02-24 01:20:20 [ERROR] unit-mysql-0.log: 2021-02-24 01:20:16 WARNING nrpe-external-master-relation-joined cursor.execute(sql)
2021-02-24 01:20:20 [ERROR] unit-mysql-0.log: 2021-02-24 01:20:16 WARNING nrpe-external-master-relation-joined File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 226, in execute
2021-02-24 01:20:20 [ERROR] unit-mysql-0.log: 2021-02-24 01:20:16 WARNING nrpe-external-master-relation-joined self.errorhandler(self, exc, value)
2021-02-24 01:20:20 [ERROR] unit-mysql-0.log: 2021-02-24 01:20:16 WARNING nrpe-external-master-relation-joined File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2021-02-24 01:20:20 [ERROR] unit-mysql-0.log: 2021-02-24 01:20:16 WARNING nrpe-external-master-relation-joined raise errorvalue
2021-02-24 01:20:20 [ERROR] unit-mysql-0.log: 2021-02-24 01:20:16 WARNING nrpe-external-master-relation-joined File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 217, in execute
2021-02-24 01:20:20 [ERROR] unit-mysql-0.log: 2021-02-24 01:20:16 WARNING nrpe-external-master-relation-joined res = self._query(query)
2021-02-24 01:20:20 [ERROR] unit-mysql-0.log: 2021-02-24 01:20:16 WARNING nrpe-external-master-relation-joined File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 378, in _query
2021-02-24 01:20:20 [ERROR] unit-mysql-0.log: 2021-02-24 01:20:16 WARNING nrpe-external-master-relation-joined rowcount = self._do_query(q)
2021-02-24 01:20:20 [ERROR] unit-mysql-0.log: 2021-02-24 01:20:16 WARNING nrpe-external-master-relation-joined File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 341, in _do_query
2021-02-24 01:20:20 [ERROR] unit-mysql-0.log: 2021-02-24 01:20:16 WARNING nrpe-external-master-relation-joined db.query(q)
2021-02-24 01:20:20 [ERROR] unit-mysql-0.log: 2021-02-24 01:20:16 WARNING nrpe-external-master-relation-joined File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 280, in query
2021-02-24 01:20:20 [ERROR] unit-mysql-0.log: 2021-02-24 01:20:16 WARNING nrpe-external-master-relation-joined _mysql.connection.query(self, query)
2021-02-24 01:20:20 [ERROR] unit-mysql-0.log: 2021-02-24 01:20:16 WARNING nrpe-external-master-relation-joined _mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'ssYCNHXVT2n3wNwZh6MBHMjYNrRpG9TPqFnj7'' at line 1")
2021-02-24 01:20:20 [ERROR] unit-mysql-0.log: 2021-02-24 01:20:16 ERROR juju.worker.uniter.operation runhook.go:136 hook "nrpe-external-master-relation-joined" (via explicit, bespoke hook script) failed: exit status 1
2021-02-24 01:20:20 [ERROR] unit-mysql-0.log: 2021-02-24 01:20:16 INFO juju.worker.uniter resolver.go:143 awaiting error resolution for "relation-joined" hook
2021-02-24 01:20:20 [ERROR] unit-mysql-0.log: 2021-02-24 01:20:18 INFO juju.worker.uniter resolver.go:143 awaiting error resolution for "relation-joined" hook
2021-02-24 01:20:20 [ERROR] unit-mysql-0.log:
Traceback (most recent call last):
  File "/tmp/charm-nrpe/.tox/func/bin/functest-run-suite", line 8, in <module>
    sys.exit(main())
  File "/tmp/charm-nrpe/.tox/func/lib/python3.6/site-packages/zaza/charm_lifecycle/func_test_runner.py", line 279, in main
    test_directory=args.test_directory)
  File "/tmp/charm-nrpe/.tox/func/lib/python3.6/site-packages/zaza/charm_lifecycle/func_test_runner.py", line 214, in func_test_runner
    force=force, test_directory=test_directory)
  File "/tmp/charm-nrpe/.tox/func/lib/python3.6/site-packages/zaza/charm_lifecycle/func_test_runner.py", line 129, in run_env_deployment
    test_directory=test_directory)
  File "/tmp/charm-nrpe/.tox/func/lib/python3.6/site-packages/zaza/charm_lifecycle/deploy.py", line 388, in deploy
    timeout=timeout)
  File "/tmp/charm-nrpe/.tox/func/lib/python3.6/site-packages/zaza/__init__.py", line 48, in _wrapper
    return run(_run_it())
  File "/tmp/charm-nrpe/.tox/func/lib/python3.6/site-packages/zaza/__init__.py", line 36, in run
    return task.result()
  File "/tmp/charm-nrpe/.tox/func/lib/python3.6/site-packages/zaza/__init__.py", line 47, in _run_it
    return await f(*args, **kwargs)
  File "/tmp/charm-nrpe/.tox/func/lib/python3.6/site-packages/zaza/model.py", line 1115, in async_wait_for_application_states
    timeout=timeout)
  File "/tmp/charm-nrpe/.tox/func/lib/python3.6/site-packages/juju/model.py", line 730, in block_until
    loop=self.loop)
  File "/tmp/charm-nrpe/.tox/func/lib/python3.6/site-packages/juju/utils.py", line 87, in block_until
    await asyncio.wait_for(_block(), timeout, loop=loop)
  File "/usr/lib/python3.6/asyncio/tasks.py", line 358, in wait_for
    return fut.result()
  File "/tmp/charm-nrpe/.tox/func/lib/python3.6/site-packages/juju/utils.py", line 85, in _block
    while not all(c() for c in conditions):
  File "/tmp/charm-nrpe/.tox/func/lib/python3.6/site-packages/juju/utils.py", line 85, in <genexpr>
    while not all(c() for c in conditions):
  File "/tmp/charm-nrpe/.tox/func/lib/python3.6/site-packages/juju/model.py", line 725, in done
    return _disconnected() or all(c() for c in conditions)
  File "/tmp/charm-nrpe/.tox/func/lib/python3.6/site-packages/juju/model.py", line 725, in <genexpr>
    return _disconnected() or all(c() for c in conditions)
  File "/tmp/charm-nrpe/.tox/func/lib/python3.6/site-packages/zaza/model.py", line 1114, in <lambda>
    model) or model.all_units_idle(),
  File "/tmp/charm-nrpe/.tox/func/lib/python3.6/site-packages/zaza/model.py", line 980, in check_model_for_hard_errors
    raise UnitError(errored_units)
zaza.model.UnitError: Units mysql/0 in error state
ERROR: InvocationError for command /tmp/charm-nrpe/.tox/func/bin/functest-run-suite (exited with code 1)
_______________________________________________________ summary _______________________________________________________
ERROR: func: commands failed
Makefile:67: recipe for target 'functional' failed