It is failed to upgrade db from 0.10.1 to 2.0.0

[chenhb]

It is failed to upgrade db from 0.10.1 to 2.0.0, the db server is mysql.

The error info:

Command failed, please check log for more info
2019-09-30 14:55:44.247 1987 CRITICAL rally [-] Unhandled error: CommandError: All MySQL CHANGE/MODIFY COLUMN operations require the existing type.
2019-09-30 14:55:44.247 1987 ERROR rally Traceback (most recent call last):
2019-09-30 14:55:44.247 1987 ERROR rally File "/opt/rally/bin/rally", line 10, in <module>
2019-09-30 14:55:44.247 1987 ERROR rally sys.exit(main())
2019-09-30 14:55:44.247 1987 ERROR rally File "/opt/rally/lib/python2.7/site-packages/rally/cli/main.py", line 42, in main
2019-09-30 14:55:44.247 1987 ERROR rally return cliutils.run(sys.argv, categories)
2019-09-30 14:55:44.247 1987 ERROR rally File "/opt/rally/lib/python2.7/site-packages/rally/cli/cliutils.py", line 674, in run
2019-09-30 14:55:44.247 1987 ERROR rally ret = fn(*fn_args, **fn_kwargs)
2019-09-30 14:55:44.247 1987 ERROR rally File "/opt/rally/lib/python2.7/site-packages/rally/cli/commands/db.py", line 66, in upgrade
2019-09-30 14:55:44.247 1987 ERROR rally db.schema.schema_upgrade()
2019-09-30 14:55:44.247 1987 ERROR rally File "/opt/rally/lib/python2.7/site-packages/rally/common/db/schema.py", line 119, in schema_upgrade
2019-09-30 14:55:44.247 1987 ERROR rally alembic.command.upgrade(config, revision or "head")
2019-09-30 14:55:44.247 1987 ERROR rally File "/opt/rally/lib/python2.7/site-packages/alembic/command.py", line 298, in upgrade
2019-09-30 14:55:44.247 1987 ERROR rally script.run_env()
2019-09-30 14:55:44.247 1987 ERROR rally File "/opt/rally/lib/python2.7/site-packages/alembic/script/base.py", line 489, in run_env
2019-09-30 14:55:44.247 1987 ERROR rally util.load_python_file(self.dir, "env.py")
2019-09-30 14:55:44.247 1987 ERROR rally File "/opt/rally/lib/python2.7/site-packages/alembic/util/pyfiles.py", line 98, in load_python_file
2019-09-30 14:55:44.247 1987 ERROR rally module = load_module_py(module_id, path)
2019-09-30 14:55:44.247 1987 ERROR rally File "/opt/rally/lib/python2.7/site-packages/alembic/util/compat.py", line 239, in load_module_py
2019-09-30 14:55:44.247 1987 ERROR rally mod = imp.load_source(module_id, path, fp)
2019-09-30 14:55:44.247 1987 ERROR rally File "/opt/rally/lib/python2.7/site-packages/rally/common/db/migrations/env.py", line 47, in <module>
2019-09-30 14:55:44.247 1987 ERROR rally run_migrations_online()
2019-09-30 14:55:44.247 1987 ERROR rally File "/opt/rally/lib/python2.7/site-packages/rally/common/db/migrations/env.py", line 44, in run_migrations_online
2019-09-30 14:55:44.247 1987 ERROR rally context.run_migrations()
2019-09-30 14:55:44.247 1987 ERROR rally File "<string>", line 8, in run_migrations
2019-09-30 14:55:44.247 1987 ERROR rally File "/opt/rally/lib/python2.7/site-packages/alembic/runtime/environment.py", line 846, in run_migrations
2019-09-30 14:55:44.247 1987 ERROR rally self.get_context().run_migrations(**kw)
2019-09-30 14:55:44.247 1987 ERROR rally File "/opt/rally/lib/python2.7/site-packages/alembic/runtime/migration.py", line 518, in run_migrations
2019-09-30 14:55:44.247 1987 ERROR rally step.migration_fn(**kw)
2019-09-30 14:55:44.247 1987 ERROR rally File "/opt/rally/lib/python2.7/site-packages/rally/common/db/migrations/versions/2018_02_bc908ac9a1fc_move_deployment_to_env_2.py", line 224, in upgrade
2019-09-30 14:55:44.247 1987 ERROR rally batch_op.drop_column("deployment_uuid")
2019-09-30 14:55:44.247 1987 ERROR rally File "/usr/lib64/python2.7/contextlib.py", line 24, in __exit__
2019-09-30 14:55:44.247 1987 ERROR rally self.gen.next()
2019-09-30 14:55:44.247 1987 ERROR rally File "/opt/rally/lib/python2.7/site-packages/alembic/operations/base.py", line 325, in batch_alter_table
2019-09-30 14:55:44.247 1987 ERROR rally impl.flush()
2019-09-30 14:55:44.247 1987 ERROR rally File "/opt/rally/lib/python2.7/site-packages/alembic/operations/batch.py", line 79, in flush
2019-09-30 14:55:44.247 1987 ERROR rally fn(*arg, **kw)
2019-09-30 14:55:44.247 1987 ERROR rally File "/opt/rally/lib/python2.7/site-packages/alembic/ddl/mysql.py", line 98, in alter_column
2019-09-30 14:55:44.247 1987 ERROR rally else existing_comment,
2019-09-30 14:55:44.247 1987 ERROR rally File "/opt/rally/lib/python2.7/site-packages/alembic/ddl/mysql.py", line 324, in __init__
2019-09-30 14:55:44.247 1987 ERROR rally "All MySQL CHANGE/MODIFY COLUMN operations "
2019-09-30 14:55:44.247 1987 ERROR rally CommandError: All MySQL CHANGE/MODIFY COLUMN operations require the existing type.