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