yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1515860] Re: No sql_connection parameter is established when nova-manage api_db sync

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Eli Qiao <liyong.qiao@xxxxxxxxx>
Date: Fri, 13 Nov 2015 06:45:10 -0000
Reply-to: Bug 1515860 <1515860@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
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.

** Changed in: nova
       Status: New => Invalid

-- 
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):
  Invalid

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
References

[Bug 1515860] [NEW] No sql_connection parameter is established when nova-manage api_db sync
From: Eli Qiao, 2015-11-13