【 TiDB 使用环境`】生产环境
【 TiDB 版本】v5.2.3 升级v5.3.1
【复现路径】 tikv升级完成后,先升级一个tiflash,之后发现tiflash查询结果不一致
tikv 查询结果正常,后面把tiflash全部升级完成后,把有问题的表重新tiflash同步 后正常
【问题现象及影响】
结果不一致
异常时
SELECT own_appid,COUNT(1),SUM(cost) FROM tbl_new_ad_cost WHERE create_time>=‘2022-03-29’ AND create_time<‘2022-03-30’ GROUP BY own_appid ORDER BY 1
own_appid count(1) sum(cost)
1092 1043 39102.390
1093 253 24.360
1095 280 273.840
SELECT own_appid,COUNT(1),SUM(cost) FROM tbl_new_ad_cost WHERE create_time>=‘2022-03-29’ AND create_time<‘2022-03-30’ GROUP BY own_appid ORDER BY 1
own_appid count(1) sum(cost)
1092 543 19102.390
1093 153 14.360
1095 148 172.240
稳定之后
SELECT own_appid,COUNT(1),SUM(cost) FROM tbl_new_ad_cost WHERE create_time>=‘2022-03-29’ AND create_time<‘2022-03-30’ GROUP BY own_appid ORDER BY 1
own_appid count(1) sum(cost)
1092 1043 39102.390
1093 253 24.360
1095 280 273.840