[ 
https://issues.apache.org/jira/browse/IGNITE-23734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17900012#comment-17900012
 ] 

Pavel Pereslegin commented on IGNITE-23734:
-------------------------------------------

I noticed similar failures in another test, for example

{{ItCastToIntWithoutFastQueryOptimizationTest.explicitCastOfLiteralsOnSelectWithOverflow([28]
 '9223372036854775808.1') }}

{noformat}
org.opentest4j.AssertionFailedError: Unexpected exception type thrown, 
expected: <org.apache.ignite.sql.SqlException> but was: 
<org.apache.ignite.lang.CursorClosedException>
        at 
app//org.apache.ignite.internal.sql.engine.util.SqlTestUtils.assertThrowsSqlException(SqlTestUtils.java:159)
        at 
app//org.apache.ignite.internal.sql.engine.util.SqlTestUtils.assertThrowsSqlException(SqlTestUtils.java:141)
        at 
app//org.apache.ignite.internal.sql.engine.datatypes.ItCastToIntTest.explicitCastOfLiteralsOnSelectWithOverflow(ItCastToIntTest.java:127)
        at [email protected]/java.lang.reflect.Method.invoke(Method.java:566)
        at 
[email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
        at 
[email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
        at 
[email protected]/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
        at 
[email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
        at 
[email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
        at 
[email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
        at 
[email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
        at 
[email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
        at 
[email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
        at 
[email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
        at 
[email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
        at 
[email protected]/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
        at 
[email protected]/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
        at 
[email protected]/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
        at 
[email protected]/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
        at 
[email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
        at 
[email protected]/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
        at 
[email protected]/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
        at 
[email protected]/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
        at 
[email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
        at 
[email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
        at 
[email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
        at 
[email protected]/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
        at 
[email protected]/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
        at 
[email protected]/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
        at 
[email protected]/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
        at 
[email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
        at 
[email protected]/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
        at 
[email protected]/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
        at 
[email protected]/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
        at 
[email protected]/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
        at 
[email protected]/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
        at 
[email protected]/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
        at 
[email protected]/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
        at 
[email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
        at 
[email protected]/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
        at 
[email protected]/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
        at 
[email protected]/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
        at 
[email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
        at 
[email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
        at 
[email protected]/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
        at 
[email protected]/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
        at 
[email protected]/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
        at 
[email protected]/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
        at 
[email protected]/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
        at 
[email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
        at 
[email protected]/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
        at 
[email protected]/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
        at 
[email protected]/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
        at 
[email protected]/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
        at 
[email protected]/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
        at 
[email protected]/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
        at 
[email protected]/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
        at 
[email protected]/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
        at 
[email protected]/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
        at 
[email protected]/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
        at [email protected]/java.util.ArrayList.forEach(ArrayList.java:1541)
        at [email protected]/java.util.ArrayList.forEach(ArrayList.java:1541)
Caused by: org.apache.ignite.lang.CursorClosedException: IGN-CMN-6 
TraceId:18a0a7fe-0ae4-48df-b25f-6070fc3c11ba Cursor is closed
        at 
[email protected]/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:710)
        at 
app//org.apache.ignite.internal.util.ExceptionUtils$12.copy(ExceptionUtils.java:929)
        at 
app//org.apache.ignite.internal.util.ExceptionUtils$ExceptionFactory.createCopy(ExceptionUtils.java:723)
        at 
app//org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:525)
        at 
app//org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCauseInternal(ExceptionUtils.java:658)
        at 
app//org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:476)
        at 
app//org.apache.ignite.internal.sql.api.IgniteSqlImpl.execute(IgniteSqlImpl.java:233)
        at 
app//org.apache.ignite.internal.sql.api.PublicApiThreadingIgniteSql.lambda$execute$2(PublicApiThreadingIgniteSql.java:81)
        at 
app//org.apache.ignite.internal.thread.PublicApiThreading.executeWithRole(PublicApiThreading.java:144)
        at 
app//org.apache.ignite.internal.thread.PublicApiThreading.execUserSyncOperation(PublicApiThreading.java:102)
        at 
app//org.apache.ignite.internal.sql.api.PublicApiThreadingIgniteSql.execute(PublicApiThreadingIgniteSql.java:81)
        at 
app//org.apache.ignite.internal.restart.RestartProofIgniteSql.lambda$execute$3(RestartProofIgniteSql.java:78)
        at 
app//org.apache.ignite.internal.restart.IgniteAttachmentLock.attached(IgniteAttachmentLock.java:59)
        at 
app//org.apache.ignite.internal.restart.RestartProofIgniteSql.execute(RestartProofIgniteSql.java:78)
        at app//org.apache.ignite.sql.IgniteSql.execute(IgniteSql.java:90)
        at 
app//org.apache.ignite.internal.ClusterPerClassIntegrationTest.sql(ClusterPerClassIntegrationTest.java:389)
        at 
app//org.apache.ignite.internal.ClusterPerClassIntegrationTest.sql(ClusterPerClassIntegrationTest.java:403)
        at 
app//org.apache.ignite.internal.ClusterPerClassIntegrationTest.sql(ClusterPerClassIntegrationTest.java:399)
        at 
app//org.apache.ignite.internal.ClusterPerClassIntegrationTest.sql(ClusterPerClassIntegrationTest.java:395)
        at 
app//org.apache.ignite.internal.ClusterPerClassIntegrationTest.sql(ClusterPerClassIntegrationTest.java:356)
        at 
app//org.apache.ignite.internal.sql.engine.datatypes.ItCastToIntTest.lambda$explicitCastOfLiteralsOnSelectWithOverflow$2(ItCastToIntTest.java:131)
        ... 62 more
{noformat}

build link: https://ci.ignite.apache.org/viewLog.html?buildId=8635979

The problem is not reproduced locally, but... may be this is related to the 
following test case:

{code:java}
    @Test
    public void testCancelMultipleQueries()  {
        IgniteImpl igniteImpl = TestWrappers.unwrapIgniteImpl(CLUSTER.node(0));

        SqlProperties properties = SqlPropertiesHelper.newBuilder()
                .set(ALLOWED_QUERY_TYPES, Set.of(SqlQueryType.QUERY))
                .build();

        HybridTimestampTracker hybridTimestampTracker = 
igniteImpl.observableTimeTracker();

        SqlQueryProcessor qryProc = queryProcessor();

        AsyncSqlCursor<InternalSqlRow> query1 = await(qryProc.queryAsync(
                properties,
                hybridTimestampTracker,
                null,
                null,
                "SELECT 1"
        ));

        try {
            Thread.sleep(1000);
        } catch (InterruptedException e) {
            throw new RuntimeException(e);
        }


        // FAILING HERE
        // throws CursorClosedException because cursor is closed automatically 
if data fits single page.
        await(query1.requestNextAsync(1));
    }
{code}

> Sql. ItSqlLogicTest.sql(types/integer/integer_overflow.test) is flaky
> ---------------------------------------------------------------------
>
>                 Key: IGNITE-23734
>                 URL: https://issues.apache.org/jira/browse/IGNITE-23734
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 3.0.0-beta1
>            Reporter: Pavel Pereslegin
>            Priority: Major
>              Labels: ignite-3
>
> The test ItSqlLogicTest.sql(types/integer/integer_overflow.test) is flaky
> Failed build: 
> https://ci.ignite.apache.org/buildConfiguration/ApacheIgnite3xGradle_Test_RunAllTests/8637119?hideTestsFromDependencies=false&hideProblemsFromDependencies=false&expandBuildTestsSection=true&expandCode+Inspection=true&expandBuildProblemsSection=true&expandBuildChangesSection=true&expandBuildDeploymentsSection=false&logView=flowAware
> {noformat}
> java.lang.AssertionError: Not expected result at: (integer_overflow.test:38). 
> Statement: SELECT -32000::SMALLINT - 1000::SMALLINT. Expected: SMALLINT out 
> of range
> Expected: a string containing "SMALLINT out of range"
>      but: was "Cursor is closed"
>       at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
>       at 
> org.apache.ignite.internal.sql.sqllogic.Statement.execute(Statement.java:123)
>       at 
> org.apache.ignite.internal.sql.sqllogic.SqlScriptRunner.run(SqlScriptRunner.java:70)
>       at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
>       at 
> java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
>       at 
> java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
>       at java.base/java.lang.Thread.run(Thread.java:834)
> {noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to