undercloud ironic dbsync failed

[Haiwei Xu]

Deploy baremetal environment with devtest, found an error in os-collect-config.log in undercloud:

Oct 27 02:23:57 undercloud-undercloud-vozb7mkenamm os-collect-config: + sudo -u ironic -- ironic-dbsync --config-file /etc/ironic/ironic.conf
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: CRITI [ironic] ArgumentError: Could not parse rfc1738 URL from string ''
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: Traceback (most recent call last):
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: File "/usr/local/bin/ironic-dbsync", line 10, in <module>
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: sys.exit(main())
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: File "/opt/stack/venvs/openstack/local/lib/python2.7/site-packages/ironic/cmd/dbsync.py", line 100, in main
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: CONF.command.func()
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: File "/opt/stack/venvs/openstack/local/lib/python2.7/site-packages/ironic/cmd/dbsync.py", line 36, in upgrade
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: migration.upgrade(CONF.command.revision)
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: File "/opt/stack/venvs/openstack/local/lib/python2.7/site-packages/ironic/db/migration.py", line 36, in upgrade
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: return get_backend().upgrade(version)
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: File "/opt/stack/venvs/openstack/local/lib/python2.7/site-packages/ironic/db/sqlalchemy/migration.py", line 56, in upgrade
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: alembic.command.upgrade(config, revision or 'head')
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: File "/opt/stack/venvs/openstack/local/lib/python2.7/site-packages/alembic/command.py", line 129, in upgrade
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: script.run_env()
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: File "/opt/stack/venvs/openstack/local/lib/python2.7/site-packages/alembic/script.py", line 208, in run_env
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: util.load_python_file(self.dir, 'env.py')
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: File "/opt/stack/venvs/openstack/local/lib/python2.7/site-packages/alembic/util.py", line 230, in load_python_file
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: module = load_module_py(module_id, path)
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: File "/opt/stack/venvs/openstack/local/lib/python2.7/site-packages/alembic/compat.py", line 63, in load_module_py
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: mod = imp.load_source(module_id, path, fp)
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: File "/opt/stack/venvs/openstack/local/lib/python2.7/site-packages/ironic/db/sqlalchemy/alembic/env.py", line 54, in <module>
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: run_migrations_online()
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: File "/opt/stack/venvs/openstack/local/lib/python2.7/site-packages/ironic/db/sqlalchemy/alembic/env.py", line 46, in run_migrations_online
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: engine = sqla_api.get_engine()
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: File "/opt/stack/venvs/openstack/local/lib/python2.7/site-packages/ironic/db/sqlalchemy/api.py", line 56, in get_engine
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: facade = _create_facade_lazily()
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: File "/opt/stack/venvs/openstack/local/lib/python2.7/site-packages/ironic/db/sqlalchemy/api.py", line 51, in _create_facade_lazily
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: _FACADE = db_session.EngineFacade.from_config(CONF)
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: File "/opt/stack/venvs/openstack/local/lib/python2.7/site-packages/oslo/db/sqlalchemy/session.py", line 795, in from_config
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: retry_interval=conf.database.retry_interval)
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: File "/opt/stack/venvs/openstack/local/lib/python2.7/site-packages/oslo/db/sqlalchemy/session.py", line 711, in __init__
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: **engine_kwargs)
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: File "/opt/stack/venvs/openstack/local/lib/python2.7/site-packages/oslo/db/sqlalchemy/session.py", line 361, in create_engine
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: url = sqlalchemy.engine.url.make_url(sql_connection)
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: File "/opt/stack/venvs/openstack/local/lib/python2.7/site-packages/sqlalchemy/engine/url.py", line 164, in make_url
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: return _parse_rfc1738_args(name_or_url)
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: File "/opt/stack/venvs/openstack/local/lib/python2.7/site-packages/sqlalchemy/engine/url.py", line 213, in _parse_rfc1738_args
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: "Could not parse rfc1738 URL from string '%s'" % name)
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: ArgumentError: Could not parse rfc1738 URL from string ''
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: [2014-10-27 02:23:59,208] (os-refresh-config) [ERROR] during configure phase. [Command '['dib-run-parts', '/opt/stack/os-config-refresh/configure.d']' returned non-zero exit status 1]
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config:
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: ERROR:os-refresh-config:during configure phase. [Command '['dib-run-parts', '/opt/stack/os-config-refresh/configure.d']' returned non-zero exit status 1]
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config:
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: [2014-10-27 02:23:59,209] (os-refresh-config) [ERROR] Aborting...
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: ERROR:os-refresh-config:Aborting...
Oct 27 02:23:59 undercloud-undercloud-vozb7mkenamm os-collect-config: 2014-10-27 02:23:59.214 1603 ERROR os-collect-config [-] Command failed, will not cache new data. Command 'os-refresh-config' returned non-zero exit status

[Haiwei Xu (xu-haiwei)]

The database connection URL is not configured.

[database]
connection=

[Haiwei Xu (xu-haiwei)]

The reason why "connection" is blank is that there is no 'ironic' resource in the heat template, so undercloud-bm.yaml is not suitable for baremetal environment when using ironic.