[MDEV-20068] History partition rotation is not done under LOCK TABLES Created: 2019-07-16  Updated: 2021-04-08  Resolved: 2019-08-11

Status: Closed
Project: MariaDB Server
Component/s: Partitioning, Versioned Tables
Affects Version/s: 10.3, 10.4
Fix Version/s: 10.3.18, 10.4.8

Type: Bug Priority: Major
Reporter: Aleksey Midenkov Assignee: Aleksey Midenkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
PartOf
is part of MDEV-17554 Auto-create history partitions for sy... Closed
Relates
relates to MDEV-20077 Warning on full history partition is ... Closed

 Description   

Due to partition rotation is done under lock_external() LOCK TABLES prevents table from further rotation checks. This may lead to partition overflow without any warnings.

Reproduce:

create or replace table t1 (x int) with system versioning partition by system_time limit 1;
 
lock tables t1 write;
 
insert into t1 values (0), (1), (2), (3);
 
delete from t1 where x < 3;
 
delete from t1;
 
unlock tables;


Generated at Thu Feb 08 08:56:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.