Reset State Robustification

Reset state table for volume, backup, and snapshot which I think need to do in this spec https://review.opendev.org/c/openstack/cinder-specs/+/766716

https://docs.google.com/spreadsheets/d/1cd3auGYk1xlushNA2kwK-nVAEE3p2nloAMNfC0km_3A/edit?usp=sharing

spec description: https://review.opendev.org/c/openstack/cinder-specs/+/766716