为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:4.0.1
- 【问题描述】:tidb-server大并发下重启
查看日志是执行了一条sql后重启的:
[2020/07/10 15:28:35.218 +08:00] [ERROR] [conn.go:728] [“command dispatched failed”] [conn=1173] [connInfo=“id:1173, addr:10.1.2.114:52602 status:10, collation:utf8_general_ci, user:guorou”] [command=Query] [status=“inTxn:0, autocommit:1”] [sql="\
SELECT \
temp.*,\
dense_rank () over (order by temp.num desc) as rank_no\
FROM\
(SELECT student_id,SUM(num) num ,u.username ,u. avatar_oss_id avatar_url\
FROM\
(SELECT student_id, SUM(num) num \
FROM coin_log \
WHERE clazz_plan_id = ‘75800’\
GROUP BY student_id\
UNION ALL\
SELECT student_id, SUM(-num) num \
FROM \
coin_consume_log \
WHERE clazz_plan_id = ‘75800’ AND type NOT IN (‘26’,‘42’)\
GROUP BY student_id\
) as a\
LEFT JOIN users u ON u.id =a.student_id\
GROUP BY student_id\
ORDER BY num DESC LIMIT 0,10) temp\
“] [txn_mode=PESSIMISTIC] [err=”[tikv:9007]Execution terminated due to exceeding the deadline\ngithub.com/pingcap/errors.AddStack\
\t/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20190809092503-95897b64e011/errors.go:174\
github.com/pingcap/errors.Trace\
\t/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20190809092503-95897b64e011/juju_adaptor.go:15\
github.com/pingcap/tidb/executor.(*indexWorker).extractTaskHandles\
\t/home/jenkins/agent/workspace/build-linux-amd64-4.0-githash/go/src/github.com/pingcap/tidb/executor/distsql.go:713\ngithub.com/pingcap/tidb/executor.(*indexWorker).fetchHandles\
\t/home/jenkins/agent/workspace/build-linux-amd64-4.0-githash/go/src/github.com/pingcap/tidb/executor/distsql.go:670\ngithub.com/pingcap/tidb/executor.(*IndexLookUpExecutor).startIndexWorker.func1\
\t/home/jenkins/agent/workspace/build-linux-amd64-4.0-githash/go/src/github.com/pingcap/tidb/executor/distsql.go:485\
runtime.goexit\
\t/usr/local/go/src/runtime/asm_amd64.s:1357"]
[2020/07/10 15:29:51.707 +08:00] [INFO] [printer.go:42] [“Welcome to TiDB.”] [“Release Version”=v4.0.1] [Edition=Community] [“Git Commit Hash”=689a6b6439ae7835947fcaccf329a3fc303986cb] [“Git Branch”=heads/v4.0.1] [“UTC Build Time”=“2020-06-15 03:54:18”] [GoVersion=go1.13] [“Race Enabled”=false] [“Check Table Before Drop”=false] [“TiKV Min Version”=v3.0.0-60965b006877ca7234adaced7890d7b029ed1306]
若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出打印结果,请务必全选并复制粘贴上传。