So I created a load balancer and deleted it afterwords, i expected to see the lb and amphora are shown deleted and vip info relates to this lb will be cleared as well, but i can still see it in the data table, is this designed in purpose and when will we clear up these info then?
mysql> select * from load_balancer;
+----------------------------------+--------------------------------------+------+-------------+---------------------+------------------+---------+----------+-----------------+
| project_id | id | name | description | provisioning_status | operating_status | enabled | topology | server_group_id |
+----------------------------------+--------------------------------------+------+-------------+---------------------+------------------+---------+----------+-----------------+
| 54d4e1b0776e4bc7a58bddc2a5e900a3 | 99d064ef-3038-4db9-a5da-d53e8cac7c4d | lb1 | | DELETED | ONLINE | 1 | SINGLE | NULL |
+----------------------------------+--------------------------------------+------+-------------+---------------------+------------------+---------+----------+-----------------+
1 row in set (0.00 sec)
mysql> select * from amphora;
+--------------------------------------+--------------------------------------+---------+--------------------------------------+---------------+----------+----------+--------------------------------------+--------------------------------------+------------+---------------------+-----------+----------------+---------+---------------+
| id | compute_id | status | load_balancer_id | lb_network_ip | vrrp_ip | ha_ip | vrrp_port_id | ha_port_id | role | cert_expiration | cert_busy | vrrp_interface | vrrp_id | vrrp_priority |
+--------------------------------------+--------------------------------------+---------+--------------------------------------+---------------+----------+----------+--------------------------------------+--------------------------------------+------------+---------------------+-----------+----------------+---------+---------------+
| a02bcedb-227e-47a2-bba4-47c58ca82e88 | 03ca5269-7f74-4670-92b8-68712cfb40cd | DELETED | 99d064ef-3038-4db9-a5da-d53e8cac7c4d | 192.168.0.4 | 10.0.0.4 | 10.0.0.3 | 2822dd69-1d31-403c-b3fb-ce9179d71371 | 9b5e041e-4b2a-4005-96e3-fcb263e421a9 | STANDALONE | 2018-04-22 17:41:07 | 0 | NULL | 1 | NULL |
+--------------------------------------+--------------------------------------+---------+--------------------------------------+---------------+----------+----------+--------------------------------------+--------------------------------------+------------+---------------------+-----------+----------------+---------+---------------+
1 row in set (0.00 sec)
mysql> select * from vip;
+--------------------------------------+------------+--------------------------------------+--------------------------------------+
| load_balancer_id | ip_address | port_id | subnet_id |
+--------------------------------------+------------+--------------------------------------+--------------------------------------+
| 99d064ef-3038-4db9-a5da-d53e8cac7c4d | 10.0.0.3 | 9b5e041e-4b2a-4005-96e3-fcb263e421a9 | 29e8791b-568c-4e68-afed-d0300488897b |
+--------------------------------------+------------+--------------------------------------+--------------------------------------+
The two records marked "deleted" I would expect. The VIP record concerns me. We need to figure out why these aren't getting cleaned up.