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)
