[ https://issues.apache.org/jira/browse/PHOENIX-4473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16298434#comment-16298434 ]
Rajeshbabu Chintaguntla commented on PHOENIX-4473: -------------------------------------------------- +1 [~an...@apache.org]. > Exception when Adding new columns to base table and view diverge > ---------------------------------------------------------------- > > Key: PHOENIX-4473 > URL: https://issues.apache.org/jira/browse/PHOENIX-4473 > Project: Phoenix > Issue Type: Sub-task > Reporter: Ankit Singhal > Assignee: Ankit Singhal > Labels: HBase-2.0 > Fix For: 5.0.0 > > Attachments: PHOENIX-4473.patch > > > {code} > [ERROR] > testAddPKColumnToBaseTableWhoseViewsHaveIndices(org.apache.phoenix.end2end.AlterMultiTenantTableWithViewsIT) > Time elapsed: 11.102 s <<< ERROR! > java.sql.SQLException: ERROR 201 (22000): Illegal data. Expected length of at > least 4 bytes, but had 1 > at > org.apache.phoenix.end2end.AlterMultiTenantTableWithViewsIT.testAddPKColumnToBaseTableWhoseViewsHaveIndices(AlterMultiTenantTableWithViewsIT.java:371) > Caused by: org.apache.hadoop.hbase.ipc.RemoteWithExtrasException: > org.apache.hadoop.hbase.DoNotRetryIOException: T000001_VIEW2: > java.sql.SQLException: ERROR 201 (22000): Illegal data. Expected length of at > least 4 bytes, but had 1 > at > org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:98) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.getTable(MetaDataEndpointImpl.java:557) > at > org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService.callMethod(MetaDataProtos.java:16267) > at > org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:7950) > at > org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(RSRpcServices.java:2339) > at > org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:2321) > at > org.apache.hadoop.hbase.shaded.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:41556) > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:403) > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:130) > at > org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:325) > at > org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:305) > Caused by: java.lang.RuntimeException: java.sql.SQLException: ERROR 201 > (22000): Illegal data. Expected length of at least 4 bytes, but had 1 > at > org.apache.phoenix.schema.types.PDataType.checkForSufficientLength(PDataType.java:290) > at > org.apache.phoenix.schema.types.PInteger$IntCodec.decodeInt(PInteger.java:183) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.addColumnToTable(MetaDataEndpointImpl.java:705) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.getTable(MetaDataEndpointImpl.java:1005) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.buildTable(MetaDataEndpointImpl.java:571) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.doGetTable(MetaDataEndpointImpl.java:3197) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.doGetTable(MetaDataEndpointImpl.java:3142) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.addIndexToTable(MetaDataEndpointImpl.java:656) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.getTable(MetaDataEndpointImpl.java:997) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.buildTable(MetaDataEndpointImpl.java:571) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.doGetTable(MetaDataEndpointImpl.java:3197) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.doGetTable(MetaDataEndpointImpl.java:3142) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.getTable(MetaDataEndpointImpl.java:523) > ... 9 more > Caused by: java.sql.SQLException: ERROR 201 (22000): Illegal data. Expected > length of at least 4 bytes, but had 1 > at > org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:488) > at > org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:150) > ... 22 more > [ERROR] > testAddingPkAndKeyValueColumnsToBaseTableWithDivergedView(org.apache.phoenix.end2end.AlterMultiTenantTableWithViewsIT) > Time elapsed: 10.795 s <<< ERROR! > java.sql.SQLException: ERROR 201 (22000): Illegal data. Expected length of at > least 4 bytes, but had 1 > at > org.apache.phoenix.end2end.AlterMultiTenantTableWithViewsIT.testAddingPkAndKeyValueColumnsToBaseTableWithDivergedView(AlterMultiTenantTableWithViewsIT.java:454) > Caused by: org.apache.hadoop.hbase.ipc.RemoteWithExtrasException: > org.apache.hadoop.hbase.DoNotRetryIOException: T000007: > java.sql.SQLException: ERROR 201 (22000): Illegal data. Expected length of at > least 4 bytes, but had 1 > at > org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:98) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.getTable(MetaDataEndpointImpl.java:557) > at > org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService.callMethod(MetaDataProtos.java:16267) > at > org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:7950) > at > org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(RSRpcServices.java:2339) > at > org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:2321) > at > org.apache.hadoop.hbase.shaded.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:41556) > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:403) > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:130) > at > org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:325) > at > org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:305) > Caused by: java.lang.RuntimeException: java.sql.SQLException: ERROR 201 > (22000): Illegal data. Expected length of at least 4 bytes, but had 1 > at > org.apache.phoenix.schema.types.PDataType.checkForSufficientLength(PDataType.java:290) > at > org.apache.phoenix.schema.types.PInteger$IntCodec.decodeInt(PInteger.java:183) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.addColumnToTable(MetaDataEndpointImpl.java:705) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.getTable(MetaDataEndpointImpl.java:1005) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.buildTable(MetaDataEndpointImpl.java:571) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.doGetTable(MetaDataEndpointImpl.java:3197) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.doGetTable(MetaDataEndpointImpl.java:3142) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.addIndexToTable(MetaDataEndpointImpl.java:656) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.getTable(MetaDataEndpointImpl.java:997) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.buildTable(MetaDataEndpointImpl.java:571) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.doGetTable(MetaDataEndpointImpl.java:3197) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.doGetTable(MetaDataEndpointImpl.java:3142) > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.getTable(MetaDataEndpointImpl.java:523) > ... 9 more > Caused by: java.sql.SQLException: ERROR 201 (22000): Illegal data. Expected > length of at least 4 bytes, but had 1 > at > org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:488) > at > org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:150) > ... 22 more > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)