tpch 100g 加载失败

[happysky]

太搓了, 怎么加载, 试了n遍, 数据就是加载不全, order表和lineitem 表就是数据不全.

customer
15000000
region
5
nation
25
supplier
1000000
part
20000000
partsupp
80000000
orders
51563520
lineitem
206259200

[GangShen]

tidb.log 中有没有 dispatch error 之类的错误日志报 SQL 执行失败的？

[mahjonp]

@happysky

方式2: 参考
https://docs.pingcap.com/zh/tidb/stable/v4.0-performance-benchmarking-with-tpch
tiup bench tpch prepare
–host tidb --port 4000 --db tpch100 --password xxxx --user root
–sf 100
–tiflash
–analyze --tidb_build_stats_concurrency 8 --tidb_distsql_scan_concurrency 30

Got signal [hangup] again to exit.
[mysql] 2021/02/23 00:33:31 connection.go:310: invalid connection
Component bench exit with error: exit status 1
Starting component bench : /root/.tiup/components/bench/v1.3.2/tiup-bench tpch --sf=100 --check=true run -D tpch -H tidb -P 4000 -U root -p xxxxx
[Current] Q1: 0.00s
[Current] Q10: 0.00s
[Current] Q2: 34.41s
[Current] Q3: 0.01s
[Current] Q4: 0.01s
[Current] Q5: 0.01s
[Current] Q6: 0.00s

数据明显不全,
customer
15000000
region
5
nation
25
supplier
1000000
part
4862976
partsupp
19452928
orders
0
lineitem
0

这里有一个中断信号，很明显数据并没有导入完成。

Got signal [hangup] again to exit.
[mysql] 2021/02/23 00:33:31 connection.go:310: invalid connection
Component bench exit with error: exit status 1

[yilong (yi888long)]

启动任务时候，是在后台执行的吗？