Public bug reported:
./stack.sh
taget@liyong:/opt/stack/nova$ git log --oneline | head -n3
98af6b1 Merge "Deprecate Extensible Resource Tracker"
7c5acd4 Merge "Remove vcpu resource from extensible resource tracker"
b587881 Merge "Split up test_is_volume_backed_instance() into five functions"
taget@liyong:~/devstack$ /usr/local/bin/nova-manage api_db sync
No handlers could be found for logger "oslo_config.cfg"
2015-11-13 11:49:34.620 DEBUG migrate.versioning.repository [-] Loading
repository /opt/stack/nova/nova/db/sqlalchemy/api_migrations/migrate_repo...
from (pid=15818) __init__
/usr/local/lib/python2.7/dist-packages/migrate/versioning/repository.py:76
2015-11-13 11:49:34.621 DEBUG migrate.versioning.script.base [-] Loading script
/opt/stack/nova/nova/db/sqlalchemy/api_migrations/migrate_repo/versions/001_cell_mapping.py...
from (pid=15818) __init__
/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/base.py:27
2015-11-13 11:49:34.621 DEBUG migrate.versioning.script.base [-] Script
/opt/stack/nova/nova/db/sqlalchemy/api_migrations/migrate_repo/versions/001_cell_mapping.py
loaded successfully from (pid=15818) __init__
/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/base.py:30
2015-11-13 11:49:34.621 DEBUG migrate.versioning.script.base [-] Loading script
/opt/stack/nova/nova/db/sqlalchemy/api_migrations/migrate_repo/versions/002_instance_mapping.py...
from (pid=15818) __init__
/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/base.py:27
2015-11-13 11:49:34.622 DEBUG migrate.versioning.script.base [-] Script
/opt/stack/nova/nova/db/sqlalchemy/api_migrations/migrate_repo/versions/002_instance_mapping.py
loaded successfully from (pid=15818) __init__
/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/base.py:30
2015-11-13 11:49:34.622 DEBUG migrate.versioning.script.base [-] Loading script
/opt/stack/nova/nova/db/sqlalchemy/api_migrations/migrate_repo/versions/003_host_mapping.py...
from (pid=15818) __init__
/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/base.py:27
2015-11-13 11:49:34.622 DEBUG migrate.versioning.script.base [-] Script
/opt/stack/nova/nova/db/sqlalchemy/api_migrations/migrate_repo/versions/003_host_mapping.py
loaded successfully from (pid=15818) __init__
/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/base.py:30
2015-11-13 11:49:34.623 DEBUG migrate.versioning.repository [-] Repository
/opt/stack/nova/nova/db/sqlalchemy/api_migrations/migrate_repo loaded
successfully from (pid=15818) __init__
/usr/local/lib/python2.7/dist-packages/migrate/versioning/repository.py:82
2015-11-13 11:49:34.623 DEBUG migrate.versioning.repository [-] Config:
OrderedDict([('db_settings', OrderedDict([('__name__', 'db_settings'),
('repository_id', 'nova_api'), ('version_table', 'migrate_version'),
('required_dbs', '[]')]))]) from (pid=15818) __init__
/usr/local/lib/python2.7/dist-packages/migrate/versioning/repository.py:83
Command failed, please check log for more info
2015-11-13 11:49:34.624 CRITICAL nova [-] CantStartEngineError: No
sql_connection parameter is established
2015-11-13 11:49:34.624 TRACE nova Traceback (most recent call last):
2015-11-13 11:49:34.624 TRACE nova File "/usr/local/bin/nova-manage", line
10, in <module>
2015-11-13 11:49:34.624 TRACE nova sys.exit(main())
2015-11-13 11:49:34.624 TRACE nova File "/opt/stack/nova/nova/cmd/manage.py",
line 1425, in main
2015-11-13 11:49:34.624 TRACE nova ret = fn(*fn_args, **fn_kwargs)
2015-11-13 11:49:34.624 TRACE nova File "/opt/stack/nova/nova/cmd/manage.py",
line 976, in sync
2015-11-13 11:49:34.624 TRACE nova return migration.db_sync(version,
database='api')
2015-11-13 11:49:34.624 TRACE nova File
"/opt/stack/nova/nova/db/migration.py", line 26, in db_sync
2015-11-13 11:49:34.624 TRACE nova return IMPL.db_sync(version=version,
database=database)
2015-11-13 11:49:34.624 TRACE nova File
"/opt/stack/nova/nova/db/sqlalchemy/migration.py", line 53, in db_sync
2015-11-13 11:49:34.624 TRACE nova current_version = db_version(database)
2015-11-13 11:49:34.624 TRACE nova File
"/opt/stack/nova/nova/db/sqlalchemy/migration.py", line 66, in db_version
2015-11-13 11:49:34.624 TRACE nova return
versioning_api.db_version(get_engine(database), repository)
2015-11-13 11:49:34.624 TRACE nova File
"/opt/stack/nova/nova/db/sqlalchemy/migration.py", line 43, in get_engine
2015-11-13 11:49:34.624 TRACE nova return db_session.get_api_engine()
2015-11-13 11:49:34.624 TRACE nova File
"/opt/stack/nova/nova/db/sqlalchemy/api.py", line 167, in get_api_engine
2015-11-13 11:49:34.624 TRACE nova return
api_context_manager._factory.get_legacy_facade().get_engine()
2015-11-13 11:49:34.624 TRACE nova File
"/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py",
line 256, in get_legacy_facade
2015-11-13 11:49:34.624 TRACE nova self._start()
2015-11-13 11:49:34.624 TRACE nova File
"/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py",
line 338, in _start
2015-11-13 11:49:34.624 TRACE nova engine_args, maker_args)
2015-11-13 11:49:34.624 TRACE nova File
"/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py",
line 360, in _setup_for_connection
2015-11-13 11:49:34.624 TRACE nova "No sql_connection parameter is
established")
2015-11-13 11:49:34.624 TRACE nova CantStartEngineError: No sql_connection
parameter is established
** Affects: nova
Importance: Critical
Status: New
** Changed in: nova
Importance: Undecided => Critical
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1515860
Title:
No sql_connection parameter is established when nova-manage api_db
sync
Status in OpenStack Compute (nova):
New
Bug description:
./stack.sh
taget@liyong:/opt/stack/nova$ git log --oneline | head -n3
98af6b1 Merge "Deprecate Extensible Resource Tracker"
7c5acd4 Merge "Remove vcpu resource from extensible resource tracker"
b587881 Merge "Split up test_is_volume_backed_instance() into five functions"
taget@liyong:~/devstack$ /usr/local/bin/nova-manage api_db sync
No handlers could be found for logger "oslo_config.cfg"
2015-11-13 11:49:34.620 DEBUG migrate.versioning.repository [-] Loading
repository /opt/stack/nova/nova/db/sqlalchemy/api_migrations/migrate_repo...
from (pid=15818) __init__
/usr/local/lib/python2.7/dist-packages/migrate/versioning/repository.py:76
2015-11-13 11:49:34.621 DEBUG migrate.versioning.script.base [-] Loading
script
/opt/stack/nova/nova/db/sqlalchemy/api_migrations/migrate_repo/versions/001_cell_mapping.py...
from (pid=15818) __init__
/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/base.py:27
2015-11-13 11:49:34.621 DEBUG migrate.versioning.script.base [-] Script
/opt/stack/nova/nova/db/sqlalchemy/api_migrations/migrate_repo/versions/001_cell_mapping.py
loaded successfully from (pid=15818) __init__
/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/base.py:30
2015-11-13 11:49:34.621 DEBUG migrate.versioning.script.base [-] Loading
script
/opt/stack/nova/nova/db/sqlalchemy/api_migrations/migrate_repo/versions/002_instance_mapping.py...
from (pid=15818) __init__
/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/base.py:27
2015-11-13 11:49:34.622 DEBUG migrate.versioning.script.base [-] Script
/opt/stack/nova/nova/db/sqlalchemy/api_migrations/migrate_repo/versions/002_instance_mapping.py
loaded successfully from (pid=15818) __init__
/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/base.py:30
2015-11-13 11:49:34.622 DEBUG migrate.versioning.script.base [-] Loading
script
/opt/stack/nova/nova/db/sqlalchemy/api_migrations/migrate_repo/versions/003_host_mapping.py...
from (pid=15818) __init__
/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/base.py:27
2015-11-13 11:49:34.622 DEBUG migrate.versioning.script.base [-] Script
/opt/stack/nova/nova/db/sqlalchemy/api_migrations/migrate_repo/versions/003_host_mapping.py
loaded successfully from (pid=15818) __init__
/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/base.py:30
2015-11-13 11:49:34.623 DEBUG migrate.versioning.repository [-] Repository
/opt/stack/nova/nova/db/sqlalchemy/api_migrations/migrate_repo loaded
successfully from (pid=15818) __init__
/usr/local/lib/python2.7/dist-packages/migrate/versioning/repository.py:82
2015-11-13 11:49:34.623 DEBUG migrate.versioning.repository [-] Config:
OrderedDict([('db_settings', OrderedDict([('__name__', 'db_settings'),
('repository_id', 'nova_api'), ('version_table', 'migrate_version'),
('required_dbs', '[]')]))]) from (pid=15818) __init__
/usr/local/lib/python2.7/dist-packages/migrate/versioning/repository.py:83
Command failed, please check log for more info
2015-11-13 11:49:34.624 CRITICAL nova [-] CantStartEngineError: No
sql_connection parameter is established
2015-11-13 11:49:34.624 TRACE nova Traceback (most recent call last):
2015-11-13 11:49:34.624 TRACE nova File "/usr/local/bin/nova-manage", line
10, in <module>
2015-11-13 11:49:34.624 TRACE nova sys.exit(main())
2015-11-13 11:49:34.624 TRACE nova File
"/opt/stack/nova/nova/cmd/manage.py", line 1425, in main
2015-11-13 11:49:34.624 TRACE nova ret = fn(*fn_args, **fn_kwargs)
2015-11-13 11:49:34.624 TRACE nova File
"/opt/stack/nova/nova/cmd/manage.py", line 976, in sync
2015-11-13 11:49:34.624 TRACE nova return migration.db_sync(version,
database='api')
2015-11-13 11:49:34.624 TRACE nova File
"/opt/stack/nova/nova/db/migration.py", line 26, in db_sync
2015-11-13 11:49:34.624 TRACE nova return IMPL.db_sync(version=version,
database=database)
2015-11-13 11:49:34.624 TRACE nova File
"/opt/stack/nova/nova/db/sqlalchemy/migration.py", line 53, in db_sync
2015-11-13 11:49:34.624 TRACE nova current_version = db_version(database)
2015-11-13 11:49:34.624 TRACE nova File
"/opt/stack/nova/nova/db/sqlalchemy/migration.py", line 66, in db_version
2015-11-13 11:49:34.624 TRACE nova return
versioning_api.db_version(get_engine(database), repository)
2015-11-13 11:49:34.624 TRACE nova File
"/opt/stack/nova/nova/db/sqlalchemy/migration.py", line 43, in get_engine
2015-11-13 11:49:34.624 TRACE nova return db_session.get_api_engine()
2015-11-13 11:49:34.624 TRACE nova File
"/opt/stack/nova/nova/db/sqlalchemy/api.py", line 167, in get_api_engine
2015-11-13 11:49:34.624 TRACE nova return
api_context_manager._factory.get_legacy_facade().get_engine()
2015-11-13 11:49:34.624 TRACE nova File
"/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py",
line 256, in get_legacy_facade
2015-11-13 11:49:34.624 TRACE nova self._start()
2015-11-13 11:49:34.624 TRACE nova File
"/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py",
line 338, in _start
2015-11-13 11:49:34.624 TRACE nova engine_args, maker_args)
2015-11-13 11:49:34.624 TRACE nova File
"/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py",
line 360, in _setup_for_connection
2015-11-13 11:49:34.624 TRACE nova "No sql_connection parameter is
established")
2015-11-13 11:49:34.624 TRACE nova CantStartEngineError: No sql_connection
parameter is established
To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1515860/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
