I seem to have developed a referential integrity issue in on of our iTop instances.
Cleaning up old CI records specifically VirtualMachines and VirtualHosts that have been decomissioned a long time ago.
Was able through the UI delete the VirtualMachines and unhook them from tickets etc.
When trying to delete the VirtualHost a number of VirtualMachines are listed as
as must be deleted manually
*"Virtual Machine RCT-DMZ-PTM Must be deleted manually, but this is not feasible: VirtualMachine::958 Must be deleted manually"
*
However these VirtualMachines (and parent class VirtualDevice ) no longer exist.
And am unable to delete manually so cannot delete the VirtualHost.
This seems very odd , as looking at the DataModel there should not be any stray records as the VirtualMachine holds an explicit reference to the VirtualHost.
It seems somthing indirect at MariaDB is holding a directed relationship from VirtualHost -> VirtualMachine is the only thing that looks a likely candidate however I thought that would be a query for all VirtualMachines that reference the Virtualhost (virtualhost_id) and this is just an ID, so I am very confused how the dangling relationship could still exist.
My conclusion is the a some dangling references exist in the underlying MariaDB database, however integrity check shows no issues.
Hi
I seem to have developed a referential integrity issue in on of our iTop instances.
Cleaning up old CI records specifically VirtualMachines and VirtualHosts that have been decomissioned a long time ago.
Was able through the UI delete the VirtualMachines and unhook them from tickets etc.
When trying to delete the VirtualHost a number of VirtualMachines are listed as
as must be deleted manually
*"Virtual Machine RCT-DMZ-PTM Must be deleted manually, but this is not feasible: VirtualMachine::958 Must be deleted manually"
*
However these VirtualMachines (and parent class VirtualDevice ) no longer exist.
And am unable to delete manually so cannot delete the VirtualHost.
This seems very odd , as looking at the DataModel there should not be any stray records as the VirtualMachine holds an explicit reference to the VirtualHost.
It seems somthing indirect at MariaDB is holding a directed relationship from VirtualHost -> VirtualMachine is the only thing that looks a likely candidate however I thought that would be a query for all VirtualMachines that reference the Virtualhost (virtualhost_id) and this is just an ID, so I am very confused how the dangling relationship could still exist.
My conclusion is the a some dangling references exist in the underlying MariaDB database, however integrity check shows no issues.
Looking for some hints on how to resolve.
So they're listed with the "eye" icon - any chance those items were archived?
Hmm, we have yet to Archive anything , and have not activated archive mode.