[IGNITE-16896] [Ignite 2.12.0] Long Executing Query

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 2.12
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Steven Hui
• Created: 25/Apr/22 01:37
• Updated: 29/Apr/22 15:31
• Resolved: 29/Apr/22 15:31

Description

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.

1) set the 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>

2) 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";

 

3) Run the Failure Query to simulate. 

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

Issue Links

• duplicates: IGNITE-16629 Wrong calculation of replies count for queries with partition pruning and enabled parallelism