MYSQL-TIDB数据检查异常sync_diff_inspector

[Hacker_pAoOWq9O (入坑用户)]

[2020/07/22 15:46:50.687 +08:00] [WARN] [chunk.go:391] [“use tidb bucket information to get chunks failed, will split chunk by random again”] [“get chunk”=0] [error=“Error 1105: invalid encoded key flag 250”] [errorVerbose=“Error 1105: invalid encoded key flag 250
github.com/pingcap/errors.AddStack
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20190809092503-95897b64e011/errors.go:174
github.com/pingcap/errors.Trace
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20190809092503-95897b64e011/juju_adaptor.go:15
github.com/pingcap/tidb-tools/pkg/dbutil.GetBucketsInfo
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/dbutil/common.go:433
github.com/pingcap/tidb-tools/pkg/diff.(*bucketSpliter).split
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:297
github.com/pingcap/tidb-tools/pkg/diff.getChunksForTable
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:386
github.com/pingcap/tidb-tools/pkg/diff.SplitChunks
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:449
github.com/pingcap/tidb-tools/pkg/diff.(*TableDiff).CheckTableData
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/diff.go:230
github.com/pingcap/tidb-tools/pkg/diff.(*TableDiff).Equal
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/diff.go:145
main.(*Diff).Equal
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/diff.go:416
main.checkSyncState
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:79
main.main
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:62
runtime.main
\t/usr/local/go/src/runtime/proc.go:203
runtime.goexit
\t/usr/local/go/src/runtime/asm_amd64.s:1357”]
[2020/07/22 15:46:51.117 +08:00] [ERROR] [diff.go:422] [“check failed”] [table=db_xxx.tbl_xxx] [error=“Error 1105: runtime error: index out of range”] [errorVerbose=“Error 1105: runtime error: index out of range
github.com/pingcap/errors.AddStack
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20190809092503-95897b64e011/errors.go:174
github.com/pingcap/errors.Trace
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20190809092503-95897b64e011/juju_adaptor.go:15
github.com/pingcap/tidb-tools/pkg/dbutil.GetRandomValues
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/dbutil/common.go:226
github.com/pingcap/tidb-tools/pkg/diff.splitRangeByRandom
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:255
github.com/pingcap/tidb-tools/pkg/diff.(*randomSpliter).split
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:235
github.com/pingcap/tidb-tools/pkg/diff.getChunksForTable
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:396
github.com/pingcap/tidb-tools/pkg/diff.SplitChunks
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:449
github.com/pingcap/tidb-tools/pkg/diff.(*TableDiff).CheckTableData
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/diff.go:230
github.com/pingcap/tidb-tools/pkg/diff.(*TableDiff).Equal
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/diff.go:145
main.(*Diff).Equal
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/diff.go:416
main.checkSyncState
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:79
main.main
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:62
runtime.main
\t/usr/local/go/src/runtime/proc.go:203
runtime.goexit
\t/usr/local/go/src/runtime/asm_amd64.s:1357”] [stack=“github.com/pingcap/log.Error
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/pkg/mod/github.com/pingcap/log@v0.0.0-20191012051959-b742a5d432e9/global.go:42
main.(*Diff).Equal
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/diff.go:422
main.checkSyncState
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:79
main.main
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:62
runtime.main
\t/usr/local/go/src/runtime/proc.go:203”]
[2020/07/22 15:46:51.117 +08:00] [FATAL] [main.go:81] [“check data difference failed”] [error=“Error 1105: runtime error: index out of range”] [errorVerbose=“Error 1105: runtime error: index out of range
github.com/pingcap/errors.AddStack
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20190809092503-95897b64e011/errors.go:174
github.com/pingcap/errors.Trace
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20190809092503-95897b64e011/juju_adaptor.go:15
github.com/pingcap/tidb-tools/pkg/dbutil.GetRandomValues
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/dbutil/common.go:226
github.com/pingcap/tidb-tools/pkg/diff.splitRangeByRandom
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:255
github.com/pingcap/tidb-tools/pkg/diff.(*randomSpliter).split
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:235
github.com/pingcap/tidb-tools/pkg/diff.getChunksForTable
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:396
github.com/pingcap/tidb-tools/pkg/diff.SplitChunks
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:449
github.com/pingcap/tidb-tools/pkg/diff.(*TableDiff).CheckTableData
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/diff.go:230
github.com/pingcap/tidb-tools/pkg/diff.(*TableDiff).Equal
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/diff.go:145
main.(*Diff).Equal
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/diff.go:416
main.checkSyncState
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:79
main.main
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:62
runtime.main
\t/usr/local/go/src/runtime/proc.go:203
runtime.goexit
\t/usr/local/go/src/runtime/asm_amd64.s:1357”] [stack=“github.com/pingcap/log.Fatal
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/pkg/mod/github.com/pingcap/log@v0.0.0-20191012051959-b742a5d432e9/global.go:59
main.checkSyncState
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:81
main.main
\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:62
runtime.main
\t/usr/local/go/src/runtime/proc.go:203”]

