【 TiDB 使用环境】生产环境 /测试/ Poc
【 TiDB 版本】
【复现路径】做过哪些操作出现的问题
【遇到的问题:问题现象及影响】
【资源配置】进入到 TiDB Dashboard -集群信息 (Cluster Info) -主机(Hosts) 截图此页面
【附件:截图/日志/监控】
tidb 集群版本 5.2.3 , 有一个表开了tiflash, 变更了表结构 后,tiflash就一直在内部报错,
变更操作
在git 看到这个issue, 是这个问题吗
https://github.com/pingcap/tiflash/issues/6703
tiflash 日志
https://github.com/pingcap/tiflash/issues/6703
Reading mismatch data type pack. Cast from Int64 to String is NOT supported #6703
1. Minimal reproduce step (Required)
mysql> select count(*) from pk_is_handle1;
ERROR 1105 (HY000): other error for mpp stream: From MPP<query:<query_ts:1675219212921686072, local_query_id:172206, server_id:871855, start_ts:439148665346195457>,task_id:3>: Code: 0, e.displayText() = DB::Exception: Reading mismatch data type pack. Cast from Int64 to String is NOT supported!: (while reading from DTFile: /data0/db/data/t_98/stable/dmf_833), e.what() = DB::Exception,
mysql> set tidb_isolation_read_engines='tikv';
Query OK, 0 rows affected (0.05 sec)
mysql> set tidb_isolation_read_engines='tikv';
Query OK, 0 rows affected (0.04 sec)
mysql> select count(*) from pk_is_handle1;
+----------+
| count(*) |
+----------+
| 63159390 |
+----------+
1 row in set (2.39 sec)
CREATE TABLE `pk_is_handle1` (
`a` bigint(20) NOT NULL,
`b` int(11) DEFAULT NULL,
`c` varchar(100) NOT NULL,
`d` char(100) DEFAULT NULL,
`e` float DEFAULT NULL,
`g` double DEFAULT NULL,
`h` decimal(8,4) DEFAULT NULL,
`i` date DEFAULT NULL,
`j` datetime DEFAULT NULL,
PRIMARY KEY (`a`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
system
(system)
关闭
10
此话题已在最后回复的 60 天后被自动关闭。不再允许新回复。