javaPerformanceTroubleshooting
javaPerformanceTroubleshooting copied to clipboard
init.sh not reporting db load counts.
While installing javaPerformanceTroubleshooting I ran into a problem. At the end of the init.sh run I received this message:
@@ @@ Here are row counts of tables: @@ Shutting down TCP Server at tcp://localhost:9092 @@ @@ init.sh is finished. @@ The db has been stopped. @@
According to the instructions it's supposed to look like this:
@@ Here are row counts of tables: @@ [INFO] S01.BRANCHES=100 [INFO] S01.ACCOUNTS=125000 [INFO] S01.HISTORY=1250000 [INFO] S02.BRANCHES=100 [INFO] S02.ACCOUNTS=250000 [INFO] S02.HISTORY=2500000 Shutting down TCP Server at tcp://localhost:9092 @@ @@ init.sh is finished. @@ The db has been stopped.
For some reason it is not showing the row counts. Could you help me with this issue. I am sure it is caused by a simple mistake on my end. I am using a laptop with the Ubuntu OS.
I added a fix to both init.sh and init.cmd. The new revision makes these two calls to display counts of records after the db load:
$dir/load.sh countRows-01 | grep S0
$dir/load.sh countRows-02 | grep S0
An older version of load.sh required the .jmx extensions
$dir/load.sh countRows-01.jmx | grep S0
$dir/load.sh countRows-02.jmx | grep S0
....so to fix, I just removed the .jmx at the end of each parameter, when load.sh and and load.cmd are called.
Thanks for reporting the problem. --Erik