MYSQL-TIDB数据检查异常sync_diff_inspector

[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\ngithub.com/pingcap/errors.AddStack\n\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\ngithub.com/pingcap/errors.Trace\n\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\ngithub.com/pingcap/tidb-tools/pkg/dbutil.GetBucketsInfo\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/dbutil/common.go:433\ngithub.com/pingcap/tidb-tools/pkg/diff.(*bucketSpliter).split\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:297\ngithub.com/pingcap/tidb-tools/pkg/diff.getChunksForTable\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:386\ngithub.com/pingcap/tidb-tools/pkg/diff.SplitChunks\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:449\ngithub.com/pingcap/tidb-tools/pkg/diff.(*TableDiff).CheckTableData\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/diff.go:230\ngithub.com/pingcap/tidb-tools/pkg/diff.(*TableDiff).Equal\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/diff.go:145\nmain.(*Diff).Equal\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/diff.go:416\nmain.checkSyncState\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:79\nmain.main\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:62\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:203\nruntime.goexit\n\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\ngithub.com/pingcap/errors.AddStack\n\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\ngithub.com/pingcap/errors.Trace\n\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\ngithub.com/pingcap/tidb-tools/pkg/dbutil.GetRandomValues\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/dbutil/common.go:226\ngithub.com/pingcap/tidb-tools/pkg/diff.splitRangeByRandom\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:255\ngithub.com/pingcap/tidb-tools/pkg/diff.(*randomSpliter).split\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:235\ngithub.com/pingcap/tidb-tools/pkg/diff.getChunksForTable\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:396\ngithub.com/pingcap/tidb-tools/pkg/diff.SplitChunks\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:449\ngithub.com/pingcap/tidb-tools/pkg/diff.(*TableDiff).CheckTableData\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/diff.go:230\ngithub.com/pingcap/tidb-tools/pkg/diff.(*TableDiff).Equal\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/diff.go:145\nmain.(*Diff).Equal\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/diff.go:416\nmain.checkSyncState\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:79\nmain.main\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:62\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:203\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1357”] [stack=“github.com/pingcap/log.Error\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/pkg/mod/github.com/pingcap/log@v0.0.0-20191012051959-b742a5d432e9/global.go:42\nmain.(*Diff).Equal\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/diff.go:422\nmain.checkSyncState\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:79\nmain.main\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:62\nruntime.main\n\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\ngithub.com/pingcap/errors.AddStack\n\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\ngithub.com/pingcap/errors.Trace\n\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\ngithub.com/pingcap/tidb-tools/pkg/dbutil.GetRandomValues\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/dbutil/common.go:226\ngithub.com/pingcap/tidb-tools/pkg/diff.splitRangeByRandom\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:255\ngithub.com/pingcap/tidb-tools/pkg/diff.(*randomSpliter).split\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:235\ngithub.com/pingcap/tidb-tools/pkg/diff.getChunksForTable\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:396\ngithub.com/pingcap/tidb-tools/pkg/diff.SplitChunks\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/chunk.go:449\ngithub.com/pingcap/tidb-tools/pkg/diff.(*TableDiff).CheckTableData\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/diff.go:230\ngithub.com/pingcap/tidb-tools/pkg/diff.(*TableDiff).Equal\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/pkg/diff/diff.go:145\nmain.(*Diff).Equal\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/diff.go:416\nmain.checkSyncState\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:79\nmain.main\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:62\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:203\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1357”] [stack=“github.com/pingcap/log.Fatal\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/pkg/mod/github.com/pingcap/log@v0.0.0-20191012051959-b742a5d432e9/global.go:59\nmain.checkSyncState\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:81\nmain.main\n\t/home/jenkins/agent/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:62\nruntime.main\n\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

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

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

[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(...)\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/util/misc.go:60\ngithub.com/pingcap/tidb/executor.recoveryProjection(0xc3fef2cd90, 0x1a46ae0, 0x2c0c680)\n\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)\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/projection.go:347 +0x4e\npanic(0x1a46ae0, 0x2c0c680)\n\t/usr/local/go/src/runtime/panic.go:522 +0x1b5\nmath/rand.(*rngSource).Uint64(…)\n\t/usr/local/go/src/math/rand/rng.go:249\nmath/rand.(*rngSource).Int63(0xc9876bb500, 0x2e268a43ded78e26)\n\t/usr/local/go/src/math/rand/rng.go:234 +0x8a\nmath/rand.(*Rand).Int63(…)\n\t/usr/local/go/src/math/rand/rand.go:85\nmath/rand.(*Rand).Float64(…)\n\t/usr/local/go/src/math/rand/rand.go:196\ngithub.com/pingcap/tidb/expression.(*builtinRandSig).evalReal(0xc011ca6b40, 0xc042a69bc0, 0x9, 0x48, 0xc621972b60, 0x0, 0xc064545600)\n\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)\n\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, …)\n\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)\n\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)\n\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)\n\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)\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/projection.go:361 +0x110\ncreated by github.com/pingcap/tidb/executor.(*ProjectionExec).prepare\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/projection.go:245 +0x71a\n”] [stack=“github.com/pingcap/tidb/executor.recoveryProjection\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/projection.go:377\ngithub.com/pingcap/tidb/executor.(*projectionWorker).run.func1\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/projection.go:347\nruntime.gopanic\n\t/usr/local/go/src/runtime/panic.go:522\nruntime.panicindex\n\t/usr/local/go/src/runtime/panic.go:44\nmath/rand.(*rngSource).Uint64\n\t/usr/local/go/src/math/rand/rng.go:249\nmath/rand.(*rngSource).Int63\n\t/usr/local/go/src/math/rand/rng.go:234\nmath/rand.(*Rand).Int63\n\t/usr/local/go/src/math/rand/rand.go:85\nmath/rand.(*Rand).Float64\n\t/usr/local/go/src/math/rand/rand.go:196\ngithub.com/pingcap/tidb/expression.(*builtinRandSig).evalReal\n\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\n\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\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/chunk_executor.go:144\ngithub.com/pingcap/tidb/expression.evalOneColumn\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/chunk_executor.go:76\ngithub.com/pingcap/tidb/expression.(*defaultEvaluator).run\n\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\n\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\n\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\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/projection.go:374\ngithub.com/pingcap/tidb/executor.(*projectionWorker).run.func1\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/projection.go:347\nruntime.gopanic\n\t/usr/local/go/src/runtime/panic.go:522\nruntime.panicindex\n\t/usr/local/go/src/runtime/panic.go:44\nmath/rand.(*rngSource).Uint64\n\t/usr/local/go/src/math/rand/rng.go:249\nmath/rand.(*rngSource).Int63\n\t/usr/local/go/src/math/rand/rng.go:234\nmath/rand.(*Rand).Int63\n\t/usr/local/go/src/math/rand/rand.go:85\nmath/rand.(*Rand).Float64\n\t/usr/local/go/src/math/rand/rand.go:196\ngithub.com/pingcap/tidb/expression.(*builtinRandSig).evalReal\n\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\n\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\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/chunk_executor.go:144\ngithub.com/pingcap/tidb/expression.evalOneColumn\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/expression/chunk_executor.go:76\ngithub.com/pingcap/tidb/expression.(*defaultEvaluator).run\n\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\n\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\n\t/home/jenkins/workspace/release_tidb_2.1-ga/go/src/github.com/pingcap/tidb/executor/projection.go:361\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1337”]

