Open Stack

Hello everyone,

We have a strange situation regarding Availability Zones in our Openstack environment (version: Queens).


We have 3 AZs: room1, room2, and room3.

There are duplicate entries in the output of this command (openstack-pythonclient version 6.0.0):


➜ openstack availability zone list
+-----------+-------------+
| Zone Name | Zone Status |
+-----------+-------------+
| internal  | available   |
| room2     | available   |
| room1     | available   |
| room3     | available   |
| nova      | available   |
| room2     | available   |
| room3     | available   |
| room1     | available   |
| room2     | available   |
| room3     | available   |
+-----------+-------------+

However, in our database, I cannot find any reference to these duplicate entries.

What's going on here?

And how should we go about removing the duplicate entries if they don't show in the database?



MariaDB [nova_api]> select * from aggregate_metadata;
+---------------------+------------+----+--------------+-------------------+-----------------+
| created_at          | updated_at | id | aggregate_id | key               | value           |
+---------------------+------------+----+--------------+-------------------+-----------------+
| 2019-08-07 06:11:47 | NULL       |  1 |            1 | hypervisor        | standard        |
| 2019-08-07 06:22:39 | NULL       | 10 |           10 | availability_zone | room1           |
| 2019-08-07 06:22:43 | NULL       | 13 |           13 | availability_zone | room2           |
| 2019-08-15 11:31:39 | NULL       | 16 |           16 | availability_zone | room3           |
| 2019-09-11 07:50:22 | NULL       | 17 |           17 | hypervisor        | test            |
| 2021-08-06 08:43:28 | NULL       | 20 |           20 | hypervisor        | ephemeral_local |
+---------------------+------------+----+--------------+-------------------+-----------------+
6 rows in set (0.00 sec)

MariaDB [nova_api]> select * from aggregates;
+---------------------+------------+----+--------------------------------------+------------------+
| created_at          | updated_at | id | uuid                                 | name             |
+---------------------+------------+----+--------------------------------------+------------------+
| 2019-08-07 06:11:34 | NULL       |  1 | 5f6baa56-252d-4f06-998f-5d166957490d | compute_standard |
| 2019-08-07 06:22:39 | NULL       | 10 | f7805dfb-00d2-458b-bb30-24919b8c9cd2 | room1            |
| 2019-08-07 06:22:43 | NULL       | 13 | b03f7028-f303-47a2-b6ca-128065f23030 | room2            |
| 2019-08-15 11:31:39 | NULL       | 16 | 1aff7a43-695a-4a10-9b24-116af73d18c1 | room3            |
| 2019-09-11 07:50:02 | NULL       | 17 | 952fa0aa-2ef6-443e-a906-76021acced0a | compute_test     |
| 2021-08-06 08:42:40 | NULL       | 20 | bab386c4-f1a3-4482-b0ea-74c74fb172bd | ephemeral_local  |
+---------------------+------------+----+--------------------------------------+------------------+
6 rows in set (0.00 sec)





Thank you.

Best regards,
Lennart
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.openstack.org/pipermail/openstack-discuss/attachments/20221122/890a726c/attachment.htm>