devstack, while running stack.sh with nova cells enabled mysql database error: Unknown database 'nova_cell'

[Bhargava]

2015-07-28 09:45:33.390 | 2015-07-28 15:15:33.389 30577 CRITICAL nova [-] OperationalError: (OperationalError) (1049, "Unknown database 'nova_cell'") None None
2015-07-28 09:45:33.391 | 2015-07-28 15:15:33.389 30577 TRACE nova Traceback (most recent call last):
2015-07-28 09:45:33.391 | 2015-07-28 15:15:33.389 30577 TRACE nova File "/usr/local/bin/nova-manage", line 10, in <module>
2015-07-28 09:45:33.391 | 2015-07-28 15:15:33.389 30577 TRACE nova sys.exit(main())
2015-07-28 09:45:33.391 | 2015-07-28 15:15:33.389 30577 TRACE nova File "/opt/stack/nova/nova/cmd/manage.py", line 1401, in main
2015-07-28 09:45:33.391 | 2015-07-28 15:15:33.389 30577 TRACE nova ret = fn(*fn_args, **fn_kwargs)
2015-07-28 09:45:33.391 | 2015-07-28 15:15:33.389 30577 TRACE nova File "/opt/stack/nova/nova/cmd/manage.py", line 902, in sync
2015-07-28 09:45:33.391 | 2015-07-28 15:15:33.389 30577 TRACE nova return migration.db_sync(version)
2015-07-28 09:45:33.391 | 2015-07-28 15:15:33.389 30577 TRACE nova File "/opt/stack/nova/nova/db/migration.py", line 29, in db_sync
2015-07-28 09:45:33.391 | 2015-07-28 15:15:33.389 30577 TRACE nova return IMPL.db_sync(version=version)
2015-07-28 09:45:33.391 | 2015-07-28 15:15:33.389 30577 TRACE nova File "/opt/stack/nova/nova/db/sqlalchemy/migration.py", line 41, in db_sync
2015-07-28 09:45:33.391 | 2015-07-28 15:15:33.389 30577 TRACE nova current_version = db_version()
2015-07-28 09:45:33.391 | 2015-07-28 15:15:33.389 30577 TRACE nova File "/opt/stack/nova/nova/db/sqlalchemy/migration.py", line 53, in db_version
2015-07-28 09:45:33.391 | 2015-07-28 15:15:33.389 30577 TRACE nova return versioning_api.db_version(get_engine(), repository)
2015-07-28 09:45:33.391 | 2015-07-28 15:15:33.389 30577 TRACE nova File "/opt/stack/nova/nova/db/sqlalchemy/api.py", line 96, in get_engine
2015-07-28 09:45:33.391 | 2015-07-28 15:15:33.389 30577 TRACE nova facade = _create_facade_lazily()
2015-07-28 09:45:33.391 | 2015-07-28 15:15:33.389 30577 TRACE nova File "/opt/stack/nova/nova/db/sqlalchemy/api.py", line 91, in _create_facade_lazily
2015-07-28 09:45:33.392 | 2015-07-28 15:15:33.389 30577 TRACE nova _ENGINE_FACADE = db_session.EngineFacade.from_config(CONF)
2015-07-28 09:45:33.392 | 2015-07-28 15:15:33.389 30577 TRACE nova File "/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/session.py", line 816, in from_config
2015-07-28 09:45:33.392 | 2015-07-28 15:15:33.389 30577 TRACE nova retry_interval=conf.database.retry_interval)
2015-07-28 09:45:33.392 | 2015-07-28 15:15:33.389 30577 TRACE nova File "/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/session.py", line 732, in __init__
2015-07-28 09:45:33.392 | 2015-07-28 15:15:33.389 30577 TRACE nova **engine_kwargs)
2015-07-28 09:45:33.392 | 2015-07-28 15:15:33.389 30577 TRACE nova File "/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/session.py", line 409, in create_engine
2015-07-28 09:45:33.392 | 2015-07-28 15:15:33.389 30577 TRACE nova _test_connection(engine, max_retries, retry_interval)
2015-07-28 09:45:33.392 | 2015-07-28 15:15:33.389 30577 TRACE nova File "/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/session.py", line 549, in _test_connection
2015-07-28 09:45:33.392 | 2015-07-28 15:15:33.389 30577 TRACE nova return exc_filters.handle_connect_error(engine)
2015-07-28 09:45:33.392 | 2015-07-28 15:15:33.389 30577 TRACE nova File "/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/exc_filters.py", line 351, in handle_connect_error
2015-07-28 09:45:33.392 | 2015-07-28 15:15:33.389 30577 TRACE nova handler(ctx)
2015-07-28 09:45:33.392 | 2015-07-28 15:15:33.389 30577 TRACE nova File "/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/exc_filters.py", line 323, in handler
2015-07-28 09:45:33.392 | 2015-07-28 15:15:33.389 30577 TRACE nova context.is_disconnect)
2015-07-28 09:45:33.392 | 2015-07-28 15:15:33.389 30577 TRACE nova File "/usr/local/lib/python2.7/dist-packages/oslo/db/sqlalchemy/exc_filters.py", line 254, in _raise_operational_errors_directly_filter
2015-07-28 09:45:33.392 | 2015-07-28 15:15:33.389 30577 TRACE nova raise operational_error
2015-07-28 09:45:33.392 | 2015-07-28 15:15:33.389 30577 TRACE nova OperationalError: (OperationalError) (1049, "Unknown database 'nova_cell'") None None
2015-07-28 09:45:33.393 | 2015-07-28 15:15:33.389 30577 TRACE nova
2015-07-28 09:45:33.439 | Command failed, please check log for more info
2015-07-28 09:45:33.443 | + exit_trap
2015-07-28 09:45:33.443 | + local r=1
2015-07-28 09:45:33.443 | ++ jobs -p
2015-07-28 09:45:33.444 | + jobs=
2015-07-28 09:45:33.445 | + [[ -n '' ]]
2015-07-28 09:45:33.445 | + kill_spinner
2015-07-28 09:45:33.445 | + '[' '!' -z '' ']'
2015-07-28 09:45:33.445 | + [[ 1 -ne 0 ]]
2015-07-28 09:45:33.445 | + echo 'Error on exit'
2015-07-28 09:45:33.445 | Error on exit
2015-07-28 09:45:33.445 | + [[ -z /opt/stack/logs ]]
2015-07-28 09:45:33.445 | + /home/opexlabs/devstack/tools/worlddump.py -d /opt/stack/logs
2015-07-28 09:45:33.473 | + exit 1

