With computerized booking in not sure if that happens a lot. Unless the agent didn't know what they were doing and entered the booking incorrectly a cancelled advanced booking should never happen.

I've also found the larger hotels will keep a few rooms in reserve, just in case there are problems i.e. leaks.