replace 插入数据失败

[TiDBer_yyy]

【概述】 使用 sync-diff-inspector 校验两个tidb集群数据是否一致
结果数据不一致，执行replace语句后写入失败。

唯一键：

  PRIMARY KEY (`I_ID`) /*T![clustered_index] CLUSTERED */,
  UNIQUE KEY `FSI` (`I_FILE_ID`,`I_CHANNEL_ID`),

ERROR 1105 (HY000) at line 40950: can not be duplicated row, due to old row not found. handle 2396698 not found
ERROR 1105 (HY000) at line 40951: can not be duplicated row, due to old row not found. handle 2396699 not found
ERROR 1105 (HY000) at line 40952: can not be duplicated row, due to old row not found. handle 2396700 not found
ERROR 1105 (HY000) at line 40953: can not be duplicated row, due to old row not found. handle 2396701 not found
ERROR 1105 (HY000) at line 40956: can not be duplicated row, due to old row not found. handle 2396704 not found
ERROR 1105 (HY000) at line 40957: can not be duplicated row, due to old row not found. handle 2396705 not found
ERROR 1105 (HY000) at line 40964: can not be duplicated row, due to old row not found. handle 2396712 not found

[gary (feng)]

@TiDBer_yangky

PRIMARY KEY (I_ID)

数据不一致为啥要用replace插入呢？

[TiDBer_yyy]

sync-diff-inspector 校验 结果会生成replace语句

[xiaohetao (Becky)]

@TiDBer_yangky

handle 2396701 not found

集群中查询数据不存在？check-struct-only 参数怎么配置的呀？ 配置文件拿出来看看

[gary (feng)]

是在测试环境吗？
业务环境可能统计信息不准确，要手动执行 analyze table {table_name}再对比看看

[TiDBer_yyy]

参考：双云灾备建设，使用sync-diff-inspector 工具校验后，replace补数据执行失败

[TiDBer_yyy]

大佬可参考另一个帖子：双云灾备建设，使用sync-diff-inspector 工具校验后，replace补数据执行失败

[TiDBer_yyy]

2396701 值为主键值

[xiaohetao (Becky)]

看了楼上老师发的帖子链接， admin check recover 或者重建 索引解决

你用那种方式解决的？

[TiDBer_yyy]

重建索引

[xiaohetao (Becky)]

了解了

[alfred]

索引和数据不一致的问题，bug吧？