-
Bug
-
Resolution: Not a Bug
-
Critical
-
None
-
None
-
None
-
3
-
False
-
-
False
-
?
-
?
-
?
-
?
-
None
-
-
-
3
-
Important
neutron adoption service fails due to an issue with a db table
[zuul@controller-0 data-plane-adoption]$ oc logs neutron-db-sync-gblp9 + sudo -E kolla_set_configs sudo: unable to send audit message: Operation not permitted INFO:__main__:Loading config file at /var/lib/kolla/config_files/config.json INFO:__main__:Validating config file INFO:__main__:Kolla config strategy set to: COPY_ALWAYS INFO:__main__:Copying service configuration files INFO:__main__:Copying /var/lib/config-data/default/01-neutron.conf to /etc/neutron/neutron.conf.d/01-neutron.conf INFO:__main__:Setting permission for /etc/neutron/neutron.conf.d/01-neutron.conf INFO:__main__:Copying /var/lib/config-data/default/02-neutron-custom.conf to /etc/neutron/neutron.conf.d/02-neutron-custom.conf INFO:__main__:Setting permission for /etc/neutron/neutron.conf.d/02-neutron-custom.conf INFO:__main__:Deleting /etc/my.cnf INFO:__main__:Copying /var/lib/config-data/default/my.cnf to /etc/my.cnf INFO:__main__:Setting permission for /etc/my.cnf INFO:__main__:Writing out command to execute ++ cat /run_command + CMD='neutron-db-manage --config-file /usr/share/neutron/neutron-dist.conf --config-file /etc/neutron/neutron.conf --config-dir /etc/neutron/neutron.conf.d upgrade heads' + ARGS= + sudo kolla_copy_cacerts sudo: unable to send audit message: Operation not permitted + [[ ! -n '' ]] + . kolla_extend_start + echo 'Running command: '\''neutron-db-manage --config-file /usr/share/neutron/neutron-dist.conf --config-file /etc/neutron/neutron.conf --config-dir /etc/neutron/neutron.conf.d upgrade heads'\''' Running command: 'neutron-db-manage --config-file /usr/share/neutron/neutron-dist.conf --config-file /etc/neutron/neutron.conf --config-dir /etc/neutron/neutron.conf.d upgrade heads' + umask 0022 + exec neutron-db-manage --config-file /usr/share/neutron/neutron-dist.conf --config-file /etc/neutron/neutron.conf --config-dir /etc/neutron/neutron.conf.d upgrade heads INFO [alembic.runtime.migration] Context impl MySQLImpl. INFO [alembic.runtime.migration] Will assume non-transactional DDL. INFO [alembic.runtime.migration] Context impl MySQLImpl. INFO [alembic.runtime.migration] Will assume non-transactional DDL. INFO [alembic.runtime.migration] Running upgrade 8df53b0d2c0e -> 1bb3393de75d, add qos policy rule Packet Rate Limit Running upgrade for neutron ... Traceback (most recent call last): File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1050, "Table 'qos_packet_rate_limit_rules' already exists")The above exception was the direct cause of the following exception:Traceback (most recent call last): File "/usr/bin/neutron-db-manage", line 10, in <module> sys.exit(main()) File "/usr/lib/python3.9/site-packages/neutron/db/migration/cli.py", line 665, in main return_val |= bool(CONF.command.func(config, CONF.command.name)) File "/usr/lib/python3.9/site-packages/neutron/db/migration/cli.py", line 187, in do_upgrade do_alembic_command(config, cmd, revision=revision, File "/usr/lib/python3.9/site-packages/neutron/db/migration/cli.py", line 89, in do_alembic_command getattr(alembic_command, cmd)(config, *args, **kwargs) File "/usr/lib/python3.9/site-packages/alembic/command.py", line 322, in upgrade script.run_env() File "/usr/lib/python3.9/site-packages/alembic/script/base.py", line 569, in run_env util.load_python_file(self.dir, "env.py") File "/usr/lib/python3.9/site-packages/alembic/util/pyfiles.py", line 94, in load_python_file module = load_module_py(module_id, path) File "/usr/lib/python3.9/site-packages/alembic/util/pyfiles.py", line 110, in load_module_py spec.loader.exec_module(module) # type: ignore File "<frozen importlib._bootstrap_external>", line 850, in exec_module File "<frozen importlib._bootstrap>", line 228, in _call_with_frames_removed File "/usr/lib/python3.9/site-packages/neutron/db/migration/alembic_migrations/env.py", line 120, in <module> run_migrations_online() File "/usr/lib/python3.9/site-packages/neutron/db/migration/alembic_migrations/env.py", line 114, in run_migrations_online context.run_migrations() File "<string>", line 8, in run_migrations File "/usr/lib/python3.9/site-packages/alembic/runtime/environment.py", line 853, in run_migrations self.get_context().run_migrations(**kw) File "/usr/lib/python3.9/site-packages/alembic/runtime/migration.py", line 623, in run_migrations step.migration_fn(**kw) File "/usr/lib/python3.9/site-packages/neutron/db/migration/alembic_migrations/versions/xena/expand/1bb3393de75d_add_qos_pps_rule.py", line 46, in upgrade op.create_table( File "<string>", line 8, in create_table File "<string>", line 3, in create_table File "/usr/lib/python3.9/site-packages/alembic/operations/ops.py", line 1254, in create_table return operations.invoke(op) File "/usr/lib/python3.9/site-packages/alembic/operations/base.py", line 399, in invoke return fn(self, operation) File "/usr/lib/python3.9/site-packages/alembic/operations/toimpl.py", line 114, in create_table operations.impl.create_table(table) File "/usr/lib/python3.9/site-packages/alembic/ddl/impl.py", line 354, in create_table self._exec(schema.CreateTable(table)) File "/usr/lib/python3.9/site-packages/alembic/ddl/impl.py", line 195, in _exec return conn.execute(construct, multiparams) File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1380, in execute return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS) File "/usr/lib64/python3.9/site-packages/sqlalchemy/sql/ddl.py", line 80, in _execute_on_connection return connection._execute_ddl( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1472, in _execute_ddl ret = self._execute_context( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context self._handle_dbapi_exception( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 2122, in _handle_dbapi_exception util.raise_(newraise, with_traceback=exc_info[2], from_=e) File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute result = self._query(query) File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result result.read() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read first_packet = self.connection._read_packet() File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet packet.raise_for_error() File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1050, "Table 'qos_packet_rate_limit_rules' already exists") [SQL: CREATE TABLE qos_packet_rate_limit_rules ( id VARCHAR(36) NOT NULL, qos_policy_id VARCHAR(36) NOT NULL, max_kpps INTEGER, max_burst_kpps INTEGER, direction ENUM('egress','ingress') NOT NULL DEFAULT 'egress', PRIMARY KEY (id), CONSTRAINT qos_packet_rate_limit_rules0qos_policy_id0direction UNIQUE (qos_policy_id, direction), FOREIGN KEY(qos_policy_id) REFERENCES qos_policies (id) ON DELETE CASCADE )ENGINE=InnoDB]