You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Maxim Muzafarov (Jira)" <ji...@apache.org> on 2022/04/29 15:03:00 UTC
[jira] [Commented] (IGNITE-16896) [Ignite 2.12.0] Long Executing Query
[ https://issues.apache.org/jira/browse/IGNITE-16896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17530041#comment-17530041 ]
Maxim Muzafarov commented on IGNITE-16896:
------------------------------------------
[~stevenhui] Hello, can you please attach the full execution log with and example of long running query?
> [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
> Priority: Major
>
> 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)