Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.3, 10.4
-
Component/s: Partitioning, Versioned Tables
-
Labels:None
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;
|
Attachments
Issue Links
- is part of
-
MDEV-17554 Auto-create history partitions for system-versioned tables
-
- Closed
-
- relates to
-
MDEV-20077 Warning on full history partition is delayed until next DML statement
-
- Closed
-