javaPerformanceTroubleshooting icon indicating copy to clipboard operation
javaPerformanceTroubleshooting copied to clipboard

init.sh not reporting db load counts.

Open eostermueller opened this issue 7 years ago • 1 comments

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.

eostermueller avatar Jun 04 '17 14:06 eostermueller

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

eostermueller avatar Jun 04 '17 14:06 eostermueller