[
https://issues.apache.org/jira/browse/IGNITE-29178?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18138808#comment-18138808
]
Ignite TC Bot commented on IGNITE-29178:
----------------------------------------
{panel:title=Branch: [pull/13736/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/13736/head] Base: [master] : New Tests
(6)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL 1{color} [[tests
6|https://ci2.ignite.apache.org/viewLog.html?buildId=9470613]]
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.schema.IgniteStatisticsImplTest.testNodeLeftKeepsPreviousEstimate
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.tx.SqlTransactionsTopologyChangeTest.testSelectAfterAsyncCacheDestroy(boolean)[1]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.schema.IgniteStatisticsImplTest.testPrimaryRowsOnly(CacheMode)[2]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.schema.IgniteStatisticsImplTest.testPrimaryRowsOnly(CacheMode)[1]
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.query.calcite.schema.IgniteStatisticsImplTest.testTimeoutKeepsPreviousEstimate
- PASSED{color}
*
{color:#013220}org.apache.ignite.internal.processors.tx.SqlTransactionsTopologyChangeTest.testSelectAfterAsyncCacheDestroy(boolean)[2]
- PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=9470730&buildTypeId=IgniteTests24Java8_RunAll]
{color:#ffffff}tcbot-analysis-comment chainBuildId=9470730
rerunBuildIds=9473559{color}
> SQL Calcite: SELECT hangs during a topology change within a transaction
> -----------------------------------------------------------------------
>
> Key: IGNITE-29178
> URL: https://issues.apache.org/jira/browse/IGNITE-29178
> Project: Ignite
> Issue Type: Bug
> Affects Versions: 2.18
> Reporter: Kirill Tkalenko
> Assignee: Kirill Tkalenko
> Priority: Major
> Labels: calcite, sql, transaction
> Attachments: SqlTransactionsCacheDestroyTest.java
>
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> A {{SELECT}} query can hang when a topology change starts while a transaction
> is active.
> Reproduction scenario:
> {code:java}
> ignite.createCache("unrelated");
> sql("CREATE TABLE test (id INT PRIMARY KEY, val INT)");
> sql("INSERT INTO test VALUES (1, 0)");
> try (Transaction tx = ignite.transactions().txStart()) {
> sql("UPDATE test SET val = 1 WHERE id = 1");
> runAsync(() -> ignite.destroyCache("unrelated"));
> waitForCacheStopExchangeToStart();
>
> sql("SELECT * FROM test"); // Hangs.
>
> tx.commit();
> }{code}
> The query remains blocked until the transaction times out. With no
> transaction timeout, it can hang indefinitely.
> Reproducer: [^SqlTransactionsCacheDestroyTest.java]
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
