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