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

Pavel Pereslegin updated IGNITE-23733:
--------------------------------------
    Description: 
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

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 [email protected]/java.lang.reflect.Method.invoke(Method.java:566)
        at [email protected]/java.util.ArrayList.forEach(ArrayList.java:1541)
        at [email protected]/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}


It seems like the failures are related to each other (tests always fail 
together)

  was:
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

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 [email protected]/java.lang.reflect.Method.invoke(Method.java:566)
        at [email protected]/java.util.ArrayList.forEach(ArrayList.java:1541)
        at [email protected]/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}


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


> 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
>            Priority: Major
>              Labels: ignite-3
>
> 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
> 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 [email protected]/java.lang.reflect.Method.invoke(Method.java:566)
>       at [email protected]/java.util.ArrayList.forEach(ArrayList.java:1541)
>       at [email protected]/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}
> It seems like the failures are related to each other (tests always fail 
> together)



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

Reply via email to