oot@controller:~# neutron floatingip-list
+--------------------------------------+------------------+---------------------+--------------------------------------+
| id | fixed_ip_address | floating_ip_address | port_id |
+--------------------------------------+------------------+---------------------+--------------------------------------+
| 014392f6-2cd5-4e87-be7f-a86ae6540d25 | 172.16.1.253 | XXX.XXX.XXX.205 | bbc5fa62-ae81-4f51-8117-8513832b7646 |
| 14a37b8a-937d-4060-a2cc-c40a6400049b | 172.16.1.70 | XXX.XXX.XXX.239 | 1c8f54de-b26d-40e5-92c9-4c4503730dde |
| 7665c288-bafd-425d-80bf-1857d8573006 | 172.16.1.252 | XXX.XXX.XXX.207 | 992ea427-9b13-44c6-a6b8-c89391257ea4 |
| bea6b291-f0fa-47ab-b9ef-7868f7a4a041 | 192.168.202.6 | XXX.XXX.XXX.199 | 0763e1c4-57ee-42a1-bb3f-6b0e62887abc |
+--------------------------------------+------------------+---------------------+--------------------------------------+
OFFLINE 강제삭제
# neutron lbaas-loadbalancer-list
+--------------------------------------+-------------------+---------------+---------------------+----------+
| id | name | vip_address | provisioning_status | provider |
+--------------------------------------+-------------------+---------------+---------------------+----------+
| 63c0c32a-96d8-428e-a8f4-3486364a25c0 | loadbalancer_test | 172.16.1.86 | ERROR | haproxy |
| 693d9caa-2e17-47d3-9ccc-92b689f2ae98 | lb2 | 192.168.202.6 | ACTIVE | haproxy |
+--------------------------------------+-------------------+---------------+---------------------+----------+
# neutron lbaas-loadbalancer-show 63c0c32a-96d8-428e-a8f4-3486364a25c0
+---------------------+--------------------------------------+
| Field | Value |
+---------------------+--------------------------------------+
| admin_state_up | True |
| description | |
| id | 63c0c32a-96d8-428e-a8f4-3486364a25c0 |
| listeners | |
| name | loadbalancer_test |
| operating_status | OFFLINE |
| provider | haproxy |
| provisioning_status | ERROR |
| tenant_id | 52ac0ebb9b584d77b5216e33dc190ebd |
| vip_address | 172.16.1.86 |
| vip_port_id | 554f1ff7-d5e3-481f-abd3-40d7052625f8 |
| vip_subnet_id | dc23c908-9db4-439f-9a57-6d5a5e7c2b1a |
+---------------------+--------------------------------------+
:: 외래키 검사오류
mysql> delete from ports where device_owner='neutron:LOADBALANCERV2' and id='554f1ff7-d5e3-481f-abd3-40d7052625f8';
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`neutron`.`lbaas_loadbalancers`, CONSTRAINT `fk_lbaas_loadbalancers_ports_id` FOREIGN KEY (`vip_port_id`) REFERENCES `ports` (`id`))
:: 외래키 검사 일시중지
mysql> SET FOREIGN_KEY_CHECKS=0;
Query OK, 0 rows affected (0.00 sec)
mysql> delete from ports where device_owner='neutron:LOADBALANCERV2' and id='554f1ff7-d5e3-481f-abd3-40d7052625f8';
Query OK, 1 row affected (0.06 sec)
mysql> delete from lbaas_loadbalancers where id='63c0c32a-96d8-428e-a8f4-3486364a25c0';
Query OK, 1 row affected (0.05 sec)
|
