执行SQL报错

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。

  • 【TiDB 版本】:3.0
  • 【问题描述】:执行SQL报错,查看tidb日志文件,有如下报错信息:
    [2020/06/30 11:40:58.418 +08:00] [INFO] [region_cache.go:548] [“switch region leader to specific leader due to kv return NotLeader”] [regionID=47617] [currIdx=0] [leaderStoreID=2]

[2020/06/30 11:40:58.419 +08:00] [INFO] [region_cache.go:295] [“invalidate current region, because others failed on same store”] [region=47617] [store=10.19.169.67:20160]

[2020/06/30 11:40:58.421 +08:00] [INFO] [region_cache.go:548] [“switch region leader to specific leader due to kv return NotLeader”] [regionID=47617] [currIdx=0] [leaderStoreID=2]

[2020/06/30 11:40:58.439 +08:00] [INFO] [region_cache.go:548] [“switch region leader to specific leader due to kv return NotLeader”] [regionID=47617] [currIdx=0] [leaderStoreID=2]

还有如下错误信息:

[2020/06/30 11:40:58.511 +08:00] [INFO] [region_cache.go:548] [“switch region leader to specific leader due to kv return NotLeader”] [regionID=47569] [currIdx=0] [leaderStoreID=7]

[2020/06/30 11:40:58.503 +08:00] [INFO] [region_cache.go:401] [“switch region peer to next due to send request fail”] [conn=1] [current=“region ID: 47569, meta: id:47569 start_key:“t\200\000\000\000\000\000\n[_r\200\000\000\000\0007|\375” end_key:“t\200\000\000\000\000\000\n[_r\200\000\000\000\000:\246\232” region_epoch:<conf_ver:5 version:6308 > peers:<id:47570 store_id:1 > peers:<id:47571 store_id:2 > peers:<id:47572 store_id:7 > , peer: id:47572 store_id:7 , addr: 10.19.169.68:20160, idx: 2”] [needReload=false] [error=“rpc error: code = ResourceExhausted desc = Received message larger than max (11131466 vs. 10485760)”] [errorVerbose=“rpc error: code = ResourceExhausted desc = Received message larger than max (11131466 vs. 10485760)\ngithub.com/pingcap/errors.AddStack\n\t/home/jenkins/agent/workspace/tidb_v3.0.11/go/pkg/mod/github.com/pingcap/errors@v0.11.4/errors.go:174\ngithub.com/pingcap/errors.Trace\n\t/home/jenkins/agent/workspace/tidb_v3.0.11/go/pkg/mod/github.com/pingcap/errors@v0.11.4/juju_adaptor.go:15\ngithub.com/pingcap/tidb/store/tikv.sendBatchRequest\n\t/home/jenkins/agent/workspace/tidb_v3.0.11/go/src/github.com/pingcap/tidb/store/tikv/client_batch.go:585\ngithub.com/pingcap/tidb/store/tikv.(*rpcClient).SendRequest\n\t/home/jenkins/agent/workspace/tidb_v3.0.11/go/src/github.com/pingcap/tidb/store/tikv/client.go:287\ngithub.com/pingcap/tidb/store/tikv.(*RegionRequestSender).sendReqToRegion\n\t/home/jenkins/agent/workspace/tidb_v3.0.11/go/src/github.com/pingcap/tidb/store/tikv/region_request.go:166\ngithub.com/pingcap/tidb/store/tikv.(*RegionRequestSender).SendReqCtx\n\t/home/jenkins/agent/workspace/tidb_v3.0.11/go/src/github.com/pingcap/tidb/store/tikv/region_request.go:130\ngithub.com/pingcap/tidb/store/tikv.(*copIteratorWorker).handleTaskOnce\n\t/home/jenkins/agent/workspace/tidb_v3.0.11/go/src/github.com/pingcap/tidb/store/tikv/coprocessor.go:685\ngithub.com/pingcap/tidb/store/tikv.(*copIteratorWorker).handleTask\n\t/home/jenkins/agent/workspace/tidb_v3.0.11/go/src/github.com/pingcap/tidb/store/tikv/coprocessor.go:645\ngithub.com/pingcap/tidb/store/tikv.(*copIteratorWorker).run\n\t/home/jenkins/agent/workspace/tidb_v3.0.11/go/src/github.com/pingcap/tidb/store/tikv/coprocessor.go:475\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1357”]tidb日志文件报错信息.txt (102.8 KB)

你好

1/ 确认下当前集群版本为 v3.0.11
2/ 当时 qps 是否有尖峰(升高),相比于正常时间
3/ 当前的业务现象是怎么样的?