yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1353180] [NEW] neutron-db-manage current/history/branches/stamp/revision is broken

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Ronak Shah <ronak.malav.shah@xxxxxxxxx>
Date: Wed, 06 Aug 2014 00:33:47 -0000
Reply-to: Bug 1353180 <1353180@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

In order to fix bug (https://bugs.launchpad.net/neutron/+bug/1288358)
following commit was made https://review.openstack.org/#/c/81334.

That has introduce a problem where neutron-db-manage does not work with some of the options.
For example:
root@openstack-ubuntu:/opt/stack/neutron# neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file <X> --config-file <Y> current
Traceback (most recent call last):
  File "/usr/local/bin/neutron-db-manage", line 10, in <module>
    sys.exit(main())
  File "/opt/stack/neutron/neutron/db/migration/cli.py", line 175, in main
    CONF.command.func(config, CONF.command.name)
  File "/opt/stack/neutron/neutron/db/migration/cli.py", line 63, in do_alembic_command
    getattr(alembic_command, cmd)(config, *args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 233, in current
    script.run_env()
  File "/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 203, in run_env
    util.load_python_file(self.dir, 'env.py')
  File "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 212, in load_python_file
    module = load_module_py(module_id, path)
  File "/usr/local/lib/python2.7/dist-packages/alembic/compat.py", line 58, in load_module_py
    mod = imp.load_source(module_id, path, fp)
  File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", line 125, in <module>
    run_migrations_online()
  File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", line 94, in run_migrations_online
    set_mysql_engine(neutron_config.command.mysql_engine)
  File "/usr/local/lib/python2.7/dist-packages/oslo/config/cfg.py", line 2344, in __getattr__
    raise NoSuchOptError(name)
oslo.config.cfg.NoSuchOptError: no such option: mysql_engine

root@openstack-ubuntu:/opt/stack/neutron# neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file <X> --config-file <Y> stamp icehouse
Traceback (most recent call last):
  File "/usr/local/bin/neutron-db-manage", line 10, in <module>
    sys.exit(main())
  File "/opt/stack/neutron/neutron/db/migration/cli.py", line 175, in main
    CONF.command.func(config, CONF.command.name)
  File "/opt/stack/neutron/neutron/db/migration/cli.py", line 91, in do_stamp
    sql=CONF.command.sql)
  File "/opt/stack/neutron/neutron/db/migration/cli.py", line 63, in do_alembic_command
    getattr(alembic_command, cmd)(config, *args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 258, in stamp
    script.run_env()
  File "/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 203, in run_env
    util.load_python_file(self.dir, 'env.py')
  File "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 212, in load_python_file
    module = load_module_py(module_id, path)
  File "/usr/local/lib/python2.7/dist-packages/alembic/compat.py", line 58, in load_module_py
    mod = imp.load_source(module_id, path, fp)
  File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", line 125, in <module>
    run_migrations_online()
  File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", line 94, in run_migrations_online
    set_mysql_engine(neutron_config.command.mysql_engine)
  File "/usr/local/lib/python2.7/dist-packages/oslo/config/cfg.py", line 2344, in __getattr__
    raise NoSuchOptError(name)
oslo.config.cfg.NoSuchOptError: no such option: mysql_engine

** Affects: neutron
     Importance: Undecided
         Status: New

** Description changed:

- In order to fix bug () following commit was made
- https://review.openstack.org/#/c/81334.
+ In order to fix bug (https://bugs.launchpad.net/neutron/+bug/1288358)
+ following commit was made https://review.openstack.org/#/c/81334.
  
  That has introduce a problem where neutron-db-manage does not work with some of the options.
  For example:
  root@openstack-ubuntu:/opt/stack/neutron# neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file <X> --config-file <Y> current
  Traceback (most recent call last):
-   File "/usr/local/bin/neutron-db-manage", line 10, in <module>
-     sys.exit(main())
-   File "/opt/stack/neutron/neutron/db/migration/cli.py", line 175, in main
-     CONF.command.func(config, CONF.command.name)
-   File "/opt/stack/neutron/neutron/db/migration/cli.py", line 63, in do_alembic_command
-     getattr(alembic_command, cmd)(config, *args, **kwargs)
-   File "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 233, in current
-     script.run_env()
-   File "/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 203, in run_env
-     util.load_python_file(self.dir, 'env.py')
-   File "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 212, in load_python_file
-     module = load_module_py(module_id, path)
-   File "/usr/local/lib/python2.7/dist-packages/alembic/compat.py", line 58, in load_module_py
-     mod = imp.load_source(module_id, path, fp)
-   File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", line 125, in <module>
-     run_migrations_online()
-   File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", line 94, in run_migrations_online
-     set_mysql_engine(neutron_config.command.mysql_engine)
-   File "/usr/local/lib/python2.7/dist-packages/oslo/config/cfg.py", line 2344, in __getattr__
-     raise NoSuchOptError(name)
+   File "/usr/local/bin/neutron-db-manage", line 10, in <module>
+     sys.exit(main())
+   File "/opt/stack/neutron/neutron/db/migration/cli.py", line 175, in main
+     CONF.command.func(config, CONF.command.name)
+   File "/opt/stack/neutron/neutron/db/migration/cli.py", line 63, in do_alembic_command
+     getattr(alembic_command, cmd)(config, *args, **kwargs)
+   File "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 233, in current
+     script.run_env()
+   File "/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 203, in run_env
+     util.load_python_file(self.dir, 'env.py')
+   File "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 212, in load_python_file
+     module = load_module_py(module_id, path)
+   File "/usr/local/lib/python2.7/dist-packages/alembic/compat.py", line 58, in load_module_py
+     mod = imp.load_source(module_id, path, fp)
+   File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", line 125, in <module>
+     run_migrations_online()
+   File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", line 94, in run_migrations_online
+     set_mysql_engine(neutron_config.command.mysql_engine)
+   File "/usr/local/lib/python2.7/dist-packages/oslo/config/cfg.py", line 2344, in __getattr__
+     raise NoSuchOptError(name)
  oslo.config.cfg.NoSuchOptError: no such option: mysql_engine
  
  root@openstack-ubuntu:/opt/stack/neutron# neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file <X> --config-file <Y> stamp icehouse
  Traceback (most recent call last):
-   File "/usr/local/bin/neutron-db-manage", line 10, in <module>
-     sys.exit(main())
-   File "/opt/stack/neutron/neutron/db/migration/cli.py", line 175, in main
-     CONF.command.func(config, CONF.command.name)
-   File "/opt/stack/neutron/neutron/db/migration/cli.py", line 91, in do_stamp
-     sql=CONF.command.sql)
-   File "/opt/stack/neutron/neutron/db/migration/cli.py", line 63, in do_alembic_command
-     getattr(alembic_command, cmd)(config, *args, **kwargs)
-   File "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 258, in stamp
-     script.run_env()
-   File "/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 203, in run_env
-     util.load_python_file(self.dir, 'env.py')
-   File "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 212, in load_python_file
-     module = load_module_py(module_id, path)
-   File "/usr/local/lib/python2.7/dist-packages/alembic/compat.py", line 58, in load_module_py
-     mod = imp.load_source(module_id, path, fp)
-   File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", line 125, in <module>
-     run_migrations_online()
-   File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", line 94, in run_migrations_online
-     set_mysql_engine(neutron_config.command.mysql_engine)
-   File "/usr/local/lib/python2.7/dist-packages/oslo/config/cfg.py", line 2344, in __getattr__
-     raise NoSuchOptError(name)
+   File "/usr/local/bin/neutron-db-manage", line 10, in <module>
+     sys.exit(main())
+   File "/opt/stack/neutron/neutron/db/migration/cli.py", line 175, in main
+     CONF.command.func(config, CONF.command.name)
+   File "/opt/stack/neutron/neutron/db/migration/cli.py", line 91, in do_stamp
+     sql=CONF.command.sql)
+   File "/opt/stack/neutron/neutron/db/migration/cli.py", line 63, in do_alembic_command
+     getattr(alembic_command, cmd)(config, *args, **kwargs)
+   File "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 258, in stamp
+     script.run_env()
+   File "/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 203, in run_env
+     util.load_python_file(self.dir, 'env.py')
+   File "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 212, in load_python_file
+     module = load_module_py(module_id, path)
+   File "/usr/local/lib/python2.7/dist-packages/alembic/compat.py", line 58, in load_module_py
+     mod = imp.load_source(module_id, path, fp)
+   File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", line 125, in <module>
+     run_migrations_online()
+   File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", line 94, in run_migrations_online
+     set_mysql_engine(neutron_config.command.mysql_engine)
+   File "/usr/local/lib/python2.7/dist-packages/oslo/config/cfg.py", line 2344, in __getattr__
+     raise NoSuchOptError(name)
  oslo.config.cfg.NoSuchOptError: no such option: mysql_engine

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1353180

Title:
  neutron-db-manage current/history/branches/stamp/revision is broken

Status in OpenStack Neutron (virtual network service):
  New

Bug description:
  In order to fix bug (https://bugs.launchpad.net/neutron/+bug/1288358)
  following commit was made https://review.openstack.org/#/c/81334.

  That has introduce a problem where neutron-db-manage does not work with some of the options.
  For example:
  root@openstack-ubuntu:/opt/stack/neutron# neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file <X> --config-file <Y> current
  Traceback (most recent call last):
    File "/usr/local/bin/neutron-db-manage", line 10, in <module>
      sys.exit(main())
    File "/opt/stack/neutron/neutron/db/migration/cli.py", line 175, in main
      CONF.command.func(config, CONF.command.name)
    File "/opt/stack/neutron/neutron/db/migration/cli.py", line 63, in do_alembic_command
      getattr(alembic_command, cmd)(config, *args, **kwargs)
    File "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 233, in current
      script.run_env()
    File "/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 203, in run_env
      util.load_python_file(self.dir, 'env.py')
    File "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 212, in load_python_file
      module = load_module_py(module_id, path)
    File "/usr/local/lib/python2.7/dist-packages/alembic/compat.py", line 58, in load_module_py
      mod = imp.load_source(module_id, path, fp)
    File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", line 125, in <module>
      run_migrations_online()
    File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", line 94, in run_migrations_online
      set_mysql_engine(neutron_config.command.mysql_engine)
    File "/usr/local/lib/python2.7/dist-packages/oslo/config/cfg.py", line 2344, in __getattr__
      raise NoSuchOptError(name)
  oslo.config.cfg.NoSuchOptError: no such option: mysql_engine

  root@openstack-ubuntu:/opt/stack/neutron# neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file <X> --config-file <Y> stamp icehouse
  Traceback (most recent call last):
    File "/usr/local/bin/neutron-db-manage", line 10, in <module>
      sys.exit(main())
    File "/opt/stack/neutron/neutron/db/migration/cli.py", line 175, in main
      CONF.command.func(config, CONF.command.name)
    File "/opt/stack/neutron/neutron/db/migration/cli.py", line 91, in do_stamp
      sql=CONF.command.sql)
    File "/opt/stack/neutron/neutron/db/migration/cli.py", line 63, in do_alembic_command
      getattr(alembic_command, cmd)(config, *args, **kwargs)
    File "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 258, in stamp
      script.run_env()
    File "/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 203, in run_env
      util.load_python_file(self.dir, 'env.py')
    File "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 212, in load_python_file
      module = load_module_py(module_id, path)
    File "/usr/local/lib/python2.7/dist-packages/alembic/compat.py", line 58, in load_module_py
      mod = imp.load_source(module_id, path, fp)
    File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", line 125, in <module>
      run_migrations_online()
    File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", line 94, in run_migrations_online
      set_mysql_engine(neutron_config.command.mysql_engine)
    File "/usr/local/lib/python2.7/dist-packages/oslo/config/cfg.py", line 2344, in __getattr__
      raise NoSuchOptError(name)
  oslo.config.cfg.NoSuchOptError: no such option: mysql_engine

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1353180/+subscriptions
Follow ups

[Bug 1353180] Re: neutron-db-manage current/history/branches/stamp/revision is broken
From: Thierry Carrez, 2014-09-04
[Bug 1353180] [NEW] neutron-db-manage current/history/branches/stamp/revision is broken
From: Ronak Shah, 2014-08-06
References

[Bug 1353180] [NEW] neutron-db-manage current/history/branches/stamp/revision is broken
From: Ronak Shah, 2014-08-06