【OpenStack问题记录无法访问虚拟机管理器可能原因是多余的数据库参数）】

最新推荐文章于 2025-03-28 14:41:08 发布

啊酒弟弟

最新推荐文章于 2025-03-28 14:41:08 发布

阅读量483

点赞数 1

文章标签：数据库 openstack java

本文链接：https://blog.youkuaiyun.com/weixin_43663238/article/details/129901881

版权

文章展示了对OpenStackNovaCompute服务的列表查看以及在MariaDB数据库中对compute节点的删除和状态更新操作，影响了服务列表和hypervisor_hostname的记录。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在这里插入图片描述

[root@controller nova]#  openstack compute service list
+----+----------+----------+----------+---------+-------+-------------+
| Id | Binary   | Host     | Zone     | Status  | State | Updated At  |
+----+----------+----------+----------+---------+-------+-------------+
|  1 | nova-con | controll | internal | enabled | up    | 2019-12-29T |
|    | ductor   | er       |          |         |       | 19:20:11.00 |
|    |          |          |          |         |       | 0000        |
|  3 | nova-con | controll | internal | enabled | up    | 2019-12-29T |
|    | soleauth | er       |          |         |       | 19:20:04.00 |
|    |          |          |          |         |       | 0000        |
|  4 | nova-sch | controll | internal | enabled | up    | 2019-12-29T |
|    | eduler   | er       |          |         |       | 19:20:12.00 |
|    |          |          |          |         |       | 0000        |
| 13 | nova-    | compute  | nova     | enabled | up    | 2019-12-29T |
|    | compute  |          |          |         |       | 19:20:10.00 |
|    |          |          |          |         |       | 0000        |
| 14 | nova-    | controll | nova     | enabled | up    | 2019-12-29T |
|    | compute  | er       |          |         |       | 19:20:13.00 |
|    |          |          |          |         |       | 0000        |
+----+----------+----------+----------+---------+-------+-------------+



MariaDB [(none)]> select hypervisor_hostname  from nova.compute_nodes;
+---------------------+
| hypervisor_hostname |
+---------------------+
| compute             |
| compute1            |
| compute2            |
| controller          |
+---------------------+
4 rows in set (0.00 sec)

MariaDB [(none)]> use nova;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [nova]> delete from nova.services where host="compute1";
Query OK, 0 rows affected (0.01 sec)

MariaDB [nova]> delete from nova.services where host="compute2";
Query OK, 0 rows affected (0.00 sec)

MariaDB [nova]> select hypervisor_hostname  from nova.compute_nodes; 
+---------------------+
| hypervisor_hostname |
+---------------------+
| compute             |
| compute1            |
| compute2            |
| controller          |
+---------------------+
4 rows in set (0.01 sec)

MariaDB [nova]>  delete from compute_nodes where hypervisor_hostname="compute1";
Query OK, 1 row affected (0.01 sec)

MariaDB [nova]>  delete from compute_nodes where hypervisor_hostname="compute3";
Query OK, 0 rows affected (0.00 sec)

MariaDB [nova]>  delete from compute_nodes where hypervisor_hostname="compute2";
Query OK, 1 row affected (0.01 sec)

MariaDB [nova]> select hypervisor_hostname  from nova.compute_nodes;
+---------------------+
| hypervisor_hostname |
+---------------------+
| compute             |
| controller          |
+---------------------+
2 rows in set (0.00 sec)