phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Siddharth Ubale <siddharth.ub...@syncoms.com>
Subject org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException: RELATIONSHIPDATA,,1501224108837.1fc1615f5be984e13329b31a902ebf44
Date Fri, 28 Jul 2017 09:22:10 GMT
Hi ,

I am using Phoenix 4.10 over Hbase 1.2.6 . Running 2 join  queries , one with the hint   /*+
 USE_SORT_MERGE_JOIN */ and the other without .

The query with the hint gives an error where it indicated the the region servicg the table
is null. I am unable to understand why the hint is causiong the query to fail with an error
and the other query without the hint  works perfectly fine.
Queries for reference :

Query 1(Failed): Select /*+ USE_SORT_MERGE_JOIN */ olap4address.olap4address292FEC765F1C486F85A509D88096F098street,olap4customer.olap4customer292FEC765F1C486F85A509D88096F098name
as Name,olap4address.olap4address292FEC765F1C486F85A509D88096F098aid from dwh as olap4customer
 inner join RELATIONSHIPDATA as rel0 on rel0.ParentObjectDatarowkey=olap4customer.rk
 and   rel0.tenant_parentobjectid ='81aa279d-1b0a-409a-bcee-bb09da603d3e' and  rel0.tenant_childobjectid
='a5805b8b-103a-4786-ade9-bedfa0158b59'
 inner join dwh as olap4address on rel0.childobjectdatarowkey =olap4address.rk
where    olap4address.olap4address292FEC765F1C486F85A509D88096F098street = 'MG road132' AND
olap4customer.olap4customer292FEC765F1C486F85A509D88096F098Name = 'Prasad 60'

Query 2 (gives result ): Select olap4address.olap4address292FEC765F1C486F85A509D88096F098street,olap4customer.olap4customer292FEC765F1C486F85A509D88096F098name
as Name,olap4address.olap4address292FEC765F1C486F85A509D88096F098aid from dwh as olap4customer
 inner join RELATIONSHIPDATA as rel0 on rel0.ParentObjectDatarowkey=olap4customer.rk
 and   rel0.tenant_parentobjectid ='81aa279d-1b0a-409a-bcee-bb09da603d3e' and  rel0.tenant_childobjectid
='a5805b8b-103a-4786-ade9-bedfa0158b59'
 inner join dwh as olap4address on rel0.childobjectdatarowkey =olap4address.rk
where    olap4address.olap4address292FEC765F1C486F85A509D88096F098street = 'MG road132' AND
olap4customer.olap4customer292FEC765F1C486F85A509D88096F098Name = 'Prasad 60'


1.       Error: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException:
RELATIONSHIPDATA,,1501224108837.1fc1615f5be984e13329b31a902ebf44.: null

2.               at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:92)

3.               at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:58)

4.               at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:214)

5.               at org.apache.phoenix.iterate.RegionScannerResultIterator.next(RegionScannerResultIterator.java:61)

6.               at org.apache.phoenix.iterate.OrderedResultIterator.getResultIterator(OrderedResultIterator.java:255)

7.               at org.apache.phoenix.iterate.OrderedResultIterator.next(OrderedResultIterator.java:199)

8.               at org.apache.phoenix.iterate.NonAggregateRegionScannerFactory.getTopNScanner(NonAggregateRegionScannerFactory.java:319)

9.               at org.apache.phoenix.iterate.NonAggregateRegionScannerFactory.getRegionScanner(NonAggregateRegionScannerFactory.java:161)

10.           at org.apache.phoenix.coprocessor.ScanRegionObserver.doPostScannerOpen(ScanRegionObserver.java:72)

11.           at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:221)

12.           at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:266)

13.           at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2580)

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

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

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

17.           at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)

18.           at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)

19.           at java.lang.Thread.run(Thread.java:745)

20.   Caused by: java.lang.NullPointerException

21.           at org.apache.phoenix.execute.TupleProjector.projectResults(TupleProjector.java:286)

22.           at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:204)

23.           ... 15 more (state=08000,code=101)

24.   org.apache.phoenix.exception.PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException:
org.apache.hadoop.hbase.DoNotRetryIOException: RELATIONSHIPDATA,,1501224108837.1fc1615f5be984e13329b31a902ebf44.:
null

25.           at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:92)

26.           at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:58)

27.           at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:214)

28.           at org.apache.phoenix.iterate.RegionScannerResultIterator.next(RegionScannerResultIterator.java:61)

