Server may crash or corrupt data if SELECT WITH LOCK is issued against records not in the latest format [CORE3374] #3740
Labels
affect-version: 1.5.6
affect-version: 2.0.4
affect-version: 2.0.5
affect-version: 2.0.6
affect-version: 2.1.0
affect-version: 2.1.1
affect-version: 2.1.2
affect-version: 2.1.3
affect-version: 2.1.4
affect-version: 2.5.0
affect-version: 3.0 Initial
component: engine
fix-version: 2.0.7
fix-version: 2.1.5
fix-version: 2.5.1
fix-version: 3.0 Alpha 1
priority: major
qa: done successfully
type: bug
Submitted by: @dyemanov
Is related to QA467
Test case:
create table test (col1 int, col2 varchar(10), col3 date);
insert into test values (1, 'qwerty', current_date);
alter table test drop col2;
select * from test order by col1 with lock; -- crash here
Prerequisites:
1) Sorting must be present (in order to set the re-fetch flag)
2) The on-disk record must be in the prior format which must be longer than the current one
In this case deallocated memory is accessed which may lead to either crashing (most probably) or record/index errors.
Commits: d68affa 40f27b5 7208ae1 0c2900c
====== Test Details ======
Actually there is NO crash in 2.5.0, checked SS/SC/CS, WI-V2.5.0.26074
The text was updated successfully, but these errors were encountered: