There is a problem with version of alembic. With alembic>=0.6.4 for all
plugins heal script worked normal. I tested locally and I got such error
only with alembic versions 0.6.2 and older. Global requirements already
updated with alembic>=0.6.4. So the problem should get fixed with
alembic version upgrade.
** Changed in: neutron
Status: Confirmed => Invalid
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1342507
Title:
healing migration doesn't work for ryu CI
Status in OpenStack Neutron (virtual network service):
Invalid
Bug description:
ryu CI started failing after healing migration change
(https://review.openstack.org/#/c/96438/)
http://180.37.183.32/ryuci/38/96438/41/check/check-tempest-dsvm-
ryuplugin/e457d80/logs/devstacklog.txt.gz
2014-07-15 11:27:55.722 | Traceback (most recent call last):
2014-07-15 11:27:55.722 | File "/usr/local/bin/neutron-db-manage", line 10,
in <module>
2014-07-15 11:27:55.722 | sys.exit(main())
2014-07-15 11:27:55.722 | File
"/opt/stack/new/neutron/neutron/db/migration/cli.py", line 171, in main
2014-07-15 11:27:55.722 | CONF.command.func(config, CONF.command.name)
2014-07-15 11:27:55.722 | File
"/opt/stack/new/neutron/neutron/db/migration/cli.py", line 85, in
do_upgrade_downgrade
2014-07-15 11:27:55.722 | do_alembic_command(config, cmd, revision,
sql=CONF.command.sql)
2014-07-15 11:27:55.722 | File
"/opt/stack/new/neutron/neutron/db/migration/cli.py", line 63, in
do_alembic_command
2014-07-15 11:27:55.723 | getattr(alembic_command, cmd)(config, *args,
**kwargs)
2014-07-15 11:27:55.723 | File
"/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 124, in
upgrade
2014-07-15 11:27:55.733 | script.run_env()
2014-07-15 11:27:55.734 | File
"/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 199, in run_env
2014-07-15 11:27:55.736 | util.load_python_file(self.dir, 'env.py')
2014-07-15 11:27:55.737 | File
"/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 205, in
load_python_file
2014-07-15 11:27:55.737 | module = load_module_py(module_id, path)
2014-07-15 11:27:55.738 | File
"/usr/local/lib/python2.7/dist-packages/alembic/compat.py", line 58, in
load_module_py
2014-07-15 11:27:55.738 | mod = imp.load_source(module_id, path, fp)
2014-07-15 11:27:55.738 | File
"/opt/stack/new/neutron/neutron/db/migration/alembic_migrations/env.py", line
106, in <module>
2014-07-15 11:27:55.738 | run_migrations_online()
2014-07-15 11:27:55.738 | File
"/opt/stack/new/neutron/neutron/db/migration/alembic_migrations/env.py", line
90, in run_migrations_online
2014-07-15 11:27:55.738 | options=build_options())
2014-07-15 11:27:55.738 | File "<string>", line 7, in run_migrations
2014-07-15 11:27:55.739 | File
"/usr/local/lib/python2.7/dist-packages/alembic/environment.py", line 681, in
run_migrations
2014-07-15 11:27:55.740 | self.get_context().run_migrations(**kw)
2014-07-15 11:27:55.740 | File
"/usr/local/lib/python2.7/dist-packages/alembic/migration.py", line 225, in
run_migrations
2014-07-15 11:27:55.741 | change(**kw)
2014-07-15 11:27:55.741 | File
"/opt/stack/new/neutron/neutron/db/migration/alembic_migrations/versions/1d6ee1ae5da5_db_healing.py",
line 32, in upgrade
2014-07-15 11:27:55.741 | heal_script.heal()
2014-07-15 11:27:55.741 | File
"/opt/stack/new/neutron/neutron/db/migration/alembic_migrations/heal_script.py",
line 78, in heal
2014-07-15 11:27:55.741 | execute_alembic_command(el)
2014-07-15 11:27:55.741 | File
"/opt/stack/new/neutron/neutron/db/migration/alembic_migrations/heal_script.py",
line 93, in execute_alembic_command
2014-07-15 11:27:55.741 | parse_modify_command(command)
2014-07-15 11:27:55.741 | File
"/opt/stack/new/neutron/neutron/db/migration/alembic_migrations/heal_script.py",
line 126, in parse_modify_command
2014-07-15 11:27:55.741 | op.alter_column(table, column, **kwargs)
2014-07-15 11:27:55.741 | File "<string>", line 7, in alter_column
2014-07-15 11:27:55.742 | File "<string>", line 1, in <lambda>
2014-07-15 11:27:55.742 | File
"/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 322, in go
2014-07-15 11:27:55.742 | return fn(*arg, **kw)
2014-07-15 11:27:55.742 | File
"/usr/local/lib/python2.7/dist-packages/alembic/operations.py", line 300, in
alter_column
2014-07-15 11:27:55.743 | existing_autoincrement=existing_autoincrement
2014-07-15 11:27:55.743 | File
"/usr/local/lib/python2.7/dist-packages/alembic/ddl/mysql.py", line 42, in
alter_column
2014-07-15 11:27:55.743 | else existing_autoincrement
2014-07-15 11:27:55.743 | File
"/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 76, in _exec
2014-07-15 11:27:55.744 | conn.execute(construct, *multiparams, **params)
2014-07-15 11:27:55.744 | File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 717,
in execute
2014-07-15 11:27:55.745 | return meth(self, multiparams, params)
2014-07-15 11:27:55.745 | File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 67, in
_execute_on_connection
2014-07-15 11:27:55.745 | return connection._execute_ddl(self,
multiparams, params)
2014-07-15 11:27:55.745 | File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 765,
in _execute_ddl
2014-07-15 11:27:55.746 | compiled = ddl.compile(dialect=dialect)
2014-07-15 11:27:55.746 | File "<string>", line 1, in <lambda>
2014-07-15 11:27:55.746 | File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 468,
in compile
2014-07-15 11:27:55.746 | return self._compiler(dialect, bind=bind, **kw)
2014-07-15 11:27:55.746 | File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 25, in
_compiler
2014-07-15 11:27:55.746 | return dialect.ddl_compiler(dialect, self, **kw)
2014-07-15 11:27:55.746 | File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/compiler.py", line 197,
in __init__
2014-07-15 11:27:55.764 | self.string = self.process(self.statement,
**compile_kwargs)
2014-07-15 11:27:55.764 | File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/compiler.py", line 220,
in process
2014-07-15 11:27:55.764 | return obj._compiler_dispatch(self, **kwargs)
2014-07-15 11:27:55.764 | File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/ext/compiler.py", line 410,
in <lambda>
2014-07-15 11:27:55.772 | lambda *arg, **kw: existing(*arg, **kw))
2014-07-15 11:27:55.772 | File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/ext/compiler.py", line 448,
in __call__
2014-07-15 11:27:55.772 | return fn(element, compiler, **kw)
2014-07-15 11:27:55.772 | File
"/usr/local/lib/python2.7/dist-packages/alembic/ddl/mysql.py", line 98, in
_mysql_alter_column
2014-07-15 11:27:55.772 | autoincrement=element.autoincrement
2014-07-15 11:27:55.772 | File
"/usr/local/lib/python2.7/dist-packages/alembic/ddl/mysql.py", line 118, in
_mysql_colspec
2014-07-15 11:27:55.773 | spec += " DEFAULT %s" % _render_value(compiler,
server_default)
2014-07-15 11:27:55.773 | File
"/usr/local/lib/python2.7/dist-packages/alembic/ddl/mysql.py", line 106, in
_render_value
2014-07-15 11:27:55.773 | return compiler.sql_compiler.process(expr)
2014-07-15 11:27:55.773 | File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/compiler.py", line 220,
in process
2014-07-15 11:27:55.773 | return obj._compiler_dispatch(self, **kwargs)
2014-07-15 11:27:55.773 | AttributeError: 'NoneType' object has no attribute
'_compiler_dispatch'
To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1342507/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
