table table with many indexes on it. On upserts we getting this
> error:
>
> o.a.phoenix.execute.MutationState - Swallowing exception and retrying after
> clearing meta cache on connection. java.sql.SQLException: ERROR 2008 (INT10):
> Unable to find cached index metadata. ERROR
.sql.SQLException: ERROR 2008
> (INT10): Unable to find cached index metadata. ERROR 2008 (INT10): ERROR
> 2008 (INT10): Unable to find cached index metadata. key=8283602185356160420
> region=HISTORY,D\xEF\xBF\xBD\xEF\xBF\xBDNt\x1B\xEF\xBF\xBD\
> xEF\xBF\xBD\xEF\xBF\xBD5\x1E
Hello all,
We use mutable table with many indexes on it. On upserts we getting this error:
o.a.phoenix.execute.MutationState - Swallowing exception and retrying after
clearing meta cache on connection. java.sql.SQLException: ERROR 2008 (INT10):
Unable to find cached index metadata. ERROR 2008
12:15:41,250 INFO
> [RW.default.writeRpcServer.handler=40,queue=6,port=16020]
> util.IndexManagementUtil: Rethrowing
> org.apache.hadoop.hbase.DoNotRetryIOException: ERROR 2008 (INT10): ERROR
> 2008 (INT10): Unable to find cached index metadata.
> key=7015231383024113337 region=,-056946674
&
our region
>> servers. The indexes are global, the data table has more than a 100B rows
>>
>> 2016-11-26 12:15:41,250 INFO
>> [RW.default.writeRpcServer.handler=40,queue=6,port=16020]
>> util.IndexManagementUtil: Rethrowing
>> org.apache.hadoop.hbase.DoNo
r.handler=40,queue=6,port=16020]
> util.IndexManagementUtil: Rethrowing
> org.apache.hadoop.hbase.DoNotRetryIOException: ERROR 2008 (INT10): ERROR
> 2008 (INT10): Unable to find cached index metadata.
> key=7015231383024113337 region=,-056946674
>,1477336770695.07d70ebd6
er=40,queue=6,port=16020]
util.IndexManagementUtil: Rethrowing
org.apache.hadoop.hbase.DoNotRetryIOException: ERROR 2008 (INT10): ERROR
2008 (INT10): Unable to find cached index metadata.
key=7015231383024113337 region=,-056946674
,1477336770695.07d70ebd63f737a62e24387cf0912af5. Index
u
ERROR [B.defaultRpcServer.handler=25,queue=5,port=16020]
> parallel.BaseTaskRunner: Found a failed task because:
> org.apache.hadoop.hbase.DoNotRetryIOException: *ERROR 2008 (INT10): ERROR
> 2008 (INT10): Unable to find cached index metadata.* key=4276342695061435086
> region=BIDDING_EVENTS,\x
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
>>> 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 inde
g 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):
>> ERR
r 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 (I
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.
b with 20 reducers to load data into this
>> table(maybe i m doing 50 writes/second/reducer). Dataset is around 500K
>> rows only. My mapreduce job is failing due to this exception:
>> Caused by: org.apache.phoenix.execute.CommitException:
>> java.sql.SQLException: ERROR 200
oenix.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=-413539871950113484
> region=BI.TABLE,\x80M*\xBFr\xFF\x05\x1DW\x9A`\x00\x19\x0C\xC0\x0
nd 500K rows only. My
> mapreduce job is failing due to this exception:
> Caused by: 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 fi
values ()’
//hbaseUpsertExecutor.executeBatch()
//stmt.execute();
}
hbaseUpsertExecutor.executeBatch()
// connection.setAutoCommit(false);
conn.commit(); // here got the error message. ERROR
2008 (INT10): Unable to find cached index metadata.
// logger.info(" inserted batch " + bat
...@certusnet.com.cn [su...@certusnet.com.cn]
Sent: Tuesday, September 02, 2014 8:27 AM
To: user
Subject: Re: Re: Unable to find cached index metadata
Hi,
Thanks for your reply. Sorry for not completely describing my job
information.
I had configured the properties in hbase-site.xml in hmaster node and
From: rajesh babu Chintaguntla
Date: 2014-09-02 10:55
To: user
Subject: Re: Unable to find cached index metadata
Hi Sun,
Thanks for testing,
Have you configured following properties at master side and restarted it before
creating local indexes?
hbase.master.loadbalancer.class
misunderstanding.
>Best Regards, Sun.
> 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=-861467238479432
> region=RANAPS
prefixed with
'_LOCAL_IDX_' + TableRef.
Any available hints? Also corrects me if I got some misunderstanding.
Best Regards, Sun.
org.apache.phoenix.execute.CommitException: java.sql.SQLException: ERROR
2008 (INT10): Unable to find cached index metadata. ERROR 2008 (INT10): E
21 matches
Mail list logo