focal-xena test run results in no valid host found

[Corey Bryant]

focal-xena function test run results in errored zaza-nova-cirros server launch due to no valid host found.

ubuntu@coreycb-bastion:~/charms/focal/charm-nova-cell-controller$ openstack server list +--------------------------------------+------------------+--------+----------+--------+---------+ | ID | Name | Status | Networks | Image | Flavor |
+--------------------------------------+------------------+--------+----------+--------+---------+
| 86f0d047-5a6e-4273-9027-9acea866b703 | zaza-nova-cirros | ERROR | | cirros | m1.tiny |
+--------------------------------------+------------------+--------+----------+--------+---------+

ubuntu@coreycb-bastion:~/charms/focal/charm-nova-cell-controller$ openstack flavor list
+----+------------+------+------+-----------+-------+-----------+
| ID | Name | RAM | Disk | Ephemeral | VCPUs | Is Public |
+----+------------+------+------+-----------+-------+-----------+
| 1 | m1.tiny | 512 | 1 | 0 | 1 | True |

There appears to be enough resources available on the compute host.

ubuntu@coreycb-bastion:~/charms/focal/charm-nova-cell-controller$ juju ssh nova-compute-cell2/0

ubuntu@juju-e9c947-zaza-9a537bd2bebf-12:~$ df -h /
Filesystem Size Used Avail Use% Mounted on
/dev/vda1 39G 2.7G 36G 7% /

ubuntu@juju-e9c947-zaza-9a537bd2bebf-12:~$ free -m
              total used free shared buff/cache available
Mem: 3936 614 1140 1 2180 3031
Swap: 0 0 0

ubuntu@juju-e9c947-zaza-9a537bd2bebf-12:~$ cat /proc/cpuinfo |grep processor
processor : 0
processor : 1

/var/log/nova/nova-conductor.log on nova-cell-controller-cell2/0 has a DB error that may be related:

2021-11-22 19:09:45.188 33746 ERROR nova sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'nova.cell_mappings' doesn't exist")
2021-11-22 19:09:45.188 33746 ERROR nova [SQL: SELECT cell_mappings.created_at AS cell_mappings_created_at, cell_mappings.updated_at AS cell_mappings_updated_at, cell_mappings.id AS cell_mappings_id, cell_mappings.uuid AS cell_mappings_uuid, cell_mappings.name AS cell_mappings_name, cell_mappings.transport_url AS cell_mappings_transport_url, cell_mappings.database_connection AS cell_mappings_database_connection, cell_mappings.disabled AS cell_mappings_disabled

[Marcin Wilk (wilkmarcin)]

impish-xena test is also affected by this problem

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.opendev.org/c/openstack/charm-nova-cell-controller/+/830520

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/charm-nova-cell-controller/+/830520
Committed: https://opendev.org/openstack/charm-nova-cell-controller/commit/f70e186285b17ad5363af2dfe0014504af1c958d
Submitter: "Zuul (22348)"
Branch: master

commit f70e186285b17ad5363af2dfe0014504af1c958d
Author: Corey Bryant <email address hidden>
Date: Tue Feb 22 20:50:41 2022 +0000

    Use [database]/connection in templates

    nova-manage uses the [database]/connection to determine the
    database connection. This change updates the nova.conf
    template to use the parts/section-database template,
    switching away from using [DEFAULT]/sql_connection to use
    [database]/connection instead.

    [DEFAULT/sql_connection has been deprecated since at least
    mitaka:
    https://docs.openstack.org/nova/mitaka/sample_config.html

    This change also re-enables the gate tests for Xena.

    Closes-Bug: #1951874
    Change-Id: I9d77b44ad3c40f3ee60fedc3f211f3ac085fcbb2