[来了老弟]

先看下 sync-diff-inspector 的版本。
https://download.pingcap.org/tidb-toolkit-v3.0.16-linux-amd64.tar.gz

[Hacker_pAoOWq9O (入坑用户)]

@户口舟亢

https://download.pingcap.org/tidb-toolkit-v3.0.16-linux-amd64.tar.gz

有同样的报错，但任务还在继续跑

[来了老弟]

看下 15:46:50左右的 tidb log

[Hacker_pAoOWq9O (入坑用户)]

[2020/07/23 16:43:37.620 +08:00] [ERROR] [projection.go:377] [“projection executor panicked”] [error=“runtime error: index out of range”] [stack=“goroutine 4197374114 [running]:\ngithub.com/pingcap/tidb/util.GetStack(...)\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/util/misc.go:60\ github.com/pingcap/tidb/executor.recoveryProjection(0xc3fef2cd90, 0x1a46ae0, 0x2c0c680)\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/projection.go:376 +0x90\ngithub.com/pingcap/tidb/executor.(*projectionWorker).run.func1(0xc0013dd790)\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/projection.go:347 +0x4e\ panic(0x1a46ae0, 0x2c0c680)\ \t/usr/local/go/src/runtime/panic.go:522 +0x1b5\ math/rand.(*rngSource).Uint64(…)\ \t/usr/local/go/src/math/rand/rng.go:249\ math/rand.(*rngSource).Int63(0xc9876bb500, 0x2e268a43ded78e26)\ \t/usr/local/go/src/math/rand/rng.go:234 +0x8a\ math/rand.(*Rand).Int63(…)\ \t/usr/local/go/src/math/rand/rand.go:85\ math/rand.(*Rand).Float64(…)\ \t/usr/local/go/src/math/rand/rand.go:196\ngithub.com/pingcap/tidb/expression.(*builtinRandSig).evalReal(0xc011ca6b40, 0xc042a69bc0, 0x9, 0x48, 0xc621972b60, 0x0, 0xc064545600)\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/builtin_math.go:1004 +0x45\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).EvalReal(0xc0189977c0, 0x1e9dda0, 0xc3fe915ea0, 0xc042a69bc0, 0x9, 0x3fd7134521ef6bc7, 0x0, 0x0, 0x0)\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/scalar_function.go:233 +0x48\ngithub.com/pingcap/tidb/expression.executeToReal(0x1e9dda0, 0xc3fe915ea0, 0x1e9fc60, 0xc0189977c0, 0xc0b76e8ea0, 0xc042a69bc0, 0x9, 0xc042a69b90, 0x1, 0x0, …)\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/chunk_executor.go:144 +0x63\ngithub.com/pingcap/tidb/expression.evalOneColumn(0x1e9dda0, 0xc3fe915ea0, 0x1e9fc60, 0xc0189977c0, 0xc5f1876ee8, 0xc042a69b90, 0x1, 0x17e4d03, 0xc0013dd6f0)\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/chunk_executor.go:76 +0x343\ngithub.com/pingcap/tidb/expression.(*defaultEvaluator).run(0xc011ca6d00, 0x1e9dda0, 0xc3fe915ea0, 0xc042a69bc0, 0xc042a69b90, 0x0, 0x0)\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/evaluator.go:48 +0x30d\ngithub.com/pingcap/tidb/expression.(*EvaluatorSuite).Run(0xc3aacba900, 0x1e9dda0, 0xc3fe915ea0, 0xc042a69bc0, 0xc042a69b90, 0x0, 0x0)\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/evaluator.go:114 +0xad\ngithub.com/pingcap/tidb/executor.(*projectionWorker).run(0xc011ed6100, 0x1e6b540, 0xc07b0e4c30)\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/projection.go:361 +0x110\ created by github.com/pingcap/tidb/executor.(*ProjectionExec).prepare\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/projection.go:245 +0x71a\ ”] [stack=“github.com/pingcap/tidb/executor.recoveryProjection\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/projection.go:377\ github.com/pingcap/tidb/executor.(*projectionWorker).run.func1\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/projection.go:347\ runtime.gopanic\ \t/usr/local/go/src/runtime/panic.go:522\ runtime.panicindex\ \t/usr/local/go/src/runtime/panic.go:44\ math/rand.(*rngSource).Uint64\ \t/usr/local/go/src/math/rand/rng.go:249\ math/rand.(*rngSource).Int63\ \t/usr/local/go/src/math/rand/rng.go:234\ math/rand.(*Rand).Int63\ \t/usr/local/go/src/math/rand/rand.go:85\ math/rand.(*Rand).Float64\ \t/usr/local/go/src/math/rand/rand.go:196\ngithub.com/pingcap/tidb/expression.(*builtinRandSig).evalReal\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/builtin_math.go:1004\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).EvalReal\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/scalar_function.go:233\ngithub.com/pingcap/tidb/expression.executeToReal\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/chunk_executor.go:144\ github.com/pingcap/tidb/expression.evalOneColumn\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/chunk_executor.go:76\ github.com/pingcap/tidb/expression.(*defaultEvaluator).run\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/evaluator.go:48\ngithub.com/pingcap/tidb/expression.(*EvaluatorSuite).Run\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/evaluator.go:114\ngithub.com/pingcap/tidb/executor.(*projectionWorker).run\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/projection.go:361”]
[2020/07/23 16:43:37.621 +08:00] [WARN] [conn.go:520] [“dispatch error”] [conn=142380979] [connInfo=“id:142380979, addr:xxx:46694 status:2, collation:utf8_general_ci, user:crm_write”] [sql="SELECT itemID FROM (SELECT itemID, rand() rand_value FROM db_shopcrm_015.tbl_promotion_food_scope WHERE TRUE AND TRUE ORDER BY rand_value LIMIT 64)rand_tmp ORDER BY itemID"] [err=“runtime error: index out of range\ngithub.com/pingcap/tidb/executor.recoveryProjection\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/projection.go:374\ github.com/pingcap/tidb/executor.(*projectionWorker).run.func1\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/projection.go:347\ runtime.gopanic\ \t/usr/local/go/src/runtime/panic.go:522\ runtime.panicindex\ \t/usr/local/go/src/runtime/panic.go:44\ math/rand.(*rngSource).Uint64\ \t/usr/local/go/src/math/rand/rng.go:249\ math/rand.(*rngSource).Int63\ \t/usr/local/go/src/math/rand/rng.go:234\ math/rand.(*Rand).Int63\ \t/usr/local/go/src/math/rand/rand.go:85\ math/rand.(*Rand).Float64\ \t/usr/local/go/src/math/rand/rand.go:196\ngithub.com/pingcap/tidb/expression.(*builtinRandSig).evalReal\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/builtin_math.go:1004\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).EvalReal\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/scalar_function.go:233\ngithub.com/pingcap/tidb/expression.executeToReal\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/chunk_executor.go:144\ github.com/pingcap/tidb/expression.evalOneColumn\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/chunk_executor.go:76\ github.com/pingcap/tidb/expression.(*defaultEvaluator).run\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/evaluator.go:48\ngithub.com/pingcap/tidb/expression.(*EvaluatorSuite).Run\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/evaluator.go:114\ngithub.com/pingcap/tidb/executor.(*projectionWorker).run\ \t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/projection.go:361\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1337”]

