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]
