Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 数据归档出现 ERROR 1815 (HY000): Internal : Can’t find a proper physical plan for this query
|
username: zhengjunbo
[TiDB Usage Environment] Production Environment
[TiDB Version] V4.0.15
[Reproduction Path]
- Add
Create Table: CREATE TABLE `my_table` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
`post_id` varchar(32) NOT NULL DEFAULT '' COMMENT 'Order ID',
`create_sys_tm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creation Time',
PRIMARY KEY (`id`),
KEY `idx_create_sys_tm` (`create_sys_tm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=1 COMMENT='Order Table'
Add replica
ALTER TABLE my_db.my_table SET TIFLASH REPLICA 1;
Export the entire database to another database without TiFlash, execute the SQL statement
explain SELECT /*!40001 SQL_NO_CACHE */ * FROM `my_db`.`my_table` FORCE INDEX(`PRIMARY`) WHERE (create_sys_tm<'2021-09-01 00:00:00') ORDER BY `id` LIMIT 10000;
[Encountered Problem: Problem Phenomenon and Impact]
It will directly report an error
ERROR 1815 (HY000): Internal : Can't find a proper physical plan for this query
Clearing it will work normally.
ALTER TABLE `my_db`.`my_table` SET TIFLASH REPLICA 0;
|
username: 
|
username: 
|
username: