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( >> HRegion.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$ >> ClientService$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！ >>> >>> >>> >> >
