phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Csaba Skrabak (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (PHOENIX-3736) ArithmeticQueryIT.testDecimalUpsertSelect fails
Date Fri, 24 Mar 2017 16:05:41 GMT

    [ 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: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

```
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.

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
```

> 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)

Mime
View raw message