Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I read the online document here and for hours of researching and trying things out I still have a question need explanation.

The documentation says that there are two classes of failures, which for me there should be more. Failures can happen in any time when application send a query to database. For example, in section Apply Transaction to Both Accounts, what if after updating the account A, the database server failed, so account B didn't get updated. The query for updating account B was ignored. Next, the database server happens to be restarted immediately after the query for updating B was failed to execute. That means queries from Set Transaction State to Committed section all the way down are still executed successfully.

If that is the case, we could get an inconsistent database.

Could you point out what is missing here with my above thinking?

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.