Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Cannot Reproduce
-
None
-
None
Description
query returned "block missing" error while concurrently update and rollback was running.
Tested with a 1gb tpch database. The is was identified by the concurDML test in autopilot. Reproduced it few times and suddenly not happening. It may happen if you keep repeating the test.
"run a script to do:
set autocommit=0; |
update nation set n_nationkey=-1; |
update nation set n_comment='zzzz-1'; |
rollback;
|
update nation set n_nationkey=-2; |
update nation set n_comment='zzzz-2'; |
rollback;
|
The script repeats the above statements all the way to -100 and zzzz-100 |
 |
While the script is running, continueously run these two statements:
|
select count(*) from nation where n_nationkey < 0; |
select count(*) from nation where n_comment > 'zzzz'; |
"
|
The idea of the test is that the queries should return 0 or all rows in the table. We should not be getting partitially updated data