知

CAS平台直接添加在主机池下的主机无法删除

2018-12-22 发表

0关注
0收藏 1934浏览

汪普深

汪普深八段

粉丝：28人关注：2人

组网及说明

不涉及

问题描述

CAS平台未创建集群，CVK主机直接添加在主机池下，导致无法删除主机：

过程分析

登录数据库：

root@cvm2:~# mysql -uroot -p1q2w3e

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 35048

Server version: 5.5.53-0ubuntu0.12.04.1 (Ubuntu)

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

切换database：

mysql> use vservice

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

查看数据库，发现CLUSTER_ID值为NULL：

mysql> select * from TBL_HOST;

+----+--------------+------------+-------+-------------+-----------+------+--------+------+-----------+-------------+---------+--------+---------------

+--------------+-------------------------------------------+---------------------------------------------+--------------------+------------------

+---------------------------------+----------+--------------+-----------------+-------------------+-------------+---------------+---------------

+-------------+-----------+---------+-----------+----------------+---------------------+-------------+

+----+--------------+------------+-------+-------------+-----------+------+--------+------+-----------+-------------+---------+--------+---------------

+--------------+-------------------------------------------+---------------------------------------------+--------------------+------------------

+---------------------------------+----------+--------------+-----------------+-------------------+-------------+---------------+---------------

+-------------+-----------+---------+-----------+----------------+---------------------+-------------+

| 1 | 1 | 1 | cvk8 | 172.31.6.8 | root | root | 160496 | 56 | 14 | 2 | 1751907 | 1 | 2585 |

GenuineIntel | Intel(R) Xeon(R) CPU E5-2660 v4 @ 2.00GHz | New H3C Technologies Co., Ltd. UIS R390X G2 | 380415 | 1371491 | iqn.1993-

| NULL | 0 | 3.0 (E0306H16) | 2018-05-28 19:29:04 | 0 |

| 3 | 1 | 1 | cvk10 | 172.31.6.10 | root | root | 160624 | 56 | 14 | 2 | 1751907 | 1 | 2566 |

GenuineIntel | Intel(R) Xeon(R) CPU E5-2660 v4 @ 2.00GHz | New H3C Technologies Co., Ltd. UIS R390X G2 | 563636 | 1188270 | iqn.1993-

| NULL | 0 | 3.0 (E0306H16) | 2018-05-28 19:32:04 | 0 |

| 7 | 4 | NULL | cvk9 | 172.31.6.9 | root | root | 160624 | 56 | 14 | 2 | 1751907 | 1 | 2982 |

GenuineIntel | Intel(R) Xeon(R) CPU E5-2660 v4 @ 2.00GHz | New H3C Technologies Co., Ltd. UIS R390X G2 | 93185 | 1658721 | iqn.1993-

| NULL | 0 | 3.0 (E0306H16) | 2018-12-20 13:57:20 | 0 |

+----+--------------+------------+-------+-------------+-----------+------+--------+------+-----------+-------------+---------+--------+---------------

+--------------+-------------------------------------------+---------------------------------------------+--------------------+------------------

+---------------------------------+----------+--------------+-----------------+-------------------+-------------+---------------+---------------

+-------------+-----------+---------+-----------+----------------+---------------------+-------------+

3 rows in set (0.00 sec)

mysql>

解决方法

修改数据库，将主机CLUSTER_ID值修改为2：

mysql> update TBL_HOST set CLUSTER_ID='2' where ID=7;

Query OK, 1 row affected (0.00 sec)

Rows matched: 1 Changed: 1 Warnings: 0