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 >
