phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From anil gupta <anilgupt...@gmail.com>
Subject Re: ERROR 2008 (INT10): Unable to find cached index metadata.
Date Wed, 17 Feb 2016 23:13:38 GMT
phoenix.upsert.batch.size is a client side property.  We lowered it down to
20-50. Its YMMV as per your use case.

phoenix.coprocessor.maxServerCacheTimeToLiveMs is a server side property.
You will need to restart your hbase cluster for this.

On Wed, Feb 17, 2016 at 3:01 PM, Neelesh <neeleshs@gmail.com> wrote:

> Also, was your change to phoenix.upsert.batch.size on the client or on
> the region server or both?
>
> On Wed, Feb 17, 2016 at 2:57 PM, Neelesh <neeleshs@gmail.com> wrote:
>
>> Thanks Anil. We've upped phoenix.coprocessor.maxServerCacheTimeToLiveMs,
>> but haven't tried playing with phoenix.upsert.batch.size. Its at the
>> default 1000.
>>
>> On Wed, Feb 17, 2016 at 12:48 PM, anil gupta <anilgupta84@gmail.com>
>> wrote:
>>
>>> I think, this has been answered before:
>>> http://search-hadoop.com/m/9UY0h2FKuo8RfAPN
>>>
>>> Please let us know if the problem still persists.
>>>
>>> On Wed, Feb 17, 2016 at 12:02 PM, Neelesh <neeleshs@gmail.com> wrote:
>>>
>>>> We've been running phoenix 4.4 client for a while now with HBase
>>>> 1.1.2.  Once in a while while UPSERTing records (on a table with 2 global
>>>> indexes), we see the following error.  I found
>>>> https://issues.apache.org/jira/browse/PHOENIX-1718 and upped both
>>>> values in that JIRA to 3600000. This still does not help and we keep
>>>> seeing this once in a while. What's not clear is also if this setting is
>>>> relevant for client or just the server.
>>>>
>>>> Any help is appreciated
>>>>
>>>> org.apache.phoenix.execute.CommitException: java.sql.SQLException: ERROR
2008 (INT10): Unable to find cached index metadata.  ERROR 2008 (INT10): ERROR 2008 (INT10):
Unable to find cached index metadata.  key=5115312427460709976 region=TEST_TABLE,111-222-950835849
                             ,1455513914764.48b2157bcdac165898983437c1801ea7. Index update
failed
>>>>         at org.apache.phoenix.execute.MutationState.commit(MutationState.java:444)
~[phoenix-client-4.4.0-HBase-1.1.jar:4.4.0-HBase-1.1]
>>>>         at org.apache.phoenix.jdbc.PhoenixConnection$3.call(PhoenixConnection.java:459)
~[phoenix-client-4.4.0-HBase-1.1.jar:4.4.0-HBase-1.1]
>>>>         at org.apache.phoenix.jdbc.PhoenixConnection$3.call(PhoenixConnection.java:456)
~[phoenix-client-4.4.0-HBase-1.1.jar:4.4.0-HBase-1.1]
>>>>         at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) ~[phoenix-client-4.4.0-HBase-1.1.jar:4.4.0-HBase-1.1]
>>>>         at org.apache.phoenix.jdbc.PhoenixConnection.commit(PhoenixConnection.java:456)
~[phoenix-client-4.4.0-HBase-1.1.jar:4.4.0-HBase-1.1]
>>>>
>>>>
>>>
>>>
>>> --
>>> Thanks & Regards,
>>> Anil Gupta
>>>
>>
>>
>


-- 
Thanks & Regards,
Anil Gupta

Mime
View raw message