Shared IP that is part of a VIP causing problems listing VIP and deleting equipment association

[marcusgc]

OBS: Dois equipamentos podem ter o mesmo IP cadastrado. Isso é o esperado para IP<>equipamentos. It is expected an IP to be registered to one or more equipments. The problem occurs when we add this shared IP to a VIP (Virtual Server - LB). When listing this VIP, we get the error "Falha ao acessar a fonte de dados. (Database failure).". As the VIP pool member is related to an IP, the issue is possibly because the NetworkAPI tries to find a unique equipment to this VIP but it gets more than one. If the IP is registered to more than one equipment, the VIP has to show them all.

Another problem: I tryed to delete the association of one of the servers but it does not let me do that. When I tryed to do that, it gave the me error:

"Não foi possível excluir o ip de id 42002 pois ele está sendo usado em uma requisição VIP."

I am not trying to delete the IP itself. It should still be registered in the DB for the other equipment and this error should not happen.

[marcusgc]

[DEBUG] 27/Jul/2015:19:53:24 +0000 - U:USER, P:/ip/37751/equipamento/246/, T:RCDBEIVXRRWSXWPU5WAULA, MSG:INICIO da requisição DELETE. Data: []. [WARNING] 27/Jul/2015:19:53:24 +0000 - U:USER, P:/ip/37751/equipamento/246/, T:RCDBEIVXRRWSXWPU5WAULA, MSG:Added=True [DEBUG] 27/Jul/2015:19:53:24 +0000 - U:USER, P:/ip/37751/equipamento/246/, T:RCDBEIVXRRWSXWPU5WAULA, MSG:Requisição concluída com falha. Conteúdo: [0385Não foi possível desassociar o ip 10.10.32.3 do equipamento RIOLB144 pois o ip está sendo utilizado nos server pools (id:identifier) 1805: BD_ORACLEPARCEIROS2_1522.]. [DEBUG] 27/Jul/2015:19:53:24 +0000 - U:USER, P:/ip/37751/equipamento/246/, T:RCDBEIVXRRWSXWPU5WAULA, MSG:FIM da requisição.

Select * from ips_dos_equipamentos where id_ip = 37751 id_ips_dos_equipamentos, id_ip, id_equip '135708', '37751', '202' '43656', '37751', '246'

select * from equipamentos where id_equip in (202,246) id_equip, id_tipo_equipamento, id_modelo, nome '202', '2', '1', 'SERVER1' '246', '2', '1', 'SERVER2'

select * from server_pool_member where ips_id_ip IN (select id_ip from ips where id_ip IN (select id_ip from ips_dos_equipamentos where id_equip IN (select id_equip from equipamentos where nome ='SERVER1' or nome='SERVER2' ) ) ) id_server_pool_member, id_server_pool, identifier, ipsv6_id_ipv6, ips_id_ip, priority, weight, limit, port, healthcheck_id_healthcheck, status, last_status_update '2416', '1805', '10.10.32.32', NULL, '37751', '3', '1', '0', '1522', NULL, '0', NULL '24060', '14527', '10.10.32.32', NULL, '113574', '3', '1', '0', '1522', NULL, '7', '2015-07-27 19:37:24'