Tidb-ansible-3.0.2 在跑sql时报错

  1. 错误:[2019/09/19 00:16:41.718 +08:00] [WARN] [pd.go:109] [“get timestamp too slow”] [conn=43018] [“cost time”=305.212183ms]

2.[2019/09/19 00:16:41.834 +08:00] [WARN] [builtin_string.go:269] [“unexpected Flen value(-1) in CONCAT’s args”] [“arg’s index”=1]

3.[2019/09/19 00:16:41.867 +08:00] [ERROR] [distsql.go:918] [“table reader fetch next chunk failed”] [conn=42952] [error=“context canceled”] [errorVerbose=“context canceled github.com/pingcap/errors.AddStack /home/jenkins/workspace/release_tidb_3.0/go/pkg/mod/github.com/pingcap/errors@v0.11.4/errors.go:174 github.com/pingcap/errors.Trace /home/jenkins/workspace/release_tidb_3.0/go/pkg/mod/github.com/pingcap/errors@v0.11.4/juju_adaptor.go:15 github.com/pingcap/tidb/store/tikv.sendBatchRequest /home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/store/tikv/client_batch.go:506 github.com/pingcap/tidb/store/tikv.(*rpcClient).SendRequest /home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/store/tikv/client.go:287 github.com/pingcap/tidb/store/tikv.(*RegionRequestSender).sendReqToRegion /home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/store/tikv/region_request.go:145 github.com/pingcap/tidb/store/tikv.(*RegionRequestSender).SendReqCtx /home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/store/tikv/region_request.go:116 github.com/pingcap/tidb/store/tikv.(*copIteratorWorker).handleTaskOnce /home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/store/tikv/coprocessor.go:668 github.com/pingcap/tidb/store/tikv.(*copIteratorWorker).handleTask /home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/store/tikv/coprocessor.go:628 github.com/pingcap/tidb/store/tikv.(*copIteratorWorker).run /home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/store/tikv/coprocessor.go:467 runtime.goexit /usr/local/go/src/runtime/asm_amd64.s:1337”] [stack=“github.com/pingcap/tidb/executor.(*tableWorker).executeTask /home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/executor/distsql.go:918 github.com/pingcap/tidb/executor.(*tableWorker).pickAndExecTask /home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/executor/distsql.go:829 github.com/pingcap/tidb/executor.(*IndexLookUpExecutor).startTableWorker.func2 /home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/executor/distsql.go:554”]

4.[2019/09/19 00:16:41.287 +08:00] [ERROR] [distsql.go:956] [“inconsistent index handles”] [conn=42033] [index=PRIMARY] [index_cnt=1] [table_cnt=0] [missing_handles="[243704]"] [total_handles="[243704]"] [stack=“github.com/pingcap/tidb/executor.(*tableWorker).executeTask /home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/executor/distsql.go:956 github.com/pingcap/tidb/executor.(*tableWorker).pickAndExecTask /home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/executor/distsql.go:829 github.com/pingcap/tidb/executor.(*IndexLookUpExecutor).startTableWorker.func2 /home/jenkins/workspace/release_tidb_3.0/go/src/github.com/pingcap/tidb/executor/distsql.go:554”]

帮看一下以上错误大概什么原因导致的,有什么排查的思路。

辛苦按照提问模版提供下版本信息,另外检查下集群是否有大查询、以及负载情况。可以看下 coprocessor 监控情况是否存在异常