phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael McAllister <mmcallis...@homeaway.com>
Subject RE: Error thrown when trying to drop table
Date Wed, 26 Aug 2015 17:57:34 GMT
Will do, thanks for the help.

From: James Taylor [mailto:jamestaylor@apache.org]
Sent: Wednesday, August 26, 2015 12:27 PM
To: user
Subject: Re: Error thrown when trying to drop table

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<mailto:mmcallister@homeaway.com>>
wrote:
OK, and then delete the table within HBase as well I assume?


From: James Taylor [mailto:jamestaylor@apache.org<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<mailto: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<mailto:mmcallister@HomeAway.com> | C: 512.423.7447<tel:512.423.7447>
| skype: michael.mcallister.ha<mailto:zimmkate@hotmail.com> | webex: https://h.a/mikewebex

[cid:image001.png@01D0DFFE.C51131B0]
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<mailto: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<mailto: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<mailto:mmcallister@HomeAway.com> | C: 512.423.7447<tel:512.423.7447>
| skype: michael.mcallister.ha<mailto: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