[Bug 1882900] Re: Missing sqlalchemy-utils dep on ussuri

[Liam Young]

Yep thats the traceback I'm seeing.

Charm shows:

2020-06-10 12:45:57 ERROR juju-log amqp:40: Hook error:
Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-masakari-0/.venv/lib/python3.6/site-packages/charms/reactive/__init__.py", line 74, in main
    bus.dispatch(restricted=restricted_mode)
  File "/var/lib/juju/agents/unit-masakari-0/.venv/lib/python3.6/site-packages/charms/reactive/bus.py", line 390, in dispatch
    _invoke(other_handlers)
  File "/var/lib/juju/agents/unit-masakari-0/.venv/lib/python3.6/site-packages/charms/reactive/bus.py", line 359, in _invoke
    handler.invoke()
  File "/var/lib/juju/agents/unit-masakari-0/.venv/lib/python3.6/site-packages/charms/reactive/bus.py", line 181, in invoke
    self._action(*args)
  File "/var/lib/juju/agents/unit-masakari-0/charm/reactive/masakari_handlers.py", line 50, in init_db
    charm_class.db_sync()
  File "/var/lib/juju/agents/unit-masakari-0/.venv/lib/python3.6/site-packages/charms_openstack/charm/core.py", line 849, in db_sync
    subprocess.check_call(self.sync_cmd)
  File "/usr/lib/python3.6/subprocess.py", line 311, in check_call
    raise CalledProcessError(retcode, cmd)
subprocess.CalledProcessError: Command '['masakari-manage', '--config-file', '/etc/masakari/masakari.conf', 'db', 'sync']' returned non-zero exit status 1.

2020-06-10 12:45:57 DEBUG amqp-relation-changed Traceback (most recent call last):
2020-06-10 12:45:57 DEBUG amqp-relation-changed   File "/var/lib/juju/agents/unit-masakari-0/charm/hooks/amqp-relation-changed", line 22, in <module>
2020-06-10 12:45:57 DEBUG amqp-relation-changed     main()
2020-06-10 12:45:57 DEBUG amqp-relation-changed   File "/var/lib/juju/agents/unit-masakari-0/.venv/lib/python3.6/site-packages/charms/reactive/__init__.py", line 74, in main
2020-06-10 12:45:57 DEBUG amqp-relation-changed     bus.dispatch(restricted=restricted_mode)
2020-06-10 12:45:57 DEBUG amqp-relation-changed   File "/var/lib/juju/agents/unit-masakari-0/.venv/lib/python3.6/site-packages/charms/reactive/bus.py", line 390, in dispatch
2020-06-10 12:45:57 DEBUG amqp-relation-changed     _invoke(other_handlers)
2020-06-10 12:45:57 DEBUG amqp-relation-changed   File "/var/lib/juju/agents/unit-masakari-0/.venv/lib/python3.6/site-packages/charms/reactive/bus.py", line 359, in _invoke
2020-06-10 12:45:57 DEBUG amqp-relation-changed     handler.invoke()
2020-06-10 12:45:57 DEBUG amqp-relation-changed   File "/var/lib/juju/agents/unit-masakari-0/.venv/lib/python3.6/site-packages/charms/reactive/bus.py", line 181, in invoke
2020-06-10 12:45:57 DEBUG amqp-relation-changed     self._action(*args)
2020-06-10 12:45:57 DEBUG amqp-relation-changed   File "/var/lib/juju/agents/unit-masakari-0/charm/reactive/masakari_handlers.py", line 50, in init_db
2020-06-10 12:45:57 DEBUG amqp-relation-changed     charm_class.db_sync()
2020-06-10 12:45:57 DEBUG amqp-relation-changed   File "/var/lib/juju/agents/unit-masakari-0/.venv/lib/python3.6/site-packages/charms_openstack/charm/core.py", line 849, in db_sync
2020-06-10 12:45:57 DEBUG amqp-relation-changed     subprocess.check_call(self.sync_cmd)
2020-06-10 12:45:57 DEBUG amqp-relation-changed   File "/usr/lib/python3.6/subprocess.py", line 311, in check_call
2020-06-10 12:45:57 DEBUG amqp-relation-changed     raise CalledProcessError(retcode, cmd)
2020-06-10 12:45:57 DEBUG amqp-relation-changed subprocess.CalledProcessError: Command '['masakari-manage', '--config-file', '/etc/masakari/masakari.conf', 'db', 'sync']' returned non-zero exit status 1.


And manual run of masakari-manage returns:
root at juju-656c93-zaza-74a8633f51ae-9:~# masakari-manage --config-file /etc/masakari/masakari.conf db sync
2020-06-10 12:59:29.604 6755 INFO migrate.versioning.api [-] 5 -> 6... 
2020-06-10 12:59:29.606 6755 INFO masakari.engine.driver [-] Loading masakari notification driver 'taskflow_driver'
2020-06-10 12:59:29.681 6755 INFO keyring.backend [-] Loading Gnome
2020-06-10 12:59:29.695 6755 INFO keyring.backend [-] Loading Google
2020-06-10 12:59:29.697 6755 INFO keyring.backend [-] Loading Windows (alt)
2020-06-10 12:59:29.699 6755 INFO keyring.backend [-] Loading file
2020-06-10 12:59:29.700 6755 INFO keyring.backend [-] Loading keyczar
2020-06-10 12:59:29.700 6755 INFO keyring.backend [-] Loading multi
2020-06-10 12:59:29.701 6755 INFO keyring.backend [-] Loading pyfs
Invalid input received: No module named 'sqlalchemy_utils'

-- 
You received this bug notification because you are a member of Ubuntu
OpenStack, which is subscribed to python-taskflow in Ubuntu.
https://bugs.launchpad.net/bugs/1882900

Title:
  Missing sqlalchemy-utils dep on ussuri

Status in python-taskflow package in Ubuntu:
  Triaged
Status in python-taskflow source package in Focal:
  Triaged
Status in python-taskflow source package in Groovy:
  Triaged

Bug description:
  Package seems to be missing a dependency on sqlalchemy-utils *1. The
  issue shows itself when running masakari-manage with the new
  'taskflow' section enabled *2

  *1 https://opendev.org/openstack/masakari/src/branch/stable/ussuri/requirements.txt#L29
  *2 https://review.opendev.org/734450

  I saw this with bionic ussuri but I assume affects focal too.

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/python-taskflow/+bug/1882900/+subscriptions