Hi Goutham,
I did not get from your last message does it work now as expected? If
not does it work without a trick with disable/enable WAL?
ср, 19 июн. 2019 г. в 19:18, goutham manchikatla <gaut...@gmail.com>:
>
> 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
>>
--
Best regards,
Ivan Pavlukhin
