[
https://issues.apache.org/jira/browse/IGNITE-24002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Puchkovskiy updated IGNITE-24002:
---------------------------------------
Attachment: patch.patch
> SELECT in finished RO transaction hangs
> ---------------------------------------
>
> Key: IGNITE-24002
> URL: https://issues.apache.org/jira/browse/IGNITE-24002
> Project: Ignite
> Issue Type: Bug
> Reporter: Roman Puchkovskiy
> Priority: Major
> Labels: ignite-3
> Attachments: patch.patch
>
>
> This can be reproduced test_filter_clause.test with the following patch:
>
> Subject: [PATCH]
> ---
> Index:
> modules/sql-engine/src/integrationTest/java/org/apache/ignite/internal/sql/sqllogic/ItSqlLogicTest.java
> IDEA additional info:
> Subsystem: com.intellij.openapi.diff.impl.patch.CharsetEP
> <+>UTF-8
> ===================================================================
> diff --git
> a/modules/sql-engine/src/integrationTest/java/org/apache/ignite/internal/sql/sqllogic/ItSqlLogicTest.java
>
> b/modules/sql-engine/src/integrationTest/java/org/apache/ignite/internal/sql/sqllogic/ItSqlLogicTest.java
> ---
> a/modules/sql-engine/src/integrationTest/java/org/apache/ignite/internal/sql/sqllogic/ItSqlLogicTest.java
> (revision 60ba00c032275813e942e928d95b4d3cd603815b)
> +++
> b/modules/sql-engine/src/integrationTest/java/org/apache/ignite/internal/sql/sqllogic/ItSqlLogicTest.java
> (date 1734346968854)
> @@ -142,7 +142,7 @@
> @Tag("sqllogic")
> @ExtendWith(\{SystemPropertiesExtension.class, WorkDirectoryExtension.class})
> @WithSystemProperty(key = "IMPLICIT_PK_ENABLED", value = "true")
> -@SqlLogicTestEnvironment(scriptsRoot = "src/integrationTest/sql/group1")
> +@SqlLogicTestEnvironment(scriptsRoot = "src/integrationTest/sql/group1",
> regex = ".*test_filter_clause.*")
> public class ItSqlLogicTest extends BaseIgniteAbstractTest {
> private static final String SQL_LOGIC_TEST_INCLUDE_SLOW =
> "SQL_LOGIC_TEST_INCLUDE_SLOW";
>
> @@ -349,7 +349,7 @@
> .clusterConfiguration("ignite {"
> + "metaStorage.idleSyncTimeInterval: " +
> METASTORAGE_IDLE_SYNC_TIME_INTERVAL_MS + ",\n"
> // TODO: Set dataAvailabilityTime to 1010 after
> IGNITE-24002 is fixed.
> - + "gc.lowWatermark.dataAvailabilityTime: 30010,\n"
> + + "gc.lowWatermark.dataAvailabilityTime: 1010,\n"
> + "gc.lowWatermark.updateInterval: 3000,\n"
> + "metrics.exporters.logPush.exporterName:
> logPush,\n"
> + "metrics.exporters.logPush.period: 5000\n"
>
> The hanging query is this one:
> SELECT
> SUM(i) FILTER (WHERE i < (select i from t as t2 where t.i = t2.i))
> FROM t;
> It usually takes more than 2 seconds to execute on my machine. RO
> transactions by default get timeout equal to dataAvailabilityTime, so in this
> case it's roughly 1 second and the transaction gets aborted before the query
> finishes execution. This seems to be the cause as, if dataAvailabilityTime is
> increased to 3 seconds, this query does not hang anymore.
> I suspect that inflights are the cause of this problem. This might have
> something to do with IGNITE-23980
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
