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

trinath.somanchi at freescale.com trinath.somanchi at freescale.com
Thu Jul 17 10:18:35 UTC 2014


Hi Kevin-

The fix given in the bug report is not working for my CI. I think I need to wait for the real fix in the main stream.

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

From: Kevin Benton [mailto:blak111 at gmail.com]
Sent: Wednesday, July 16, 2014 10:01 PM
To: OpenStack Development Mailing List (not for usage questions)
Subject: Re: [openstack-dev] [Neutron][CI] DB migration error


This bug is also affecting Ryu and the Big Switch CI.
There is a patch to bump the version requirement for alembic linked in the bug report that should fix it. It we can't get that merged we may have to revert the healing patch.

https://bugs.launchpad.net/bugs/1342507
On Jul 16, 2014 9:27 AM, "trinath.somanchi at freescale.com<mailto:trinath.somanchi at freescale.com>" <trinath.somanchi at freescale.com<mailto:trinath.somanchi at freescale.com>> wrote:
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<http://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<mailto:trinath.somanchi at freescale.com> | extn: 4048


_______________________________________________
OpenStack-dev mailing list
OpenStack-dev at lists.openstack.org<mailto:OpenStack-dev at lists.openstack.org>
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20140717/7de04ae3/attachment.html>


More information about the OpenStack-dev mailing list