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 <blak...@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.soman...@freescale.com" > <trinath.soman...@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.soman...@freescale.com | extn: 4048 >> >> >> >> >> _______________________________________________ >> OpenStack-dev mailing list >> OpenStack-dev@lists.openstack.org >> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev >> > > _______________________________________________ > OpenStack-dev mailing list > OpenStack-dev@lists.openstack.org > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > _______________________________________________ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev