Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
Copy link to this message
-
Re: drop table problem
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 Odell 2013-01-24, 13:47
+
Adrien Mogenet 2013-01-24, 19:49
+
Mohammad Tariq 2013-01-24, 10:24
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB