[Octavia] DB내용 삭제

로드 밸런서를 생성하였으나, 계속해서 pending create 상태였으며, error 상태로 떨어지지 않고 있었습니다.

강제로 삭제하는 방법을 찾다, db에서 강제로 active 상태로 변경하여 삭제할 수 있습니다.

 

1. Loadbalancer 삭제

root@controller:~# openstack loadbalancer list
+--------------------------------------+------+----------------------------------+-------------+---------------------+------------------+----------+
| id | name | project_id | vip_address | provisioning_status | operating_status | provider |
+--------------------------------------+------+----------------------------------+-------------+---------------------+------------------+----------+
| 8d48d451-edea-402c-8630-f1bafb00daf5 | lb01 | a9288ffbf3d242278547a49d2b10eb1b | 10.1.2.112 | PENDING_CREATE | OFFLINE | amphora |
+--------------------------------------+------+----------------------------------+-------------+---------------------+------------------+----------+

root@controller:~# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 16206
Server version: 10.3.25-MariaDB-0ubuntu0.20.04.1 Ubuntu 20.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use octavia;
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 [octavia]> select * from load_balancer \G;
*************************** 1. row ***************************
project_id: a9288ffbf3d242278547a49d2b10eb1b
id: 8d48d451-edea-402c-8630-f1bafb00daf5
name: lb01
description: NULL
provisioning_status: PENDING_CREATE
operating_status: OFFLINE
enabled: 1
topology: SINGLE
server_group_id: NULL
created_at: 2021-05-19 23:34:11
updated_at: NULL
provider: amphora
flavor_id: NULL
availability_zone: NULL 3
rows in set (0.000 sec)

MariaDB [octavia]> update load_balancer set provisioning_status = 'ACTIVE' where id ='8d48d451-edea-402c-8630-f1bafb00daf5';
Query OK, 1 row affected (0.004 sec)
Rows matched: 1 Changed: 1 Warnings: 0

MariaDB [octavia]> quit Bye

root@controller:~# openstack loadbalancer list
+--------------------------------------+------+----------------------------------+-------------+---------------------+------------------+----------+
| id | name | project_id | vip_address | provisioning_status | operating_status | provider |
+--------------------------------------+------+----------------------------------+-------------+---------------------+------------------+----------+
| 8d48d451-edea-402c-8630-f1bafb00daf5 | lb01 | a9288ffbf3d242278547a49d2b10eb1b | 10.1.2.112 | ACTIVE | OFFLINE | amphora |
+--------------------------------------+------+----------------------------------+-------------+---------------------+------------------+----------+

root@controller:~# openstack loadbalancer delete 8d48d451-edea-402c-8630-f1bafb00daf5

 

2. amphora 이미지 삭제하는 방법

root@controller:~# openstack loadbalancer amphora list
+--------------------------------------+-----------------+---------+------+---------------+-------+
| id | loadbalancer_id | status | role | lb_network_ip | ha_ip |
+--------------------------------------+-----------------+---------+------+---------------+-------+
| 405fe2ac-223f-4950-8c23-32d6e5886a88 | None | BOOTING | None | 172.1.6.21 | None |
+--------------------------------------+-----------------+---------+------+---------------+-------+


root@controller:~# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 16206
Server version: 10.3.25-MariaDB-0ubuntu0.20.04.1 Ubuntu 20.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use octavia;
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 [octavia]> update amphora set status ='DELETED' where id='405fe2ac-223f-4950-8c23-32d6e5886a88';
Query OK, 1 row affected (0.009 sec)
Rows matched: 1 Changed: 1 Warnings: 0

root@controller:~# openstack loadbalancer amphora list
+--------------------------------------+-----------------+---------+------+---------------+-------+
| id | loadbalancer_id | status | role | lb_network_ip | ha_ip |
+--------------------------------------+-----------------+---------+------+---------------+-------+
| |
+--------------------------------------+-----------------+---------+------+---------------+-------+