On 07/17/2014 12:18 PM, trinath.soman...@freescale.com wrote: > 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. What version of alembic library did you have at the time of error? Are you sure you re-run pip install -r requirements.txt after you changed the version?
Kuba > > > > -- > > Trinath Somanchi - B39208 > > trinath.soman...@freescale.com| extn: 4048 > > > > *From:*Kevin Benton [mailto:blak...@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.soman...@freescale.com > <mailto:trinath.soman...@freescale.com>" <trinath.soman...@freescale.com > <mailto: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 <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.soman...@freescale.com > <mailto:trinath.soman...@freescale.com> | extn: 4048 > > > > > _______________________________________________ > OpenStack-dev mailing list > OpenStack-dev@lists.openstack.org > <mailto: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