Can't run the test

[arashnikoo]

I am running HammerDB 4.3. After building the schema I start the load testing process but keep getting this error:

hammerdb>Vuser 1:Processing 10000000 transactions without output suppressed...
Vuser 1:new order
Vuser 1:mysqlexec/db server: PROCEDURE tpcc.NEWORD does not exist
Vuser 1:new order
Vuser 1:mysqlexec/db server: PROCEDURE tpcc.NEWORD does not exist
Vuser 1:new order
Vuser 1:mysqlexec/db server: PROCEDURE tpcc.NEWORD does not exist
.
.

My script is very simple:

puts "SETTING CONFIGURATION"
dbset db mysql
diset connection mysql_host [removed]
diset connection mysql_port 3306
diset tpcc mysql_user [removed]
diset tpcc mysql_pass [removed]
diset tpcc mysql_num_vu 2
diset tpcc mysql_count_ware 2
diset tpcc mysql_storage_engine innodb
print dict
buildschema

For the test:

dbset db mysql
diset connection mysql_host [removed]
diset connection mysql_port 3306
diset tpcc mysql_user [removed]
diset tpcc mysql_pass [removed]    
diset tpcc mysql_num_vu 2
diset tpcc mysql_count_ware 2
diset tpcc mysql_storage_engine innodb
print dict
loadscript
puts "SEQUENCE STARTED"
foreach z { 1 2 4 } {
puts "$z VU TEST"
vuset vu $z
vucreate
vurun
runtimer 600
vudestroy
after 5000
}

[sm-shaw]

So the error:
PROCEDURE tpcc.NEWORD does not exist
means the schema build didn't complete successfully.
The stored procedures are created at the end of the schema build process, so check the output at the end of the build to see if everything completed as expected and query the stored procedures to see if they have been created.

Drop the database and recreate it - if you still see the error copy the output at the end of the build here for further guidance.

[arashnikoo]

Thank you for taking a look at this. I tried dropping the database multiple times but still no luck:

Script cleared
Building 2 Warehouses with 3 Virtual Users, 2 active + 1 Monitor VU(dict value mysql_num_vu is set to 2)
Ready to create a 2 Warehouse MySQL TPROC-C schema
in host [REMOVED]:3306 under user DB_ADMIN in database TPCC with storage engine INNODB?
Enter yes or no: replied yes
Vuser 1 created - WAIT IDLE
Vuser 2 created - WAIT IDLE
Vuser 3 created - WAIT IDLE
Vuser 1:RUNNING
Vuser 1:Monitor Thread
Vuser 1:CREATING TPCC SCHEMA
Vuser 2:RUNNING
Vuser 2:Worker Thread
Vuser 2:Waiting for Monitor Thread...
Vuser 1:CREATING DATABASE tpcc
Vuser 3:RUNNING
Vuser 3:Worker Thread
Vuser 3:Waiting for Monitor Thread...
Vuser 1:CREATING TPCC TABLES

