RE: [Ignite 2.12.0] Long Executing Query

[Hui, Steven]

Hello ignite team,

                I raised the jira 
https://issues.apache.org/jira/browse/IGNITE-16896  for this issue.

                Could you please take a look?

                Thanks!

From: Hui, Steven [ICG-IT]
Sent: Friday, April 22, 2022 2:57 PM
To: 'user@ignite.apache.org'
Cc: Chan, Boris [ICG-IT]; Lo, Marcus [ICG-IT]
Subject: RE: [Ignite 2.12.0] Long Executing Query

Hello Ignite Team,

                Any update in this issue?

                Thanks!

From: Hui, Steven [ICG-IT]
Sent: Wednesday, April 20, 2022 11:31 AM
To: 'user@ignite.apache.org'
Cc: Chan, Boris [ICG-IT]; Lo, Marcus [ICG-IT]
Subject: [Ignite 2.12.0] Long Executing Query

Hello Ignite Team,

Recently, we have upgraded the ignite version from 2.10.0 to 2.12.0 and found 
some queries keep executing and never return under ver. 2.12.0 but no such 
issue in ver. 2.10.0.

Below is the scenario to simulate this issue.

                Could you please check why they keep running and never return?

                Thanks!

Create Table DDL
CREATE TABLE IF NOT EXISTS TestRiskTemplate(
                id VARCHAR(36) NOT NULL,
                details VARCHAR NOT NULL,
                PRIMARY KEY (id)
) WITH "cache_name=TestRiskTemplateCache, affinity_key=id, 
template=RiskDataTemplate";


RiskDataTemplate configuration
<bean id="cache-template-bean1" abstract="true"
      class="org.apache.ignite.configuration.CacheConfiguration">
    <property name="name" value="RiskDataTemplate*"/>
    <property name="cacheMode" value="PARTITIONED"/>
    <property name="atomicityMode" value="ATOMIC"/>
    <property name="backups" value="2"/>
    <property name="queryParallelism" value="8"/>
    <property name="sqlSchema" value="PUBLIC"/>
    <property name="affinity">
        <bean 
class="org.apache.ignite.cache.affinity.rendezvous.RendezvousAffinityFunction">
            <property name="partitions" value="1024"/>
            <property name="excludeNeighbors" value="false"/>
            <property name="affinityBackupFilter">
                <bean 
class="org.apache.ignite.cache.affinity.rendezvous.ClusterNodeAttributeAffinityBackupFilter">
                    <constructor-arg>
                        <array value-type="java.lang.String">
                            <value>AVAILABILITY_ZONE</value>
                        </array>
                    </constructor-arg>
                </bean>
            </property>
        </bean>
    </property>
</bean>

Failure Query
select * from TestRiskTemplate where id in (1, 3)
select * from TestRiskTemplate where id in (1) UNION ALL select * from 
TestRiskTemplate where id = 3
select * from TestRiskTemplate where id = 1 OR id = 3