[
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: [email protected]):
[~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)
