【TiDB 使用环境】生产环境
【TiDB 版本】7.1.3
【操作系统】centos7.9
【部署方式】自建
【集群数据量】
【集群节点数】20+
【问题复现路径】做过哪些操作出现的问题
【遇到的问题：问题现象及影响】
研发反馈主键查询返回多条数据，随机出现，重新查询可能恢复正常，研发确认不存在条件字符类型问题，返回的异常结果集没有查询的id！我手动查询上百次也没复现，甚至把id='1’字符串类型也没复现！下面sql是研发提供的模板，java日志打印的就是这个？格式！
这个表数据量也就5000左右！
sql：
select
id, optimistic, create_time, last_modify_time, merchant_no, settle_cycle, settlement_method, status, settle_target
from
tbl_rebate_settle_info
where
id = ?[2426235565659127819]
返回结果：
id=2426235565659127819,entityList=[
{"createTime":"2025-04-09 06:59:43","lastModifyTime":"2025-04-09 06:59:43","id":2587638478392262841,"merchantNo":"10090789729"},
{"createTime":"2025-04-09 06:59:48","lastModifyTime":"2025-04-09 06:59:48","id":2587638564291870804,"merchantNo":"10091025725"},
{"createTime":"2025-04-09 06:59:50","lastModifyTime":"2025-04-09 06:59:50","id":2587638598652133522,"merchantNo":"10091040477"},
{"createTime":"2025-04-09 06:59:50","lastModifyTime":"2025-04-09 06:59:50","id":2587638598653706425,"merchantNo":"10091041645"},
{"createTime":"2025-04-09 06:59:54","lastModifyTime":"2025-04-09 06:59:54","id":2587638667371872287,"merchantNo":"10091043004"},
{"createTime":"2025-04-09 06:59:55","lastModifyTime":"2025-04-09 06:59:55","id":2587638684551217216,"merchantNo":"10091045244"},
{"createTime":"2025-04-09 06:59:55","lastModifyTime":"2025-04-09 06:59:55","id":2587638684551479411,"merchantNo":"10091045344"},
{"createTime":"2025-04-09 06:59:55","lastModifyTime":"2025-04-09 06:59:55","id":2587638684551741457,"merchantNo":"10091045293"}
]
查询计划：
|id|estRows|task|access object|operator info|
|---|---|---|---|---|
|Point_Get_1|1.00|root|table:tbl_rebate_settle_info|handle:2426235565659127819|
表结构：
CREATE TABLE `tbl_rebate_settle_info` (
`id` bigint(20) NOT NULL,
`optimistic` smallint(6) NOT NULL,
`create_time` datetime(6) NOT NULL,
`last_modify_time` datetime(6) NOT NULL,
`merchant_no` varchar(32) NOT NULL,
`settle_cycle` varchar(32) NOT NULL,
`status` varchar(32) NOT NULL,
`settlement_method` varchar(32) DEFAULT 'AUTO',
`fund_handle_strategy` varchar(32) DEFAULT NULL,
`settle_target` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */,
UNIQUE KEY `idx_rsi_mn` (`merchant_no`),
KEY `idx_rsi_ct` (`create_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
其他信息：
还有一种方式开启general_log拿一下真是sql，不排除是程序问题，没有传对值或者传值有截断。或者程序和手工查的不是一个库 
