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 <neele...@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 <neele...@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 <anilgupt...@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 <neele...@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
