[MDEV-20068] History partition rotation is not done under LOCK TABLES - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.3(EOL), 10.4(EOL)
Fix Version/s: 10.3.18, 10.4.8
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

Activity

People

Assignee:: Aleksey Midenkov

Reporter:: Aleksey Midenkov

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2019-07-16 07:40

Updated:: 2021-04-08 11:28

Resolved:: 2019-08-11 11:40

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.