[PHOENIX-5863] Upsert into view against a table with index throws exception when 4.14.3 client connects to 4.16 server

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 4.16.0
• Fix Version/s: 4.16.0
• Assignee: Sandeep Guggilam
• Reporter: Sandeep Guggilam
• Created: 22/Apr/20 00:41
• Updated: 14/Dec/22 15:51
• Resolved: 19/May/20 23:43

Description

Steps to reproduce:

1. Bring up a 4.16 server ( current 4.x branch)
2. Connect a 4.14.3 client to the server and execute below queries
3. CREATE TABLE IF NOT EXISTS T1 (ID INTEGER NOT NULL PRIMARY KEY, V1 VARCHAR(10));
4. CREATE INDEX T1_IDX ON T1(V1);
5. CREATE VIEW T1_V1 (V2 INTEGER) AS SELECT * FROM T1 WHERE ID=1;
6. UPSERT INTO T1_V1(ID, V1, V2) VALUES (1, 'abc', 1); //This throws below exception**

Error: org.apache.hadoop.hbase.client.RetriesExhaustedWithDetailsException: Failed 1 action: org.apache.hadoop.hbase.DoNotRetryIOException: At least one index write failed after retries,serverTimestamp=1587513404084,

at org.apache.phoenix.util.ServerUtil.wrapInDoNotRetryIOException(ServerUtil.java:267)

at org.apache.phoenix.hbase.index.write.TrackingParallelWriterIndexCommitter.write(TrackingParallelWriterIndexCommitter.java:249)

at org.apache.phoenix.hbase.index.write.IndexWriter.write(IndexWriter.java:203)

at org.apache.phoenix.hbase.index.IndexRegionObserver.doIndexWritesWithExceptions(IndexRegionObserver.java:1025)

at org.apache.phoenix.hbase.index.IndexRegionObserver.doPre(IndexRegionObserver.java:1053)

at org.apache.phoenix.hbase.index.IndexRegionObserver.preBatchMutateWithExceptions(IndexRegionObserver.java:938)

at org.apache.phoenix.hbase.index.IndexRegionObserver.preBatchMutate(IndexRegionObserver.java:351)

at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$35.call(RegionCoprocessorHost.java:1024)

at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$RegionOperation.call(RegionCoprocessorHost.java:1742)

at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1827)

at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.execOperation(RegionCoprocessorHost.java:1783)

at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.preBatchMutate(RegionCoprocessorHost.java:1020)

at org.apache.hadoop.hbase.regionserver.HRegion.doMiniBatchMutation(HRegion.java:3420)

at org.apache.hadoop.hbase.regionserver.HRegion.batchMutate(HRegion.java:3158)

at org.apache.hadoop.hbase.regionserver.HRegion.batchMutate(HRegion.java:3100)

at org.apache.hadoop.hbase.regionserver.RSRpcServices.doBatchOp(RSRpcServices.java:944)

at org.apache.hadoop.hbase.regionserver.RSRpcServices.doNonAtomicRegionMutation(RSRpcServices.java:872)

at org.apache.hadoop.hbase.regionserver.RSRpcServices.multi(RSRpcServices.java:2472)

at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:36812)

at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2399)

at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:124)

at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:311)

at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:291)

Caused by: org.apache.phoenix.hbase.index.exception.MultiIndexWriteFailureException:  disableIndexOnFailure=false, Failed to write to multiple index tables: V2#I2

at org.apache.phoenix.hbase.index.write.TrackingParallelWriterIndexCommitter.write(TrackingParallelWriterIndexCommitter.java:245)

... 21 more