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 >>>>>>>>>> >>>>>>>>>
