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

Kyle Mestery mestery at mestery.com
Wed Jul 16 20:29:55 UTC 2014


I've poked some folks on the infra channel about this now, as we need
this merged soon.

On Wed, Jul 16, 2014 at 11:30 AM, Kevin Benton <blak111 at gmail.com> wrote:
> 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
>>
>
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>



More information about the OpenStack-dev mailing list