[cfzjywxk]

你好，这个问题在最新的 release-2.1 版本应该已经修复 https://github.com/pingcap/tidb/pull/11170，可否升级到最新 release-2.1 版本试一试？

[来了老弟]

@cfzjywxk-PingCAP 提供下下载链接?
https://download.pingcap.org/tidb-toolkit-v3.0.16-linux-amd64.tar.gz
是在release-2.1 之上吗？如何判断呢？

[Hacker_pAoOWq9O (入坑用户)]

已经是最新了，，，

[不懂就问 (zhouyueyue)]

辛苦提供下版本信息，我们再检查下修复的版本。

[Hacker_pAoOWq9O (入坑用户)]

https://download.pingcap.org/tidb-toolkit-v3.0.16-linux-amd64.tar.gz

就是链接提供的这个版本，，，，

[来了老弟]

https://download.pingcap.org/tidb-tools-v2.1.17-linux-amd64.tar.gz

试下这个

[Hacker_pAoOWq9O (入坑用户)]

一样的 有问题的，，，同时引入collation 这个也有些问题，，
[2020/07/28 16:06:30.186 +08:00] [ERROR] [diff.go:362] [“check chunk data equal failed”] [chunk="{“id”:2,“bounds”:[{“column”:“shopID”,“lower”:“76088123”,“lower-symbol”:"\u003e=",“upper”:“76657008”,“upper-symbol”:"\u003c="}],“mode”:“normalMode”,“where”:"(shopID COLLATE ‘utf8mb4_general_ci’ \u003e= ? AND shopID COLLATE ‘utf8mb4_general_ci’ \u003c= ? AND createStamp\u003e=‘2018-01-01 01:01:01’ and createStamp\u003c’2020-07-26 23:59:59’)",“args”:[“76088123”,“76657008”],“state”:“error”}"] [error=“Error 1253: COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘latin1’”] [errorVerbose=“Error 1253: COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘latin1’\ngithub.com/pingcap/errors.AddStack\ \t/home/jenkins/workspace/release_tidb_2.1/go/pkg/mod/github.com/pingcap/errors@v0.11.1/errors.go:174\ github.com/pingcap/errors.Trace\ \t/home/jenkins/workspace/release_tidb_2.1/go/pkg/mod/github.com/pingcap/errors@v0.11.1/juju_adaptor.go:15\ github.com/pingcap/tidb-tools/pkg/dbutil.GetCRC32Checksum\ \t/home/jenkins/workspace/release_tidb_2.1/go/src/github.com/pingcap/tidb-tools/pkg/dbutil/common.go:400\ github.com/pingcap/tidb-tools/pkg/diff.(*TableDiff).getSourceTableChecksum\ \t/home/jenkins/workspace/release_tidb_2.1/go/src/github.com/pingcap/tidb-tools/pkg/diff/diff.go:339\ngithub.com/pingcap/tidb-tools/pkg/diff.(*TableDiff).compareChecksum\ \t/home/jenkins/workspace/release_tidb_2.1/go/src/github.com/pingcap/tidb-tools/pkg/diff/diff.go:440\ngithub.com/pingcap/tidb-tools/pkg/diff.(*TableDiff).checkChunkDataEqual\ \t/home/jenkins/workspace/release_tidb_2.1/go/src/github.com/pingcap/tidb-tools/pkg/diff/diff.go:414\ngithub.com/pingcap/tidb-tools/pkg/diff.(*TableDiff).checkChunksDataEqual\ \t/home/jenkins/workspace/release_tidb_2.1/go/src/github.com/pingcap/tidb-tools/pkg/diff/diff.go:360\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1337”] [stack=“github.com/pingcap/log.Error\ \t/home/jenkins/workspace/release_tidb_2.1/go/pkg/mod/github.com/pingcap/log@v0.0.0-20190307075452-bd41d9273596/global.go:42\ github.com/pingcap/tidb-tools/pkg/diff.(*TableDiff).checkChunksDataEqual\ \t/home/jenkins/workspace/release_tidb_2.1/go/src/github.com/pingcap/tidb-tools/pkg/diff/diff.go:362”]

[来了老弟]

• TiDB 使用的 collation 为 utf8_bin 。如果对 MySQL 和 TiDB 的数据进行对比，需要注意 MySQL 中表的 collation 设置。如果表的主键／唯一键为 varchar 类型，且 MySQL 中 collation 设置与 TiDB 不同，可能会因为排序问题导致最终校验结果不正确，需要在 sync-diff-inspector 的配置文件中增加 collation 设置。

@Hacker_pAoOWq9O

一样的 有问题的，，，同时引入collation 这个也有些问题，，

辛苦看下上面 panic 的信息，是否可以提供完成的日志我们看下。附件哦~

[来了老弟]

hi，请问下问题是否已经解决