2 Replies Latest reply on Aug 15, 2016 5:39 PM by Katherine L

    TabJolt - Successful Run, No Results; Where's the Error?

    Katherine L

      Hi All,

       

      I'm trying to run TabJolt against a workbook on our dev machine and the TabJolt script seems to run successfully, but I can't see any results. Per Russell's awesome Mondo TabJolt post series, I believe I should be seeing something related to "actual binding" towards the end of the run in cmd. Do you know what in the output is pointing towards the error or if there even is an error? Since we don't have JMX set up yet, the errors at the end related to performance counters seem ok to me, but that could be wrong.

       

      I double checked the ServerTestConfig.yaml and Vizpool.csv

       

      C:\TabJolt>go --t=testplans\InteractVizLoadTest.jmx --d=240 --c=1

      Perf harness is started with parameters: --rootPath=C:\TabJolt --t=testplans\InteractVizLoadTest.jmx --d=240 --c=1

      -------------start collecting JMX counters--------------

      Output File:C:\TabJolt/results/2016-07-21_11-25-08/jmxcounter.tsv

      -------------start collecting Zabbix counters--------------

      Output File:C:\TabJolt/results/2016-07-21_11-25-08/zabbixcounter.tsv

      -------------start windows performance counters collection-------------

      Output File:c:\tabjolt/results/2016-07-21_11-25-08/wincounter.tsv

      -------------start Jmeter load test run-------------

      Output file: C:\TabJolt/results/2016-07-21_11-25-08/result.jtl

      Command: [C:\TabJolt/bin/jmeter.bat, -n, -t=C:\TabJolt//testplans\InteractVizLoadTest.jmx, -j=C:\TabJolt/logs/jmeter_2016-07-21_11-25-08.log, -JthreadCount=1, -

      Jduration=240, -JconfigFolderPath=C:\TabJolt/config/, -Jlogpath=C:\TabJolt/results/2016-07-21_11-25-08/result.jtl]

      Created the tree successfully using C:\TabJolt//testplans\InteractVizLoadTest.jmx

      Starting the test @ Thu Jul 21 11:25:11 CDT 2016 (1469118311200)

      Waiting for possible shutdown message on port 4445

      Tidying up ...    @ Thu Jul 21 11:25:11 CDT 2016 (1469118311794)

      ... end of run

      Java HotSpot(TM) 64-Bit Server VM warning: ignoring option PermSize=64m; support was removed in 8.0

      Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=128m; support was removed in 8.0

      Jmeter process has exited. Waiting for the other processes to exit.

      Waiting for processes "Windows Perf Counter Data Retriever;JMX/Zabbix Counter Data Retriever" to complete. 30 seconds have elapsed.

      Waiting for processes "Windows Perf Counter Data Retriever;JMX/Zabbix Counter Data Retriever" to complete. 60 seconds have elapsed.

      Waiting for processes "Windows Perf Counter Data Retriever;JMX/Zabbix Counter Data Retriever" to complete. 90 seconds have elapsed.

      Waiting for processes "Windows Perf Counter Data Retriever;JMX/Zabbix Counter Data Retriever" to complete. 120 seconds have elapsed.

      Waiting for processes "Windows Perf Counter Data Retriever;JMX/Zabbix Counter Data Retriever" to complete. 150 seconds have elapsed.

      Timeout of Waiting for processes "Windows Perf Counter Data Retriever;JMX/Zabbix Counter Data Retriever" to complete. Killinng the processes.

      killing process Windows Perf Counter Data Retriever

      Successfully killed process Windows Perf Counter Data Retriever

      killing process JMX/Zabbix Counter Data Retriever

      Successfully killed process JMX/Zabbix Counter Data Retriever

      All processes have exited.

      -------------start processing perf counters and run result-------------

      Unable to parse line "1469118490368     LOCALHOST       Process Thread Counttab"

      Finished processing all perf counter records

      Finish processeing all Jmeter perf result samples.

      Failed to process perf counters and run result.

      org.postgresql.util.PSQLException: ERROR: division by zero

        Where: SQL statement "UPDATE test_runs

                      SET TPS_average=(

                                   totalSamples/totalseconds

                               )

                      WHERE id=runId"

      PL/pgSQL function sp_update_test_run_stats(integer) line 116 at SQL statement

              at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)

              at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)

              at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

              at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)

              at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)

              at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:359)

              at com.tableausoftware.test.tools.ResultProcessor.DBHelper.updateTestRunStats(DBHelper.java:189)

              at com.tableausoftware.test.tools.ResultProcessor.ResultProcessor.startProcessing(ResultProcessor.java:86)

              at com.tableausoftware.test.tools.perfRunHarness.Main.startPerfResultsSaver(Main.java:111)

              at com.tableausoftware.test.tools.perfRunHarness.Main.main(Main.java:77)

       

      Thanks!