<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p>Hello everyone,<br>
<br>
We have a strange situation regarding Availability Zones in our Openstack environment (version: Queens).<br>
<br>
</p>
<p>We have 3 AZs: room1, room2, and room3.<br>
<br>
<span style="font-family: Calibri, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">There are duplicate entries in the output of this command <span style="font-family: Calibri, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">(</span><span style="font-family: Calibri, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">openstack-pythonclient
version 6.0.0)</span>:<br>
</span><br>
</p>
<pre class="code-java" style="margin-top: 0px; margin-bottom: 0px; padding: 0px; max-height: 30em; overflow: auto; white-space: pre-wrap; overflow-wrap: normal; color: rgb(200, 196, 189); font-size: 12px; background-color: rgb(29, 32, 33); --darkreader-inline-color:#c2bcb4; --darkreader-inline-bgcolor:#17191a;" data-darkreader-inline-colordata-darkreader-inline-bgcolor="">➜ 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 |
+-----------+-------------+</pre>
<br>
However, in our database, I cannot find any reference to these duplicate entries.<br>
<br>
<span style="font-family: Calibri, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">W</span><span style="font-family: Calibri, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">hat's
going on here?</span>
<div style="font-family: Calibri, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">
<br>
<div>And how should we go about removing the duplicate entries if they don't show in the database?</div>
</div>
<br>
<br>
<pre class="code-java" style="margin-top: 0px; margin-bottom: 0px; padding: 0px; max-height: 30em; overflow: auto; white-space: pre-wrap; overflow-wrap: normal; color: rgb(200, 196, 189); font-size: 12px; background-color: rgb(29, 32, 33); --darkreader-inline-color:#c2bcb4; --darkreader-inline-bgcolor:#17191a;" data-darkreader-inline-colordata-darkreader-inline-bgcolor="">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)</pre>
<div><br>
</div>
<br>
<div>
<div><br>
<br>
<br>
Thank you.<br>
<br>
Best regards,<br>
Lennart
<p></p>
</div>
</div>
</div>
</body>
</html>