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
Normally you wouldn't need to remove the whole /hbase root on ZK. Removing
the node which is related to your table should be enough. Restart your
master so that it will read table state again, and you'll be able to drop
your ghost table.
On Thu, Jan 24, 2013 at 2:47 PM, Kevin O'dell <[EMAIL PROTECTED]>wrote:

> 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
06.59.16.64.22
http://www.mogenet.me