Thanks for following up with the root cause. This bug has been fixed in PHOENIX-930 and will appear in the next release (4.8.1).
On Tue, Sep 6, 2016 at 7:42 PM, Yang Zhang <zhang.yang...@gmail.com> wrote: > Thanks > > I have already handled this problem with your help. > and I also learned what make this mistake > when i create table with duplicate column name (i.e. create table test(id > integer primary key,name char(32),name char(64)) ) > phoenix will throw an exception but i can still find the wrong table. This > cause my table doesn't match my metadata. > afther that, i can't drop my table and get the DoNotRetryIOException > > I am not sure whether this is an issue or the version latter had handled > this(my version is 4.4.0 ). > But in my opinion ,phoenix shoule not create a helf table when customer's > grammer has error. > > > > 2016-09-07 9:21 GMT+08:00 James Taylor <jamestay...@apache.org>: > >> Sorry for the issue you've hit, Yang Zhang. You may need to do the >> following to recover: >> - drop the table from the hbase shell >> - create a snapshot of the SYSTEM.CATALOG table just in case >> - delete the rows for the table from the SYSTEM.CATALOG table (i.e. issue >> a DELETE FROM SYSTEM.CATALOG WHERE TABLE_SCHEM = <your schema name> AND >> TABLE_NAME = <your table name>) >> - bounce your cluster (since the SYSTEM.CATALOG table is cached) >> >> On Tue, Sep 6, 2016 at 5:56 PM, Yang Zhang <zhang.yang...@gmail.com> >> wrote: >> >>> it got the DoNotRetryIOException again, >>> >>> This time i just try to creat a table, When i Try to drop the table ,I >>> got this Exception, >>> Here are the Exception stack below >>> >>> Error: org.apache.hadoop.hbase.DoNotRetryIOException: MAGNETISM_MODEL: 6 >>> at org.apache.phoenix.util.ServerUtil.createIOException(ServerU >>> til.java:84) >>> at org.apache.phoenix.coprocessor.MetaDataEndpointImpl.dropTabl >>> e(MetaDataEndpointImpl.java:1298) >>> at org.apache.phoenix.coprocessor.generated.MetaDataProtos$Meta >>> DataService.callMethod(MetaDataProtos.java:10525) >>> at org.apache.hadoop.hbase.regionserver.HRegion.execService(HRe >>> gion.java:6864) >>> at org.apache.hadoop.hbase.regionserver.HRegionServer.execServi >>> ceOnRegion(HRegionServer.java:3415) >>> at org.apache.hadoop.hbase.regionserver.HRegionServer.execServi >>> ce(HRegionServer.java:3397) >>> at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$Clie >>> ntService$2.callBlockingMethod(ClientProtos.java:29998) >>> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2078) >>> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:108) >>> at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExec >>> utor.java:114) >>> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:94) >>> at java.lang.Thread.run(Thread.java:745) >>> Caused by: java.lang.ArrayIndexOutOfBoundsException: 6 >>> at org.apache.phoenix.schema.PTableImpl.init(PTableImpl.java:354) >>> at org.apache.phoenix.schema.PTableImpl.<init>(PTableImpl.java:276) >>> at org.apache.phoenix.schema.PTableImpl.makePTable(PTableImpl.java:265) >>> at org.apache.phoenix.coprocessor.MetaDataEndpointImpl.getTable >>> (MetaDataEndpointImpl.java:811) >>> at org.apache.phoenix.coprocessor.MetaDataEndpointImpl.buildTab >>> le(MetaDataEndpointImpl.java:448) >>> at org.apache.phoenix.coprocessor.MetaDataEndpointImpl.doDropTa >>> ble(MetaDataEndpointImpl.java:1318) >>> at org.apache.phoenix.coprocessor.MetaDataEndpointImpl.dropTabl >>> e(MetaDataEndpointImpl.java:1272) >>> ... 10 more >>> >>> SQLState: 08000 >>> ErrorCode: 101 >>> >>> >>> I still can't handle this problem, Any one can help me ? >>> >>> Thank you very much >>> >>> 2016-07-23 10:34 GMT+08:00 Yang Zhang <zhang.yang...@gmail.com>: >>> >>>> Hello everyone >>>> >>>> I got an (org.apache.hadoop.hbase.DoNotRetryIOException) when >>>> using phoenix. my version is phoenix-4.4.0-HBase-0.98-bin. >>>> I create a table and upsert data into it. But someday i want to modify >>>> it, so i execute (alter table drop column c1)and ( alter table add c2 >>>> bigint). after that i upsert new data into my table for each row. I >>>> try select * from my table,it got success。 >>>> >>>> But afther a time, I try to select * from it, I got >>>> DoNotRetryIOException >>>> at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84) >>>> and java .lang.ArrayIndexOutOfBoundsException:10 at >>>> org.apache.phoenix.schema.PtableImpl.init(PtableImpl.java:354)。 >>>> >>>> >>>> When I try to drop the table I still got DoNotRetryException >>>> Exception, Btw anyone have try drop phoenix table in hbase shell ? I >>>> should find some way to drop the table. >>>> >>>> >>>> >>>> Thanks very much! >>>> >>>> >>>> >>> >> >