你好,这个问题在最新的 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 之上吗?如何判断呢?

已经是最新了,,,

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

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

试下这个

一样的 有问题的,,,同时引入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\n\t/home/jenkins/workspace/release_tidb_2.1/go/pkg/mod/github.com/pingcap/errors@v0.11.1/errors.go:174\ngithub.com/pingcap/errors.Trace\n\t/home/jenkins/workspace/release_tidb_2.1/go/pkg/mod/github.com/pingcap/errors@v0.11.1/juju_adaptor.go:15\ngithub.com/pingcap/tidb-tools/pkg/dbutil.GetCRC32Checksum\n\t/home/jenkins/workspace/release_tidb_2.1/go/src/github.com/pingcap/tidb-tools/pkg/dbutil/common.go:400\ngithub.com/pingcap/tidb-tools/pkg/diff.(*TableDiff).getSourceTableChecksum\n\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\n\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\n\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\n\t/home/jenkins/workspace/release_tidb_2.1/go/src/github.com/pingcap/tidb-tools/pkg/diff/diff.go:360\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1337”] [stack=“github.com/pingcap/log.Error\n\t/home/jenkins/workspace/release_tidb_2.1/go/pkg/mod/github.com/pingcap/log@v0.0.0-20190307075452-bd41d9273596/global.go:42\ngithub.com/pingcap/tidb-tools/pkg/diff.(*TableDiff).checkChunksDataEqual\n\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 设置。

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

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