Rollback database partial changes if a query fails

[nigelmpofu]

Rollback any partial changes that would have been made to database if a query fails. This is done to prevent a build up of garbage data in that database.