** Changed in: quantum
Status: Fix Committed => Fix Released
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to quantum.
https://bugs.launchpad.net/bugs/1153585
Title:
Add a migration for plugins which added L3 support in Grizzly
Status in OpenStack Quantum (virtual network service):
Fix Released
Bug description:
I am observing the following failure when migrating from folsom to
Grizzly:
INFO [alembic.migration] Running upgrade 363468ac592c -> 511471cc46b
INFO [alembic.migration] Running upgrade 511471cc46b -> 3b54bf9e29f7
INFO [alembic.migration] Running upgrade 3b54bf9e29f7 -> 4692d074d587
Traceback (most recent call last):
File "./bin/quantum-db-manage", line 26, in <module>
main()
File "/opt/stack/quantum/quantum/db/migration/cli.py", line 137, in main
CONF.command.func(config, CONF.command.name)
File "/opt/stack/quantum/quantum/db/migration/cli.py", line 76, in
do_upgrade_downgrade
do_alembic_command(config, cmd, revision, sql=CONF.command.sql)
File "/opt/stack/quantum/quantum/db/migration/cli.py", line 55, in
do_alembic_command
getattr(alembic_command, cmd)(config, *args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 124,
in upgrade
script.run_env()
File "/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 191,
in run_env
util.load_python_file(self.dir, 'env.py')
File "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 186, in
load_python_file
module = imp.load_source(module_id, path, open(path, 'rb'))
File "/opt/stack/quantum/quantum/db/migration/alembic_migrations/env.py",
line 100, in <module>
run_migrations_online()
File "/opt/stack/quantum/quantum/db/migration/alembic_migrations/env.py",
line 84, in run_migrations_online
options=build_options())
File "<string>", line 7, in run_migrations
File "/usr/local/lib/python2.7/dist-packages/alembic/environment.py", line
494, in run_migrations
self.get_context().run_migrations(**kw)
File "/usr/local/lib/python2.7/dist-packages/alembic/migration.py", line
211, in run_migrations
change(**kw)
File
"/opt/stack/quantum/quantum/db/migration/alembic_migrations/versions/4692d074d587_agent_scheduler.py",
line 70, in upgrade
sa.PrimaryKeyConstraint('id')
File "<string>", line 7, in create_table
File "/usr/local/lib/python2.7/dist-packages/alembic/operations.py", line
570, in create_table
self._table(name, *columns, **kw)
File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line
148, in create_table
self._exec(schema.CreateTable(table))
File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 75,
in _exec
conn.execute(construct, *multiparams, **params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1449, in execute
params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1542, in _execute_ddl
compiled
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1698, in _execute_context
context)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1691, in _execute_context
context)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py",
line 331, in do_execute
cursor.execute(statement, parameters)
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in
execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in
defaulterrorhandler
raise errorclass, errorvalue
sqlalchemy.exc.OperationalError: (OperationalError) (1005, "Can't create
table 'quantum_nvp.routerl3agentbindings' (errno: 150)") '\nCREATE TABLE
routerl3agentbindings (\n\tid VARCHAR(36) NOT NULL, \n\trouter_id VARCHAR(36),
\n\tl3_agent_id VARCHAR(36), \n\tPRIMARY KEY (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)\n\n' ()
user@nvp-os-ctrl:/opt/stack/quantum$ vi
quantum/db/migration/alembic_migrations/versions/4692d074d587_agent_scheduler.py
It looks like the problem is related to the fact that the 'routers'
table is not in the database as I am running migrations for the NVP
plugin which is not L3 capable in folsom.
Setting to grizzly-rc-1 just to keep it on the radar until it's
confirmed or rejected.
To manage notifications about this bug go to:
https://bugs.launchpad.net/quantum/+bug/1153585/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
