Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
HBase >> mail # user >> drop table problem


+
hua beatls 2013-01-24, 10:18
+
Vikas Jadhav 2013-01-24, 13:34
+
Kevin Odell 2013-01-24, 13:47
Copy link to this message
-
Re: drop table problem
Sorry I should have specified those are different options to try, not an
ordered set of instructions.

On Thu, Jan 24, 2013 at 8:47 AM, Kevin O'dell <[EMAIL PROTECTED]>wrote:

> Typically, hbck won't detect anything wrong here, as Ram said in another
> thread we really should work in this functionality.
>
> 1.) Shut the HBase cluster - go to ZKcli and rmr /hbase - Start HBase back
> up
>
> 2.) Move the table, use hbck -fixMeta -fixAssignments, restart the HBase
> (not a great option if there is data on the table)
>
> 3.) Force an assign on the region for the table and see if it clears it up
> (Should create a new znode)
>
> 4.) Go to ZK Cli and check /hbase for unassigned regions and other data
> correlating with that region and remove it, then restart HBase
>
> On Thu, Jan 24, 2013 at 8:34 AM, Vikas Jadhav <[EMAIL PROTECTED]>wrote:
>
>> try to diable table first
>>
>> disable 'table_name'
>>
>> drop 'tab-name'
>>
>>
>>
>> On Thu, Jan 24, 2013 at 3:48 PM, hua beatls <[EMAIL PROTECTED]> wrote:
>>
>> > HI,
>> > i have a table in 'transition' state, which couldn't be 'disable' or
>> > enable. I try to 'drop' it but failed. below is the error messages.
>> >
>> > hbase(main):012:0> drop 'T21_0513_201301_bigtable'
>> > ERROR: org.apache.hadoop.hbase.TableNotDisabledException:
>> > org.apache.hadoop.hbase.TableNotDisabledException:
>> T21_0513_201301_bigtable
>> > at
>> >
>> >
>> org.apache.hadoop.hbase.master.HMaster.checkTableModifiable(HMaster.java:1240)
>> > at
>> >
>> >
>> org.apache.hadoop.hbase.master.handler.TableEventHandler.<init>(TableEventHandler.java:70)
>> > at
>> >
>> >
>> org.apache.hadoop.hbase.master.handler.DeleteTableHandler.<init>(DeleteTableHandler.java:42)
>> > at org.apache.hadoop.hbase.master.HMaster.deleteTable(HMaster.java:1099)
>> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> > at
>> >
>> >
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>> > at
>> >
>> >
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> > at java.lang.reflect.Method.invoke(Method.java:601)
>> > at
>> >
>> >
>> org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:364)
>> > at
>> >
>> org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1345)
>> >  below is the excerpts from webui:
>> > Regions in
>> >
>> TransitionRegionStatebd8d2bf3ef04d0f8d3dac5ca2f612f42T21_0513_201301_bigtable,27100750000000000000000000000000000000000000000000000000000,1358994123350.bd8d2bf3ef04d0f8d3dac5ca2f612f42.
>> > state=PENDING_OPEN, ts=Thu Jan 24 16:58:34 CST 2013 (699s ago),
>> > server=hadoop1,60020,1358993820407
>> >
>>
>>
>>
>> --
>> *
>> *
>> *
>>
>> Thanx and Regards*
>> * Vikas Jadhav*
>>
>
>
>
> --
> Kevin O'Dell
> Customer Operations Engineer, Cloudera
>

--
Kevin O'Dell
Customer Operations Engineer, Cloudera
+
Adrien Mogenet 2013-01-24, 19:49
+
Mohammad Tariq 2013-01-24, 10:24