Potential race condition with already existing allocations table on a fresh focal:wallaby deployement

Bug #1946386 reported by Syed Mohammad Adnan Karim
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Placement Charm
New
Undecided
Unassigned

Bug Description

2021-10-07 18:00:17 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 Synchronizing state of apache2.service with SysV service script with /lib/systemd/systemd-sysv-install.
2021-10-07 18:00:17 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 Executing: /lib/systemd/systemd-sysv-install disable apache2
2021-10-07 18:00:18 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 Unit /etc/systemd/system/apache2.service is masked, ignoring.
2021-10-07 18:00:18 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 Synchronizing state of haproxy.service with SysV service script with /lib/systemd/systemd-sysv-install.
2021-10-07 18:00:18 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 Executing: /lib/systemd/systemd-sysv-install disable haproxy
2021-10-07 18:00:19 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 Unit /etc/systemd/system/haproxy.service is masked, ignoring.
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 /usr/lib/python3/dist-packages/pymysql/cursors.py:170: Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.")
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 result = self._query(query)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 DBAPIError exception wrapped.
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 Traceback (most recent call last):
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 self.dialect.do_execute(
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 609, in do_execute
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 cursor.execute(statement, parameters)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 170, in execute
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 result = self._query(query)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 328, in _query
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 conn.query(q)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 517, in query
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 732, in _read_query_result
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 result.read()
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1075, in read
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 first_packet = self.connection._read_packet()
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 684, in _read_packet
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 packet.check_error()
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/protocol.py", line 220, in check_error
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 err.raise_mysql_exception(self._data)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 raise errorclass(errno, errval)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 pymysql.err.InternalError: (1050, "Table 'allocations' already exists")
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 Traceback (most recent call last):
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 self.dialect.do_execute(
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 609, in do_execute
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 cursor.execute(statement, parameters)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 170, in execute
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 result = self._query(query)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 328, in _query
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 conn.query(q)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 517, in query
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 732, in _read_query_result
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 result.read()
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1075, in read
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 first_packet = self.connection._read_packet()
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 684, in _read_packet
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 packet.check_error()
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/protocol.py", line 220, in check_error
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 err.raise_mysql_exception(self._data)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 raise errorclass(errno, errval)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 pymysql.err.InternalError: (1050, "Table 'allocations' already exists")
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 The above exception was the direct cause of the following exception:
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 Traceback (most recent call last):
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/bin/placement-manage", line 10, in <module>
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 sys.exit(main())
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/placement/cmd/manage.py", line 225, in main
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 return_code = func()
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/placement/cmd/manage.py", line 59, in db_sync
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 migration.upgrade('head')
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/placement/db/sqlalchemy/migration.py", line 67, in upgrade
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 alembic.command.upgrade(config, revision)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/alembic/command.py", line 298, in upgrade
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 script.run_env()
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/alembic/script/base.py", line 489, in run_env
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 util.load_python_file(self.dir, "env.py")
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/alembic/util/pyfiles.py", line 98, in load_python_file
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 module = load_module_py(module_id, path)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/alembic/util/compat.py", line 184, in load_module_py
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 spec.loader.exec_module(module)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "<frozen importlib._bootstrap_external>", line 848, in exec_module
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/placement/db/sqlalchemy/alembic/env.py", line 65, in <module>
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 run_migrations_online()
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/placement/db/sqlalchemy/alembic/env.py", line 59, in run_migrations_online
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 context.run_migrations()
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "<string>", line 8, in run_migrations
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/alembic/runtime/environment.py", line 846, in run_migrations
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 self.get_context().run_migrations(**kw)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/alembic/runtime/migration.py", line 522, in run_migrations
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 step.migration_fn(**kw)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/placement/db/sqlalchemy/alembic/versions/b4ed3a175331_initial.py", line 33, in upgrade
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 op.create_table(
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "<string>", line 8, in create_table
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "<string>", line 3, in create_table
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/alembic/operations/ops.py", line 1252, in create_table
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 return operations.invoke(op)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/alembic/operations/base.py", line 373, in invoke
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 return fn(self, operation)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/alembic/operations/toimpl.py", line 101, in create_table
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 operations.impl.create_table(table)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/alembic/ddl/impl.py", line 259, in create_table
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 self._exec(schema.CreateTable(table))
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/alembic/ddl/impl.py", line 141, in _exec
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 return conn.execute(construct, *multiparams, **params)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1011, in execute
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 return meth(self, multiparams, params)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 return connection._execute_ddl(self, multiparams, params)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1068, in _execute_ddl
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 ret = self._execute_context(
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 self._handle_dbapi_exception(
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1508, in _handle_dbapi_exception
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 util.raise_(newraise, with_traceback=exc_info[2], from_=e)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 182, in raise_
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 raise exception
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 self.dialect.do_execute(
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 609, in do_execute
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 cursor.execute(statement, parameters)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 170, in execute
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 result = self._query(query)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 328, in _query
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 conn.query(q)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 517, in query
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 732, in _read_query_result
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 result.read()
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1075, in read
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 first_packet = self.connection._read_packet()
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 684, in _read_packet
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 packet.check_error()
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/protocol.py", line 220, in check_error
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 err.raise_mysql_exception(self._data)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 raise errorclass(errno, errval)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 oslo_db.exception.DBError: (pymysql.err.InternalError) (1050, "Table 'allocations' already exists")
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 [SQL:
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 CREATE TABLE allocations (
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 created_at DATETIME,
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 updated_at DATETIME,
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 id INTEGER NOT NULL AUTO_INCREMENT,
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 resource_provider_id INTEGER NOT NULL,
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 consumer_id VARCHAR(36) NOT NULL,
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 resource_class_id INTEGER NOT NULL,
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 used INTEGER NOT NULL,
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 PRIMARY KEY (id)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 )
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 ]
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 (Background on this error at: http://sqlalche.me/e/13/2j85)
2021-10-07 18:00:25 ERROR unit.placement/2.juju-log server.go:325 shared-db:121: Hook error:
Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-placement-2/.venv/lib/python3.8/site-packages/charms/reactive/__init__.py", line 74, in main
    bus.dispatch(restricted=restricted_mode)
  File "/var/lib/juju/agents/unit-placement-2/.venv/lib/python3.8/site-packages/charms/reactive/bus.py", line 390, in dispatch
    _invoke(other_handlers)
  File "/var/lib/juju/agents/unit-placement-2/.venv/lib/python3.8/site-packages/charms/reactive/bus.py", line 359, in _invoke
    handler.invoke()
  File "/var/lib/juju/agents/unit-placement-2/.venv/lib/python3.8/site-packages/charms/reactive/bus.py", line 181, in invoke
    self._action(*args)
  File "/var/lib/juju/agents/unit-placement-2/charm/reactive/placement_handlers.py", line 73, in init_db
    placement_charm.db_sync()
  File "/var/lib/juju/agents/unit-placement-2/charm/lib/charm/openstack/placement.py", line 107, in db_sync
    subprocess.check_call(self.sync_cmd)
  File "/usr/lib/python3.8/subprocess.py", line 364, in check_call
    raise CalledProcessError(retcode, cmd)
subprocess.CalledProcessError: Command '['placement-manage', 'db', 'sync']' returned non-zero exit status 1.

2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 Traceback (most recent call last):
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/var/lib/juju/agents/unit-placement-2/charm/hooks/shared-db-relation-changed", line 22, in <module>
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 main()
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/var/lib/juju/agents/unit-placement-2/.venv/lib/python3.8/site-packages/charms/reactive/__init__.py", line 74, in main
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 bus.dispatch(restricted=restricted_mode)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/var/lib/juju/agents/unit-placement-2/.venv/lib/python3.8/site-packages/charms/reactive/bus.py", line 390, in dispatch
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 _invoke(other_handlers)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/var/lib/juju/agents/unit-placement-2/.venv/lib/python3.8/site-packages/charms/reactive/bus.py", line 359, in _invoke
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 handler.invoke()
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/var/lib/juju/agents/unit-placement-2/.venv/lib/python3.8/site-packages/charms/reactive/bus.py", line 181, in invoke
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 self._action(*args)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/var/lib/juju/agents/unit-placement-2/charm/reactive/placement_handlers.py", line 73, in init_db
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 placement_charm.db_sync()
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/var/lib/juju/agents/unit-placement-2/charm/lib/charm/openstack/placement.py", line 107, in db_sync
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 subprocess.check_call(self.sync_cmd)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 File "/usr/lib/python3.8/subprocess.py", line 364, in check_call
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 raise CalledProcessError(retcode, cmd)
2021-10-07 18:00:25 WARNING unit.placement/2.shared-db-relation-changed logger.go:60 subprocess.CalledProcessError: Command '['placement-manage', 'db', 'sync']' returned non-zero exit status 1.
2021-10-07 18:00:26 ERROR juju.worker.uniter.operation runhook.go:146 hook "shared-db-relation-changed" (via explicit, bespoke hook script) failed: exit status 1
2021-10-07 18:00:26 INFO juju.worker.uniter resolver.go:150 awaiting error resolution for "relation-changed" hook
2021-10-07 18:03:05 INFO juju.worker.uniter resolver.go:150 awaiting error resolution for "relation-changed" hook
2021-10-07 18:03:06 INFO unit.placement/2.juju-log server.go:325 shared-db:121: Reactive main running for hook shared-db-relation-changed
2021-10-07 18:03:06 INFO unit.placement/2.juju-log server.go:325 shared-db:121: Initializing Leadership Layer (is leader)
2021-10-07 18:03:06 INFO unit.placement/2.juju-log server.go:325 shared-db:121: Invoking reactive handler: hooks/relations/mysql-shared/requires.py:20:changed
2021-10-07 18:03:06 INFO unit.placement/2.juju-log server.go:325 shared-db:121: Checking placement/2 is in ['placement/2']
2021-10-07 18:03:06 INFO unit.placement/2.juju-log server.go:325 shared-db:121: Unit allowed: True
2021-10-07 18:03:06 INFO unit.placement/2.juju-log server.go:325 shared-db:121: Checking placement/2 is in ['placement/2']
2021-10-07 18:03:06 INFO unit.placement/2.juju-log server.go:325 shared-db:121: Unit allowed: True

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.