This is a strange one but has bitten us 3 times now. We've run into cases where the Orion DB transaction log fills, and we find that DB maintenance hangs at the exact same point:
INFO SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Beginning Maintenance for NetObjectDowntime
INFO SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Action 'Remove orphaned data from NetObjectDowntime' started
The common thread I can see is that the day before, node(s) were removed from Orion. This doesn't happen each time we remove nodes from Orion, but when it does happen, at least one node was removed. In the case that happened today, I saw the Transaction Log growth begin at the same time the first node was deleted yesterday.
Restarting Orion does not resolve the issue, but restarting the DB in conjunction with restarting Orion does resolve it.
It seems plausible that deleting a node begins a series of processes to remove references throughout the database, and something may hang somewhere, but I've found no evidence to prove where the issue may be, nor has support in the cases we have opened over the past year. Has anyone encountered similar behavior?