29.           at org.apache.phoenix.iterate.OrderedResultIterator.getResultIterator(OrderedResultIterator.java:255)

30.           at org.apache.phoenix.iterate.OrderedResultIterator.next(OrderedResultIterator.java:199)

31.           at org.apache.phoenix.iterate.NonAggregateRegionScannerFactory.getTopNScanner(NonAggregateRegionScannerFactory.java:319)

32.           at org.apache.phoenix.iterate.NonAggregateRegionScannerFactory.getRegionScanner(NonAggregateRegionScannerFactory.java:161)

33.           at org.apache.phoenix.coprocessor.ScanRegionObserver.doPostScannerOpen(ScanRegionObserver.java:72)

34.           at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:221)

35.           at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:266)

36.           at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2580)

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

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

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

40.           at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)

41.           at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)

42.           at java.lang.Thread.run(Thread.java:745)

43.   Caused by: java.lang.NullPointerException

44.           at org.apache.phoenix.execute.TupleProjector.projectResults(TupleProjector.java:286)

45.           at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:204)

46.           ... 15 more

47.

48.           at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:113)

49.           at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:852)

50.           at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:796)

51.           at org.apache.phoenix.iterate.MergeSortResultIterator.getMinHeap(MergeSortResultIterator.java:72)

52.           at org.apache.phoenix.iterate.MergeSortResultIterator.minIterator(MergeSortResultIterator.java:93)

53.           at org.apache.phoenix.iterate.MergeSortResultIterator.next(MergeSortResultIterator.java:58)

54.           at org.apache.phoenix.iterate.MergeSortTopNResultIterator.next(MergeSortTopNResultIterator.java:95)

55.           at org.apache.phoenix.execute.SortMergeJoinPlan$BasicJoinIterator.init(SortMergeJoinPlan.java:356)

56.           at org.apache.phoenix.execute.SortMergeJoinPlan$BasicJoinIterator.next(SortMergeJoinPlan.java:286)

57.           at org.apache.phoenix.iterate.OrderedResultIterator.getResultIterator(OrderedResultIterator.java:255)

58.           at org.apache.phoenix.iterate.OrderedResultIterator.next(OrderedResultIterator.java:199)

59.           at org.apache.phoenix.execute.SortMergeJoinPlan$BasicJoinIterator.init(SortMergeJoinPlan.java:351)

60.           at org.apache.phoenix.execute.SortMergeJoinPlan$BasicJoinIterator.next(SortMergeJoinPlan.java:286)

61.           at org.apache.phoenix.jdbc.PhoenixResultSet.next(PhoenixResultSet.java:778)

62.           at sqlline.BufferedRows.<init>(BufferedRows.java:37)

63.           at sqlline.SqlLine.print(SqlLine.java:1660)

64.           at sqlline.Commands.execute(Commands.java:833)

65.           at sqlline.Commands.sql(Commands.java:732)

66.           at sqlline.SqlLine.dispatch(SqlLine.java:813)

67.           at sqlline.SqlLine.begin(SqlLine.java:686)

68.           at sqlline.SqlLine.start(SqlLine.java:398)

69.           at sqlline.SqlLine.main(SqlLine.java:291)

70.   Caused by: java.util.concurrent.ExecutionException: org.apache.phoenix.exception.PhoenixIOException:
org.apache.hadoop.hbase.DoNotRetryIOException: RELATIONSHIPDATA,,1501224108837.1fc1615f5be984e13329b31a902ebf44.:
null

71.           at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:92)

72.           at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:58)

73.           at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:214)

74.           at org.apache.phoenix.iterate.RegionScannerResultIterator.next(RegionScannerResultIterator.java:61)

75.           at org.apache.phoenix.iterate.OrderedResultIterator.getResultIterator(OrderedResultIterator.java:255)

76.           at org.apache.phoenix.iterate.OrderedResultIterator.next(OrderedResultIterator.java:199)

77.           at org.apache.phoenix.iterate.NonAggregateRegionScannerFactory.getTopNScanner(NonAggregateRegionScannerFactory.java:319)

78.           at org.apache.phoenix.iterate.NonAggregateRegionScannerFactory.getRegionScanner(NonAggregateRegionScannerFactory.java:161)

79.           at org.apache.phoenix.coprocessor.ScanRegionObserver.doPostScannerOpen(ScanRegionObserver.java:72)

80.           at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:221)

81.           at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:266)

82.           at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2580)

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

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

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

86.           at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)

87.           at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)

88.           at java.lang.Thread.run(Thread.java:745)

