Open Stack

Thanks for the tip.
I will investigate further.

It seems that the AZs Zone Resource are of type 'network' and 'router'.
I was not aware of that distinction.


➜ openstack availability zone list --network --long
+-----------+-------------+---------------+-----------+--------------+----------------+
| Zone Name | Zone Status | Zone Resource | Host Name | Service Name | Service Status |
+-----------+-------------+---------------+-----------+--------------+----------------+
| room2     | available   | network       |           |              |                |
| room3     | available   | router        |           |              |                |
| room1     | available   | network       |           |              |                |
| room2     | available   | router        |           |              |                |
| room3     | available   | network       |           |              |                |
+-----------+-------------+---------------+-----------+--------------+----------------+



________________________________
From: Stephen Finucane <stephenfin at redhat.com>
Sent: Tuesday, November 22, 2022 12:45 PM
To: Lennart van Gijtenbeek | Routz; openstack-discuss
Subject: Re: Strange situation regarding Availability Zones


CAUTION: This email originated from outside the organization.

On Tue, 2022-11-22 at 10:55 +0000, Lennart van Gijtenbeek | Routz wrote:

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   |
+-----------+-------------+


Please run this command with debug mode enabled (--debug). That should give you far more information regarding what's going on here.

Stephen

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/bab90590/attachment-0001.htm>