[ 
https://issues.apache.org/jira/browse/PHOENIX-4366?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16249276#comment-16249276
 ] 

Marcin Januszkiewicz commented on PHOENIX-4366:
-----------------------------------------------

The DDLs are, broadly:

{noformat}
create table traces (
rowkey VARCHAR,
"s"."v.1" VARCHAR,
"s"."v.2" VARCHAR,
"s"."v.3" VARCHAR,
"s"."v.4" VARCHAR,
"s"."v.5" VARCHAR,
"s"."v.6" VARCHAR,
"s"."v.7" VARCHAR,
"s"."v.8" VARCHAR,
"s"."v.9" VARCHAR,
"s"."v.10" VARCHAR,
"s"."v.11" VARCHAR,
"s"."v.12" VARCHAR,
"s"."v.13" VARCHAR,
"s"."v.14" VARCHAR,
"s"."v.15" VARCHAR,
"s"."v.16" VARCHAR,
"s"."v.17" VARCHAR,
"s"."v.18" VARCHAR,

"cf"."b.1" VARCHAR,
"cf"."b.2" VARCHAR,
"cf"."b.3" VARCHAR,
"cf"."b.4" VARCHAR,
"cf"."b.5" VARCHAR,
"cf"."b.6" VARCHAR,
"cf"."b.7" VARCHAR,
"cf"."b.8" VARCHAR,
"cf"."b.9" VARCHAR,
"cf"."b.10" VARCHAR,
"cf"."b.11" VARCHAR,
"cf"."b.12" VARCHAR,
"cf"."b.13" VARCHAR,
"cf"."b.14" VARCHAR,
"cf"."b.15" VARCHAR,
"cf"."b.16" VARCHAR,
"cf"."b.17" VARCHAR,
"cf"."b.18" VARCHAR,
"cf"."b.19" VARCHAR,
"cf"."b.20" VARCHAR,
"cf"."b.21" VARCHAR,
"cf"."data" VARCHAR

CONSTRAINT pk PRIMARY KEY (ROWKEY)) SALT_BUCKETS=5, COMPRESSION=SNAPPY, 
DISABLE_WAL=TRUE, NORMALIZATION_ENABLED=true;

CREATE LOCAL INDEX test_1
ON traces (UPPER("s"."v.1"))
INCLUDE (
  "s"."v.2",
  "s"."v.3",
  "s"."v.4",
  "s"."v.5",
  "s"."v.6",
  "s"."v.7",
  "s"."v.8",
  "s"."v.9",
  "s"."v.10",
  "s"."v.11",
  "s"."v.12",
  "s"."v.13",
  "s"."v.14",
  "s"."v.15",
  "s"."v.16",
  "s"."v.17",
  "s"."v.18",
  )
COMPRESSION=snappy;

CREATE LOCAL INDEX test_2
ON traces (UPPER("s"."v.2"))
INCLUDE (
  "s"."v.1",
  "s"."v.3",
  "s"."v.4",
  "s"."v.5",
  "s"."v.6",
  "s"."v.7",
  "s"."v.8",
  "s"."v.9",
  "s"."v.10",
  "s"."v.11",
  "s"."v.12",
  "s"."v.13",
  "s"."v.14",
  "s"."v.15",
  "s"."v.16",
  "s"."v.17",
  "s"."v.18",
  )
COMPRESSION=snappy;
{noformat}

> Rebuilding a local index fails sometimes
> ----------------------------------------
>
>                 Key: PHOENIX-4366
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4366
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.12.0
>            Reporter: Marcin Januszkiewicz
>
> We have a table created in 4.12 with the new column encoding scheme and with 
> several local indexes. Sometimes when we issue an ALTER INDEX ... REBUILD 
> command, it fails with the following exception:
> {noformat}
> Error: org.apache.phoenix.exception.PhoenixIOException: 
> org.apache.hadoop.hbase.DoNotRetryIOException: 
> TRACES,\x01BY01O90A6-$599a349e,1509979836322.3f
> 30c9d449ed6c60a1cda6898f766bd0.: null                                         
>                                                                               
>                                   
>         at 
> org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:96)      
>                                                                               
>                        
>         at 
> org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:62)       
>                                                                               
>                        
>         at 
> org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:255)
>                                                   
>         at 
> org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:284)
>                                                            
>         at 
> org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2541)
>                                                                               
>                      
>         at 
> org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33648)
>                                                                 
>         at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2183)    
>                                                                               
>                                   
>         at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112)    
>                                                                               
>                                   
>         at 
> org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:183)     
>                                                                               
>                        
>         at 
> org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:163)     
>                                                                               
>                        
> Caused by: java.lang.UnsupportedOperationException                            
>                                                                               
>                                   
>         at 
> org.apache.phoenix.schema.PTable$QualifierEncodingScheme$1.decode(PTable.java:247)
>                                                                               
>                    
>         at 
> org.apache.phoenix.schema.tuple.EncodedColumnQualiferCellsList.add(EncodedColumnQualiferCellsList.java:141)
>                                                                         
>         at 
> org.apache.phoenix.schema.tuple.EncodedColumnQualiferCellsList.add(EncodedColumnQualiferCellsList.java:56)
>                                                                          
>         at 
> org.apache.hadoop.hbase.regionserver.StoreScanner.next(StoreScanner.java:560) 
>                                                                               
>                        
>         at 
> org.apache.hadoop.hbase.regionserver.KeyValueHeap.next(KeyValueHeap.java:147) 
>                                                                               
>                        
>         at 
> org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.populateResult(HRegion.java:5735)
>                                                                               
>      
>         at 
> org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextInternal(HRegion.java:5891)
>                                                                               
>        
>         at 
> org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextRaw(HRegion.java:5669)
>                                                                               
>             
>         at 
> org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextRaw(HRegion.java:5654)
>                                                                               
>             
>         at 
> org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver.doPostScannerOpen(UngroupedAggregateRegionObserver.java:522)
>                                                        
>         at 
> org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:236)
>                                                   
>         ... 7 more (state=08000,code=101) 
> {noformat}
> This failure is intermittent, since usually we can run the command again and 
> it will succeed.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to