Duplicated IP : 2 IPs assigned to different MAC

Issue

After creating and deleting VM, we may encounter a situation where the MAC address of the deleted VM is still present in the MySQL database and still attached to on IP.

Check OVN NB database ouput for affected IP:

root@controller/]# ovn-nbctl show | grep 32.28
        addresses: ["fa:16:3e:27:d7:ce 172.26.32.28"]
        addresses: ["fa:16:3e:e8:3b:d0 172.26.32.28"]
[root@controller /]# ovn-nbctl show | grep 32.26
        addresses: ["fa:16:3e:11:29:7d 172.26.32.26"]
        addresses: ["fa:16:3e:ff:0c:92 172.26.32.26"]
[root@controller /]# ovn-nbctl show | grep 32.51
        addresses: ["fa:16:3e:ac:6d:18 172.26.32.51"]

Below is the log from compute node - logged on the "ovn_metadata_agent" container.

2022-06-22 12:33:50.722 703371 ERROR networking_ovn.agent.metadata.server [-] More than one port found in network b61113bd-ea5a-4bcc-8583-c675984cbe24 with IP address 172.26.32.51. Please run the neutron-ovn-db-sync-util script as there seems to be inconsistent data between Neutron and OVN databases. OVN Port uuids: 0069dd11-3582-4967-acb8-dd1548396950, 84a84887-5548-4b32-a4e5-7305254da215
2022-06-22 12:33:50.723 703371 INFO eventlet.wsgi.server [-] 172.26.32.51,<local> "GET /2009-04-04/meta-data/instance-id HTTP/1.1" status: 404  len: 297 time: 0.0107405
2022-06-22 12:33:52.740 703371 ERROR networking_ovn.agent.metadata.server [-] More than one port found in network b61113bd-ea5a-4bcc-8583-c675984cbe24 with IP address 172.26.32.51. Please run the neutron-ovn-db-sync-util script as there seems to be inconsistent data between Neutron and OVN databases. OVN Port uuids: 0069dd11-3582-4967-acb8-dd1548396950, 84a84887-5548-4b32-a4e5-7305254da215
2022-06-22 12:33:52.740 703371 INFO eventlet.wsgi.server [-] 172.26.32.51,<local> "GET /2009-04-04/meta-data/instance-id HTTP/1.1" status: 404  len: 297 time: 0.0115314
2022-06-22 12:33:54.757 703371 ERROR networking_ovn.agent.metadata.server [-] More than one port found in network b61113bd-ea5a-4bcc-8583-c675984cbe24 with IP address 172.26.32.51. Please run the neutron-ovn-db-sync-util script as there seems to be inconsistent data between Neutron and OVN databases. OVN Port uuids: 0069dd11-3582-4967-acb8-dd1548396950, 84a84887-5548-4b32-a4e5-7305254da215
2022-06-22 12:33:54.757 703371 INFO eventlet.wsgi.server [-] 172.26.32.51,<local> "GET /2009-04-04/meta-data/instance-id HTTP/1.1" status: 404  len: 297 time: 0.0105944
2022-06-22 12:33:56.773 703371 ERROR networking_ovn.agent.metadata.server [-] More than one port found in network b61113bd-ea5a-4bcc-8583-c675984cbe24 with IP address 172.26.32.51. Please run the neutron-ovn-db-sync-util script as there seems to be inconsistent data between Neutron and OVN databases. OVN Port uuids: 0069dd11-3582-4967-acb8-dd1548396950, 84a84887-5548-4b32-a4e5-7305254da215