yuqi1129 opened a new issue, #13894: URL: https://github.com/apache/gravitino/issues/13894
### Describe the subtask Several entity reads load the parent row and its child rows in separate statements. If an overwrite or drop commits between those statements, the reader gets an incomplete or mixed-version entity, and that result can also be written into the entity cache: - **Table:** the table row and its columns. Readers get 0 columns even while an overwrite keeps the table alive. Measured rates: MySQL 72/823, PostgreSQL 44/563, H2 6/2425. #13181 described this and was closed as not planned. - **Role:** the role row and its securable objects / privileges. - **User / Group:** the user/group row and its role memberships. Fix: load each of these aggregates together with its parent metadata in a single SELECT, and use the same snapshot as the updater input. Audit the other reads that span several statements and record the result. ### Parent issue #13853 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
