phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Error thrown when trying to drop table
Date Wed, 26 Aug 2015 17:26:38 GMT
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 <
mmcallister@homeaway.com> wrote:

> OK, and then delete the table within HBase as well I assume?
>
>
>
>
>
> *From:* James Taylor [mailto:jamestaylor@apache.org]
> *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 <
> mmcallister@homeaway.com> 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
>
> mmcallister@HomeAway.com | C: 512.423.7447 | skype: michael.mcallister.ha
> <zimmkate@hotmail.com> | 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 <jamestaylor@apache.org> 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 <
> mmcallister@homeaway.com> 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
>
> mmcallister@HomeAway.com | C: 512.423.7447 | skype: michael.mcallister.ha
> <zimmkate@hotmail.com> | 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.
>
>
>
>
>
>
>
>
>

Mime
View raw message