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