yahoo-eng-team team mailing list archive

[Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>]

** Changed in: neutron
       Status: Fix Committed => Fix Released

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

Title:
  db migration fails for linuxbridge

Status in OpenStack Neutron (virtual network service):
  Fix Released

Bug description:
  The
  neutron/db/migration/alembic_migrations/versions/1c33fa3cd1a1_extra_route_config.py
  is failing for linuxbridge, below the whole log:

  mysql -uroot -pnova -hlocalhost -e 'CREATE DATABASE neutron_linux_bridge CHARACTER SET utf8;'
  + /usr/local/bin/neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugins/linuxbridge/linuxbridge_conf.ini upgrade head
  No handlers could be found for logger "neutron.common.legacy"
  INFO  [alembic.migration] Context impl MySQLImpl.
  INFO  [alembic.migration] Will assume non-transactional DDL.
  INFO  [alembic.migration] Running upgrade None -> folsom, folsom initial database
  INFO  [alembic.migration] Running upgrade folsom -> 2c4af419145b, l3_support
  INFO  [alembic.migration] Running upgrade 2c4af419145b -> 5a875d0e5c, ryu
  INFO  [alembic.migration] Running upgrade 5a875d0e5c -> 48b6f43f7471, DB support for service types
  INFO  [alembic.migration] Running upgrade 48b6f43f7471 -> 3cb5d900c5de, security_groups
  INFO  [alembic.migration] Running upgrade 3cb5d900c5de -> 1d76643bcec4, nvp_netbinding
  INFO  [alembic.migration] Running upgrade 1d76643bcec4 -> 2a6d0b51f4bb, cisco plugin cleanup
  INFO  [alembic.migration] Running upgrade 2a6d0b51f4bb -> 1b693c095aa3, Quota ext support added in Grizzly
  INFO  [alembic.migration] Running upgrade 1b693c095aa3 -> 1149d7de0cfa, inital port security
  INFO  [alembic.migration] Running upgrade 1149d7de0cfa -> 49332180ca96, ryu plugin update
  INFO  [alembic.migration] Running upgrade 49332180ca96 -> 38335592a0dc, nvp_portmap
  INFO  [alembic.migration] Running upgrade 38335592a0dc -> 54c2c487e913, 'DB support for load balancing service
  INFO  [alembic.migration] Running upgrade 54c2c487e913 -> 45680af419f9, nvp_qos
  INFO  [alembic.migration] Running upgrade 45680af419f9 -> 1c33fa3cd1a1, Support routring table configration on Router
  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 140, in main
      CONF.command.func(config, CONF.command.name)
    File "/opt/stack/neutron/neutron/db/migration/cli.py", line 77, in do_upgrade_downgrade
      do_alembic_command(config, cmd, revision, sql=CONF.command.sql)
    File "/opt/stack/neutron/neutron/db/migration/cli.py", line 56, in do_alembic_command
      getattr(alembic_command, cmd)(config, *args, **kwargs)
    File "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 124, in upgrade
      script.run_env()
    File "/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 193, in run_env
      util.load_python_file(self.dir, 'env.py')
    File "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 177, in load_python_file
      module = load_module(module_id, path)
    File "/usr/local/lib/python2.7/dist-packages/alembic/compat.py", line 39, in load_module
      return imp.load_source(module_id, path, fp)
    File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", line 102, in <module>
      run_migrations_online()
    File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", line 86, in run_migrations_online
  disable_service n-net
      options=build_options())
    File "<string>", line 7, in run_migrations
    File "/usr/local/lib/python2.7/dist-packages/alembic/environment.py", line 652, in run_migrations
      self.get_context().run_migrations(**kw)
    File "/usr/local/lib/python2.7/dist-packages/alembic/migration.py", line 224, in run_migrations
      change(**kw)
    File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/versions/1c33fa3cd1a1_extra_route_config.py", line 62, in upgrade
      sa.PrimaryKeyConstraint('destination', 'nexthop', 'router_id')
    File "<string>", line 7, in create_table
    File "/usr/local/lib/python2.7/dist-packages/alembic/operations.py", line 631, in create_table
      self._table(name, *columns, **kw)
    File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 149, in create_table
      self._exec(schema.CreateTable(table))
    File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 76, in _exec
      conn.execute(construct, *multiparams, **params)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute
      params)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1542, in _execute_ddl
      compiled
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
      context)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
      context)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute
      cursor.execute(statement, parameters)
    File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
      self.errorhandler(self, exc, value)
    File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
      raise errorclass, errorvalue
  sqlalchemy.exc.OperationalError: (OperationalError) (1005, "Can't create table 'neutron_linux_bridge.routerroutes' (errno: 150)") '\nCREATE TABLE routerroutes (\n\tdestination VARCHAR(64) NOT NULL, \n\tnexthop VARCHAR(64) NOT NULL, \n\trouter_id VARCHAR(36) NOT NULL, \n\tPRIMARY KEY (destination, nexthop, router_id), \n\tFOREIGN KEY(router_id) REFERENCES routers (id) ON DELETE CASCADE\n)\n\n' ()

  I tried with OVS plugin and the problem is not there.

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