[jira] [Updated] (IGNITE-21089) [YCSB] "IgniteException: readerIndex: 0, writerIndex: 257" on SQL SELECT

2023-12-15 Thread Ivan Artiukhov (Jira)


 [ 
https://issues.apache.org/jira/browse/IGNITE-21089?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ivan Artiukhov updated IGNITE-21089:

Labels: ignite-3  (was: ignite-3 performance)

> [YCSB] "IgniteException: readerIndex: 0, writerIndex: 257" on SQL SELECT
> 
>
> Key: IGNITE-21089
> URL: https://issues.apache.org/jira/browse/IGNITE-21089
> Project: Ignite
>  Issue Type: Bug
>  Components: sql
>Reporter: Ivan Artiukhov
>Priority: Major
>  Labels: ignite-3
> Attachments: 2023-12-15-04-58-54_run.txt, logs-818.zip
>
>
> AI3 rev. {{ba6cd4dfff0e4bc2eacb437a1331454e030bff84}}
> Benchmark: 
> [https://github.com/gridgain/YCSB/blob/ycsb-2023.9/ignite3/src/main/java/site/ycsb/db/ignite3/IgniteSqlClient.java]
>  
> The benchmark uses Ignite 3 Java SQL API to perform SQL queries. 
> h1. Setup
> 1 server node, 1 client node (1 thread)
> h1. Steps
> The benchmark was started 2 times:
>  # in {{load}} mode to preload 165k unique entries via {{INSERT}} (15k in 
> warmup phase + 150k in payload phase)
>  # in {{run}} mode to {{SELECT}} each entry one by one
> h1. Expected result
>  # The {{load}} mode finishes successfully without errors
>  # The {{run}} mode finishes successfully without errors
> h1. Actual result
>  # The {{load}} mode finishes successfully without errors
>  # In the {{run}} mode the very first 128 entries were read with the 
> following error. All other entries were read successfully.
> {noformat}
> org.apache.ignite.lang.IgniteException: readerIndex: 0, writerIndex: 257 
> (expected: 0 <= readerIndex <= writerIndex <= capacity(256))
>   at 
> java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:710) 
> ~[?:?]
>   at 
> org.apache.ignite.internal.util.ExceptionUtils$1.copy(ExceptionUtils.java:754)
>  ~[ignite-core-3.0.0-SNAPSHOT.jar:?]
>   at 
> org.apache.ignite.internal.util.ExceptionUtils$ExceptionFactory.createCopy(ExceptionUtils.java:688)
>  ~[ignite-core-3.0.0-SNAPSHOT.jar:?]
>   at 
> org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:525)
>  ~[ignite-core-3.0.0-SNAPSHOT.jar:?]
>   at 
> org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCauseInternal(ExceptionUtils.java:623)
>  ~[ignite-core-3.0.0-SNAPSHOT.jar:?]
>   at 
> org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:476)
>  ~[ignite-core-3.0.0-SNAPSHOT.jar:?]
>   at 
> org.apache.ignite.internal.sql.AbstractSession.execute(AbstractSession.java:63)
>  ~[ignite-core-3.0.0-SNAPSHOT.jar:?]
>   at site.ycsb.db.ignite3.IgniteSqlClient.read(IgniteSqlClient.java:51) 
> [ignite3-binding-2023.9.jar:?]
>   at site.ycsb.DBWrapper.read(DBWrapper.java:145) [core-2023.9.jar:?]
>   at 
> site.ycsb.workloads.CoreWorkload.doTransactionRead(CoreWorkload.java:746) 
> [core-2023.9.jar:?]
>   at 
> site.ycsb.workloads.CoreWorkload.doTransaction(CoreWorkload.java:666) 
> [core-2023.9.jar:?]
>   at site.ycsb.ClientThread.run(ClientThread.java:145) [core-2023.9.jar:?]
>   at java.lang.Thread.run(Thread.java:829) [?:?]
> Caused by: java.util.concurrent.CompletionException: 
> org.apache.ignite.lang.IgniteException: IGN-CMN-65535 
> TraceId:b0e3aa62-ba41-47bd-8238-f39537f78e28 readerIndex: 0, writerIndex: 257 
> (expected: 0 <= readerIndex <= writerIndex <= capacity(256))
>   at 
> java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:331)
>  ~[?:?]
>   at 
> java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:346)
>  ~[?:?]
>   at 
> java.util.concurrent.CompletableFuture$UniApply.tryFire(CompletableFuture.java:632)
>  ~[?:?]
>   at 
> java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506)
>  ~[?:?]
>   at 
> java.util.concurrent.CompletableFuture.completeExceptionally(CompletableFuture.java:2088)
>  ~[?:?]
>   at 
> org.apache.ignite.internal.client.TcpClientChannel.processNextMessage(TcpClientChannel.java:417)
>  ~[ignite-client-3.0.0-SNAPSHOT.jar:?]
>   at 
> org.apache.ignite.internal.client.TcpClientChannel.lambda$onMessage$3(TcpClientChannel.java:241)
>  ~[ignite-client-3.0.0-SNAPSHOT.jar:?]
>   at 
> java.util.concurrent.ForkJoinTask$RunnableExecuteAction.exec(ForkJoinTask.java:1426)
>  ~[?:?]
>   at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290) 
> ~[?:?]
>   at 
> java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020)
>  ~[?:?]
>   at java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656) ~[?:?]
>   at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594) 
> ~[?:?]
>   at 
> java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:183) 
> ~[?:?]
> 