hammerdb>Vuser 1:Loading Item
Vuser 2:Loading 1 Warehouses start:1 end:1
Vuser 2:Start:Thu Jan 27 20:26:13 UTC 2022
Vuser 2:Loading Warehouse
Vuser 2:Loading Stock Wid=1
Vuser 3:Loading 1 Warehouses start:2 end:2
Vuser 3:Start:Thu Jan 27 20:26:14 UTC 2022
Vuser 3:Loading Warehouse
Vuser 3:Loading Stock Wid=2
Vuser 2:Loading Stock - 20000
Vuser 3:Loading Stock - 20000
Vuser 2:Loading Stock - 40000
Vuser 3:Loading Stock - 40000
Vuser 2:Loading Stock - 60000
Vuser 3:Loading Stock - 60000
Vuser 2:Loading Stock - 80000
Vuser 3:Loading Stock - 80000
Vuser 2:Loading Stock - 100000
Vuser 2:Stock done
Vuser 2:Loading District
Vuser 3:Loading Stock - 100000
Vuser 3:Stock done
Vuser 3:Loading District
Vuser 2:District done
Vuser 2:Loading Customer for DID=1 WID=1
Vuser 3:District done
Vuser 3:Loading Customer for DID=1 WID=2
Vuser 2:Customer Done
Vuser 2:Loading Customer for DID=2 WID=1
Vuser 3:Customer Done
Vuser 3:Loading Customer for DID=2 WID=2
Vuser 2:Customer Done
Vuser 2:Loading Customer for DID=3 WID=1
Vuser 3:Customer Done
Vuser 3:Loading Customer for DID=3 WID=2
Vuser 2:Customer Done
Vuser 2:Loading Customer for DID=4 WID=1
Vuser 3:Customer Done
Vuser 3:Loading Customer for DID=4 WID=2
Vuser 2:Customer Done
Vuser 2:Loading Customer for DID=5 WID=1
Vuser 3:Customer Done
Vuser 3:Loading Customer for DID=5 WID=2
Vuser 2:Customer Done
Vuser 2:Loading Customer for DID=6 WID=1
Vuser 2:Customer Done
Vuser 2:Loading Customer for DID=7 WID=1
Vuser 3:Customer Done
Vuser 3:Loading Customer for DID=6 WID=2
Vuser 2:Customer Done
Vuser 2:Loading Customer for DID=8 WID=1
Vuser 3:Customer Done
Vuser 3:Loading Customer for DID=7 WID=2
Vuser 2:Customer Done
Vuser 2:Loading Customer for DID=9 WID=1
Vuser 3:Customer Done
Vuser 3:Loading Customer for DID=8 WID=2
Vuser 2:Customer Done
Vuser 2:Loading Customer for DID=10 WID=1
Vuser 3:Customer Done
Vuser 3:Loading Customer for DID=9 WID=2
Vuser 2:Customer Done
Vuser 2:Loading Orders for D=1 W=1
Vuser 3:Customer Done
Vuser 3:Loading Customer for DID=10 WID=2
Vuser 2:...1000
Vuser 3:Customer Done
Vuser 3:Loading Orders for D=1 W=2
Vuser 2:...2000
Vuser 3:...1000
Vuser 2:...3000
Vuser 2:Orders Done
Vuser 2:Loading Orders for D=2 W=1
Vuser 3:...2000
Vuser 2:...1000
Vuser 3:...3000
Vuser 3:Orders Done
Vuser 3:Loading Orders for D=2 W=2
Vuser 2:...2000
Vuser 3:...1000
Vuser 2:...3000
Vuser 2:Orders Done
Vuser 2:Loading Orders for D=3 W=1
Vuser 3:...2000
Vuser 2:...1000
Vuser 3:...3000
Vuser 3:Orders Done
Vuser 3:Loading Orders for D=3 W=2
Vuser 2:...2000
Vuser 3:...1000
Vuser 2:...3000
Vuser 2:Orders Done
Vuser 2:Loading Orders for D=4 W=1
Vuser 3:...2000
Vuser 2:...1000
Vuser 3:...3000
Vuser 3:Orders Done
Vuser 3:Loading Orders for D=4 W=2
Vuser 2:...2000
Vuser 3:...1000
Vuser 2:...3000
Vuser 2:Orders Done
Vuser 2:Loading Orders for D=5 W=1
Vuser 3:...2000
Vuser 2:...1000
Vuser 2:...2000
Vuser 3:...3000
Vuser 3:Orders Done
Vuser 3:Loading Orders for D=5 W=2
Vuser 2:...3000
Vuser 2:Orders Done
Vuser 2:Loading Orders for D=6 W=1
Vuser 3:...1000
Vuser 2:...1000
Vuser 3:...2000
Vuser 2:...2000
Vuser 3:...3000
Vuser 3:Orders Done
Vuser 3:Loading Orders for D=6 W=2
Vuser 2:...3000
Vuser 2:Orders Done
Vuser 2:Loading Orders for D=7 W=1
Vuser 3:...1000
Vuser 2:...1000
Vuser 3:...2000
Vuser 2:...2000
Vuser 3:...3000
Vuser 3:Orders Done
Vuser 3:Loading Orders for D=7 W=2
Vuser 2:...3000
Vuser 2:Orders Done
Vuser 2:Loading Orders for D=8 W=1
Vuser 3:...1000
Vuser 2:...1000
Vuser 3:...2000
Vuser 2:...2000
Vuser 3:...3000
Vuser 2:...3000
Vuser 3:Orders Done
Vuser 3:Loading Orders for D=8 W=2
Vuser 2:Orders Done
Vuser 2:Loading Orders for D=9 W=1
Vuser 3:...1000
Vuser 2:...1000
Vuser 3:...2000
Vuser 2:...2000
Vuser 2:...3000
Vuser 2:Orders Done
Vuser 2:Loading Orders for D=10 W=1
Vuser 3:...3000
Vuser 3:Orders Done
Vuser 3:Loading Orders for D=9 W=2
Vuser 2:...1000
Vuser 3:...1000
Vuser 2:...2000
Vuser 3:...2000
Vuser 2:...3000
Vuser 2:Orders Done
Vuser 2:End:Thu Jan 27 20:29:33 UTC 2022
Vuser 2:FINISHED SUCCESS
Vuser 3:...3000
Vuser 3:Orders Done
Vuser 3:Loading Orders for D=10 W=2
Vuser 3:...1000
Vuser 3:...2000
Vuser 3:...3000
Vuser 3:Orders Done
Vuser 3:End:Thu Jan 27 20:29:47 UTC 2022
Vuser 3:FINISHED SUCCESS
hammerdb>vustatus
1 = RUNNING
2 = FINISH SUCCESS
3 = FINISH SUCCESS


hammerdb>

[sm-shaw]

the schema build output is incomplete - it says Virtual User 1 is still running.

hammerdb>vustatus
1 = RUNNING
2 = FINISH SUCCESS
3 = FINISH SUCCESS

Did you stop/interrupt the build at this point?
The final message should be schema build complete.

Try running again and leave it completely until it has finished.
Note that it is possible for the stored procedures to fail to create if the database creation was corrupted, however the build will generate an error saying this is the case. From your output the build was stopped.

[arashnikoo]

The tables are created but the stored procs aren't there.