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