Help Center/
GaussDB/
Developer Guide(Centralized_V2.0-8.x)/
FAQ/
What is Dirty Read, Phantom Read, and Non-repeatable Read?
Updated on 2025-05-29 GMT+08:00
What is Dirty Read, Phantom Read, and Non-repeatable Read?
Answer: Dirty read, phantom read, and non-repeatable read are problems of concurrent transactions.
- Dirty read: Transaction A reads data that has been modified by transaction B but has not been submitted, and transaction B is rolled back.
- Phantom read: If the same data is read in two consecutive periods, inconsistent results may occur.
- Non-repeatable read: The data queried twice in the same transaction is different.
Parent topic: FAQ
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot