[jira] [Created] (IGNITE-11306) NativeSqlJoinQueryRangeBenchmark doesn't work

["Ilya Suntsov (JIRA)" <ji...@apache.org>]

Ilya Suntsov created IGNITE-11306:
-------------------------------------

             Summary: 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


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)