Open Stack

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