Hi Denis,
I tried removing Default_Region name property from config, still I see the
same behavior. But when I trigger load_cache process, and query the
cache(after a complete cluster restart) , I am getting the response.
Below is the Load_cache process.
*try* (Ignite ignite = Ignition.*start*(configFile)) {
// Start loading cache on all caching nodes.
*final* IgniteCache<String, Account> cache = ignite.cache(cacheName);
*long* ts = System.*currentTimeMillis*();
IgniteCluster cluster = ignite.cluster();
cluster.disableWal(cacheName);
*LOG*.info("Disabling WAL for Initial Data Loading");
cache.loadCache(*null*, ignite, cacheName, sqlquery);
*LOG*.info("Loaded Cache in " + (System.*currentTimeMillis*() - ts) + "
millisecs");
cluster.enableWal(cacheName);
*LOG*.info("Enabling WAL after the pre-loading is complete");
}
Thanks,
Goutham
On Tue, Jun 18, 2019 at 8:45 PM Denis Magda <dma...@apache.org> wrote:
> Try to remove Default_Region name property from your config. If to follow
> this example that’s how persistence is enabled for the default region:
> https://apacheignite.readme.io/docs/distributed-persistent-store
>
> Denis
>
>
> On Thursday, June 6, 2019, goutham manchikatla <gaut...@gmail.com> wrote:
>
>> Hi,
>>
>> I didn't change any code between restarts. Below is the configuration.
>>
>> <property name="dataStorageConfiguration">
>> <bean
>> class="org.apache.ignite.configuration.DataStorageConfiguration">
>> <property name="concurrencyLevel" value="4"/>
>> <property name="walHistorySize" value="2"/>
>> <property name="writeThrottlingEnabled" value="true"/>
>> <property name="pageSize" value="#{4 * 1024}"/>
>> <property name="defaultDataRegionConfiguration">
>> <bean
>> class="org.apache.ignite.configuration.DataRegionConfiguration">
>> <property name="name" value="Default_Region"/>
>> <property name="initialSize" value="#{100 * 1024 *
>> 1024}"/>
>> </bean>
>> </property>
>> <property name="dataRegionConfigurations">
>> <list>
>> <bean
>> class="org.apache.ignite.configuration.DataRegionConfiguration">
>> <property name="name" value="500MB_Region"/>
>> <!-- Memory region of 600 MB initial size. -->
>> <property name="initialSize" value="#{600 * 1024
>> * 1024}"/>
>> <!-- Maximum size is 10GB. -->
>> <property name="maxSize" value="#{10L * 1024 *
>> 1024 * 1024}"/>
>> <!-- Enabling persistence for the region -->
>> <property name="persistenceEnabled"
>> value="true"/>
>> <!-- Enabling RANDOM_LRU eviction for this
>> region. -->
>> <property name="pageEvictionMode"
>> value="RANDOM_LRU"/>
>> <!-- Increasing the buffer size to 1 GB. -->
>> <property name="checkpointPageBufferSize"
>> value="#{1024L * 1024 * 1024}"/>
>> </bean>
>> </list>
>> </property>
>> </bean>
>> </property>
>> <!-- Enabling authentication. -->
>> <property name="authenticationEnabled" value="true"/>
>> <!-- cache configuration -->
>> <property name="cacheConfiguration">
>> <list>
>> <!-- partitioned cache configuration. -->
>> <bean
>> class="org.apache.ignite.configuration.CacheConfiguration">
>> <property name="dataRegionName" value="500MB_Region"/>
>> <property name="groupName" value="oegress"/>
>> <property name="name" value="lincs_cache"/>
>> <property name="sqlSchema" value="lincs"/>
>> <property name="cacheMode" value="PARTITIONED"/>
>> <property name="atomicityMode" value="ATOMIC"/>
>> <property name="backups" value="0"/>
>> <property name="readFromBackup" value="true"/>
>> <property name="copyOnRead" value="true"/>
>> <property name="readThrough" value="true"/>
>> <property name="writeThrough" value="true"/>
>> <property name="cacheStoreFactory">
>> <bean
>> class="javax.cache.configuration.FactoryBuilder" factory-method="factoryOf">
>> <constructor-arg
>> value="com.cachestore.AccountCacheStore"></constructor-arg>
>> </bean>
>> </property>
>> <property name="queryEntities">
>> <list>
>> <bean
>> class="org.apache.ignite.cache.QueryEntity">
>> <property name="keyType"
>> value="java.lang.String"></property>
>> <property name="valueType"
>> value="com.domain.Account"></property>
>> <property name="fields">
>> <map>
>> <entry key="accountNumber"
>> value="java.lang.String"></entry>
>> <entry key="firstName"
>> value="java.lang.String"></entry>
>> <entry key="lastName"
>> value="java.lang.String"></entry>
>> <entry key="servAddrLine1"
>> value="java.lang.String"></entry>
>> <entry key="servAddrLine2"
>> value="java.lang.String"></entry>
>> <entry key="servAddrCity"
>> value="java.lang.String"></entry>
>> <entry key="servAddrState"
>> value="java.lang.String"></entry>
>> <entry key="servAddrZip"
>> value="java.lang.String"></entry>
>> <entry key="billingSystem"
>> value="java.lang.String"></entry>
>> </map>
>> </property>
>> </bean>
>> </list>
>> </property>
>> </bean>
>> </list>
>> </property>
>> </bean>
>>
>>
>> On Thu, Jun 6, 2019 at 8:32 AM Ilya Kasnacheev <ilya.kasnach...@gmail.com>
>> wrote:
>>
>>> Hello!
>>>
>>> This is strange. What's cache configuration? Is there a reproducer? Did
>>> you change the code between restarts, including key/value types, if any?
>>>
>>> Regards,
>>> --
>>> Ilya Kasnacheev
>>>
>>>
>>> чт, 6 июн. 2019 г. в 16:16, goutham manchikatla <gaut...@gmail.com>:
>>>
>>>> Yes , the query worked before restart.
>>>>
>>>> On Thu, Jun 6, 2019 at 4:16 AM Ilya Kasnacheev <
>>>> ilya.kasnach...@gmail.com> wrote:
>>>>
>>>>> Hello!
>>>>>
>>>>> Does the query work before the restart?
>>>>>
>>>>> Regards,
>>>>>
>>>>> --
>>>>> Ilya Kasnacheev
>>>>>
>>>>>
>>>>> ср, 5 июн. 2019 г. в 22:37, goutham manchikatla <gaut...@gmail.com>:
>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> I have an Ignite SQL cache setup with persistence enabled and loaded
>>>>>> the cache with 10 million records.
>>>>>> Once I do a cache restart, I get an empty response when I query the
>>>>>> cache.
>>>>>> But when I check cache size it gives me 10 million record count in
>>>>>> cache.
>>>>>> Any suggestions?
>>>>>>
>>>>>> Thanks
>>>>>>
>>>>>
>
> --
> -
> Denis
>
>
