Uploaded image for project: 'Red Hat OpenStack Services on OpenShift'
  1. Red Hat OpenStack Services on OpenShift
  2. OSPRH-10103

Neuton adoption fails in NFV deployment

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Not a Bug
    • Icon: Critical Critical
    • None
    • None
    • neutron-operator
    • None
    • 3
    • False
    • Hide

      None

      Show
      None
    • 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] 

       

       

              eshulman Ella Shulman
              eshulman Ella Shulman
              rhos-dfg-networking-squad-neutron
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: