ErrorCode = 4016, SQLState = HY000, Details = Internal error;
版本为社区版3.1.1
生产环境
service 配置 32cpu 129G
ErrorCode = 4016, SQLState = HY000, Details = Internal error;
版本为社区版3.1.1
生产环境
service 配置 32cpu 129G
4016是一个内部错误码,一般是由软件本身的bug导致的
请提供一下具体的sql语句和表结构。
SELECT
shard_id
FROM
asd_bank_records
GROUP BY
cxkh,
jysj,
jyje,
jyye,
jdbz,
jydfzkh
– 表结构
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 = ‘明细表’