[
https://issues.apache.org/jira/browse/IGNITE-11306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ilya Suntsov updated IGNITE-11306:
----------------------------------
Description:
Config:
{noformat}
now0=`date +'%H%M%S'`
# JVM options.
JVM_OPTS=${JVM_OPTS}" -DIGNITE_QUIET=false"
# Uncomment to enable concurrent garbage collection (GC) if you encounter long
GC pauses.
JVM_OPTS=${JVM_OPTS}" \
-Xms8g \
-Xmx8g \
-Xloggc:./gc${now0}.log \
-XX:+PrintGCDetails \
-verbose:gc \
-XX:+UseParNewGC \
-XX:+UseConcMarkSweepGC \
-XX:+PrintGCDateStamps \
"
#Ignite version
ver=ver-2.8.0-SNAPSHOT-rev-816f435d-
# List of default probes.
# Add DStatProbe or VmStatProbe if your OS supports it (e.g. if running on
Linux).
BENCHMARK_DEFAULT_PROBES=ThroughputLatencyProbe,PercentileProbe,DStatProbe
# Packages where the specified benchmark is searched by reflection mechanism.
BENCHMARK_PACKAGES=org.yardstickframework,org.apache.ignite.yardstick
# Flag which indicates to restart the servers before every benchmark execution.
RESTART_SERVERS=true
# Probe point writer class name.
# BENCHMARK_WRITER=
# Comma-separated list of the hosts to run BenchmarkServers on.
SERVER_HOSTS=172.25.1.30,172.25.1.27,172.25.1.28,172.25.1.29
# Comma-separated list of the hosts to run BenchmarkDrivers on.
DRIVER_HOSTS=172.25.1.11
# Remote username.
# REMOTE_USER=
# Number of nodes, used to wait for the specified number of nodes to start.
nodesNum=$((`echo ${SERVER_HOSTS} | tr ',' '\n' | wc -l` + `echo
${DRIVER_HOSTS} | tr ',' '\n' | wc -l`))
# Backups count.
b=1
# Warmup.
w=60
# Duration.
d=180
# Threads count.
t=64
# Sync mode.
sm=PRIMARY_SYNC
# Jobs.
j=10
# Run configuration which contains all benchmarks.
# Note that each benchmark is set to run for 300 seconds (5 min) with warm-up
set to 60 seconds (1 minute).
CONFIGS="\
-cfg ${SCRIPT_DIR}/../config/ignite-config.xml -nn ${nodesNum} -b ${b} -w ${w}
-d ${d} -t ${t} -sm ${sm} -pc 2 -r 100000 --sqlRange 1 --client
-dn NativeSqlJoinQueryRangeBenchmark -sn IgniteNode -ds
${ver}sql-select-native-join-r1-${b}-backup,\
"
{noformat}
Exception:
{noformat}
<12:50:49><main><yardstick> Populate 90000
<12:50:50><main><yardstick> Populate 100000
<12:50:50><main><yardstick> Probe writer is not configured (using default CSV
writer)
<12:50:50><main><yardstick> ThroughputLatencyProbe is started.
<12:50:50><main><yardstick> PercentileProbe is started.
<12:50:50><main><yardstick> DStatProbe is started. Command: 'dstat -m --all
--noheaders --noupdate 1'
<12:50:50><main><yardstick> Starting warmup.
Finishing main test [ts=1550051451762, date=Wed Feb 13 12:50:51 MSK 2019]
ERROR: Shutting down benchmark driver to unexpected exception.
Type '--help' for usage.
java.lang.Exception: Invalid result set size [actual=0, expected=1]
*<------>*at
org.apache.ignite.yardstick.jdbc.NativeSqlJoinQueryRangeBenchmark.test(NativeSqlJoinQueryRangeBenchmark.java:84)
*<------>*at
org.yardstickframework.impl.BenchmarkRunner$2.run(BenchmarkRunner.java:178)
*<------>*at java.lang.Thread.run(Thread.java:748)
[2019-02-13 12:50:51,810][INFO ][Thread-8][GridCacheProcessor] Stopped cache
[cacheName=compute]
[2019-02-13 12:50:51,812][INFO ][Thread-8][GridCacheProcessor] Stopped cache
[cacheName=query]
[2019-02-13 12:50:51,813][INFO ][Thread-8][GridCacheProcessor] Stopped cache
[cacheName=atomic-index-with-eviction]
[2019-02-13 12:50:51,813][INFO ][Thread-8][GridCacheProcessor] Stopped cache
[cacheName=atomic-index]
[2019-02-13 12:50:51,813][INFO ][Thread-8][GridCacheProcessor] Stopped cache
[cacheName=tx]
[2019-02-13 12:50:51,815][INFO ][Thread-8][GridCacheProcessor] Stopped cache
[cacheName=atomic]
[2019-02-13 12:50:51,815][INFO ][Thread-8][GridCacheProcessor] Stopped cache
[cacheName=ignite-sys-cache]
[2019-02-13 12:50:51,815][INFO ][Thread-8][GridCacheProcessor] Stopped cache
[cacheName=SQL_PUBLIC_PERSON]
[2019-02-13 12:50:51,816][INFO ][Thread-8][GridCacheProcessor] Stopped cache
[cacheName=SQL_PUBLIC_ORGANIZATION]
[2019-02-13 12:50:51,825][INFO ][Thread-8][IgniteKernal]*.*
{noformat}
was:
Config:
{noformat}
*now0**=*`date +'%H%M%S'`
# JVM options.
*JVM_OPTS**=**${JVM_OPTS}*" -DIGNITE_QUIET*=**false*"
# Uncomment to enable concurrent garbage collection (GC) if you encounter long
GC pauses.
*JVM_OPTS**=**${JVM_OPTS}*" *\*
-Xms8g *\*
-Xmx8g *\*
-Xloggc:./gc*${now0}*.log *\*
-XX:+PrintGCDetails *\*
-verbose:gc *\*
-XX:+UseParNewGC *\*
-XX:+UseConcMarkSweepGC *\*
-XX:+PrintGCDateStamps *\*
"
#Ignite version
*ver**=*ver-*2*.*8*.*0*-SNAPSHOT-rev-816f435d-
# List of default probes.
# Add DStatProbe or VmStatProbe if your OS supports it (e.g. if running on
Linux).
*BENCHMARK_DEFAULT_PROBES**=*ThroughputLatencyProbe,PercentileProbe,DStatProbe
# Packages where the specified benchmark is searched by reflection mechanism.
*BENCHMARK_PACKAGES**=*org.yardstickframework,org.apache.ignite.yardstick
# Flag which indicates to restart the servers before every benchmark execution.
*RESTART_SERVERS**=**true*
# Probe point writer class name.
# BENCHMARK_WRITER=
# Comma-separated list of the hosts to run BenchmarkServers on.
*SERVER_HOSTS**=172*.*25*.*1*.*30*,*172*.*25*.*1*.*27*,*172*.*25*.*1*.*28*,*172*.*25*.*1*.*29*
# Comma-separated list of the hosts to run BenchmarkDrivers on.
*DRIVER_HOSTS**=172*.*25*.*1*.*11*
# Remote username.
# REMOTE_USER=
# Number of nodes, used to wait for the specified number of nodes to start.
*nodesNum**=*$((`echo *${SERVER_HOSTS}* | tr ',' '\n' | wc -l` + `echo
*${DRIVER_HOSTS}* | tr ',' '\n' | wc -l`))
# Backups count.
*b**=1*
# Warmup.
*w**=60*
# Duration.
*d**=180*
# Threads count.
*t**=64*
# Sync mode.
*sm**=*PRIMARY_SYNC
# Jobs.
*j**=10*
# Run configuration which contains all benchmarks.
# Note that each benchmark is set to run for 300 seconds (5 min) with warm-up
set to 60 seconds (1 minute).
*CONFIGS**=*"*\*
-cfg *${SCRIPT_DIR}*/../config/ignite-config.xml -nn *${nodesNum}* -b *${b}* -w
*${w}* -d *${d}* -t *${t}* -sm *${sm}* -pc *2* -r *100000* *-*-sqlRange *1*
*-*-client
*-dn* NativeSqlJoinQueryRangeBenchmark -sn IgniteNode -ds
*${ver}*sql-select-native-join-r1-*${b}*-backup,*\*
"
{noformat}
Exception:
{noformat}
<12:50:49><main><yardstick> Populate 90000
<12:50:50><main><yardstick> Populate 100000
<12:50:50><main><yardstick> Probe writer is not configured (using default CSV
writer)
<12:50:50><main><yardstick> ThroughputLatencyProbe is started.
<12:50:50><main><yardstick> PercentileProbe is started.
<12:50:50><main><yardstick> DStatProbe is started. Command: 'dstat -m --all
--noheaders --noupdate 1'
<12:50:50><main><yardstick> Starting warmup.
Finishing main test [ts=1550051451762, date=Wed Feb 13 12:50:51 MSK 2019]
ERROR: Shutting down benchmark driver to unexpected exception.
Type '--help' for usage.
java.lang.Exception: Invalid result set size [actual=0, expected=1]
*<------>*at
org.apache.ignite.yardstick.jdbc.NativeSqlJoinQueryRangeBenchmark.test(NativeSqlJoinQueryRangeBenchmark.java:84)
*<------>*at
org.yardstickframework.impl.BenchmarkRunner$2.run(BenchmarkRunner.java:178)
*<------>*at java.lang.Thread.run(Thread.java:748)
[2019-02-13 12:50:51,810][INFO ][Thread-8][GridCacheProcessor] Stopped cache
[cacheName=compute]
[2019-02-13 12:50:51,812][INFO ][Thread-8][GridCacheProcessor] Stopped cache
[cacheName=query]
[2019-02-13 12:50:51,813][INFO ][Thread-8][GridCacheProcessor] Stopped cache
[cacheName=atomic-index-with-eviction]
[2019-02-13 12:50:51,813][INFO ][Thread-8][GridCacheProcessor] Stopped cache
[cacheName=atomic-index]
[2019-02-13 12:50:51,813][INFO ][Thread-8][GridCacheProcessor] Stopped cache
[cacheName=tx]
[2019-02-13 12:50:51,815][INFO ][Thread-8][GridCacheProcessor] Stopped cache
[cacheName=atomic]
[2019-02-13 12:50:51,815][INFO ][Thread-8][GridCacheProcessor] Stopped cache
[cacheName=ignite-sys-cache]
[2019-02-13 12:50:51,815][INFO ][Thread-8][GridCacheProcessor] Stopped cache
[cacheName=SQL_PUBLIC_PERSON]
[2019-02-13 12:50:51,816][INFO ][Thread-8][GridCacheProcessor] Stopped cache
[cacheName=SQL_PUBLIC_ORGANIZATION]
[2019-02-13 12:50:51,825][INFO ][Thread-8][IgniteKernal]*.*
{noformat}
> NativeSqlJoinQueryRangeBenchmark doesn't work
> ---------------------------------------------
>
> Key: IGNITE-11306
> URL: https://issues.apache.org/jira/browse/IGNITE-11306
> Project: Ignite
> Issue Type: Task
> Components: yardstick
> Affects Versions: 2.7
> Reporter: Ilya Suntsov
> Priority: Major
>
> Config:
> {noformat}
> now0=`date +'%H%M%S'`
> # JVM options.
> JVM_OPTS=${JVM_OPTS}" -DIGNITE_QUIET=false"
> # Uncomment to enable concurrent garbage collection (GC) if you encounter
> long GC pauses.
> JVM_OPTS=${JVM_OPTS}" \
> -Xms8g \
> -Xmx8g \
> -Xloggc:./gc${now0}.log \
> -XX:+PrintGCDetails \
> -verbose:gc \
> -XX:+UseParNewGC \
> -XX:+UseConcMarkSweepGC \
> -XX:+PrintGCDateStamps \
> "
> #Ignite version
> ver=ver-2.8.0-SNAPSHOT-rev-816f435d-
> # List of default probes.
> # Add DStatProbe or VmStatProbe if your OS supports it (e.g. if running on
> Linux).
> BENCHMARK_DEFAULT_PROBES=ThroughputLatencyProbe,PercentileProbe,DStatProbe
> # Packages where the specified benchmark is searched by reflection mechanism.
> BENCHMARK_PACKAGES=org.yardstickframework,org.apache.ignite.yardstick
> # Flag which indicates to restart the servers before every benchmark
> execution.
> RESTART_SERVERS=true
> # Probe point writer class name.
> # BENCHMARK_WRITER=
> # Comma-separated list of the hosts to run BenchmarkServers on.
> SERVER_HOSTS=172.25.1.30,172.25.1.27,172.25.1.28,172.25.1.29
> # Comma-separated list of the hosts to run BenchmarkDrivers on.
> DRIVER_HOSTS=172.25.1.11
> # Remote username.
> # REMOTE_USER=
> # Number of nodes, used to wait for the specified number of nodes to start.
> nodesNum=$((`echo ${SERVER_HOSTS} | tr ',' '\n' | wc -l` + `echo
> ${DRIVER_HOSTS} | tr ',' '\n' | wc -l`))
> # Backups count.
> b=1
> # Warmup.
> w=60
> # Duration.
> d=180
> # Threads count.
> t=64
> # Sync mode.
> sm=PRIMARY_SYNC
> # Jobs.
> j=10
> # Run configuration which contains all benchmarks.
> # Note that each benchmark is set to run for 300 seconds (5 min) with warm-up
> set to 60 seconds (1 minute).
> CONFIGS="\
> -cfg ${SCRIPT_DIR}/../config/ignite-config.xml -nn ${nodesNum} -b ${b} -w
> ${w} -d ${d} -t ${t} -sm ${sm} -pc 2 -r 100000 --sqlRange 1 --client
> -dn NativeSqlJoinQueryRangeBenchmark -sn IgniteNode -ds
> ${ver}sql-select-native-join-r1-${b}-backup,\
> "
> {noformat}
> Exception:
> {noformat}
> <12:50:49><main><yardstick> Populate 90000
> <12:50:50><main><yardstick> Populate 100000
> <12:50:50><main><yardstick> Probe writer is not configured (using default CSV
> writer)
> <12:50:50><main><yardstick> ThroughputLatencyProbe is started.
> <12:50:50><main><yardstick> PercentileProbe is started.
> <12:50:50><main><yardstick> DStatProbe is started. Command: 'dstat -m --all
> --noheaders --noupdate 1'
> <12:50:50><main><yardstick> Starting warmup.
> Finishing main test [ts=1550051451762, date=Wed Feb 13 12:50:51 MSK 2019]
> ERROR: Shutting down benchmark driver to unexpected exception.
> Type '--help' for usage.
> java.lang.Exception: Invalid result set size [actual=0, expected=1]
> *<------>*at
> org.apache.ignite.yardstick.jdbc.NativeSqlJoinQueryRangeBenchmark.test(NativeSqlJoinQueryRangeBenchmark.java:84)
> *<------>*at
> org.yardstickframework.impl.BenchmarkRunner$2.run(BenchmarkRunner.java:178)
> *<------>*at java.lang.Thread.run(Thread.java:748)
> [2019-02-13 12:50:51,810][INFO ][Thread-8][GridCacheProcessor] Stopped cache
> [cacheName=compute]
> [2019-02-13 12:50:51,812][INFO ][Thread-8][GridCacheProcessor] Stopped cache
> [cacheName=query]
> [2019-02-13 12:50:51,813][INFO ][Thread-8][GridCacheProcessor] Stopped cache
> [cacheName=atomic-index-with-eviction]
> [2019-02-13 12:50:51,813][INFO ][Thread-8][GridCacheProcessor] Stopped cache
> [cacheName=atomic-index]
> [2019-02-13 12:50:51,813][INFO ][Thread-8][GridCacheProcessor] Stopped cache
> [cacheName=tx]
> [2019-02-13 12:50:51,815][INFO ][Thread-8][GridCacheProcessor] Stopped cache
> [cacheName=atomic]
> [2019-02-13 12:50:51,815][INFO ][Thread-8][GridCacheProcessor] Stopped cache
> [cacheName=ignite-sys-cache]
> [2019-02-13 12:50:51,815][INFO ][Thread-8][GridCacheProcessor] Stopped cache
> [cacheName=SQL_PUBLIC_PERSON]
> [2019-02-13 12:50:51,816][INFO ][Thread-8][GridCacheProcessor] Stopped cache
> [cacheName=SQL_PUBLIC_ORGANIZATION]
> [2019-02-13 12:50:51,825][INFO ][Thread-8][IgniteKernal]*.*
>
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
