Netbox database referential integrity violation

[someconservator]

We found a violation of referential integrity in the Netbox database, for example, in the tables of virtual machines/hardware servers there is an IP address field that is a link to the IP address table, and it has a non-zero value, but there is no record with such a key in the IP address table. And there are quite a lot of such records with errors. We did not climb into the database manually, only through requests to the Netbox API or through the web interface. And we upgraded several times. We don’t remember the exact version, but our first Netbox was some version 2+. Since then we have been making upgrades. Our latest version is 4.2.2, but we suspect it does not depend on the version. We see this in previous versions of Netbox as well. Where could such errors come from and does Netbox have any self-checking/self-cleaning tools or something similar? Thank you.