89.   Caused by: java.lang.NullPointerException

90.           at org.apache.phoenix.execute.TupleProjector.projectResults(TupleProjector.java:286)

91.           at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:204)

92.           ... 15 more

93.

94.           at java.util.concurrent.FutureTask.report(FutureTask.java:122)

95.           at java.util.concurrent.FutureTask.get(FutureTask.java:206)

96.           at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:847)

97.           ... 20 more

98.   Caused by: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException:
RELATIONSHIPDATA,,1501224108837.1fc1615f5be984e13329b31a902ebf44.: null

99.           at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:92)

100.                               at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:58)

101.                               at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:214)

102.                               at org.apache.phoenix.iterate.RegionScannerResultIterator.next(RegionScannerResultIterator.java:61)

103.                               at org.apache.phoenix.iterate.OrderedResultIterator.getResultIterator(OrderedResultIterator.java:255)

104.                               at org.apache.phoenix.iterate.OrderedResultIterator.next(OrderedResultIterator.java:199)

105.                               at org.apache.phoenix.iterate.NonAggregateRegionScannerFactory.getTopNScanner(NonAggregateRegionScannerFactory.java:319)

106.                               at org.apache.phoenix.iterate.NonAggregateRegionScannerFactory.getRegionScanner(NonAggregateRegionScannerFactory.java:161)

107.                               at org.apache.phoenix.coprocessor.ScanRegionObserver.doPostScannerOpen(ScanRegionObserver.java:72)

108.                               at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:221)

109.                               at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:266)

110.                               at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2580)

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

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

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

114.                               at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)

115.                               at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)

116.                               at java.lang.Thread.run(Thread.java:745)

117.                       Caused by: java.lang.NullPointerException

118.                               at org.apache.phoenix.execute.TupleProjector.projectResults(TupleProjector.java:286)

119.                               at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:204)

120.                               ... 15 more

121.

122.                               at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:113)

123.                               at org.apache.phoenix.iterate.TableResultIterator.next(TableResultIterator.java:146)

124.                               at org.apache.phoenix.iterate.LookAheadResultIterator$1.advance(LookAheadResultIterator.java:47)

125.                               at org.apache.phoenix.iterate.LookAheadResultIterator.init(LookAheadResultIterator.java:59)

126.                               at org.apache.phoenix.iterate.LookAheadResultIterator.peek(LookAheadResultIterator.java:73)

127.                               at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:121)

128.                               at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:106)

129.                               at java.util.concurrent.FutureTask.run(FutureTask.java:266)

130.                               at org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask.run(JobManager.java:183)

131.                               at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

132.                               at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

133.                               at java.lang.Thread.run(Thread.java:745)

134.                       Caused by: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException:
RELATIONSHIPDATA,,1501224108837.1fc1615f5be984e13329b31a902ebf44.: null

135.                               at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:92)

136.                               at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:58)

137.                               at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:214)

138.                               at org.apache.phoenix.iterate.RegionScannerResultIterator.next(RegionScannerResultIterator.java:61)

139.                               at org.apache.phoenix.iterate.OrderedResultIterator.getResultIterator(OrderedResultIterator.java:255)

140.                               at org.apache.phoenix.iterate.OrderedResultIterator.next(OrderedResultIterator.java:199)

141.                               at org.apache.phoenix.iterate.NonAggregateRegionScannerFactory.getTopNScanner(NonAggregateRegionScannerFactory.java:319)

142.                               at org.apache.phoenix.iterate.NonAggregateRegionScannerFactory.getRegionScanner(NonAggregateRegionScannerFactory.java:161)

143.                               at org.apache.phoenix.coprocessor.ScanRegionObserver.doPostScannerOpen(ScanRegionObserver.java:72)

144.                               at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:221)

145.                               at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:266)

146.                               at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2580)

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

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

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

150.                               at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)

151.                               at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)

152.                               at java.lang.Thread.run(Thread.java:745)

153.                       Caused by: java.lang.NullPointerException

154.                               at org.apache.phoenix.execute.TupleProjector.projectResults(TupleProjector.java:286)

155.                               at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:204)

156.                               ... 15 more

157.

158.                               at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:113)

159.                               at org.apache.phoenix.iterate.ScanningResultIterator.next(ScanningResultIterator.java:65)

160.                               at org.apache.phoenix.iterate.TableResultIterator.next(TableResultIterator.java:139)

161.                               ... 10 more

