Description of problem:
Now the splice database contains a copy of all system checkins. When a system is deleted in spacewalk, the checkins remain in splice and will still be visible in all inactive reports.
The best solution is to have a single report (instead of having Active/Inactive pair) with the following flags:
1) Active - system was active during the given time period.
2) Inactive - the system was inactive (== no checkins happened) during the given time period _AND_ it wasn't removed.
3) Deleted - the system was inactive (==no checkins happened) during the given time period _AND_ it was removed.
I think #3 should be just "it was removed". It is possible for a system to have a checkin and be removed, if the removal happened soon after the last checkin.
Agreed.. a system can go from active directly to deleted.
There are a few components that need changes to support this, but the new deleted_consumer candlepin API will be in 0.8.14 (cace30f)
These versions should have the changes needed:
splice-server fe9ffc4 (0.138)
candlepin 97fd00f (0.8.18)
spacewalk-splice-tool 4dcb0bab1 (0.34)
splice-reports 5e550fe (0.0.5-36)
marking as modified
SNAP0 contains these bug fixes. Moving to ON_QA.
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.
For information on the advisory, and where to find the updated
files, follow the link below.
If the solution does not work for you, open a new bug report.