Details
-
Type:
Bug
-
Status: Open (View Workflow)
-
Priority:
Critical
-
Resolution: Unresolved
-
Affects Version/s: 10.6.8
-
Fix Version/s: None
-
Component/s: Partitioning, Storage Engine - MyISAM
-
Labels:None
Description
for the table definition:
ID_SUB_SITE int(10) NOT NULL AUTO_INCREMENT,
|
DATE_METER timestamp / mariadb-5.3 / NOT NULL DEFAULT current_timestamp(),
|
MEASURE_VALUE mediumint(8) unsigned DEFAULT NULL
|
PRIMARY KEY (ID_SUB_SITE,DATE_METER,DELAY_IN_MINUTES) USING BTREE,
|
KEY EDA_SITE_RESULT_FKIndex1 (DATE_METER),
|
KEY EDA_SITE_RESULT_FKIndex2 (DELAY_IN_MINUTES)
|
) ENGINE=MyISAM AUTO_INCREMENT=873679 DEFAULT CHARSET=utf8mb3
|
PARTITION BY RANGE (unix_timestamp(DATE_METER))
|
(PARTITION p20220220 VALUES LESS THAN (1645398000) ENGINE = MyISAM,
|
PARTITION p20220504 VALUES LESS THAN (1651701600) ENGINE = MyISAM,
|
PARTITION p20220505` VALUES LESS THAN (1651788000) ENGINE = MyISAM,
|
...
|
PARTITION `pDEFAULT` VALUES LESS THAN MAXVALUE ENGINE = MyISAM)
|
After restoring a snapshot of MariaDB 10.3 datadir upgrade mariadb and system tables to 10.6
Do a repair table
And run following query
ALTER TABLE DATA_V3.EDA_SITE_RESULT_REAL_TIME REORGANIZE PARTITION pDEFAULT INTO ( PARTITION p20220515 VALUES LESS THAN ( UNIX_TIMESTAMP( '2022-05-16')), PARTITION pDEFAULT VALUES LESS THAN MAXVALUE)
|
The table get corrupted