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
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
