[
https://issues.apache.org/jira/browse/IGNITE-19278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alexander Belyak updated IGNITE-19278:
--------------------------------------
Description:
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.
was:
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
> 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
> Reporter: Alexander Belyak
> Priority: Major
> Labels: ignite-3
> Attachments: queueFull.txt
>
>
> 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)
