无法在rapid引擎中执行。

查看下表状态“SHOW TABLE STATUS like 't1'\G”
查看建表语句“SHOW CREATE TABLE t1\G”

KAiTO 发表于 2024-3-13 09:57
查看下表状态“SHOW TABLE STATUS like 't1'\G”
查看建表语句“SHOW CREATE TABLE t1\G”
...

mysql> set use_secondary_engine = FORCED;
Query OK, 0 rows affected (0.00 sec)

mysql> select count(*) from customer;
ERROR 3889 (HY000): Secondary engine operation failed. use_secondary_engine is FORCED but query could not be executed in secondary engine.
mysql> show table status like 'customer'\G;
*************************** 1. row ***************************
           Name: customer
         Engine: InnoDB
        Version: 10
     Row_format: Dynamic
           Rows: 135248189
Avg_row_length: 194
    Data_length: 26294091776
Max_data_length: 0
   Index_length: 1887436800
      Data_free: 0
Auto_increment: NULL
    Create_time: 2024-03-11 18:03:22
    Update_time: NULL
     Check_time: NULL
      Collation: latin1_swedish_ci
       Checksum: NULL
Create_options: SECONDARY_ENGINE="rapid" SECONDARY_LOAD="1"
        Comment:
1 row in set (0.01 sec)

ERROR:
No query specified

mysql> show create table customer;
+----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table    | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                           |
+----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| customer | CREATE TABLE `customer` (
  `c_custkey` int NOT NULL,
  `c_name` varchar(25) NOT NULL,
  `c_address` varchar(40) NOT NULL,
  `c_nationkey` int NOT NULL,
  `c_phone` char(15) NOT NULL,
  `c_acctbal` decimal(15,2) NOT NULL,
  `c_mktsegment` char(10) NOT NULL,
  `c_comment` varchar(117) NOT NULL,
  PRIMARY KEY (`c_custkey`),
  KEY `customer_fk1` (`c_nationkey`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 SECONDARY_ENGINE=rapid |
+----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql>

今天发现查询不能走列存引擎了，已经设定 use_secondary_engine = FORCED, 报错 ERROR 3889 (HY000): Secondary engine operation failed. use_secondary_engine is FORCED but query could not be executed in secondary engine.
===
可以尝试再执行一次

1. 
   
2. alter table xx secondary_load;
   

复制代码

如果该表已经加载到secondary中，上述操作不会重新加载一遍，应该会很快完成；如果没有加载，那么会重新加载一遍，可能会比较慢。