Normally you're right, this should get retried at the HBase layer and would be transparent. However as part of PHOENIX-4130, we have the hbase client only try the write once, so there's no chance to retry. We did that to avoid tying up rpc handlers on the server. Instead, we retry the entire Phoenix mutation from the client side. The index is put into "PENDING_DISABLE", so that if the next write succeeds, it can flip back to "ACTIVE".
On Tue, Sep 10, 2019 at 2:29 PM Alexander Batyrshin <0x62...@gmail.com> wrote: > As I know RegionMovedException is not a problem at all, its just > notification that we need to update meta information about table regions > and retry. > Why we do extra work with changing state of index? > > 2019-09-10 22:35:00,764 WARN [hconnection-0x4a63b6ea-shared--pool10-t961] > client.AsyncProcess: #41, table=IDX_TABLE, attempt=1/1 failed=1ops, last > exception: org.apache.hadoop.hbase.exceptions.RegionMovedException: Region > moved to: hostname=prod023 port=60020 startCode=1568139705179. As > of locationSeqNum=93740117. on prod027,60020,1568142287280, tracking > started Tue Sep 10 22:35:00 MSK 2019; not retrying 1 - final failure > 2019-09-10 22:35:00,789 INFO > [RpcServer.default.FPBQ.Fifo.handler=170,queue=10,port=60020] > index.PhoenixIndexFailurePolicy: Successfully update > INDEX_DISABLE_TIMESTAMP for IDX_TABLE due to an exception while writing > updates. indexState=PENDING_DISABLE > org.apache.phoenix.hbase.index.exception.MultiIndexWriteFailureException: > disableIndexOnFailure=true, Failed to write to multiple index tables: > [IDX_TABLE] > at > org.apache.phoenix.hbase.index.write.TrackingParallelWriterIndexCommitter.write(TrackingParallelWriterIndexCommitter.java:236) > at > org.apache.phoenix.hbase.index.write.IndexWriter.write(IndexWriter.java:195) > at > org.apache.phoenix.hbase.index.write.IndexWriter.writeAndKillYourselfOnFailure(IndexWriter.java:156) > at > org.apache.phoenix.hbase.index.write.IndexWriter.writeAndKillYourselfOnFailure(IndexWriter.java:145) > at > org.apache.phoenix.hbase.index.Indexer.doPostWithExceptions(Indexer.java:614) > at org.apache.phoenix.hbase.index.Indexer.doPost(Indexer.java:589) > at > org.apache.phoenix.hbase.index.Indexer.postBatchMutateIndispensably(Indexer.java:572) > at > org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$37.call(RegionCoprocessorHost.java:1048) > at > org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$RegionOperation.call(RegionCoprocessorHost.java:1711) > at > org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1789) > at > org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1745) > at > org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postBatchMutateIndispensably(RegionCoprocessorHost.java:1044) > at > org.apache.hadoop.hbase.regionserver.HRegion.doMiniBatchMutation(HRegion.java:3677) > at > org.apache.hadoop.hbase.regionserver.HRegion.batchMutate(HRegion.java:3138) > at > org.apache.hadoop.hbase.regionserver.HRegion.batchMutate(HRegion.java:3080) > at > org.apache.hadoop.hbase.regionserver.RSRpcServices.doBatchOp(RSRpcServices.java:916) > at > org.apache.hadoop.hbase.regionserver.RSRpcServices.doNonAtomicRegionMutation(RSRpcServices.java:844) > at > org.apache.hadoop.hbase.regionserver.RSRpcServices.multi(RSRpcServices.java:2406) > at > org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:36621) > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2380) > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:124) > at > org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:297) > at > org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:277)
