You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Csaba Skrabak (JIRA)" <ji...@apache.org> on 2017/03/24 16:01:42 UTC
[jira] [Comment Edited] (PHOENIX-3736)
ArithmeticQueryIT.testDecimalUpsertSelect fails
[ https://issues.apache.org/jira/browse/PHOENIX-3736?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15940492#comment-15940492 ]
Csaba Skrabak edited comment on PHOENIX-3736 at 3/24/17 4:01 PM:
-----------------------------------------------------------------
With hbase 1.2.3, test also passes.
Actual SQL error code 6000 is timeout. Query really lasts long with HBase 1.2.4.
The expected SQLException with the code 206 is thrown in 1.2.4, too. But since the surrounding DoNotRetryIOException is hidden inside an UnknownScannerException's cause, client keeps retrying forever. Finally the timeout happens.
```
2017-03-24 16:50:55,118 DEBUG [B.defaultRpcServer.handler=0,queue=0,port=60631] org.apache.hadoop.hbase.ipc.CallRunner(115): B.defaultRpcServer.handler=0,queue=0,port=60631: callId: 8270 service: ClientService methodName: Scan size: 34 connection: 10.200.51.63:60706
org.apache.hadoop.hbase.UnknownScannerException: Throwing UnknownScannerException to reset the client scanner state for clients older than 1.3.
at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2661)
at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33648)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2180)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112)
at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: T000001,,1490370472874.2b5fe29b201777af35213d8329049ca2.: java.sql.SQLException: ERROR 206 (22003): The data exceeds the max capacity for the data type. COL4 DECIMAL(4,4) value=100.12
at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:89)
at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:55)
at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:256)
at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:282)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2563)
... 6 more
Caused by: org.apache.phoenix.exception.DataExceedsCapacityException: java.sql.SQLException: ERROR 206 (22003): The data exceeds the max capacity for the data type. COL4 DECIMAL(4,4) value=100.12
at org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver.doPostScannerOpen(UngroupedAggregateRegionObserver.java:651)
at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:237)
... 8 more
Caused by: java.sql.SQLException: ERROR 206 (22003): The data exceeds the max capacity for the data type. COL4 DECIMAL(4,4) value=100.12
at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:476)
at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:150)
at org.apache.phoenix.exception.DataExceedsCapacityException.<init>(DataExceedsCapacityException.java:37)
... 10 more
2017-03-24 16:50:55,119 DEBUG [B.defaultRpcServer.handler=3,queue=0,port=60631] org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver(471): Starting ungrouped coprocessor scan {"loadColumnFamiliesOnDemand":true,"startRow":"","stopRow":"","batch":-1,"cacheBlocks":true,"totalColumns":2,"maxResultSize":2097152,"families":{"0":["\\x00\\x00\\x00\\x00","\\x80\\x0B"]},"caching":2147483647,"maxVersions":1,"timeRange":[0,1490370475524]} {ENCODED => 2b5fe29b201777af35213d8329049ca2, NAME => 'T000001,,1490370472874.2b5fe29b201777af35213d8329049ca2.', STARTKEY => '', ENDKEY => ''}
2017-03-24 16:50:55,119 DEBUG [B.defaultRpcServer.handler=3,queue=0,port=60631] org.apache.hadoop.hbase.ipc.CallRunner(115): B.defaultRpcServer.handler=3,queue=0,port=60631: callId: 8272 service: ClientService methodName: Scan size: 34 connection: 10.200.51.63:60706
org.apache.hadoop.hbase.UnknownScannerException: Throwing UnknownScannerException to reset the client scanner state for clients older than 1.3.
at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2661)
at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33648)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2180)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112)
at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: T000001,,1490370472874.2b5fe29b201777af35213d8329049ca2.: java.sql.SQLException: ERROR 206 (22003): The data exceeds the max capacity for the data type. COL4 DECIMAL(4,4) value=100.12
at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:89)
at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:55)
at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:256)
at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:282)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2563)
... 6 more
Caused by: org.apache.phoenix.exception.DataExceedsCapacityException: java.sql.SQLException: ERROR 206 (22003): The data exceeds the max capacity for the data type. COL4 DECIMAL(4,4) value=100.12
at org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver.doPostScannerOpen(UngroupedAggregateRegionObserver.java:651)
at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:237)
... 8 more
Caused by: java.sql.SQLException: ERROR 206 (22003): The data exceeds the max capacity for the data type. COL4 DECIMAL(4,4) value=100.12
at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:476)
at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:150)
at org.apache.phoenix.exception.DataExceedsCapacityException.<init>(DataExceedsCapacityException.java:37)
... 10 more
```
was (Author: cskrabak):
With hbase 1.2.3, test also passes.
Actual SQL error code 6000 is timeout. Query really lasts long with HBase 1.2.4.
> ArithmeticQueryIT.testDecimalUpsertSelect fails
> -----------------------------------------------
>
> Key: PHOENIX-3736
> URL: https://issues.apache.org/jira/browse/PHOENIX-3736
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.10.0
> Environment: HBase 1.2.4
> Reporter: Andrew Purtell
>
> ArithmeticQueryIT.testDecimalUpsertSelect fails when built against HBase 1.2.4. No failure observed when testing with 0.98.24-hadoop2.
> {noformat}
> Tests run: 26, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 359.938 sec <<< FAILURE! - in org.apache.phoenix.end2end.ArithmeticQueryIT
> testDecimalUpsertSelect(org.apache.phoenix.end2end.ArithmeticQueryIT) Time elapsed: 304.574 sec <<< FAILURE!
> java.lang.AssertionError: expected:<206> but was:<6000>
> at org.apache.phoenix.end2end.ArithmeticQueryIT.testDecimalUpsertSelect(ArithmeticQueryIT.java:236)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)