You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Taras Ledkov (JIRA)" <ji...@apache.org> on 2018/03/19 12:52:00 UTC
[jira] [Commented] (IGNITE-7960) Wrong type name in cache metadata
on query execution
[ https://issues.apache.org/jira/browse/IGNITE-7960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16404762#comment-16404762 ]
Taras Ledkov commented on IGNITE-7960:
--------------------------------------
*Root cause*: Ignite#getOrCreateCaches creates table with not valid name.
> Wrong type name in cache metadata on query execution
> ----------------------------------------------------
>
> Key: IGNITE-7960
> URL: https://issues.apache.org/jira/browse/IGNITE-7960
> Project: Ignite
> Issue Type: Bug
> Components: cache, sql
> Affects Versions: 2.5
> Reporter: Vasiliy Sisko
> Assignee: Taras Ledkov
> Priority: Major
> Attachments: Country.java, TestQuery.java, reproducer.zip
>
>
> 1) On run of demo mode in Web console in Queries page for every query showed error. F.e.:
> Error: Table "CAR" not found.
> After debug I notice that org.h2.schema.Schema#tablesAndViews map contains key with type name stored as "Car". In that case query parser require "CAR" name and query fail.
> Caches created by invocation of java config org.apache.ignite.Ignite#getOrCreateCaches
> Added reproducer. See [^reproducer.zip]. Run RunFirst.java, stop RunFirst. run RunFirst.java again then run RunSecond.java. Second class try to execute query and print error.
> 2) I create simple reproducer (See files TestQuery.java and Country.java), but metadata and parser in that case use the same name "Car".
> Caches created by invocation of java config org.apache.ignite.Ignite#getOrCreateCaches
> 3) Configured in XML cache has normalised name of type "CAR". In that case parser too require "CAR" name and work without error.
> Caches created in process of cluster activation.
> Base cache config:
> {code}
> <bean id="tester_cache" abstract="true" class="org.apache.ignite.configuration.CacheConfiguration">
> <property name="statisticsEnabled" value="true"/>
> <property name="queryDetailMetricsSize" value="10"/>
> <property name="affinity">
> <bean class="org.apache.ignite.cache.affinity.rendezvous.RendezvousAffinityFunction">
> <property name="partitions" value="10"/>
> </bean>
> </property>
> </bean>
> {code}
> Partitioned cache config:
> {code}
> <bean id="default_partitioned" abstract="true" parent="tester_cache">
> <property name="name" value="DEFAULT"/>
> <property name="cacheMode" value="PARTITIONED"/>
> <property name="writeSynchronizationMode" value="PRIMARY_SYNC"/>
> <property name="backups" value="1"/>
> <property name="indexedTypes">
> <list>
> <value>java.lang.Integer</value>
> <value>java.lang.String</value>
> </list>
> </property>
> <property name="sqlFunctionClasses">
> <list>
> <value>org.ignite.sql.VisorTesterSQLFunctionsClass</value>
> <value>org.ignite.sql.VisorTesterSQLMathFunctionsClass</value>
> <value>org.ignite.sql.VisorTesterSQLStrFunctionsClass</value>
> </list>
> </property>
> </bean>
> {code}
> Final cache config:
> {code}
> <bean id="c_partitioned2" abstract="true" parent="default_partitioned">
> <property name="name" value="c_partitioned2"/>
> <property name="indexedTypes">
> <list>
> <value>java.util.UUID</value>
> <value>org.ignite.sql.Car</value>
> </list>
> </property>
> <property name="queryEntities">
> <list>
> <bean class="org.apache.ignite.cache.QueryEntity">
> <property name="keyType" value="org.ignite.sql.AddressKey"/>
> <property name="valueType" value="org.ignite.sql.Address"/>
> <property name="keyFields">
> <list>
> <value>pk</value>
> </list>
> </property>
> <property name="fields">
> <map>
> <entry key="pk" value="java.lang.Integer"/>
> <entry key="street" value="java.lang.String"/>
> <entry key="zip" value="java.lang.Integer"/>
> </map>
> </property>
> <property name="indexes">
> <list>
> <bean class="org.apache.ignite.cache.QueryIndex">
> <property name="name" value="ZIP_DESC_IDX"/>
> <property name="fields">
> <map>
> <entry key="zip" value="false"/>
> </map>
> </property>
> <property name="indexType" value="SORTED"/>
> </bean>
> <bean class="org.apache.ignite.cache.QueryIndex">
> <property name="name" value="STREET_TXT_IDX"/>
> <property name="fields">
> <map>
> <entry key="street" value="true"/>
> </map>
> </property>
> <property name="indexType" value="FULLTEXT"/>
> </bean>
> <bean class="org.apache.ignite.cache.QueryIndex">
> <property name="name" value="GRP_IDX"/>
> <property name="fields">
> <map>
> <entry key="street" value="true"/>
> <entry key="zip" value="true"/>
> </map>
> </property>
> <property name="indexType" value="SORTED"/>
> </bean>
> </list>
> </property>
> </bean>
> <bean class="org.apache.ignite.cache.QueryEntity">
> <property name="keyType" value="org.ignite.sql.CountryKey"/>
> <property name="valueType" value="org.ignite.sql.CountryVal"/>
> <property name="keyFields">
> <list>
> <value>pk</value>
> </list>
> </property>
> <property name="fields">
> <map>
> <entry key="pk" value="java.lang.Integer"/>
> <entry key="name" value="java.lang.String"/>
> <entry key="population" value="java.lang.Integer"/>
> </map>
> </property>
> <property name="indexes">
> <list>
> <bean class="org.apache.ignite.cache.QueryIndex">
> <property name="name" value="Country_name_ppl_IDX"/>
> <property name="fields">
> <map>
> <entry key="name" value="true"/>
> <entry key="population" value="false"/>
> </map>
> </property>
> <property name="indexType" value="SORTED"/>
> </bean>
> </list>
> </property>
> </bean>
> </list>
> </property>
> </bean>
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)