Yes, correct - then just disable and drop the table from the HBase shell. Let us know if you see it again or develop a theory on when it starts to happen.
On Wed, Aug 26, 2015 at 7:48 AM, Michael McAllister < [email protected]> wrote: > OK, and then delete the table within HBase as well I assume? > > > > > > *From:* James Taylor [mailto:[email protected]] > *Sent:* Tuesday, August 25, 2015 6:18 PM > *To:* user > *Subject:* Re: Error thrown when trying to drop table > > > > I think you'll need to resort to manually deleting from the SYSTEM.CATALOG > table. Something like the following: > > > > DELETE FROM SYSTEM.CATALOG WHERE TENANT_ID IS NULL > > AND TABLE_SCHEM = 'MYSCHEMA' > > AND TABLE_NAME = 'MYTABLE'; > > > > You'll need to bounce your cluster to cause the server-side cache to be > cleared too. > > > > On Tue, Aug 25, 2015 at 10:29 AM, Michael McAllister < > [email protected]> wrote: > > James > > > > We’re on Phoenix 4.2 on HDP 2.2.6. > > > > I’ve tried reproducing the problem and I can’t. My issue is specific to > these two tables. When I try recreating the exact same table I can drop it. > I’m willing to do some digging on these tables if it will help you, but in > the end what I’d like to do is get them dropped. > > > > Michael McAllister > > Staff Data Warehouse Engineer | Decision Systems > > [email protected] | C: 512.423.7447 | skype: michael.mcallister.ha > <[email protected]> | webex: https://h.a/mikewebex > > > > This electronic communication (including any attachment) is confidential. > If you are not an intended recipient of this communication, please be > advised that any disclosure, dissemination, distribution, copying or other > use of this communication or any attachment is strictly prohibited. If you > have received this communication in error, please notify the sender > immediately by reply e-mail and promptly destroy all electronic and printed > copies of this communication and any attachment. > > > > On Aug 24, 2015, at 10:48 PM, James Taylor <[email protected]> wrote: > > > > Hi Michael, > > What version are you on over there? Can you setup a test that consistently > reproduces the issue? > > Thanks, > > James > > > > On Mon, Aug 24, 2015 at 8:20 PM, Michael McAllister < > [email protected]> wrote: > > Hi > > > > I have an empty table that, when I try and drop, I get an error returned. > > > > I issue a command similar to the following:- > > > > drop table myschema.mytable; > > > > I get the following error:- > > > > 22:17:53 [DROP - 0 row(s), 0.276 secs] [Error Code: 101, SQL State: > 08000] org.apache.hadoop.hbase.DoNotRetryIOException: MYSCHEMA.MYTABLE: 29 > > at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84) > > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.dropTable(MetaDataEndpointImpl.java:965) > > at > org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService.callMethod(MetaDataProtos.java:7768) > > at > org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:6896) > > at > org.apache.hadoop.hbase.regionserver.HRegionServer.execServiceOnRegion(HRegionServer.java:3420) > > at > org.apache.hadoop.hbase.regionserver.HRegionServer.execService(HRegionServer.java:3402) > > 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(RpcExecutor.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: 29 > > at org.apache.phoenix.schema.PTableImpl.init(PTableImpl.java:320) > > at org.apache.phoenix.schema.PTableImpl.<init>(PTableImpl.java:250) > > at org.apache.phoenix.schema.PTableImpl.makePTable(PTableImpl.java:240) > > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.getTable(MetaDataEndpointImpl.java:638) > > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.buildTable(MetaDataEndpointImpl.java:376) > > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.doDropTable(MetaDataEndpointImpl.java:985) > > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.dropTable(MetaDataEndpointImpl.java:939) > > ... 10 more > > ... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: > 0.276/0.000 sec [0 successful, 0 warnings, 1 errors] > > > > > > Michael McAllister > > Staff Data Warehouse Engineer | Decision Systems > > [email protected] | C: 512.423.7447 | skype: michael.mcallister.ha > <[email protected]> | webex: https://h.a/mikewebex > > > <image002.png> > This electronic communication (including any attachment) is confidential. > If you are not an intended recipient of this communication, please be > advised that any disclosure, dissemination, distribution, copying or other > use of this communication or any attachment is strictly prohibited. If you > have received this communication in error, please notify the sender > immediately by reply e-mail and promptly destroy all electronic and printed > copies of this communication and any attachment. > > > > > > > > >
