vurun in TPC-C fails

[noginahalchetan]

In hammerdb 4.0 TPC-C, "vurun" command fails with error "invalid command name "cal/bin/tclsh8.6"".
Looks like the pathname is truncated and it is expecting the path "/usr/local/bin/tclsh8.6"

Below is the output when we run "vurun"

Error in Virtual User 19: invalid command name "cal/bin/tclsh8.6"
Vuser 19:FINISHED FAILED
Error in Virtual User 20: invalid command name "cal/bin/tclsh8.6"
Vuser 20:FINISHED FAILED
Vuser 22:RUNNING
Vuser 23:RUNNING
Error in Virtual User 21: invalid command name "cal/bin/tclsh8.6"
Vuser 21:FINISHED FAILED
Error in Virtual User 22: invalid command name "cal/bin/tclsh8.6"
Vuser 22:FINISHED FAILED
Vuser 24:RUNNING
Vuser 25:RUNNING
Error in Virtual User 23: invalid command name "cal/bin/tclsh8.6"
Vuser 23:FINISHED FAILED
Vuser 26:RUNNING
Error in Virtual User 24: invalid command name "cal/bin/tclsh8.6"
Vuser 24:FINISHED FAILED

hammer-tpcc-run.log
mysql-dict.log

In the logs the my_sql host IP address has been masked for reasons of privacy

How do we fix this? We want to run tpc-c benchmarking.

[sm-shaw]

It looks like in your script you have a bare line of

cal/bin/tclsh8.6

It is possible that a typing error removed part of the line included the preceding #.

This line allows you to also run directly in the tcl shell, e.g.

#!/usr/bin/tclsh

However, when running the CLI this line is automatic, so you can either make sure it has a # so it doesn't detect it as a command or remove the line.

[noginahalchetan]

I haven't made any changes to the original code. I downloaded the tar.gz file and used it as is.

[sm-shaw]

Here is an example of a very basic interactive session to build a schema and run a test with the CLI against MySQL with 1 Virtual User.

$ ./hammerdbcli 
HammerDB CLI v4.0
Copyright (C) 2003-2020 Steve Shaw
Type "help" for a list of commands
The xml is well-formed, applying configuration
hammerdb>librarycheck
...
Checking database library for MySQL
Success ... loaded library mysqltcl for MySQL

hammerdb>dbset db mysql
Database set to MySQL

hammerdb>dbset bm TPC-C
Benchmark set to TPC-C for MySQL

hammerdb>print dict
Dictionary Settings for MySQL
connection {
 mysql_host   = 127.0.0.1
 mysql_port   = 3306
 mysql_socket = /tmp/mysql.sock
}
tpcc       {
 mysql_count_ware       = 1
 mysql_num_vu           = 1
 mysql_user             = root
 mysql_pass             = mysql
 mysql_dbase            = tpcc
 mysql_storage_engine   = innodb
 mysql_partition        = false
 mysql_prepared         = false
 mysql_total_iterations = 1000000
 mysql_raiseerror       = false
 mysql_keyandthink      = false
 mysql_driver           = test
 mysql_rampup           = 2
 mysql_duration         = 5
 mysql_allwarehouse     = false
 mysql_timeprofile      = false
 mysql_async_scale      = false
 mysql_async_client     = 10
 mysql_async_verbose    = false
 mysql_async_delay      = 1000
 mysql_connect_pool     = false
}

hammerdb>buildschema
Script cleared
Building 1 Warehouses(s) with 1 Virtual User
Ready to create a 1 Warehouse MySQL TPROC-C schema
in host 127.0.0.1:/TMP/MYSQL.SOCK under user ROOT in database TPCC with storage engine INNODB?
Enter yes or no: replied yes
Vuser 1 created - WAIT IDLE
Vuser 1:RUNNING
Vuser 1:CREATING TPCC SCHEMA
Vuser 1:CREATING DATABASE tpcc
Vuser 1:CREATING TPCC TABLES
Vuser 1:Loading Item

