如何查看TPCC初始化数据进度

🪐 TiDB 技术问题
1

【 TiDB 使用环境】测试
【 TiDB 版本】V6.1.0
【复现路径】做过哪些操作出现的问题
> # tiup bench tpcc -H192.168.169.31 -P4000 -D tpcc --warehouses 1 prepare
1.重新初始化、检查、清理等操作，皆提示“panic: failed to connect to database when loading data”;
2.重启数据库依然如此；

【遇到的问题：问题现象及影响】

问题：
1.如何查看数据初始化进度和相关日志？
2.如何终止数据初始化？

【资源配置】进入到 TiDB Dashboard -集群信息 (Cluster Info) -主机(Hosts) 截图此页面
【复制黏贴 ERROR 报错的日志】

> 
> [root@tidb30 ~]#  tiup bench tpcc -H192.168.169.31 -P4000 -D tpcc --warehouses 1 check
> Checking updates for component bench... Timedout (after 2s)
> Starting component bench: /root/.tiup/components/bench/v1.12.0/tiup-bench tpcc -H192.168.169.31 -P4000 -D tpcc --warehouses 1 check
> panic: failed to connect to database when loading data
> 
> goroutine 1 [running]:
> github.com/pingcap/go-tpc/tpcc.NewWorkloader(0x0?, 0xc000470140?)
>         /home/runner/work/go-tpc/go-tpc/tpcc/workload.go:110 +0x93d
> main.executeTpcc({0xa9aa18, 0x5})
>         /home/runner/work/go-tpc/go-tpc/cmd/go-tpc/tpcc.go:64 +0x1ea
> main.registerTpcc.func4(0xc000451340?, {0xa99807?, 0x6?, 0x6?})
>         /home/runner/work/go-tpc/go-tpc/cmd/go-tpc/tpcc.go:129 +0x25
> github.com/spf13/cobra.(*Command).execute(0xc000451340, {0xc0000a2cc0, 0x6, 0x6})
>         /home/runner/go/pkg/mod/github.com/spf13/cobra@v1.0.0/command.go:846 +0x663
> github.com/spf13/cobra.(*Command).ExecuteC(0xc0004502c0)
>         /home/runner/go/pkg/mod/github.com/spf13/cobra@v1.0.0/command.go:950 +0x39c
> github.com/spf13/cobra.(*Command).Execute(...)
>         /home/runner/go/pkg/mod/github.com/spf13/cobra@v1.0.0/command.go:887
> main.main()
>         /home/runner/work/go-tpc/go-tpc/cmd/go-tpc/main.go:250 +0x7e5

【其他附件：截图/日志/监控】

2

是没指定账号密码吗？

2 个赞
3

果然如此，被报错迷惑了 :sweat_smile: :cold_sweat:

[root@tidb30 ~]# tiup bench tpcc -H192.168.169.31 -P4000 -D tpcc -Uroot -ptidb --warehouses 4 --parts 4 prepare
Starting component bench: /root/.tiup/components/bench/v1.12.0/tiup-bench tpcc -H192.168.169.31 -P4000 -D tpcc -Uroot -p****** --warehouses 4 --parts 4 prepare
creating table warehouse
creating table district
creating table customer
creating table history
creating table new_order
creating table orders
creating table order_line
creating table stock
creating table item
load to item
1 个赞
4

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