Revision history [back]

click to hide/show revision 1
initial version

DB sync for neutron not happened while installing openstack Kilo using RC build

When tried to install openstack kilo using RC build, while doing neutron db sync using the following command , 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

got the below error, INFO [alembic.migration] Context impl MySQLImpl. INFO [alembic.migration] Will assume non-transactional DDL. Traceback (most recent call last): File "/usr/bin/neutron-db-manage", line 10, in <module> sys.exit(main()) File "/usr/lib/python2.7/dist-packages/neutron/db/migration/cli.py", line 238, in main CONF.command.func(config, CONF.command.name) File "/usr/lib/python2.7/dist-packages/neutron/db/migration/cli.py", line 105, in do_upgrade run_sanity_checks(config, revision) File "/usr/lib/python2.7/dist-packages/neutron/db/migration/cli.py", line 229, in run_sanity_checks script_dir.run_env() File "/usr/lib/python2.7/dist-packages/alembic/script.py", line 382, in run_env util.load_python_file(self.dir, 'env.py') File "/usr/lib/python2.7/dist-packages/alembic/util.py", line 241, in load_python_file module = load_module_py(module_id, path) File "/usr/lib/python2.7/dist-packages/alembic/compat.py", 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/env.py", line 109, in <module> run_migrations_online() File "/usr/lib/python2.7/dist-packages/neutron/db/migration/alembic_migrations/env.py", line 100, in run_migrations_online context.run_migrations() File "<string>", line 7, in run_migrations File "/usr/lib/python2.7/dist-packages/alembic/environment.py", line 742, in run_migrations self.get_context().run_migrations(**kw) File "/usr/lib/python2.7/dist-packages/alembic/migration.py", line 296, in run_migrations for step in self._migrations_fn(heads, self): File "/usr/lib/python2.7/dist-packages/neutron/db/migration/cli.py", line 220, in check_sanity for script in script_dir.iterate_revisions(revision, rev): File "/usr/lib/python2.7/dist-packages/alembic/revision.py", line 580, in _iterate_revisions uppers = self.get_revisions(upper) File "/usr/lib/python2.7/dist-packages/alembic/revision.py", line 273, in get_revisions for rev_id in resolved_id) File "/usr/lib/python2.7/dist-packages/alembic/revision.py", line 273, in <genexpr> for rev_id in resolved_id) File "/usr/lib/python2.7/dist-packages/alembic/revision.py", line 326, in _revision_for_ident "No such revision or branch '%s'" % resolved_id) alembic.revision.ResolutionError: No such revision or branch 'kilo'

So, we tried to take db sync command from Kilo devstack and when executed the below command su -s /bin/sh -c "neutron-db-manage --config-file /etc/neutron/neutron.conf \ --config-file /etc/neutron/plugins/ml2/ml2_conf.ini upgrade head" neutron

it got upgraded for juno, but not for KILO.

Is that Kilo code is available for DB sync to populate the database? if so what is the command to execute?

DB sync for neutron not happened while installing openstack Kilo using RC build

When tried to install openstack kilo using RC build, while doing neutron db sync using the following command ,

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

neutron

got the below error, error,

INFO  [alembic.migration] Context impl MySQLImpl.
INFO  [alembic.migration] Will assume non-transactional DDL.
Traceback (most recent call last):
  File "/usr/bin/neutron-db-manage", line 10, in <module>
    sys.exit(main())
  File "/usr/lib/python2.7/dist-packages/neutron/db/migration/cli.py", line 238, in main
    CONF.command.func(config, CONF.command.name)
  File "/usr/lib/python2.7/dist-packages/neutron/db/migration/cli.py", line 105, in do_upgrade
    run_sanity_checks(config, revision)
  File "/usr/lib/python2.7/dist-packages/neutron/db/migration/cli.py", line 229, in run_sanity_checks
    script_dir.run_env()
  File "/usr/lib/python2.7/dist-packages/alembic/script.py", line 382, in run_env
    util.load_python_file(self.dir, 'env.py')
  File "/usr/lib/python2.7/dist-packages/alembic/util.py", line 241, in load_python_file
    module = load_module_py(module_id, path)
  File "/usr/lib/python2.7/dist-packages/alembic/compat.py", 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/env.py", line 109, in <module>
    run_migrations_online()
  File "/usr/lib/python2.7/dist-packages/neutron/db/migration/alembic_migrations/env.py", line 100, in run_migrations_online
    context.run_migrations()
  File "<string>", line 7, in run_migrations
  File "/usr/lib/python2.7/dist-packages/alembic/environment.py", line 742, in run_migrations
    self.get_context().run_migrations(**kw)
  File "/usr/lib/python2.7/dist-packages/alembic/migration.py", line 296, in run_migrations
    for step in self._migrations_fn(heads, self):
  File "/usr/lib/python2.7/dist-packages/neutron/db/migration/cli.py", line 220, in check_sanity
    for script in script_dir.iterate_revisions(revision, rev):
  File "/usr/lib/python2.7/dist-packages/alembic/revision.py", line 580, in _iterate_revisions
    uppers = self.get_revisions(upper)
  File "/usr/lib/python2.7/dist-packages/alembic/revision.py", line 273, in get_revisions
    for rev_id in resolved_id)
  File "/usr/lib/python2.7/dist-packages/alembic/revision.py", line 273, in <genexpr>
    for rev_id in resolved_id)
  File "/usr/lib/python2.7/dist-packages/alembic/revision.py", line 326, in _revision_for_ident
    "No such revision or branch '%s'" % resolved_id)
alembic.revision.ResolutionError: No such revision or branch 'kilo'

'kilo'

So, we tried to take db sync command from Kilo devstack and when executed the below command command

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

neutron

it got upgraded for juno, but not for KILO.

Is that Kilo code is available for DB sync to populate the database? if so what is the command to execute?