[
https://issues.apache.org/jira/browse/IGNITE-19278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yury Gerzhedovich updated IGNITE-19278:
---------------------------------------
Component/s: sql
> Table hang on
> InternalTableImpl$PartitionScanPublisher$PartitionScanSubscription.lambda$scanBatch
> -------------------------------------------------------------------------------------------------
>
> Key: IGNITE-19278
> URL: https://issues.apache.org/jira/browse/IGNITE-19278
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 3.0.0-beta1
> Reporter: Alexander Belyak
> Assignee: Pavel Pereslegin
> Priority: Major
> Labels: ignite-3
> Fix For: 3.0.0-beta2
>
> Attachments: queueFull.txt, server.log
>
>
> 1) Create table
>
> {noformat}
> CREATE TABLE order_line (
> ol_w_id bigint NOT NULL,
> ol_d_id bigint NOT NULL,
> ol_o_id bigint NOT NULL,
> ol_number int NOT NULL,
> ol_i_id bigint NOT NULL,
> ol_delivery_d bigint,
> ol_amount double NOT NULL,
> ol_supply_w_id bigint NOT NULL,
> ol_quantity double NOT NULL,
> ol_dist_info char(24) NOT NULL,
> PRIMARY KEY (ol_w_id, ol_d_id, ol_o_id, ol_number)
> );{noformat}
>
> 2) Populate 30k random rows into it
> 3) Execute query
> SELECT OL_I_ID, OL_SUPPLY_W_ID, OL_QUANTITY, OL_AMOUNT, OL_DELIVERY_D FROM
> order_line WHERE OL_O_ID = ? AND OL_D_ID = ? AND OL_W_ID = ?
> Get error:
>
> {noformat}
> [Code: 0, SQL State: 50000] Failed to fetch query results [curId=3]. Error
> message:java.util.concurrent.CompletionException:
> org.apache.ignite.lang.IgniteException: IGN-CMN-65535
> TraceId:276bc015-a683-4e9d-83c3-c03243d1e0a5 Remote query execution
> at
> java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:314)
> at
> java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:319)
> ...
> Caused by: java.lang.IllegalStateException: Queue full
> at java.base/java.util.AbstractQueue.add(AbstractQueue.java:98)
> at
> org.apache.ignite.internal.sql.engine.exec.rel.StorageScanNode$SubscriberImpl.onNext(StorageScanNode.java:278)
> at
> org.apache.ignite.internal.util.subscription.ConcatenatedPublisher$ConcatenatedSubscriber.onNext(ConcatenatedPublisher.java:96)
> at
> org.apache.ignite.internal.sql.engine.exec.rel.StorageScanNode$1.onNext(StorageScanNode.java:158)
> at
> org.apache.ignite.internal.sql.engine.exec.rel.StorageScanNode$1.onNext(StorageScanNode.java:150)
> at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
> at
> org.apache.ignite.internal.table.distributed.storage.InternalTableImpl$PartitionScanPublisher$PartitionScanSubscription.lambda$scanBatch$2(InternalTableImpl.java:1398)
> at
> java.base/java.util.concurrent.CompletableFuture$UniAccept.tryFire(CompletableFuture.java:714){noformat}
> Full error stack trace in attachment
> Similar error on any query with this table, queries with the others works
> well.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
