[Question]: [ERROR] BenchmarkSQL jar file not found at /usr/ob-benchmarksql/OB-BenchmarkSQL-5.0.jar. Please use `--bmsql-jar` to set BenchmarkSQL jar file

[FrankXMX]

Please check the issue list for the same question

• [X] Please try full text in English and attach precise description.

Describe your question

[root@77aa13b9ca07 ~]# obd test tpcc obcluster Get local repositories and plugins ok Open ssh connection ok Cluster status check ok Connect to observer ok [ERROR] BenchmarkSQL jar file not found at /usr/ob-benchmarksql/OB-BenchmarkSQL-5.0.jar. Please use --bmsql-jar to set BenchmarkSQL jar file See https://www.oceanbase.com/product/ob-deployer/error-codes .

[hnwyllmm]

yum install obtpcc

[longdafeng]

obtpcc hasn't been officially supported, right now, it just for testing.

[hnwyllmm]

yum install obtpcc

发自我的iPhone

在 2022年11月23日，16:43，Longda @.***> 写道：

 obtpcc hasn't been officially supported, right now, it just for testing.

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you commented.

[FrankXMX]

yum install obtpcc Is it available in openEuler?

[gys-git]

You can find and download the appropriate tpcc RPM package for your operating system from the following link: https://mirrors.oceanbase.com/development-kit/el/ and install the tpcc environment.

[sunmin89]

If your archtecture is neither x86_64 nor aarch64, the prebuilt tpcc packages should not be available for you(https://mirrors.oceanbase.com/development-kit/el/9/)

You should read this guide.: https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000001033259

1.prepare ant build tool and jdk_1.8

2.download benchmarksql 5.0 (https://sourceforge.net/projects/benchmarksql/files/latest/download/)

3.modify benchmarksql 5.0 source code and shell script to add support for oceanbase

4. build benchmarksql 5.0 with ant

5. call obd.sh with --bmsql-dir

./tools/deploy/obd.sh tpcc -n DEPLOY_NAME --bmsql-dir /mnt/shared/sunmin/benchmarksql-5.0/
or
obd test tpcc obcluster --bmsql-dir /mnt/shared/sunmin/benchmarksql-5.0/