Hi, First bet is that it is a problem with configuring persistence for a cache, but I have not found any problems in config. I can suggest to check a directory with database files to check that the same directory is used among node restarts and that it contains files for the cache in question.
чт, 6 июн. 2019 г. в 19:39, goutham manchikatla <[email protected]>: > > Hi, > I will work on the reproducer project. > > I am using 2.7 version. Also I tried with Java SQL API > > SqlFieldsQuery sql = new SqlFieldsQuery(query); > > QueryCursor<List<?>> cursor = cache.query(sql) > > > On Thu, Jun 6, 2019 at 10:32 AM Ilya Kasnacheev <[email protected]> > wrote: >> >> Hello! >> >> Can you make a reproducer project which will exhibit this behavior? One >> which will fill enough data in cache so that this behavior is observable >> after restart. >> >> BTW, what's the version you are on? >> >> Have you tried scan query (via Java code)? >> >> Regards, >> -- >> Ilya Kasnacheev >> >> >> чт, 6 июн. 2019 г. в 19:25, goutham manchikatla <[email protected]>: >>> >>> http://localhost:8080/ignite?user=ignite&password=ignite&cmd=qryexe&type=Account&pageSize=10&cacheName=lincs_cache&qry=select%20*%20from%20lincs.account%20LIMIT%2010 >>> >>> Yes I tried using Debeaver JDBC, query -SELECT * FROM LINCS.ACCOUNT LIMIT >>> 10; >>> >>> Still the same behavior. >>> >>> On Thu, Jun 6, 2019 at 10:20 AM Ilya Kasnacheev <[email protected]> >>> wrote: >>>> >>>> Hello! >>>> >>>> What's the query in question? Have you tried using e.g. sqlline to connect >>>> via JDBC? >>>> >>>> Regards, >>>> -- >>>> Ilya Kasnacheev >>>> >>>> >>>> чт, 6 июн. 2019 г. в 19:15, goutham manchikatla <[email protected]>: >>>>> >>>>> Hi, >>>>> >>>>> I reproduced the behavior. I stopped the cache nodes and started them >>>>> again. I see the metadata, cache count, but no query response: >>>>> >>>>> {"successStatus":0,"sessionToken":"94DAD112C4E848E98663AF5883BBDDE2","response":[{"cacheName":"lincs_cache","types":["Account"],"keyClasses":{"Account":"java.lang.String"},"valClasses":{"Account":"com.domain.Account"},"fields":{"Account":{"ACCOUNTNUMBER":"java.lang.String","FIRSTNAME":"java.lang.String","LASTNAME":"java.lang.String","SERVADDRLINE1":"java.lang.String","SERVADDRLINE2":"java.lang.String","SERVADDRCITY":"java.lang.String","SERVADDRSTATE":"java.lang.String","SERVADDRZIP":"java.lang.String","BILLADDRLINE1":"java.lang.String","BILLADDRLINE2":"java.lang.String","BILLADDRCITY":"java.lang.String","BILLADDRSTATE":"java.lang.String","BILLADDRZIP":"java.lang.String","BILLINGSYSTEM":"java.lang.String"}},"indexes":{"Account":[]}}],"error":null} >>>>> >>>>> Record count: >>>>> >>>>> {"successStatus":0,"affinityNodeId":null,"sessionToken":"0BBB1DA51FA243298D378D1F2D2DFE80","response":121039244,"error":null} >>>>> >>>>> Query Output: >>>>> >>>>> {"successStatus":0,"sessionToken":"69E405FB1E93472FA3F06A1312E31597","error":null,"response":{"items":[],"last":true,"fieldsMetadata":[],"queryId":6}} >>>>> >>>>> >>>>> I don't see any data in the response. >>>>> >>>>> >>>>> On Thu, Jun 6, 2019 at 9:50 AM Ilya Kasnacheev >>>>> <[email protected]> wrote: >>>>>> >>>>>> Hello! >>>>>> >>>>>> Looks OK. Can you reproduce the behavior, or is it a one-time >>>>>> occurrence? What happens if you try to scan that cache? Anything >>>>>> suspicious in your logs? >>>>>> >>>>>> Regards, >>>>>> -- >>>>>> Ilya Kasnacheev >>>>>> >>>>>> >>>>>> чт, 6 июн. 2019 г. в 18:30, goutham manchikatla <[email protected]>: >>>>>>> >>>>>>> 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 -- Best regards, Ivan Pavlukhin
