Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.5, 10.6, 10.6.8, 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
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
Attachments
Issue Links
- is duplicated by
-
MDEV-29754 Unexpected ER_NOT_FORM_FILE or ER_VERS_FIELD_WRONG_TYPE upon creating system-versioned table under mysql56_temporal_format=0
- Closed
- relates to
-
MDEV-29754 Unexpected ER_NOT_FORM_FILE or ER_VERS_FIELD_WRONG_TYPE upon creating system-versioned table under mysql56_temporal_format=0
- Closed