[Hanxi Liu (hanxi-liu)]

/usr/bin/nova-manage --config-file /etc/nova/nova-cells.conf db sync

An error has occurred:
Traceback (most recent call last):
  File "/opt/stack/nova/nova/cmd/manage.py", line 1602, in main
    ret = fn(*fn_args, **fn_kwargs)
  File "/opt/stack/nova/nova/cmd/manage.py", line 645, in sync
    return migration.db_sync(version)
  File "/opt/stack/nova/nova/db/migration.py", line 26, in db_sync
    return IMPL.db_sync(version=version, database=database, context=context)
  File "/opt/stack/nova/nova/db/sqlalchemy/migration.py", line 53, in db_sync
    current_version = db_version(database, context=context)
  File "/opt/stack/nova/nova/db/sqlalchemy/migration.py", line 66, in db_version
    return versioning_api.db_version(get_engine(database, context=context),
  File "/opt/stack/nova/nova/db/sqlalchemy/migration.py", line 41, in get_engine
    return db_session.get_engine(context=context)
  File "/opt/stack/nova/nova/db/sqlalchemy/api.py", line 149, in get_engine
    return ctxt_mgr.get_legacy_facade().get_engine(use_slave=use_slave)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 707, in get_legacy_facade
    return self._factory.get_legacy_facade()
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 261, in get_legacy_facade
    self._start()
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 403, in _start
    engine_args, maker_args)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 427, in _setup_for_connection
    sql_connection=sql_connection, **engine_kwargs)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 155, in create_engine
    test_conn = _test_connection(engine, max_retries, retry_interval)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 331, in _test_connection
    return engine.connect()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2018, in connect
    return self._connection_cls(self, **kwargs)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 72, in __init__
    if connection is not None else engine.raw_connection()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2104, in raw_connection
    self.pool.unique_connection, _connection)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2078, in _wrap_pool_connect
    e, dialect, self)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1401, in _handle_dbapi_exception_noconnection
    util.raise_from_cause(newraise, exc_info)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect
    return fn()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 318, in unique_connection
    return _ConnectionFairy._checkout(self)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 713, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  Fi...

[Sean Dague (sdague)]

No reviews found in this bug, unassigning. Please add a comment with active reviews before assigning an individual, or tag the bug in the gerrit review, which will do that automatically

[Hanxi Liu (hanxi-liu)]

not clear why this has no tag automatically. but the patch has been really proposed.
https://review.openstack.org/#/c/470598/

[Sean Dague (sdague)]

There are no currently open reviews on this bug, changing the status back to the previous state and unassigning. If there are active reviews related to this bug, please include links in comments.

[OpenStack Infra (hudson-openstack)]

Change abandoned by Hanxi Liu (<email address hidden>) on branch: master
Review: https://review.openstack.org/470598

[Dr. Jens Harbott (j-harbott)]

No review in progress. Given the age of the bug report, it is unclear whether this is still a valid issue. Please update with fresh logs if this issue still persists.

[Launchpad Janitor (janitor)]

[Expired for devstack because there has been no activity for 60 days.]