yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1355649] [NEW] L3 scheduler additions to support DVR migration fails

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Robert Collins <1355649@xxxxxxxxxxxxxxxxxx>
Date: Tue, 12 Aug 2014 07:59:45 -0000
Reply-to: Bug 1355649 <1355649@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

I have a running cloud (off of trunk) which I'm upgrading, and is failing to apply neutron migrations:
+ neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugins/ml2/ml2_conf.ini upgrade head
INFO  [alembic.migration] Context impl MySQLImpl.
INFO  [alembic.migration] Will assume non-transactional DDL.
INFO  [alembic.migration] Running upgrade 31d7f831a591 -> 5589aa32bf80, L3 scheduler additions to support DVR
Traceback (most recent call last):
  File "/usr/local/bin/neutron-db-manage", line 10, in <module>
    sys.exit(main())
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/neutron/db/migration/cli.py", line 175, in main
    CONF.command.func(config, CONF.command.name)
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/neutron/db/migration/cli.py", line 85, in do_upgrade_downgrade
    do_alembic_command(config, cmd, revision, sql=CONF.command.sql)
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/neutron/db/migration/cli.py", line 63, in do_alembic_command
    getattr(alembic_command, cmd)(config, *args, **kwargs)
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/alembic/command.py", line 125, in upgrade
    script.run_env()
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/alembic/script.py", line 203, in run_env
    util.load_python_file(self.dir, 'env.py')
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/alembic/util.py", line 215, in load_python_file
    module = load_module_py(module_id, path)
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/alembic/compat.py", line 58, in load_module_py
    mod = imp.load_source(module_id, path, fp)
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/env.py", line 125, in <module>
    run_migrations_online()
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/env.py", line 109, in run_migrations_online
    options=build_options())
  File "<string>", line 7, in run_migrations
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/alembic/environment.py", line 689, in run_migrations
    self.get_context().run_migrations(**kw)
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/alembic/migration.py", line 263, in run_migrations
    change(**kw)
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/versions/5589aa32bf80_l3_dvr_scheduler.py", line 54, in upgrade
    sa.PrimaryKeyConstraint('router_id')
  File "<string>", line 7, in create_table
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/alembic/operations.py", line 713, in create_table
    self._table(name, *columns, **kw)
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/alembic/ddl/impl.py", line 149, in create_table
    self._exec(schema.CreateTable(table))
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/alembic/ddl/impl.py", line 76, in _exec
    conn.execute(construct, *multiparams, **params)
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 729, in execute
    return meth(self, multiparams, params)
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 69, in _execute_on_connection
    return connection._execute_ddl(self, multiparams, params)
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 783, in _execute_ddl
    compiled
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
    context)
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1160, in _handle_dbapi_exception
    exc_info
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
    context)
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute
    cursor.execute(statement, parameters)
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
sqlalchemy.exc.OperationalError: (OperationalError) (1050, "Table 'csnat_l3_agent_bindings' already exists") '\nCREATE TABLE csnat_l3_agent_bindings (\n\trouter_id VARCHAR(36) NOT NULL, \n\tl3_agent_id VARCHAR(36) NOT NULL, \n\thost_id VARCHAR(255), \n\tcsnat_gw_port_id VARCHAR(36), \n\tPRIMARY KEY (router_id), \n\tFOREIGN KEY(l3_agent_id) REFERENCES agents (id) ON DELETE CASCADE, \n\tFOREIGN KEY(router_id) REFERENCES routers (id) ON DELETE CASCADE, \n\tFOREIGN KEY(csnat_gw_port_id) REFERENCES ports (id) ON DELETE CASCADE\n)ENGINE=InnoDB\n\n' ()
[2014-08-12 07:57:55,805] (os-refresh-config) [ERROR] during configure phase. [Command '['dib-run-parts', '/opt/stack/os-config-refresh/configure.d']' returned non-zero exit status 1]

** Affects: neutron
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1355649

Title:
  L3 scheduler additions to support DVR migration fails

Status in OpenStack Neutron (virtual network service):
  New

