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

Switch to Threaded View
HBase, mail # user - drop table problem


Copy link to this message
-
Re: drop table problem
Kevin O'dell 2013-01-24, 13:47
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