为提高效率,请提供以下信息,问题描述清晰能够更快得到解决:
【 TiDB 使用环境】
【概述】场景+问题概述
【背景】做过哪些操作
tidb从v5.0.3升级到v5.3.0
【现象】业务和数据库现象
dashboard的sql语句分析页面和慢查询页面报错。如图
【业务影响】
暂时未发现影响。
【TiDB 版本】
【附件】
- 相关日志 和 监控
直接使用root账号,DBeaver访问也报错。
[2021/12/11 10:14:18.973 +08:00] [WARN] [coprocessor.go:914] ["other error"] [conn=56097] [txnStartTS=429703524231413776] [regionID=0] [storeAddr=10.205.200.97:10080] [error="other error: Column ID 90 of table cluster_statements_summary_history not found"]
[2021/12/11 10:14:18.973 +08:00] [INFO] [conn.go:1069] ["command dispatched failed"] [conn=56097] [connInfo="id:56097, addr:xx.xx.xx.xx:65403 status:10, collation:utf8_general_ci, user:root"] [command=Query] [status="inTxn:0, autocommit:1"] [sql="/* ApplicationName=DBeaver 21.2.0 - SQLEditor <Script-8.sql> */ select * from INFORMATION_SCHEMA.CLUSTER_STATEMENTS_SUMMARY_HISTORY\r\
\
LIMIT 0, 200"] [txn_mode=PESSIMISTIC] [err="other error: Column ID 90 of table cluster_statements_summary_history not found\
github.com/pingcap/tidb/store/copr.(*copIteratorWorker).handleCopResponse\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/store/copr/coprocessor.go:913\
github.com/pingcap/tidb/store/copr.(*copIteratorWorker).handleTaskOnce\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/store/copr/coprocessor.go:755\
github.com/pingcap/tidb/store/copr.(*copIteratorWorker).handleTask\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/store/copr/coprocessor.go:645\
github.com/pingcap/tidb/store/copr.(*copIteratorWorker).run\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/store/copr/coprocessor.go:382\
runtime.goexit\
\t/usr/local/go/src/runtime/asm_amd64.s:1371"]
mysql客户端登录访问,也是偶尔报错
MySQL [test]> select * from INFORMATION_SCHEMA.CLUSTER_STATEMENTS_SUMMARY_HISTORY limit 1;
ERROR 1105 (HY000): other error: Column ID 90 of table cluster_statements_summary_history not found
MySQL [test]>
-
TiUP Cluster Display 信息
-
TiUP Cluster Edit Config 信息
-
TiDB- Overview 监控
- 对应模块日志(包含问题前后1小时日志)