There was a post on this forum (or maybe the late lamented Federal Soup security clearance forums) from somebody who got this outcome. As I recall this person was a military member so I suspect your second bullet may have applied.
I’d say this is a pretty rare outcome… I wonder if it mostly occurs when somebody loses interest in the job or finds something else after waiting a long time for the clearance.