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