Tabjolt - division by zero
Zach Krzyzanowski Jul 15, 2016 12:53 PMHi,
I'm trying to run TabJolt on a virtual machine on my laptop to a Tableau server that isn't attached to any domain. I'm receiving the following output:
C:\tabjolt>go --t=testplans\ViewVizLoadTest.jmx --d=10 --c=1
[2016-07-15 15:29:44,110] Perf harness is started with parameters: --rootPath=C:\tabjolt --t=testplans\ViewVizLoadTest.jmx --d=10 --c=1
[2016-07-15 15:29:44,360] Loading PerfTestConfig yaml file C:\tabjolt\config\PerfTestConfig.yaml
[2016-07-15 15:29:44,594] Loading ServerTestConfig yaml file C:\tabjolt\config\ServerTestConfig.yaml
-------------start collecting JMX counters--------------
Output File:C:\tabjolt/results/2016-07-15_15-29-44/jmxcounter.tsv
-------------start collecting Zabbix counters--------------
Output File:C:\tabjolt/results/2016-07-15_15-29-44/zabbixcounter.tsv
-------------start windows performance counters collection-------------
Output File:c:\tabjolt/results/2016-07-15_15-29-44/wincounter.tsv
INFO [2016-07-15 15:30:05,157][main] (PerfRunHelper.java:346) - -------------start Jmeter load test run-------------
INFO [2016-07-15 15:30:05,157][main] (PerfRunHelper.java:347) - Output file: C:\tabjolt/results/2016-07-15_15-29-44/result-DESKTOP-RD85OP1-0.jtl
INFO [2016-07-15 15:30:05,157][main] (PerfRunHelper.java:348) - Command: [C:\tabjolt/bin/jmeter.bat, , , , , , -n, -t=C:\tabjolt\testplans\ViewVizLoadTest.jmx, -j=C:\tabjolt/logs/jmeter_2016-07-15_15-29-44.log, -JthreadCount=1, -Jduration=10, -JloginWeight=1.0, -JconfigFolderPath=C:\tabjolt/config/, -Jlogpath=C:\tabjolt/results/2016-07-15_15-29-44/result-DESKTOP-RD85OP1-0.jtl, ]
INFO [2016-07-15 15:30:05,379][main] (ResultProcessor.java:132) - -------------start processing perf counters and run result-------------
INFO [2016-07-15 15:30:05,384][main] (ResultProcessor.java:133) - Perf run result is saving to result repository. Please use this RUN ID 30 to view your result in Tableau
INFO [2016-07-15 15:30:05,422][Thread-13] (PerfRunMonitor.java:37) - Starting Perfrun monitor thread
Created the tree successfully using C:\tabjolt\testplans\ViewVizLoadTest.jmx
Starting the test @ Fri Jul 15 15:30:06 PDT 2016 (1468621806866)
Waiting for possible shutdown message on port 4445
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/C:/tabjolt/lib/slf4j-nop-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/C:/tabjolt/lib/ext/slf4j-nop-1.7.7.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.helpers.NOPLoggerFactory]
Tidying up ... @ Fri Jul 15 15:30:21 PDT 2016 (1468621821735)
... end of run
INFO [2016-07-15 15:30:25,410][main] (PerfRunHelper.java:195) - Jmeter process has exited. Waiting for the other processes to exit.
Failed to connect to the JMX connector due to the following error: ConnectException: Connection timed out: connect
Failed to get the object from the pool due to the following error: ConnectException: Connection timed out: connect
The Health Service failed to open JMX connection with component: vizqlserver, service URL: /jndi/rmi://tableau.b-analytics.net:9400/jmxrmi
Failed to connect to the JMX connector due to the following error: ConnectException: Connection timed out: connect
Failed to get the object from the pool due to the following error: ConnectException: Connection timed out: connect
The Health Service failed to open JMX connection with component: vizqlserver, service URL: /jndi/rmi://tableau.b-analytics.net:9400/jmxrmi
INFO [2016-07-15 15:30:55,657][main] (PerfRunHelper.java:225) - Waiting for processes "Windows Perf Counter Data Retriever;JMX/Zabbix Counter Data Retriever" to complete. 30 seconds have elapsed.
Failed to connect to the JMX connector due to the following error: ConnectException: Connection timed out: connect
Failed to get the object from the pool due to the following error: ConnectException: Connection timed out: connect
The Health Service failed to open JMX connection with component: vizqlserver, service URL: /jndi/rmi://tableau.b-analytics.net:9400/jmxrmi
INFO [2016-07-15 15:31:25,876][main] (PerfRunHelper.java:225) - Waiting for processes "JMX/Zabbix Counter Data Retriever" to complete. 60 seconds have elapsed.
Failed to connect to the JMX connector due to the following error: ConnectException: Connection timed out: connect
Failed to get the object from the pool due to the following error: ConnectException: Connection timed out: connect
The Health Service failed to open JMX connection with component: vizqlserver, service URL: /jndi/rmi://tableau.b-analytics.net:9400/jmxrmi
INFO [2016-07-15 15:31:56,173][main] (PerfRunHelper.java:225) - Waiting for processes "JMX/Zabbix Counter Data Retriever" to complete. 90 seconds have elapsed.
Failed to connect to the JMX connector due to the following error: ConnectException: Connection timed out: connect
Failed to get the object from the pool due to the following error: ConnectException: Connection timed out: connect
The Health Service failed to open JMX connection with component: vizqlserver#1, service URL: /jndi/rmi://tableau.b-analytics.net:9401/jmxrmi
INFO [2016-07-15 15:32:26,469][main] (PerfRunHelper.java:225) - Waiting for processes "JMX/Zabbix Counter Data Retriever" to complete. 120 seconds have elapsed.
Failed to connect to the JMX connector due to the following error: ConnectException: Connection timed out: connect
Failed to get the object from the pool due to the following error: ConnectException: Connection timed out: connect
The Health Service failed to open JMX connection with component: vizqlserver#1, service URL: /jndi/rmi://tableau.b-analytics.net:9401/jmxrmi
Failed to connect to the JMX connector due to the following error: ConnectException: Connection timed out: connect
Failed to get the object from the pool due to the following error: ConnectException: Connection timed out: connect
The Health Service failed to open JMX connection with component: vizqlserver#1, service URL: /jndi/rmi://tableau.b-analytics.net:9401/jmxrmi
INFO [2016-07-15 15:32:56,719][main] (PerfRunHelper.java:225) - Waiting for processes "JMX/Zabbix Counter Data Retriever" to complete. 150 seconds have elapsed.
Failed to connect to the JMX connector due to the following error: ConnectException: Connection timed out: connect
Failed to get the object from the pool due to the following error: ConnectException: Connection timed out: connect
The Health Service failed to open JMX connection with component: vizqlserver#1, service URL: /jndi/rmi://tableau.b-analytics.net:9401/jmxrmi
INFO [2016-07-15 15:33:26,986][main] (PerfRunHelper.java:221) - Timeout of Waiting for processes "JMX/Zabbix Counter Data Retriever" to complete. Killinng the processes.
INFO [2016-07-15 15:33:27,002][main] (PerfRunHelper.java:206) - killing process JMX/Zabbix Counter Data Retriever
INFO [2016-07-15 15:33:27,006][main] (PerfRunHelper.java:208) - Successfully killed process JMX/Zabbix Counter Data Retriever
INFO [2016-07-15 15:33:27,010][main] (PerfRunHelper.java:214) - All processes have exited.
INFO [2016-07-15 15:33:27,014][main] (PerfRunMonitor.java:57) - Perfrun is completed - ending monitor thread
INFO [2016-07-15 15:33:27,203][Thread-7] (JmeterResultDBSender.java:81) - Finish processeing all Jmeter perf result samples.
INFO [2016-07-15 15:33:28,000][Thread-9] (PerfCounterDBSender.java:72) - Finished processing all perf counter records
Exception in thread "main" 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:2270)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:362)
at com.tableausoftware.test.tools.ResultProcessor.PostgresDBHelper.updateTestRunStats(PostgresDBHelper.java:238)
at com.tableausoftware.test.tools.ResultProcessor.ResultProcessor.signalRunCompleted(ResultProcessor.java:188)
at com.tableausoftware.test.tools.perfRunHarness.Main.runOneTest(Main.java:261)
at com.tableausoftware.test.tools.perfRunHarness.Main.main(Main.java:138)
C:\tabjolt>
I've done all recommended setting changes fromThe Mondo Tableau Server TabJolt Series – Part 3 - Tableau Love and windows firewall is turned off