Task fail with ' File \"/usr/lib6
4/python2.7/site-packages/sqlalchemy/engine/url.py\", line 235, in _parse_rfc1738_args", " \"Could not parse rfc1738 URL from string '%s'\" % name)", "Argument Error: Could not parse rfc1738 URL from string 'nil'"]}'
Expected results:
To get past this step and complete the ffwd upgrade
Additional info:
we can get the same error message when running:
nova-manage cell_v2 discover_hosts --verbose
seems linked to nova_api.cell_mappings that returns 'nil' for the database_url
| 2020-05-05 03:20:26 | NULL | 4 | 00000000-0000-0000-0000-000000000000 | cell0 | none:/// | mysql+pymysql://nova:zkXkf74ENtad7rTwJTt7QBqDj@10.0.0.10/nova_cell0?read_default_group=tripleo&read_default_file=/etc/my.cnf.d/tripleo.cnf |
| 2020-05-05 03:20:31 | NULL | 7 | d6405273-156b-4a78-a87f-ef5bad138a27 | default | rabbit://guest:<email address hidden>:5672,guest:<email address hidden>:5672,guest:<email address hidden>:5672/?ssl=0 | nil
The error output:
TASK [Setup cell_v2 (migrate hosts)] *******************************************
Tuesday 05 May 2020 16:06:27 -0700 (0:00:04.940) 0:22:22.200 ***********
fatal: [overcloud-controller-0]: FAILED! => {"changed": true, "cmd": ["nova-manage", "cell_v2", "discover_hosts", "--cell_uuid", "d6405273-156b-4a78-a87f-ef5bad13
8a27", "--verbose"], "delta": "0:00:04.334594", "end": "2020-05-05 16:06:32.474565", "msg": "non-zero return code", "rc": 1, "start": "2020-05-05 16:06:28.139971"
, "stderr": "Option \"rabbit_use_ssl\" from group \"oslo_messaging_rabbit\" is deprecated. Use option \"ssl\" from group \"oslo_messaging_rabbit\".\nOption \"noti
fication_format\" from group \"DEFAULT\" is deprecated. Use option \"notification_format\" from group \"notifications\".", "stderr_lines": ["Option \"rabbit_use_s
sl\" from group \"oslo_messaging_rabbit\" is deprecated. Use option \"ssl\" from group \"oslo_messaging_rabbit\".", "Option \"notification_format\" from group \"D
EFAULT\" is deprecated. Use option \"notification_format\" from group \"notifications\"."], "stdout": "Getting computes from cell 'default': d6405273-156b-4a78-a8
7f-ef5bad138a27\nAn error has occurred:\nTraceback (most recent call last):\n File \"/usr/lib/python2.7/site-packages/nova/cmd/manage.py\", line 2101, in main\n
ret = fn(*fn_args, **fn_kwargs)\n File \"/usr/lib/python2.7/site-packages/nova/cmd/manage.py\", line 1501, in discover_hosts\n by_service)\n File \"/usr/l
ib/python2.7/site-packages/nova/objects/host_mapping.py\", line 265, in discover_hosts\n by_service)\n File \"/usr/lib/python2.7/site-packages/nova/objects/ho
st_mapping.py\", line 227, in _check_and_create_host_mappings\n ctxt, 1)\n File \"/usr/lib/python2.7/site-packages/oslo_versionedobjects/base.py\", line 184,
in wrapper\n result = fn(cls, context, *args, **kwargs)\n File \"/usr/lib/python2.7/site-packages/nova/objects/compute_node.py\", line 398, in get_all_by_not_
mapped\n context, mapped_less_than)\n File \"/usr/lib/python2.7/site-packages/nova/db/api.py\", line 273, in compute_node_get_all_mapped_less_than\n mapped
_less_than)\n File \"/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py\", line 254, in wrapped\n with ctxt_mgr.reader.using(context):\n File \"/usr/
lib64/python2.7/contextlib.py\", line 17, in __enter__\n return self.gen.next()\n File \"/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py\"
, line 1037, in _transaction_scope\n context=context) as resource:\n File \"/usr/lib64/python2.7/contextlib.py\", line 17, in __enter__\n return self.gen.n
ext()\n File \"/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py\", line 640, in _session\n bind=self.connection, mode=self.mode)\n File \"
/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py\", line 404, in _create_session\n self._start()\n File \"/usr/lib/python2.7/site-packages/
oslo_db/sqlalchemy/enginefacade.py\", line 491, in _start\n engine_args, maker_args)\n File \"/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade
.py\", line 515, in _setup_for_connection\n sql_connection=sql_connection, **engine_kwargs)\n File \"/usr/lib/python2.7/site-packages/debtcollector/renames.py
\", line 43, in decorator\n return wrapped(*args, **kwargs)\n File \"/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py\", line 138, in create_eng
ine\n url = sqlalchemy.engine.url.make_url(sql_connection)\n File \"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/url.py\", line 186, in make_url\n
return _parse_rfc1738_args(name_or_url)\n File \"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/url.py\", line 235, in _parse_rfc1738_args\n \"Could not
parse rfc1738 URL from string '%s'\" % name)\nArgumentError: Could not parse rfc1738 URL from string 'nil'", "stdout_lines": ["Getting computes from cell 'defaul
t': d6405273-156b-4a78-a87f-ef5bad138a27", "An error has occurred:", "Traceback (most recent call last):", " File \"/usr/lib/python2.7/site-packages/nova/cmd/man
age.py\", line 2101, in main", " ret = fn(*fn_args, **fn_kwargs)", " File \"/usr/lib/python2.7/site-packages/nova/cmd/manage.py\", line 1501, in discover_host
s", " by_service)", " File \"/usr/lib/python2.7/site-packages/nova/objects/host_mapping.py\", line 265, in discover_hosts", " by_service)", " File \"/usr/
lib/python2.7/site-packages/nova/objects/host_mapping.py\", line 227, in _check_and_create_host_mappings", " ctxt, 1)", " File \"/usr/lib/python2.7/site-packa
ges/oslo_versionedobjects/base.py\", line 184, in wrapper", " result = fn(cls, context, *args, **kwargs)", " File \"/usr/lib/python2.7/site-packages/nova/obje
cts/compute_node.py\", line 398, in get_all_by_not_mapped", " context, mapped_less_than)", " File \"/usr/lib/python2.7/site-packages/nova/db/api.py\", line 27
3, in compute_node_get_all_mapped_less_than", " mapped_less_than)", " File \"/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py\", line 254, in wrappe
d", " with ctxt_mgr.reader.using(context):", " File \"/usr/lib64/python2.7/contextlib.py\", line 17, in __enter__", " return self.gen.next()", " File \"/u
sr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py\", line 1037, in _transaction_scope", " context=context) as resource:", " File \"/usr/lib64/
python2.7/contextlib.py\", line 17, in __enter__", " return self.gen.next()", " File \"/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py\",
line 640, in _session", " bind=self.connection, mode=self.mode)", " File \"/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py\", line 404, in
_create_session", " self._start()", " File \"/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py\", line 491, in _start", " engine_args, m
aker_args)", " File \"/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py\", line 515, in _setup_for_connection", " sql_connection=sql_connect
ion, **engine_kwargs)", " File \"/usr/lib/python2.7/site-packages/debtcollector/renames.py\", line 43, in decorator", " return wrapped(*args, **kwargs)", " F
ile \"/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py\", line 138, in create_engine", " url = sqlalchemy.engine.url.make_url(sql_connection)", "
File \"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/url.py\", line 186, in make_url", " return _parse_rfc1738_args(name_or_url)", " File \"/usr/lib6
4/python2.7/site-packages/sqlalchemy/engine/url.py\", line 235, in _parse_rfc1738_args", " \"Could not parse rfc1738 URL from string '%s'\" % name)", "Argument
Error: Could not parse rfc1738 URL from string 'nil'"]}
Fix proposed to branch: stable/queens /review. opendev. org/734341
Review: https:/