What does "Error in Virtual User 1: no such table: JOBMAIN" mean?

[jsrz]

Running HammerDB 4.8 against MySQL 8.1.0, I occasionally see the below error after tests complete.

...
Vuser 19:FINISHED SUCCESS                                             
Vuser 24:FINISHED SUCCESS                                                                                                                    
Vuser 31:FINISHED SUCCESS                                             
Vuser 14:FINISHED SUCCESS                                                                                                                    
Vuser 18:FINISHED SUCCESS                                                                                                                    
Vuser 1:Calculating timings...                                                                                                               
Vuser 1:Writing timing data to /tmp/hdbxtprofile_652FDE37607F03E253130333.log                                                                                                                                                                                                             
Error in Virtual User 1: no such table: JOBMAIN                                                                                              
Vuser 1:FINISHED FAILED                                               
ALL VIRTUAL USERS COMPLETE                                                                                                                   
vudestroy success 

That timing data file is also empty when this occurs. Not sure if that's related or due to something else. Reported NOPM/TPM seem to be as expected though. Would like to know what this error means? What is JOBMAIN?

[sm-shaw]

JOBMAIN is the main table of the SQLite storage of results, configuration, timing data etc, so in this example you can see the hammer.DB SQLite database in my Windows TEMP area.

It sounds like somehow the database has corrupted or deleted in trying to set the timing data. If you remove it. Set your TMP environment variable to where you want to store it and restart HammerDB you should see the Hammer.DB SQLite database created in this location.

When you use the webservice this is where the job related data is stored including charts etc

[jsrz]

ok, that seems to be it. I'm running on Linux. I explicitly set the directory, that makes things to work now.

Thanks