[openstack-dev] [Neutron][CI] DB migration error

trinath.somanchi at freescale.com trinath.somanchi at freescale.com
Wed Jul 16 16:22:58 UTC 2014


Hi-

With the neutron Update to my CI, I get the following error while configuring Neutron in devstack.

2014-07-16 16:12:06.349 | INFO  [alembic.autogenerate.compare] Detected server default on column 'poolmonitorassociations.status'
2014-07-16 16:12:06.411 | INFO  [neutron.db.migration.alembic_migrations.heal_script] Detected added foreign key for column 'id' on table u'ml2_brocadeports'
2014-07-16 16:12:14.853 | Traceback (most recent call last):
2014-07-16 16:12:14.853 |   File "/usr/local/bin/neutron-db-manage", line 10, in <module>
2014-07-16 16:12:14.853 |     sys.exit(main())
2014-07-16 16:12:14.854 |   File "/opt/stack/new/neutron/neutron/db/migration/cli.py", line 171, in main
2014-07-16 16:12:14.854 |     CONF.command.func(config, CONF.command.name)
2014-07-16 16:12:14.854 |   File "/opt/stack/new/neutron/neutron/db/migration/cli.py", line 85, in do_upgrade_downgrade
2014-07-16 16:12:14.854 |     do_alembic_command(config, cmd, revision, sql=CONF.command.sql)
2014-07-16 16:12:14.854 |   File "/opt/stack/new/neutron/neutron/db/migration/cli.py", line 63, in do_alembic_command
2014-07-16 16:12:14.854 |     getattr(alembic_command, cmd)(config, *args, **kwargs)
2014-07-16 16:12:14.854 |   File "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 124, in upgrade
2014-07-16 16:12:14.854 |     script.run_env()
2014-07-16 16:12:14.854 |   File "/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 199, in run_env
2014-07-16 16:12:14.854 |     util.load_python_file(self.dir, 'env.py')
2014-07-16 16:12:14.854 |   File "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 205, in load_python_file
2014-07-16 16:12:14.854 |     module = load_module_py(module_id, path)
2014-07-16 16:12:14.854 |   File "/usr/local/lib/python2.7/dist-packages/alembic/compat.py", line 58, in load_module_py
2014-07-16 16:12:14.854 |     mod = imp.load_source(module_id, path, fp)
2014-07-16 16:12:14.854 |   File "/opt/stack/new/neutron/neutron/db/migration/alembic_migrations/env.py", line 106, in <module>
2014-07-16 16:12:14.854 |     run_migrations_online()
2014-07-16 16:12:14.855 |   File "/opt/stack/new/neutron/neutron/db/migration/alembic_migrations/env.py", line 90, in run_migrations_online
2014-07-16 16:12:14.855 |     options=build_options())
2014-07-16 16:12:14.855 |   File "<string>", line 7, in run_migrations
2014-07-16 16:12:14.855 |   File "/usr/local/lib/python2.7/dist-packages/alembic/environment.py", line 681, in run_migrations
2014-07-16 16:12:14.855 |     self.get_context().run_migrations(**kw)
2014-07-16 16:12:14.855 |   File "/usr/local/lib/python2.7/dist-packages/alembic/migration.py", line 225, in run_migrations
2014-07-16 16:12:14.855 |     change(**kw)
2014-07-16 16:12:14.856 |   File "/opt/stack/new/neutron/neutron/db/migration/alembic_migrations/versions/1d6ee1ae5da5_db_healing.py", line 32, in upgrade
2014-07-16 16:12:14.856 |     heal_script.heal()
2014-07-16 16:12:14.856 |   File "/opt/stack/new/neutron/neutron/db/migration/alembic_migrations/heal_script.py", line 78, in heal
2014-07-16 16:12:14.856 |     execute_alembic_command(el)
2014-07-16 16:12:14.856 |   File "/opt/stack/new/neutron/neutron/db/migration/alembic_migrations/heal_script.py", line 93, in execute_alembic_command
2014-07-16 16:12:14.856 |     parse_modify_command(command)
2014-07-16 16:12:14.856 |   File "/opt/stack/new/neutron/neutron/db/migration/alembic_migrations/heal_script.py", line 126, in parse_modify_command
2014-07-16 16:12:14.856 |     op.alter_column(table, column, **kwargs)
2014-07-16 16:12:14.856 |   File "<string>", line 7, in alter_column
2014-07-16 16:12:14.856 |   File "<string>", line 1, in <lambda>
2014-07-16 16:12:14.856 |   File "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 322, in go
2014-07-16 16:12:14.857 |     return fn(*arg, **kw)
2014-07-16 16:12:14.857 |   File "/usr/local/lib/python2.7/dist-packages/alembic/operations.py", line 300, in alter_column
2014-07-16 16:12:14.857 |     existing_autoincrement=existing_autoincrement
2014-07-16 16:12:14.857 |   File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/mysql.py", line 42, in alter_column
2014-07-16 16:12:14.857 |     else existing_autoincrement
2014-07-16 16:12:14.857 |   File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 76, in _exec
2014-07-16 16:12:14.857 |     conn.execute(construct, *multiparams, **params)
2014-07-16 16:12:14.857 |   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 727, in execute
2014-07-16 16:12:14.857 |     return meth(self, multiparams, params)
2014-07-16 16:12:14.858 |   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 67, in _execute_on_connection
2014-07-16 16:12:14.858 |     return connection._execute_ddl(self, multiparams, params)
2014-07-16 16:12:14.858 |   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 775, in _execute_ddl
2014-07-16 16:12:14.858 |     compiled = ddl.compile(dialect=dialect)
2014-07-16 16:12:14.858 |   File "<string>", line 1, in <lambda>
2014-07-16 16:12:14.858 |   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 493, in compile
2014-07-16 16:12:14.859 |     return self._compiler(dialect, bind=bind, **kw)
2014-07-16 16:12:14.859 |   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 25, in _compiler
2014-07-16 16:12:14.859 |     return dialect.ddl_compiler(dialect, self, **kw)
2014-07-16 16:12:14.859 |   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/compiler.py", line 196, in __init__
2014-07-16 16:12:14.859 |     self.string = self.process(self.statement, **compile_kwargs)
2014-07-16 16:12:14.859 |   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/compiler.py", line 219, in process
2014-07-16 16:12:14.859 |     return obj._compiler_dispatch(self, **kwargs)
2014-07-16 16:12:14.859 |   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/ext/compiler.py", line 410, in <lambda>
2014-07-16 16:12:14.859 |     lambda *arg, **kw: existing(*arg, **kw))
2014-07-16 16:12:14.859 |   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/ext/compiler.py", line 448, in __call__
2014-07-16 16:12:14.859 |     return fn(element, compiler, **kw)
2014-07-16 16:12:14.859 |   File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/mysql.py", line 98, in _mysql_alter_column
2014-07-16 16:12:14.860 |     autoincrement=element.autoincrement
2014-07-16 16:12:14.860 |   File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/mysql.py", line 118, in _mysql_colspec
2014-07-16 16:12:14.860 |     spec += " DEFAULT %s" % _render_value(compiler, server_default)
2014-07-16 16:12:14.860 |   File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/mysql.py", line 106, in _render_value
2014-07-16 16:12:14.860 |     return compiler.sql_compiler.process(expr)
2014-07-16 16:12:14.860 |   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/compiler.py", line 219, in process
2014-07-16 16:12:14.860 |     return obj._compiler_dispatch(self, **kwargs)
2014-07-16 16:12:14.860 | AttributeError: 'DefaultClause' object has no attribute '_compiler_dispatch'

Kindly help how to resolve this issue.

Thanks in advance.


--
Trinath Somanchi - B39208
trinath.somanchi at freescale.com | extn: 4048

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20140716/6e6e4df7/attachment.html>


More information about the OpenStack-dev mailing list