[MCOL-20] query returned "block missing" error while concurrently update and rollback was running. Created: 2016-05-03  Updated: 2016-06-15  Resolved: 2016-05-28

Status: Closed
Project: MariaDB ColumnStore
Component/s: regression suite
Affects Version/s: None
Fix Version/s: 1.0.0

Type: Bug Priority: Critical
Reporter: Dipti Joshi (Inactive) Assignee: David Hall (Inactive)
Resolution: Cannot Reproduce Votes: 0
Labels: 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

 Comments   
Comment by Daniel Lee (Inactive) [ 2016-05-25 ]

Build tested:

mscadmin> getsoftware
getsoftwareinfo Wed May 25 17:21:43 2016

Name : mariadb-columnstore-platform Relocations: (not relocatable)
Version : 1.0 Vendor: MariaDB Corporation Ab
Release : 0 Build Date: Tue 24 May 2016 07:24:06 PM CDT
Install Date: Wed 25 May 2016 12:27:43 PM CDT Build Host: srvbuilder
Group : Applications Source RPM: mariadb-columnstore-1.0-0.src.rpm

Executed the test case again on the latest build and did not encounter this issue.

Comment by Dipti Joshi (Inactive) [ 2016-05-28 ]

With the latest build since May 25th - this error is not happening- hence closing

Generated at Thu Feb 08 02:17:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.