[jira] [Created] (IGNITE-16896) [Ignite 2.12.0] Long Executing Query

["Steven Hui (Jira)" <ji...@apache.org>]

Steven Hui created IGNITE-16896:
-----------------------------------

             Summary: [Ignite 2.12.0] Long Executing Query
                 Key: IGNITE-16896
                 URL: https://issues.apache.org/jira/browse/IGNITE-16896
             Project: Ignite
          Issue Type: Bug
    Affects Versions: 2.12
            Reporter: Steven Hui


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



--
This message was sent by Atlassian Jira
(v8.20.7#820007)