resource_manager_resource_unit 含义?

【 TiDB 使用环境】生产环境 /测试/ Poc
【 TiDB 版本】
【复现路径】做过哪些操作出现的问题
【遇到的问题:问题现象及影响】
【资源配置】进入到 TiDB Dashboard -集群信息 (Cluster Info) -主机(Hosts) 截图此页面
【附件:截图/日志/监控】

Error 1105 (HY000): metrics ‘resource_manager_resource_unit’ is empty
这个报错是什么意思呢?文档里也没找到相关说明

tidb log:
[2023/06/27 23:08:58.552 +08:00] [INFO] [conn.go:1184] [“command dispatched failed”] [conn=7548864206263550385] [connInfo=“id:7548864206263550385, addr:192.168.8.171:53890 status:10, collation:utf8mb4_general_ci, user:root”] [command=Query] [status=“inTxn:0, autocommit:1”] [sql=“calibrate resource start_time ‘2023-06-27 22:38:58’ end_time ‘2023-06-27 23:08:59’”] [txn_mode=PESSIMISTIC] [timestamp=0] [err=“metrics ‘resource_manager_resource_unit’ is empty\ngithub.com/pingcap/tidb/executor.getValuesFromMetrics\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/calibrate_resource.go:343\ngithub.com/pingcap/tidb/executor.getRUPerSec\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/calibrate_resource.go:317\ngithub.com/pingcap/tidb/executor.(*calibrateResourceExec).dynamicCalibrate\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/calibrate_resource.go:214\ngithub.com/pingcap/tidb/executor.(*calibrateResourceExec).Next\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/calibrate_resource.go:193\ngithub.com/pingcap/tidb/executor.Next\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/executor.go:326\ngithub.com/pingcap/tidb/executor.(*ExecStmt).next\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/adapter.go:1194\ngithub.com/pingcap/tidb/executor.(*recordSet).Next\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/adapter.go:150\ngithub.com/pingcap/tidb/server.(*tidbResultSet).Next\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/driver_tidb.go:428\ngithub.com/pingcap/tidb/server.(*clientConn).writeChunks\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:2308\ngithub.com/pingcap/tidb/server.(*clientConn).writeResultSet\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:2251\ngithub.com/pingcap/tidb/server.(*clientConn).handleStmt\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:2124\ngithub.com/pingcap/tidb/server.(*clientConn).handleQuery\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1885\ngithub.com/pingcap/tidb/server.(*clientConn).dispatch\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1372\ngithub.com/pingcap/tidb/server.(*clientConn).Run\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1153\ngithub.com/pingcap/tidb/server.(*Server).onConn\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/server.go:677\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1598”]

应该是需要集群有一定的负载才能估算。

确实如此,不然这个表就是空的。

mysql> select * from metrics_schema.resource_manager_resource_unit;
+----------------------------+----------------------+
| time                       | value                |
+----------------------------+----------------------+
| 2023-06-28 00:35:16.666000 |                    0 |
| 2023-06-28 00:36:16.666000 | 0.004957504103305845 |
+----------------------------+----------------------+
2 rows in set (0.01 sec)
1 个赞

建议文档这里多加一句描述,把这个error (Error 1105 (HY000): metrics ‘resource_manager_resource_unit’ is empty)加进去。

https://docs.pingcap.com/zh/tidb/stable/dashboard-resource-manager

毕竟其他error文档里也有描述。

1 个赞

您好:
感谢您的反馈,之后文档会添加此说明

此话题已在最后回复的 60 天后被自动关闭。不再允许新回复。