Bug description:
  I have a running cloud (off of trunk) which I'm upgrading, and is failing to apply neutron migrations:
  + neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugins/ml2/ml2_conf.ini upgrade head
  INFO  [alembic.migration] Context impl MySQLImpl.
  INFO  [alembic.migration] Will assume non-transactional DDL.
  INFO  [alembic.migration] Running upgrade 31d7f831a591 -> 5589aa32bf80, L3 scheduler additions to support DVR
  Traceback (most recent call last):
    File "/usr/local/bin/neutron-db-manage", line 10, in <module>
      sys.exit(main())
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/neutron/db/migration/cli.py", line 175, in main
      CONF.command.func(config, CONF.command.name)
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/neutron/db/migration/cli.py", line 85, in do_upgrade_downgrade
      do_alembic_command(config, cmd, revision, sql=CONF.command.sql)
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/neutron/db/migration/cli.py", line 63, in do_alembic_command
      getattr(alembic_command, cmd)(config, *args, **kwargs)
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/alembic/command.py", line 125, in upgrade
      script.run_env()
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/alembic/script.py", line 203, in run_env
      util.load_python_file(self.dir, 'env.py')
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/alembic/util.py", line 215, in load_python_file
      module = load_module_py(module_id, path)
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/alembic/compat.py", line 58, in load_module_py
      mod = imp.load_source(module_id, path, fp)
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/env.py", line 125, in <module>
      run_migrations_online()
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/env.py", line 109, in run_migrations_online
      options=build_options())
    File "<string>", line 7, in run_migrations
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/alembic/environment.py", line 689, in run_migrations
      self.get_context().run_migrations(**kw)
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/alembic/migration.py", line 263, in run_migrations
      change(**kw)
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/neutron/db/migration/alembic_migrations/versions/5589aa32bf80_l3_dvr_scheduler.py", line 54, in upgrade
      sa.PrimaryKeyConstraint('router_id')
    File "<string>", line 7, in create_table
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/alembic/operations.py", line 713, in create_table
      self._table(name, *columns, **kw)
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/alembic/ddl/impl.py", line 149, in create_table
      self._exec(schema.CreateTable(table))
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/alembic/ddl/impl.py", line 76, in _exec
      conn.execute(construct, *multiparams, **params)
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 729, in execute
      return meth(self, multiparams, params)
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 69, in _execute_on_connection
      return connection._execute_ddl(self, multiparams, params)
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 783, in _execute_ddl
      compiled
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
      context)
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1160, in _handle_dbapi_exception
      exc_info
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
      reraise(type(exception), exception, tb=exc_tb)
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
      context)
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute
      cursor.execute(statement, parameters)
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
      self.errorhandler(self, exc, value)
    File "/opt/stack/venvs/neutron/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
      raise errorclass, errorvalue
  sqlalchemy.exc.OperationalError: (OperationalError) (1050, "Table 'csnat_l3_agent_bindings' already exists") '\nCREATE TABLE csnat_l3_agent_bindings (\n\trouter_id VARCHAR(36) NOT NULL, \n\tl3_agent_id VARCHAR(36) NOT NULL, \n\thost_id VARCHAR(255), \n\tcsnat_gw_port_id VARCHAR(36), \n\tPRIMARY KEY (router_id), \n\tFOREIGN KEY(l3_agent_id) REFERENCES agents (id) ON DELETE CASCADE, \n\tFOREIGN KEY(router_id) REFERENCES routers (id) ON DELETE CASCADE, \n\tFOREIGN KEY(csnat_gw_port_id) REFERENCES ports (id) ON DELETE CASCADE\n)ENGINE=InnoDB\n\n' ()
  [2014-08-12 07:57:55,805] (os-refresh-config) [ERROR] during configure phase. [Command '['dib-run-parts', '/opt/stack/os-config-refresh/configure.d']' returned non-zero exit status 1]

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1355649/+subscriptions
Follow ups

[Bug 1355649] Re: L3 scheduler additions to support DVR DB migration fails
From: Launchpad Bug Tracker, 2014-12-07
[Bug 1355649] [NEW] L3 scheduler additions to support DVR migration fails
From: Robert Collins, 2014-08-12
References

[Bug 1355649] [NEW] L3 scheduler additions to support DVR migration fails
From: Robert Collins, 2014-08-12