[
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 5:05 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.
Related:
* HBASE-16604 (which is present in rel/1.2.4 but not yet in 1.2.3 - suspect
breaker)
* HBASE-17187 (which is neither present in 1.2.4 nor 1.2.3 - suspect fixer)
{noformat}
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
{noformat}
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.
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.
Related:
* HBASE-16604 (which is present in rel/1.2.4 but not yet in 1.2.3)
* HBASE-17187 (which is neither present in 1.2.4 nor 1.2.3)
{noformat}
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
{noformat}
> 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)
