Have no clever idea, waiting for a reproducer.
вт, 25 июн. 2019 г. в 05:59, goutham manchikatla <gaut...@gmail.com>:
>
> It didn't work as expected, tried disable/enable WAL too, still I see the
> same behavior.
>
> On Mon, Jun 24, 2019 at 7:32 AM Павлухин Иван <vololo...@gmail.com> wrote:
>>
>> 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
--
Best regards,
Ivan Pavlukhin
