<p dir="ltr">This bug is also affecting Ryu and the Big Switch CI. <br>
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. </p>
<p dir="ltr"><a href="https://bugs.launchpad.net/bugs/1342507">https://bugs.launchpad.net/bugs/1342507</a></p>
<div class="gmail_quote">On Jul 16, 2014 9:27 AM, "<a href="mailto:trinath.somanchi@freescale.com">trinath.somanchi@freescale.com</a>" <<a href="mailto:trinath.somanchi@freescale.com">trinath.somanchi@freescale.com</a>> wrote:<br type="attribution">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal">Hi-<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">With the neutron Update to my CI, I get the following error while configuring Neutron in devstack.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:06.349 | INFO [alembic.autogenerate.compare] Detected server default on column 'poolmonitorassociations.status'<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">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'<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.853 | Traceback (most recent call last):<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.853 | File "/usr/local/bin/neutron-db-manage", line 10, in <module><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.853 | sys.exit(main())<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.854 | File "/opt/stack/new/neutron/neutron/db/migration/cli.py", line 171, in main<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.854 | CONF.command.func(config, <a href="http://CONF.command.name" target="_blank">CONF.command.name</a>)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.854 | File "/opt/stack/new/neutron/neutron/db/migration/cli.py", line 85, in do_upgrade_downgrade<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.854 | do_alembic_command(config, cmd, revision, sql=CONF.command.sql)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.854 | File "/opt/stack/new/neutron/neutron/db/migration/cli.py", line 63, in do_alembic_command<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.854 | getattr(alembic_command, cmd)(config, *args, **kwargs)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.854 | File "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 124, in upgrade<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.854 | script.run_env()<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.854 | File "/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 199, in run_env<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.854 | util.load_python_file(self.dir, 'env.py')<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.854 | File "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 205, in load_python_file<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.854 | module = load_module_py(module_id, path)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.854 | File "/usr/local/lib/python2.7/dist-packages/alembic/compat.py", line 58, in load_module_py<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.854 | mod = imp.load_source(module_id, path, fp)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.854 | File "/opt/stack/new/neutron/neutron/db/migration/alembic_migrations/env.py", line 106, in <module><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.854 | run_migrations_online()<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">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<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.855 | options=build_options())<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.855 | File "<string>", line 7, in run_migrations<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.855 | File "/usr/local/lib/python2.7/dist-packages/alembic/environment.py", line 681, in run_migrations<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.855 | self.get_context().run_migrations(**kw)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.855 | File "/usr/local/lib/python2.7/dist-packages/alembic/migration.py", line 225, in run_migrations<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.855 | change(**kw)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">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<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.856 | heal_script.heal()<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.856 | File "/opt/stack/new/neutron/neutron/db/migration/alembic_migrations/heal_script.py", line 78, in heal<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.856 | execute_alembic_command(el)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">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<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.856 | parse_modify_command(command)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">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<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.856 | op.alter_column(table, column, **kwargs)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.856 | File "<string>", line 7, in alter_column<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.856 | File "<string>", line 1, in <lambda><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.856 | File "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 322, in go<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.857 | return fn(*arg, **kw)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.857 | File "/usr/local/lib/python2.7/dist-packages/alembic/operations.py", line 300, in alter_column<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.857 | existing_autoincrement=existing_autoincrement<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.857 | File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/mysql.py", line 42, in alter_column<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.857 | else existing_autoincrement<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.857 | File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 76, in _exec<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.857 | conn.execute(construct, *multiparams, **params)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.857 | File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 727, in execute<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.857 | return meth(self, multiparams, params)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">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<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.858 | return connection._execute_ddl(self, multiparams, params)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.858 | File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 775, in _execute_ddl<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.858 | compiled = ddl.compile(dialect=dialect)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.858 | File "<string>", line 1, in <lambda><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.858 | File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 493, in compile<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.859 | return self._compiler(dialect, bind=bind, **kw)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.859 | File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 25, in _compiler<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.859 | return dialect.ddl_compiler(dialect, self, **kw)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.859 | File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/compiler.py", line 196, in __init__<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.859 | self.string = self.process(self.statement, **compile_kwargs)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.859 | File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/compiler.py", line 219, in process<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.859 | return obj._compiler_dispatch(self, **kwargs)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.859 | File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/ext/compiler.py", line 410, in <lambda><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.859 | lambda *arg, **kw: existing(*arg, **kw))<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.859 | File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/ext/compiler.py", line 448, in __call__<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.859 | return fn(element, compiler, **kw)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">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<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.860 | autoincrement=element.autoincrement<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.860 | File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/mysql.py", line 118, in _mysql_colspec<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.860 | spec += " DEFAULT %s" % _render_value(compiler, server_default)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.860 | File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/mysql.py", line 106, in _render_value<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.860 | return compiler.sql_compiler.process(expr)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.860 | File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/compiler.py", line 219, in process<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.860 | return obj._compiler_dispatch(self, **kwargs)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:black">2014-07-16 16:12:14.860 | AttributeError: 'DefaultClause' object has no attribute '_compiler_dispatch'<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Kindly help how to resolve this issue.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Thanks in advance.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">--<u></u><u></u></p>
<p class="MsoNormal">Trinath Somanchi - B39208<u></u><u></u></p>
<p class="MsoNormal"><span style="color:#548dd4">trinath.somanchi@</span><span style="color:#548dd4">freescale</span><span style="color:#548dd4">.com</span> | extn: 4048<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
<br>_______________________________________________<br>
OpenStack-dev mailing list<br>
<a href="mailto:OpenStack-dev@lists.openstack.org">OpenStack-dev@lists.openstack.org</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
<br></blockquote></div>