fe查询catalog执行异常

Viewed 98

版本:doris-2.1.8-rc01

我在fe observer访问jdbc catalog提示image.png
对应fe的报错日志
image.png
但是我在fe master上是可以执行成功的,但是偶尔会提示这个错误image.png

mysql源表结构
CREATE TABLE tb_commission_ib (
id int NOT NULL AUTO_INCREMENT,
user_id varchar(64) NOT NULL ,
mt4Account int NOT NULL,
ib_id varchar(64) NOT NULL ,
agentAccount int NOT NULL ,
ib_id_type int DEFAULT '0' ,
hand_commission decimal(38, 4) DEFAULT NULL ,
pip_commission decimal(38, 4) DEFAULT NULL ,
mt4_commission decimal(38, 4) DEFAULT NULL,
ticket varchar(64) DEFAULT NULL ,
server int DEFAULT NULL,
tradeCateId int DEFAULT NULL ,
close_time datetime NOT NULL DEFAULT '1970-01-01 00:00:00' ,
status char(1) NOT NULL,
rules int NOT NULL,
commission_flag int DEFAULT NULL ,
comment text COMMENT '描述',
settleDate datetime DEFAULT NULL ,
createDate datetime NOT NULL ,
updateDate datetime DEFAULT NULL ,
tradeOnCredit int DEFAULT NULL,
pammTrade tinyint(1) DEFAULT NULL,
PRIMARY KEY (id, close_time),
UNIQUE KEY mt4Account (
mt4Account,
ticket,
rules,
ib_id,
agentAccount,
close_time
),
KEY index_ib_id_ticket (ib_id, ticket),
KEY index_mt4Account (mt4Account),
KEY index_close_agentAccount (agentAccount, close_time),
KEY idx_rules (rules),
KEY idx_comm_summary (tradeOnCredit, createDate),
KEY idx_close_time_ib_id (close_time, ib_id),
KEY idx_user_id (user_id)
) ENGINE = InnoDB AUTO_INCREMENT = 586102467 DEFAULT CHARSET = utf8mb3 ROW_FORMAT = DYNAMIC

1 Answers

原始的 mysql 表的表结构贴一下