<html><head>
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr"><div>On Tue, 2022-11-22 at 10:55 +0000, Lennart van Gijtenbeek | Routz wrote:</div><blockquote type="cite" style="margin:0 0 0 .8ex; border-left:2px #729fcf solid;padding-left:1ex"><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></div></blockquote><div><br></div><div>Please run this command with debug mode enabled (<font face="Courier New, Courier, monospace">--debug</font>). That should give you far more information regarding what's going on here.<br><br>Stephen</div><div><br></div><blockquote type="cite" style="margin:0 0 0 .8ex; border-left:2px #729fcf solid;padding-left:1ex"><div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">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><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><div><div>Thank you.<br><br>Best regards,<br>Lennart<p></p></div></div></div></blockquote><div><br></div><div><span></span></div></body></html>