hammerdb>Vuser 1:Loading Items - 50000
Vuser 1:Loading Items - 100000
Vuser 1:Item done
Vuser 1:Start:Mon Apr 25 10:25:53 BST 2022
Vuser 1:Loading Warehouse
Vuser 1:Loading Stock Wid=1
Vuser 1:Loading Stock - 20000
Vuser 1:Loading Stock - 40000
Vuser 1:Loading Stock - 60000
Vuser 1:Loading Stock - 80000
Vuser 1:Loading Stock - 100000
Vuser 1:Stock done
Vuser 1:Loading District
Vuser 1:District done
Vuser 1:Loading Customer for DID=1 WID=1
Vuser 1:Customer Done
Vuser 1:Loading Customer for DID=2 WID=1
Vuser 1:Customer Done
Vuser 1:Loading Customer for DID=3 WID=1
Vuser 1:Customer Done
Vuser 1:Loading Customer for DID=4 WID=1
Vuser 1:Customer Done
Vuser 1:Loading Customer for DID=5 WID=1
Vuser 1:Customer Done
Vuser 1:Loading Customer for DID=6 WID=1
Vuser 1:Customer Done
Vuser 1:Loading Customer for DID=7 WID=1
Vuser 1:Customer Done
Vuser 1:Loading Customer for DID=8 WID=1
Vuser 1:Customer Done
Vuser 1:Loading Customer for DID=9 WID=1
Vuser 1:Customer Done
Vuser 1:Loading Customer for DID=10 WID=1
Vuser 1:Customer Done
Vuser 1:Loading Orders for D=1 W=1
Vuser 1:...1000
Vuser 1:...2000
Vuser 1:...3000
Vuser 1:Orders Done
Vuser 1:Loading Orders for D=2 W=1
Vuser 1:...1000
Vuser 1:...2000
Vuser 1:...3000
Vuser 1:Orders Done
Vuser 1:Loading Orders for D=3 W=1
Vuser 1:...1000
Vuser 1:...2000
Vuser 1:...3000
Vuser 1:Orders Done
Vuser 1:Loading Orders for D=4 W=1
Vuser 1:...1000
Vuser 1:...2000
Vuser 1:...3000
Vuser 1:Orders Done
Vuser 1:Loading Orders for D=5 W=1
Vuser 1:...1000
Vuser 1:...2000
Vuser 1:...3000
Vuser 1:Orders Done
Vuser 1:Loading Orders for D=6 W=1
Vuser 1:...1000
Vuser 1:...2000
Vuser 1:...3000
Vuser 1:Orders Done
Vuser 1:Loading Orders for D=7 W=1
Vuser 1:...1000
Vuser 1:...2000
Vuser 1:...3000
Vuser 1:Orders Done
Vuser 1:Loading Orders for D=8 W=1
Vuser 1:...1000
Vuser 1:...2000
Vuser 1:...3000
Vuser 1:Orders Done
Vuser 1:Loading Orders for D=9 W=1
Vuser 1:...1000
Vuser 1:...2000
Vuser 1:...3000
Vuser 1:Orders Done
Vuser 1:Loading Orders for D=10 W=1
Vuser 1:...1000
Vuser 1:...2000
Vuser 1:...3000
Vuser 1:Orders Done
Vuser 1:End:Mon Apr 25 10:26:28 BST 2022
Vuser 1:CREATING TPCC STORED PROCEDURES
Vuser 1:GATHERING SCHEMA STATISTICS
Vuser 1:TPCC SCHEMA COMPLETE
Vuser 1:FINISHED SUCCESS
ALL VIRTUAL USERS COMPLETE

hammerdb>vudestroy
vudestroy success

hammerdb>diset tpcc mysql_driver timed
Clearing Script, reload script to activate new setting
Script cleared
Changed tpcc:mysql_driver from test to timed for MySQL

hammerdb>loadscript
Script loaded, Type "print script" to view

hammerdb>vucreate
Vuser 1 created MONITOR - WAIT IDLE
Vuser 2 created - WAIT IDLE
2 Virtual Users Created with Monitor VU

hammerdb>vurun
Vuser 1:RUNNING
Vuser 1:Beginning rampup time of 2 minutes
Vuser 2:RUNNING
Vuser 2:Processing 1000000 transactions with output suppressed...

hammerdb>Vuser 1:Rampup 1 minutes complete ...
Vuser 1:Rampup 2 minutes complete ...
Vuser 1:Rampup complete, Taking start Transaction Count.
Vuser 1:Timing test period of 5 in minutes
Vuser 1:1 ...,
Vuser 1:2 ...,
Vuser 1:3 ...,
Vuser 1:4 ...,
Vuser 1:5 ...,
Vuser 1:Test complete, Taking end Transaction Count.
Vuser 1:1 Active Virtual Users configured
Vuser 1:TEST RESULT : System achieved 16291 NOPM from 49074 MySQL TPM
Vuser 1:FINISHED SUCCESS
Vuser 2:FINISHED SUCCESS
ALL VIRTUAL USERS COMPLETE

hammerdb>vudestroy
vudestroy success

hammerdb>quit
Shutting down HammerDB CLI

[noginahalchetan]

It's working now. Thanks, Steve