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.
-- Trinath Somanchi - B39208 [email protected] | extn: 4048 From: Kevin Benton [mailto:[email protected]] 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, "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> 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 [email protected]<mailto:[email protected]> | extn: 4048 _______________________________________________ OpenStack-dev mailing list [email protected]<mailto:[email protected]> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
_______________________________________________ OpenStack-dev mailing list [email protected] http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
