I'm running the dbt2 test using the command:
./run_workload.sh -c 20 -t 50 -d 300 -w 20 -u root
"However, I can't get any result and it report the message as:
Stage 3. Processing of results...
MySQL pid file '/usr/local/mysql/var/localhost.pid' does not exist.
MySQL was not stopped, if it was running.
./run_workload.sh: line 523: [: -eq: unary operator expected
Use of uninitialized value in subtraction (-) at /usr/perl5/site_perl/5.8.4/Test/Parser/Dbt2.pm line 343.
Use of uninitialized value in subtraction (-) at /usr/perl5/site_perl/5.8.4/Test/Parser/Dbt2.pm line 346.
Use of uninitialized value in subtraction (-) at /usr/perl5/site_perl/5.8.4/Test/Parser/Dbt2.pm line 348.
Illegal division by zero at /usr/perl5/site_perl/5.8.4/Test/Parser/Dbt2.pm line 398."
In addition, in the error.log file under client, it report the ERROR as:
ERROR: D_NEXT_O_ID=NULL for query STOCK_LEVEL_1:
WHERE d_w_id = 2
AND d_id = 11
Does anyone ever experienced this kind of problem? In addition, I noticed even though in the command I create 20 user connections, the Threads_running is always 1 during the run time, and the CPU usage is pretty low - is this expected?
Thanks in advance for your comment. BTW, I'm not in the email alias yet, please reply me directly.