[jira] [Updated] (IGNITE-21089) [YCSB] "IgniteException: readerIndex: 0, writerIndex: 257" on SQL SELECT

2023-12-15 Thread Ivan Artiukhov (Jira)


 [ 
https://issues.apache.org/jira/browse/IGNITE-21089?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ivan Artiukhov updated IGNITE-21089:

Description: 
AI3 rev. {{ba6cd4dfff0e4bc2eacb437a1331454e030bff84}}

Benchmark: 
[https://github.com/gridgain/YCSB/blob/ycsb-2023.9/ignite3/src/main/java/site/ycsb/db/ignite3/IgniteSqlClient.java]
 

The benchmark uses Ignite 3 Java SQL API to perform SQL queries. 
h1. Setup

1 server node, 1 client node (1 thread)
h1. Steps

The benchmark was started 2 times:
 # in {{load}} mode to preload 165k unique entries via {{INSERT}} (15k in 
warmup phase + 150k in payload phase)
 # in {{run}} mode to {{SELECT}} each entry one by one

h1. Expected result
 # The {{load}} mode finishes successfully without errors
 # The {{run}} mode finishes successfully without errors

h1. Actual result
 # The {{load}} mode finishes successfully without errors
 # In the {{run}} mode the very first 128 entries were read with the following 
error. All other entries were read successfully.

{noformat}
org.apache.ignite.lang.IgniteException: readerIndex: 0, writerIndex: 257 
(expected: 0 <= readerIndex <= writerIndex <= capacity(256))
at 
java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:710) ~[?:?]
at 
org.apache.ignite.internal.util.ExceptionUtils$1.copy(ExceptionUtils.java:754) 
~[ignite-core-3.0.0-SNAPSHOT.jar:?]
at 
org.apache.ignite.internal.util.ExceptionUtils$ExceptionFactory.createCopy(ExceptionUtils.java:688)
 ~[ignite-core-3.0.0-SNAPSHOT.jar:?]
at 
org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:525)
 ~[ignite-core-3.0.0-SNAPSHOT.jar:?]
at 
org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCauseInternal(ExceptionUtils.java:623)
 ~[ignite-core-3.0.0-SNAPSHOT.jar:?]
at 
org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:476)
 ~[ignite-core-3.0.0-SNAPSHOT.jar:?]
at 
org.apache.ignite.internal.sql.AbstractSession.execute(AbstractSession.java:63) 
~[ignite-core-3.0.0-SNAPSHOT.jar:?]
at site.ycsb.db.ignite3.IgniteSqlClient.read(IgniteSqlClient.java:51) 
[ignite3-binding-2023.9.jar:?]
at site.ycsb.DBWrapper.read(DBWrapper.java:145) [core-2023.9.jar:?]
at 
site.ycsb.workloads.CoreWorkload.doTransactionRead(CoreWorkload.java:746) 
[core-2023.9.jar:?]
at 
site.ycsb.workloads.CoreWorkload.doTransaction(CoreWorkload.java:666) 
[core-2023.9.jar:?]
at site.ycsb.ClientThread.run(ClientThread.java:145) [core-2023.9.jar:?]
at java.lang.Thread.run(Thread.java:829) [?:?]
Caused by: java.util.concurrent.CompletionException: 
org.apache.ignite.lang.IgniteException: IGN-CMN-65535 
TraceId:b0e3aa62-ba41-47bd-8238-f39537f78e28 readerIndex: 0, writerIndex: 257 
(expected: 0 <= readerIndex <= writerIndex <= capacity(256))
at 
java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:331)
 ~[?:?]
at 
java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:346)
 ~[?:?]
at 
java.util.concurrent.CompletableFuture$UniApply.tryFire(CompletableFuture.java:632)
 ~[?:?]
at 
java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506) 
~[?:?]
at 
java.util.concurrent.CompletableFuture.completeExceptionally(CompletableFuture.java:2088)
 ~[?:?]
at 
org.apache.ignite.internal.client.TcpClientChannel.processNextMessage(TcpClientChannel.java:417)
 ~[ignite-client-3.0.0-SNAPSHOT.jar:?]
at 
org.apache.ignite.internal.client.TcpClientChannel.lambda$onMessage$3(TcpClientChannel.java:241)
 ~[ignite-client-3.0.0-SNAPSHOT.jar:?]
at 
java.util.concurrent.ForkJoinTask$RunnableExecuteAction.exec(ForkJoinTask.java:1426)
 ~[?:?]
at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290) 
~[?:?]
at 
java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020)
 ~[?:?]
at java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656) ~[?:?]
at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594) 
~[?:?]
at 
java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:183) 
~[?:?]
Caused by: org.apache.ignite.lang.IgniteException: readerIndex: 0, writerIndex: 
257 (expected: 0 <= readerIndex <= writerIndex <= capacity(256))
at 
java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:710) ~[?:?]
at 
org.apache.ignite.internal.util.ExceptionUtils$1.copy(ExceptionUtils.java:754) 
~[ignite-core-3.0.0-SNAPSHOT.jar:?]
at 
org.apache.ignite.internal.util.ExceptionUtils$ExceptionFactory.createCopy(ExceptionUtils.java:688)
 ~[ignite-core-3.0.0-SNAPSHOT.jar:?]
at 
org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:525)
 ~[ignite-core-3.0.0-SNAPSHOT.jar:?]
at