sql执行超时

OceanBase 技术问题
#1

ErrorCode = 4016, SQLState = HY000, Details = Internal error;

版本为社区版3.1.1
生产环境
service 配置 32cpu 129G

#3

4016是一个内部错误码，一般是由软件本身的bug导致的
请提供一下具体的sql语句和表结构。

#4

SELECT

shard_id

FROM

asd_bank_records

GROUP BY

cxkh,

jysj,

jyje,

jyye,

jdbz,

jydfzkh

#5

– 表结构
CREATE TABLE asd_bank_records (
shard_id int(11) NOT NULL AUTO_INCREMENT COMMENT ‘分片id’,
ajid varchar(255) DEFAULT ‘’ COMMENT ‘id’,
cxkh varchar(255) DEFAULT ‘’ COMMENT ‘*账号’,
cxzh varchar(255) DEFAULT ‘’ COMMENT ‘*账号’,
jymc varchar(255) DEFAULT ‘’ COMMENT ‘*名称’,
jyzjhm varchar(255) DEFAULT ‘’ COMMENT ‘*号码’,
jykhh varchar(255) DEFAULT ‘’ COMMENT ‘*开户银行’,
jdbz varchar(255) DEFAULT ‘’ COMMENT ‘*标志’,
jysj timestamp NULL DEFAULT NULL COMMENT ‘*时间’,
jyrq timestamp NULL DEFAULT NULL COMMENT ‘*日期’,
jyje decimal(22,2) DEFAULT ‘0.00’ COMMENT ‘*金额’,
jyye decimal(22,2) DEFAULT ‘0.00’ COMMENT ‘*余额’,
jybz varchar(255) DEFAULT ‘’ COMMENT ‘*币种’,
jydfzkh varchar(255) DEFAULT ‘’ COMMENT ‘*账号’,
jydfmc varchar(255) DEFAULT ‘’ COMMENT ‘*户名’,
jydfzjhm varchar(255) DEFAULT ‘’ COMMENT ‘*身份证号’,
dsjyye decimal(22,2) DEFAULT ‘0.00’ COMMENT ‘*余额’,
jydfzhkhh varchar(255) DEFAULT ‘’ COMMENT ‘*银行’,
jyyhmc varchar(255) DEFAULT ‘’ COMMENT ‘*银行名’,
zysm varchar(255) DEFAULT ‘’ COMMENT ‘*说明’,
jywdmc varchar(255) DEFAULT ‘’ COMMENT ‘*名称’,
ip varchar(255) DEFAULT ‘’ COMMENT ‘*地址’,
mac varchar(255) DEFAULT ‘’ COMMENT ‘*地址’,
jylx varchar(255) DEFAULT ‘’ COMMENT ‘*类型’,
jyhwdd varchar(255) DEFAULT ‘’ COMMENT ‘*网点号’,
jyfsd varchar(255) DEFAULT ‘’ COMMENT ‘*发生地’,
jycs varchar(255) DEFAULT ‘’ COMMENT ‘*场所’,
jylsh varchar(255) DEFAULT ‘’ COMMENT ‘*流水号’,
beiz varchar(255) DEFAULT ‘’ COMMENT ‘备注’,
bczysm varchar(255) DEFAULT ‘’ COMMENT ‘补充摘要说明’,
insert_time timestamp NULL DEFAULT NULL COMMENT ‘*时间’,
delete_time int(11) DEFAULT ‘0’ COMMENT ‘删除时间’,
PRIMARY KEY (shard_id),
KEY cxkh (cxkh, jymc, jyzjhm, jydfzkh, jydfmc, jydfzjhm, jyje, jdbz, jysj) BLOCK_SIZE 16384 GLOBAL,
KEY jyje (jyje, jysj, cxkh) BLOCK_SIZE 16384 GLOBAL,
KEY jydfzkh (jydfzkh, jydfmc, jydfzjhm, jyje, jdbz, jysj, jymc, cxkh) BLOCK_SIZE 16384 GLOBAL
) AUTO_INCREMENT = 73000001 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = COMPACT COMPRESSION = ‘lz4_1.0’ REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0 COMMENT = ‘明细表’