Metadata issues with CHECK TABLE/PARTITION before starting load
General
Escalation
General
Escalation
Description
The work on PSTRESS-132 led to the discovery of some unnoticed issues with the metadata before starting the load for each step/trial.
When CHECK TABLE/PARTITION queries were added before, a small(~5%) percentage of such queries failed because of one of the following reasons. They need to be investigated and fixed if they turn out be critical.
Table doesn't exist error.
Partition doesn't exist error.
Deadlock found when trying to get lock error.
The issues can be reproduced just by looking at the thread logs once the patch for PSTRESS-132 is pushed. But, if pstress needs to be aborted, a hard return false can be added at the error paths of method, bool check_tables_partitions_preload(Thd1 *thd) {}{}.
Environment
None
Activity
Details
Assignee
Unassigned
Unassigned
Reporter
Varun Arakere Nagaraju
Varun Arakere Nagaraju
Reviewer
Rahul Malik
Rahul Malik(Deactivated)
Needs Review
Yes
Priority
Medium
Created October 5, 2022 at 12:00 PM
Updated March 6, 2024 at 5:52 PM
Flag notifications
Something's gone wrong
Looks like you've been signed out. Try logging in again.
The work on PSTRESS-132 led to the discovery of some unnoticed issues with the metadata before starting the load for each step/trial.
When CHECK TABLE/PARTITION queries were added before, a small(~5%) percentage of such queries failed because of one of the following reasons. They need to be investigated and fixed if they turn out be critical.
Table doesn't exist error.
Partition doesn't exist error.
Deadlock found when trying to get lock error.
The issues can be reproduced just by looking at the thread logs once the patch for PSTRESS-132 is pushed. But, if pstress needs to be aborted, a hard return false can be added at the error paths of method, bool check_tables_partitions_preload(Thd1 *thd) {}{}.