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 Павлухин Иван <[email protected]> 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 <[email protected]>: > > > > 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 <[email protected]> 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 <[email protected]> > 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 < > [email protected]> 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 <[email protected]>: > >>>>> > >>>>> Yes , the query worked before restart. > >>>>> > >>>>> On Thu, Jun 6, 2019 at 4:16 AM Ilya Kasnacheev < > [email protected]> wrote: > >>>>>> > >>>>>> Hello! > >>>>>> > >>>>>> Does the query work before the restart? > >>>>>> > >>>>>> Regards, > >>>>>> > >>>>>> -- > >>>>>> Ilya Kasnacheev > >>>>>> > >>>>>> > >>>>>> ср, 5 июн. 2019 г. в 22:37, goutham manchikatla <[email protected] > >: > >>>>>>> > >>>>>>> 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 >
