<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>Thanks for the tip.<br>
I will investigate further.</p>
<p><br>
It seems that the AZs Zone Resource are of type 'network' and 'router'.<br>
I was not aware of that distinction.</p>
<p><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=""><pre data-darkreader-inline-bgcolor="" style="background-color: rgb(29, 32, 33); font-size: 16px; margin-top: 0px; margin-bottom: 0px; padding: 0px; white-space: pre-wrap; --darkreader-inline-bgcolor:#17191a;"><font size="1" style="font-family: monospace, serif, EmojiFont;"><span data-darkreader-inline-bgcolor="" style="background-color: rgb(29, 32, 33); font-size: 12px; --darkreader-inline-bgcolor:#17191a;">➜ openstack availability zone list --network --<font style="">long</font>
+-----------+-------------+---------------+-----------+--------------+----------------+
| 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 | | | |
+-----------+-------------+---------------+-----------+--------------+----------------+</span></font></pre></pre>
<div><br>
</div>
<br>
<br>
<div style="color: rgb(232, 230, 227); --darkreader-inline-color:#d8d4cf;" data-darkreader-inline-color="">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size: 11pt; --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color=""><b>From:</b> Stephen Finucane <stephenfin@redhat.com><br>
<b>Sent:</b> Tuesday, November 22, 2022 12:45 PM<br>
<b>To:</b> Lennart van Gijtenbeek | Routz; openstack-discuss<br>
<b>Subject:</b> Re: Strange situation regarding Availability Zones</font>
<div> </div>
</div>
<div>
<table border="0" cellspacing="0" cellpadding="0" align="left" width=""100%">
<tbody>
<tr>
<td style="background: rgb(187, 165, 85); padding: 5.25pt 5.5pt 5.25pt 1.5pt; --darkreader-inline-bgimage: initial; --darkreader-inline-bgcolor:#685a2a;" data-darkreader-inline-bgimagedata-darkreader-inline-bgcolor="">
</td>
<td width=""100%" cellpadding=""7px 5px 7px
15px" color=""#212121" style="width: 100%; background: rgb(255, 229, 153); padding: 5.25pt 3.75pt 5.25pt 11.25pt; overflow-wrap: break-word; --darkreader-inline-bgimage: initial; --darkreader-inline-bgcolor:#543f00;" data-darkreader-inline-bgimagedata-darkreader-inline-bgcolor="">
<div>
<p><span style="font-size: 11pt; font-family: Arial, sans-serif; color: rgb(33, 33, 33); --darkreader-inline-color:#d3cfca;" data-darkreader-inline-color=""><b>CAUTION:</b> This email originated from outside the organization.
</span></p>
</div>
</td>
</tr>
</tbody>
</table>
<div>
<div>On Tue, 2022-11-22 at 10:55 +0000, Lennart van Gijtenbeek | Routz wrote:</div>
<blockquote type="cite" style="margin: 0px 0px 0px 0.8ex; border-left: 2px solid rgb(114, 159, 207); padding-left: 1ex; --darkreader-inline-border-left:#284e76;" data-darkreader-inline-border-left="">
<div id="divtagdefaultwrapper" dir="ltr" style="font-size: 12pt; color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif; --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color="">
<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; 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: 0px 0px 0px 0.8ex; border-left: 2px solid rgb(114, 159, 207); padding-left: 1ex; --darkreader-inline-border-left:#284e76;" data-darkreader-inline-border-left="">
<div id="divtagdefaultwrapper" dir="ltr" style="font-size: 12pt; color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif; --darkreader-inline-color:#e8e6e3;" data-darkreader-inline-color="">
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; 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>
</div>
</div>
</div>
</div>
</body>
</html>