db migration fails with exception
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
networking-odl |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
db migration fails as follows.
The culprit is https:/
2016-10-25 17:41:13.288 | INFO [alembic.
2016-10-25 17:41:13.292 | INFO [alembic.
2016-10-25 17:41:13.294 | INFO [alembic.
2016-10-25 17:41:13.295 | INFO [alembic.
2016-10-25 17:41:13.299 | INFO [alembic.
2016-10-25 17:41:13.305 | INFO [alembic.
2016-10-25 17:41:13.319 | Running upgrade for neutron ...
2016-10-25 17:41:13.319 | OK
2016-10-25 17:41:13.319 | Running upgrade for networking-odl ...
2016-10-25 17:41:13.319 | Traceback (most recent call last):
2016-10-25 17:41:13.319 | File "/usr/local/
2016-10-25 17:41:13.319 | sys.exit(main())
2016-10-25 17:41:13.319 | File "/opt/stack/
2016-10-25 17:41:13.319 | return_val |= bool(CONF.
2016-10-25 17:41:13.319 | File "/opt/stack/
2016-10-25 17:41:13.320 | desc=branch, sql=CONF.
2016-10-25 17:41:13.320 | File "/opt/stack/
2016-10-25 17:41:13.320 | getattr(
2016-10-25 17:41:13.320 | File "/usr/local/
2016-10-25 17:41:13.320 | script.run_env()
2016-10-25 17:41:13.320 | File "/usr/local/
2016-10-25 17:41:13.320 | util.load_
2016-10-25 17:41:13.321 | File "/usr/local/
2016-10-25 17:41:13.321 | module = load_module_
2016-10-25 17:41:13.321 | File "/usr/local/
2016-10-25 17:41:13.321 | mod = imp.load_
2016-10-25 17:41:13.321 | File "/opt/stack/
2016-10-25 17:41:13.321 | run_migrations_
2016-10-25 17:41:13.321 | File "/opt/stack/
2016-10-25 17:41:13.321 | context.
2016-10-25 17:41:13.321 | File "<string>", line 8, in run_migrations
2016-10-25 17:41:13.321 | File "/usr/local/
2016-10-25 17:41:13.322 | self.get_
2016-10-25 17:41:13.322 | File "/usr/local/
2016-10-25 17:41:13.322 | step.migration_
2016-10-25 17:41:13.322 | File "/opt/stack/
2016-10-25 17:41:13.322 | onupdate=
2016-10-25 17:41:13.322 | File "<string>", line 8, in create_table
2016-10-25 17:41:13.323 | File "<string>", line 3, in create_table
2016-10-25 17:41:13.323 | File "/usr/local/
2016-10-25 17:41:13.323 | return operations.
2016-10-25 17:41:13.323 | File "/usr/local/
2016-10-25 17:41:13.323 | return fn(self, operation)
2016-10-25 17:41:13.323 | File "/usr/local/
2016-10-25 17:41:13.323 | operations.
2016-10-25 17:41:13.323 | File "/usr/local/
2016-10-25 17:41:13.324 | self._exec(
2016-10-25 17:41:13.324 | File "/usr/local/
2016-10-25 17:41:13.324 | return conn.execute(
2016-10-25 17:41:13.324 | File "/usr/local/
2016-10-25 17:41:13.324 | return meth(self, multiparams, params)
2016-10-25 17:41:13.324 | File "/usr/local/
2016-10-25 17:41:13.324 | return connection.
2016-10-25 17:41:13.324 | File "/usr/local/
2016-10-25 17:41:13.325 | compiled
2016-10-25 17:41:13.325 | File "/usr/local/
2016-10-25 17:41:13.325 | context)
2016-10-25 17:41:13.325 | File "/usr/local/
2016-10-25 17:41:13.325 | util.raise_
2016-10-25 17:41:13.325 | File "/usr/local/
2016-10-25 17:41:13.326 | reraise(
2016-10-25 17:41:13.326 | File "/usr/local/
2016-10-25 17:41:13.326 | context)
2016-10-25 17:41:13.326 | File "/usr/local/
2016-10-25 17:41:13.326 | cursor.
2016-10-25 17:41:13.327 | File "/usr/local/
2016-10-25 17:41:13.327 | result = self._query(query)
2016-10-25 17:41:13.327 | File "/usr/local/
2016-10-25 17:41:13.327 | conn.query(q)
2016-10-25 17:41:13.327 | File "/usr/local/
2016-10-25 17:41:13.328 | self._affected_rows = self._read_
2016-10-25 17:41:13.328 | File "/usr/local/
2016-10-25 17:41:13.328 | result.read()
2016-10-25 17:41:13.328 | File "/usr/local/
2016-10-25 17:41:13.328 | first_packet = self.connection
2016-10-25 17:41:13.328 | File "/usr/local/
2016-10-25 17:41:13.329 | packet.
2016-10-25 17:41:13.329 | File "/usr/local/
2016-10-25 17:41:13.329 | err.raise_
2016-10-25 17:41:13.329 | File "/usr/local/
2016-10-25 17:41:13.329 | raise errorclass(errno, errval)
2016-10-25 17:41:13.330 | oslo_db.
2016-10-25 17:41:13.404 | + lib/neutron-
2016-10-25 17:41:13.406 | + ./stack.
2016-10-25 17:41:13.408 | ++ ./stack.
2016-10-25 17:41:13.410 | + ./stack.
2016-10-25 17:41:13.411 | + ./stack.
2016-10-25 17:41:13.413 | + ./stack.
2016-10-25 17:41:13.415 | + ./stack.
2016-10-25 17:41:13.416 | + ./stack.
2016-10-25 17:41:13.418 | + ./stack.
2016-10-25 17:41:13.418 | Error on exit
2016-10-25 17:41:13.419 | + ./stack.
2016-10-25 17:41:13.612 | + ./stack.
2016-10-25 17:41:13.614 | + ./stack.
2016-10-25 17:41:13.911 | + ./stack.
Reviewed: https:/ /review. openstack. org/391283 /git.openstack. org/cgit/ openstack/ networking- odl/commit/ ?id=f90f5ee6572 089c090a34fe459 60cdd54b992b75
Committed: https:/
Submitter: Jenkins
Branch: master
commit f90f5ee6572089c 090a34fe45960cd d54b992b75
Author: Isaku Yamahata <email address hidden>
Date: Thu Oct 27 19:19:24 2016 +0200
alembic: db migration fails
the patch of https:/ /review. openstack. org/#/c/ 390017/ caused the
following exception during db migration.
This patch reverts the migration scripts change of the patch.
> INFO [alembic. runtime. migration] Running upgrade -> b89a299e19f9, Initial odl db, branchpoint runtime. migration] Running upgrade b89a299e19f9 -> 247501328046, Start of odl expand branch runtime. migration] Running upgrade 247501328046 -> 37e242787ae5, Opendaylight Neutron mechanism driver refactor runtime. migration] Running upgrade 37e242787ae5 -> 703dbf02afde, Add journal maintenance table runtime. migration] Running upgrade 703dbf02afde -> 3d560427d776, add sequence number to journal bin/neutron- db-manage" , line 10, in <module> neutron/ neutron/ db/migration/ cli.py" , line 687, in main command. func(config, CONF.command.name)) neutron/ neutron/ db/migration/ cli.py" , line 208, in do_upgrade command. sql) neutron/ neutron/ db/migration/ cli.py" , line 109, in do_alembic_command alembic_ command, cmd)(config, *args, **kwargs) lib/python2. 7/dist- packages/ alembic/ command. py", line 174, in upgrade lib/python2. 7/dist- packages/ alembic/ script/ base.py" , line 407, in run_env python_ file(self. dir, 'env.py') lib/python2. 7/dist- packages/ alembic/ util/pyfiles. py", line 93, in load_python_file py(module_ id, path) lib/python2. 7/dist- packages/ alembic/ util/compat. py", line 79, in load_module_py source( module_ id, path, fp) networking- odl/networking_ odl/db/ migration/ alembic_ migrations/ env.py" , line 99, in <module> online( ) networking- odl/networking_ odl/db/ migration/ alembic_ migrations/ env.py" , line 90, in run_migrations_ online run_migrations( ) lib/python2. 7/dist- packages/ alembic/ runtime/ environment. py", line 797, in run_migrations context( ).run_migration s(**kw) lib/python2. 7/dist- packages/ alembic/ runtime/ migration. py", line 312, in run_migrations fn(**kw) networking- odl/networking_ odl/db/ migration/ alembic_ migrations/ versions/ newton/ e...
> INFO [alembic.
> INFO [alembic.
> INFO [alembic.
> INFO [alembic.
> Running upgrade for neutron ...
> OK
> Running upgrade for networking-odl ...
> Traceback (most recent call last):
> File "/usr/local/
> sys.exit(main())
> File "/opt/stack/
> return_val |= bool(CONF.
> File "/opt/stack/
> desc=branch, sql=CONF.
> File "/opt/stack/
> getattr(
> File "/usr/local/
> script.run_env()
> File "/usr/local/
> util.load_
> File "/usr/local/
> module = load_module_
> File "/usr/local/
> mod = imp.load_
> File "/opt/stack/
> run_migrations_
> File "/opt/stack/
> context.
> File "<string>", line 8, in run_migrations
> File "/usr/local/
> self.get_
> File "/usr/local/
> step.migration_
> File "/opt/stack/