You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@phoenix.apache.org by "Jepson (JIRA)" <ji...@apache.org> on 2018/09/12 03:10:00 UTC
[jira] [Comment Edited] (PHOENIX-4364) java.sql.SQLException: ERROR
2008 (INT10): Unable to find cached index metadata.
[ https://issues.apache.org/jira/browse/PHOENIX-4364?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16611464#comment-16611464 ]
Jepson edited comment on PHOENIX-4364 at 9/12/18 3:09 AM:
----------------------------------------------------------
[~Jaanai] Thanks for this, help to check.
1.client code batch size: 500
2.parallel thread number of write, *which parameter?*
3.server :
[configuration|https://phoenix.apache.org/tuning.html]
phoenix.query.maxServerCacheBytes : 1048576000
phoenix.coprocessor.maxMetaDataCacheSize : 102400000
phoenix.coprocessor.maxServerCacheTimeToLiveMs : 1800000
phoenix.coprocessor.maxMetaDataCacheTimeToLiveMs: 1800000
[secondary_indexing|https://phoenix.apache.org/secondary_indexing.html]
index.builder.threads.max : 256
index.builder.threads.keepalivetime : 360
index.writer.threads.max : 256
index.writer.threads.keepalivetime : 360
hbase.htable.threads.keepalivetime : 360
index.tablefactory.cache.size : 256
org.apache.phoenix.regionserver.index.handler.count : 256
was (Author: 1028344078@qq.com):
[~Jaanai] Thanks for this, help to check.
1.client code batch size: 500
2.parallel thread number of write, *which parameter?*
3.server cache:
phoenix.query.maxServerCacheBytes : 1048576000
phoenix.coprocessor.maxMetaDataCacheSize : 102400000
phoenix.coprocessor.maxServerCacheTimeToLiveMs : 1800000
phoenix.coprocessor.maxMetaDataCacheTimeToLiveMs: 1800000
> java.sql.SQLException: ERROR 2008 (INT10): Unable to find cached index metadata.
> ---------------------------------------------------------------------------------
>
> Key: PHOENIX-4364
> URL: https://issues.apache.org/jira/browse/PHOENIX-4364
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.10.0
> Environment: phoenix4.10.0
> Reporter: Jepson
> Priority: Critical
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> use phoenix jdbc:
> {code:java}
> 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=-1442130476102410039 region=JYDW:OMS_ORDERINFO,,1509703165591.421fdfea168d20112be0d74b27cdf23a.host=hadoop52,60020,1510212373872 Index update failed
> {code}
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)