After a while we also get this error: 2016-02-14 12:45:10,515 WARN [main] org.apache.phoenix.execute.MutationState: Swallowing exception and retrying after clearing meta cache on connection. 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=-594230549321118802 region=BI.SALES,,1455470578449.44e39179789041b5a8c03316730260e7. Index update failed
We have already set: <name>phoenix.coprocessor.maxServerCacheTimeToLiveMs</name><value>180000</value> Upset batch size is 50. Write are quite frequent so the cache would not timeout in 180000ms On Sun, Feb 14, 2016 at 12:44 PM, anil gupta <[email protected]> wrote: > Hi, > > We are using phoenix4.4, hbase 1.1(hdp2.3.4). > I have a MR job that is using PhoenixOutputFormat. My job keeps on failing > due to following error: > > 2016-02-14 12:29:43,182 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:29:53,197 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:30:03,212 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:30:13,225 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:30:23,239 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:30:33,253 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:30:43,266 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:30:53,279 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:31:03,293 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:31:13,305 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:31:23,318 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:31:33,331 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:31:43,345 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:31:53,358 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:32:03,371 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:32:13,385 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:32:23,399 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:32:33,412 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:32:43,428 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:32:53,443 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:33:03,457 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:33:13,472 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:33:23,486 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:33:33,524 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:33:43,538 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:33:53,551 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:34:03,565 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:34:03,953 INFO [hconnection-0xe82ca6e-shared--pool2-t16] > org.apache.hadoop.hbase.client.AsyncProcess: #1, table=BI.SALES, > attempt=10/35 failed=2000ops, last exception: null on > hdp3.truecar.com,16020,1455326291512, tracking started null, retrying > after=10086ms, replay=2000ops > 2016-02-14 12:34:13,578 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > 2016-02-14 12:34:23,593 INFO [main] > org.apache.hadoop.hbase.client.AsyncProcess: #1, waiting for 2000 actions to > finish > > I have never seen anything like this. Can anyone give me pointers about > this problem? > > -- > Thanks & Regards, > Anil Gupta > -- Thanks & Regards, Anil Gupta
