[jira] [Created] (IGNITE-23733) Sql. Some tests from ItSqlQueriesSystemViewTest are flaky (checkCleanupOnError and multiStatement)

[Pavel Pereslegin (Jira)]

Pavel Pereslegin created IGNITE-23733:
-----------------------------------------

             Summary: Sql. Some tests from ItSqlQueriesSystemViewTest are flaky 
(checkCleanupOnError and multiStatement)
                 Key: IGNITE-23733
                 URL: https://issues.apache.org/jira/browse/IGNITE-23733
             Project: Ignite
          Issue Type: Bug
          Components: sql
            Reporter: Pavel Pereslegin


Tests ItSqlQueriesSystemViewTest.multistatement and 
ItSqlQueriesSystemViewTest.checkCleanupOnError are flaky.

Failed build: 
https://ci.ignite.apache.org/viewLog.html?buildId=8637119&buildTypeId=ApacheIgnite3xGradle_Test_RunAllTests&fromSakuraUI=true

History:
https://ci.ignite.apache.org/project.html?projectId=ApacheIgnite3xGradle_Test_IntegrationTests&buildTypeId=&tab=testDetails&testNameId=-8522008199947119678&order=TEST_STATUS_DESC&branch_ApacheIgnite3xGradle_Test_IntegrationTests=__all_branches__&itemsCount=50

Looks like failures relates to each other (test fails always together)

Error output.

multistatement 
{noformat}
java.lang.AssertionError: 
Expected: is <2>
     but: was <3>
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
        at 
org.apache.ignite.internal.sql.engine.ItSqlQueriesSystemViewTest.multiStatement(ItSqlQueriesSystemViewTest.java:201)
        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
        at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
        at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
        Suppressed: org.opentest4j.AssertionFailedError: node=isqsvt_n_0, 
count=2 ==> expected: <true> but was: <false>
                at 
app//org.junit.jupiter.api.AssertionFailureBuilder.build(AssertionFailureBuilder.java:151)
                at 
app//org.junit.jupiter.api.AssertionFailureBuilder.buildAndThrow(AssertionFailureBuilder.java:132)
                at 
app//org.junit.jupiter.api.AssertTrue.failNotTrue(AssertTrue.java:63)
                at 
app//org.junit.jupiter.api.AssertTrue.assertTrue(AssertTrue.java:36)
                at 
app//org.junit.jupiter.api.Assertions.assertTrue(Assertions.java:214)
                at 
app//org.apache.ignite.internal.sql.engine.ItSqlQueriesSystemViewTest.checkNoPendingQueries(ItSqlQueriesSystemViewTest.java:307)
                at 
app//org.apache.ignite.internal.sql.engine.ItSqlQueriesSystemViewTest.cleanup(ItSqlQueriesSystemViewTest.java:69)
                ... 3 more
        Suppressed: org.opentest4j.AssertionFailedError: expected: <0> but was: 
<1>
                at 
app//org.apache.ignite.internal.sql.engine.BaseSqlMultiStatementTest.checkNoPendingTransactionsAndOpenedCursors(BaseSqlMultiStatementTest.java:50)
                ... 3 more
{noformat}

checkCleanupOnError
{noformat}
org.opentest4j.AssertionFailedError: node=isqsvt_n_0, count=2 ==> expected: 
<true> but was: <false>
        at 
app//org.junit.jupiter.api.AssertionFailureBuilder.build(AssertionFailureBuilder.java:151)
        at 
app//org.junit.jupiter.api.AssertionFailureBuilder.buildAndThrow(AssertionFailureBuilder.java:132)
        at app//org.junit.jupiter.api.AssertTrue.failNotTrue(AssertTrue.java:63)
        at app//org.junit.jupiter.api.AssertTrue.assertTrue(AssertTrue.java:36)
        at app//org.junit.jupiter.api.Assertions.assertTrue(Assertions.java:214)
        at 
app//org.apache.ignite.internal.sql.engine.ItSqlQueriesSystemViewTest.checkNoPendingQueries(ItSqlQueriesSystemViewTest.java:307)
        at 
app//org.apache.ignite.internal.sql.engine.ItSqlQueriesSystemViewTest.checkCleanupOnError(ItSqlQueriesSystemViewTest.java:259)
        at java.base@11.0.17/java.lang.reflect.Method.invoke(Method.java:566)
        at java.base@11.0.17/java.util.ArrayList.forEach(ArrayList.java:1541)
        at java.base@11.0.17/java.util.ArrayList.forEach(ArrayList.java:1541)
        Suppressed: org.opentest4j.AssertionFailedError: node=isqsvt_n_0, 
count=2 ==> expected: <true> but was: <false>
                at 
app//org.junit.jupiter.api.AssertionFailureBuilder.build(AssertionFailureBuilder.java:151)
                at 
app//org.junit.jupiter.api.AssertionFailureBuilder.buildAndThrow(AssertionFailureBuilder.java:132)
                at 
app//org.junit.jupiter.api.AssertTrue.failNotTrue(AssertTrue.java:63)
                at 
app//org.junit.jupiter.api.AssertTrue.assertTrue(AssertTrue.java:36)
                at 
app//org.junit.jupiter.api.Assertions.assertTrue(Assertions.java:214)
                at 
app//org.apache.ignite.internal.sql.engine.ItSqlQueriesSystemViewTest.checkNoPendingQueries(ItSqlQueriesSystemViewTest.java:307)
                at 
app//org.apache.ignite.internal.sql.engine.ItSqlQueriesSystemViewTest.cleanup(ItSqlQueriesSystemViewTest.java:69)
                ... 3 more
        Suppressed: org.opentest4j.AssertionFailedError: expected: <0> but was: 
<1>
                at 
app//org.apache.ignite.internal.sql.engine.BaseSqlMultiStatementTest.checkNoPendingTransactionsAndOpenedCursors(BaseSqlMultiStatementTest.java:50)
                ... 3 more
{noformat}



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