162.                       Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: org.apache.hadoop.hbase.DoNotRetryIOException:
RELATIONSHIPDATA,,1501224108837.1fc1615f5be984e13329b31a902ebf44.: null

163.                               at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:92)

164.                               at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:58)

165.                               at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:214)

166.                               at org.apache.phoenix.iterate.RegionScannerResultIterator.next(RegionScannerResultIterator.java:61)

167.                               at org.apache.phoenix.iterate.OrderedResultIterator.getResultIterator(OrderedResultIterator.java:255)

168.                               at org.apache.phoenix.iterate.OrderedResultIterator.next(OrderedResultIterator.java:199)

169.                               at org.apache.phoenix.iterate.NonAggregateRegionScannerFactory.getTopNScanner(NonAggregateRegionScannerFactory.java:319)

170.                               at org.apache.phoenix.iterate.NonAggregateRegionScannerFactory.getRegionScanner(NonAggregateRegionScannerFactory.java:161)

171.                               at org.apache.phoenix.coprocessor.ScanRegionObserver.doPostScannerOpen(ScanRegionObserver.java:72)

172.                               at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:221)

173.                               at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:266)

174.                               at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2580)

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

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

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

178.                               at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)

179.                               at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)

180.                               at java.lang.Thread.run(Thread.java:745)

181.                       Caused by: java.lang.NullPointerException

182.                               at org.apache.phoenix.execute.TupleProjector.projectResults(TupleProjector.java:286)

183.                               at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:204)

184.                               ... 15 more

185.

186.                               at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)

187.                               at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

188.                               at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

189.                               at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

190.                               at org.apache.hadoop.ipc.RemoteException.instantiateException(RemoteException.java:106)

191.                               at org.apache.hadoop.ipc.RemoteException.unwrapRemoteException(RemoteException.java:95)

192.                               at org.apache.hadoop.hbase.protobuf.ProtobufUtil.getRemoteException(ProtobufUtil.java:329)

193.                               at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:262)

194.                               at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:64)

195.                               at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:210)

196.                               at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:364)

197.                               at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:338)

198.                               at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:136)

199.                               at org.apache.hadoop.hbase.client.ResultBoundedCompletionService$QueueingFuture.run(ResultBoundedCompletionService.java:65)

200.                               ... 3 more

201.                       Caused by: org.apache.hadoop.hbase.ipc.RemoteWithExtrasException(org.apache.hadoop.hbase.DoNotRetryIOException):
org.apache.hadoop.hbase.DoNotRetryIOException: RELATIONSHIPDATA,,1501224108837.1fc1615f5be984e13329b31a902ebf44.:
null

202.                               at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:92)

203.                               at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:58)

204.                               at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:214)

205.                               at org.apache.phoenix.iterate.RegionScannerResultIterator.next(RegionScannerResultIterator.java:61)

206.                               at org.apache.phoenix.iterate.OrderedResultIterator.getResultIterator(OrderedResultIterator.java:255)

207.                               at org.apache.phoenix.iterate.OrderedResultIterator.next(OrderedResultIterator.java:199)

208.                               at org.apache.phoenix.iterate.NonAggregateRegionScannerFactory.getTopNScanner(NonAggregateRegionScannerFactory.java:319)

209.                               at org.apache.phoenix.iterate.NonAggregateRegionScannerFactory.getRegionScanner(NonAggregateRegionScannerFactory.java:161)

210.                               at org.apache.phoenix.coprocessor.ScanRegionObserver.doPostScannerOpen(ScanRegionObserver.java:72)

211.                               at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:221)

212.                               at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:266)

213.                               at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2580)

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

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

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

217.                               at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)

218.                               at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)

219.                               at java.lang.Thread.run(Thread.java:745)

220.                       Caused by: java.lang.NullPointerException

221.                               at org.apache.phoenix.execute.TupleProjector.projectResults(TupleProjector.java:286)

222.                               at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScannerFactory.java:204)

223.                               ... 15 more

224.

225.                               at org.apache.hadoop.hbase.ipc.RpcClientImpl.call(RpcClientImpl.java:1267)

226.                               at org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(AbstractRpcClient.java:227)

227.                               at org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementation.callBlockingMethod(AbstractRpcClient.java:336)

228.                               at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$BlockingStub.scan(ClientProtos.java:34094)

229.                               at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:219)

230.                               ... 9 more


The same behavior was observed for 4.11 phoenix with hbase1.2.6 .
4.10 phoenix client with Hbase0.98 works fine with both queries.
Any thoughts Please.

Thanks
Siddharth Ubale.


Mime
View raw message