No sql_connection parameter is established when nova-manage api_db sync

[Eli Qiao]

./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

[Eli Qiao (taget-9)]

taget@liyong:~/devstack$ pip list | grep oslo.db
oslo.db (3.1.0)

[Eli Qiao (taget-9)]

what a stupid,

nova will search ~/nova.conf , and I happened have an old nova.conf in ~/ so, /etc/nova/nova.conf will be ignored.