Ask Your Question

Ubuntu 14.04 neutron upgrade juno to kilo database migration fails

asked 2015-08-04 15:01:07 -0500

konetzed gravatar image

When upgrading from Juno to Kilo on ubuntu 14.04 I get the following error when running

"su -s /bin/sh -c "neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugins/ml2/ml2_conf.ini upgrade kilo" neutron"

INFO  [alembic.migration] Context impl MySQLImpl.
INFO  [alembic.migration] Will assume non-transactional DDL.
INFO  [alembic.migration] Context impl MySQLImpl.
INFO  [alembic.migration] Will assume non-transactional DDL.
INFO  [alembic.migration] Running upgrade juno -> 44621190bc02, add_uniqueconstraint_ipavailability_ranges
INFO  [alembic.migration] Running upgrade 44621190bc02 -> 1f71e54a85e7, ml2_network_segments models change for multi-segment network.
INFO  [alembic.migration] Running upgrade 1f71e54a85e7 -> 408cfbf6923c, remove ryu plugin
INFO  [alembic.migration] Running upgrade 408cfbf6923c -> 28c0ffb8ebbd, remove mlnx plugin
INFO  [alembic.migration] Running upgrade 28c0ffb8ebbd -> 57086602ca0a, scrap_nsx_adv_svcs_models
INFO  [alembic.migration] Running upgrade 57086602ca0a -> 38495dc99731, ml2_tunnel_endpoints_table
INFO  [alembic.migration] Running upgrade 38495dc99731 -> 4dbe243cd84d, nsxv
Traceback (most recent call last):
  File "/usr/bin/neutron-db-manage", line 10, in <module>
  File "/usr/lib/python2.7/dist-packages/neutron/db/migration/", line 238, in main
  File "/usr/lib/python2.7/dist-packages/neutron/db/migration/", line 106, in do_upgrade
    do_alembic_command(config, cmd, revision, sql=CONF.command.sql)
  File "/usr/lib/python2.7/dist-packages/neutron/db/migration/", line 72, in do_alembic_command
    getattr(alembic_command, cmd)(config, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/alembic/", line 165, in upgrade
  File "/usr/lib/python2.7/dist-packages/alembic/", line 382, in run_env
    util.load_python_file(self.dir, '')
  File "/usr/lib/python2.7/dist-packages/alembic/", line 241, in load_python_file
    module = load_module_py(module_id, path)
  File "/usr/lib/python2.7/dist-packages/alembic/", line 79, in load_module_py
    mod = imp.load_source(module_id, path, fp)
  File "/usr/lib/python2.7/dist-packages/neutron/db/migration/alembic_migrations/", line 109, in <module>
  File "/usr/lib/python2.7/dist-packages/neutron/db/migration/alembic_migrations/", line 100, in run_migrations_online
  File "<string>", line 7, in run_migrations
  File "/usr/lib/python2.7/dist-packages/alembic/", line 742, in run_migrations
  File "/usr/lib/python2.7/dist-packages/alembic/", line 305, in run_migrations
  File "/usr/lib/python2.7/dist-packages/neutron/db/migration/alembic_migrations/versions/", line 65, in upgrade
  File "<string>", line 7, in create_table
  File "/usr/lib/python2.7/dist-packages/alembic/", line 936, in create_table
  File "/usr/lib/python2.7/dist-packages/alembic/ddl/", line 182, in create_table
  File "/usr/lib/python2.7/dist-packages/alembic/ddl/", line 106, in _exec
    return conn.execute(construct, *multiparams, **params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/", line 729, in execute
    return meth(self, multiparams, params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/", line 69, in _execute_on_connection
    return connection._execute_ddl(self, multiparams, params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/", line 783, in _execute_ddl
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base ...
edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted

answered 2015-08-05 11:26:18 -0500

konetzed gravatar image


Problem was database tables were in utf8 and not latin1

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower


Asked: 2015-08-04 15:01:07 -0500

Seen: 394 times

Last updated: Aug 05 '15