[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