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

Kevin Benton blak111 at gmail.com
Wed Jul 16 16:30:47 UTC 2014


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" <
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)
>
> 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
>
>
>
> _______________________________________________
> OpenStack-dev mailing list
> 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/20140716/3b2ede97/attachment.html>


More information about the OpenStack-dev mailing list