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

Switch to Threaded View
HBase >> mail # user >> how to delete a zombie table permanently?


Copy link to this message
-
Re: how to delete a zombie table permanently?
You have deleted all the entries...

Only blog under table should have been deleted.

As proposed,  have you tried to restart everything, including zookeeper?
Le 10 août 2012 08:52, "GMAIL(henry)" <[EMAIL PROTECTED]> a écrit :

> yes, it's a same situation for me.
>
> ----
> iPhone에서 보냄
>
> 2012. 8. 10. 20:22 Miguel Costa <[EMAIL PROTECTED]> 작��:
>
> > after the deletion did you restart HBase Master and region servers?
> >
> > I Had the same problem a while ago and solve it by deleted from zk and
> > then restart.
> >
> > Miguel Costa
> >
> > On 08/10/2012 09:33 AM, Henry JunYoung KIM wrote:
> >> Hi, JM.
> >>
> >> I followed procedures you mentioned.
> >>
> >> here is it.
> >>
> >> from zookeeper, I deleted it
> >>
> >> ---------------
> >> $] rmr /hbase/table/*
> >> $] ls /hbase/table
> >> Node does not exist: /hbase/table
> >> ---------------
> >>
> >> and then, I checked my hbase cluster.
> >>
> >> ---------------
> >> $> hbase hbck
> >> ,,,,
> >> Number of empty REGIONINFO_QUALIFIER rows in .META.: 0
> >> Exception in thread "main" java.lang.NullPointerException
> >>    at
> org.apache.hadoop.hbase.zookeeper.ZKTable.getDisabledOrDisablingTables(ZKTable.java:397)
> >>    at
> org.apache.hadoop.hbase.util.HBaseFsck$1.connect(HBaseFsck.java:996)
> >>    at
> org.apache.hadoop.hbase.util.HBaseFsck$1.connect(HBaseFsck.java:991)
> >>    at
> org.apache.hadoop.hbase.client.HConnectionManager.execute(HConnectionManager.java:360)
> >>    at
> org.apache.hadoop.hbase.util.HBaseFsck.loadDisabledTables(HBaseFsck.java:991)
> >>    at
> org.apache.hadoop.hbase.util.HBaseFsck.onlineConsistencyRepair(HBaseFsck.java:360)
> >>    at
> org.apache.hadoop.hbase.util.HBaseFsck.onlineHbck(HBaseFsck.java:383)
> >>    at org.apache.hadoop.hbase.util.HBaseFsck.main(HBaseFsck.java:3121)
> >> ---------------
> >>
> >> OMG.
> >>
> >> ok, let's refresh master's cache which is from zk.
> >>
> >> ---------------
> >> $> hadoop-hbase-master restart
> >> $> hbase hbck
> >> …
> >> ERROR: Found inconsistency in table blog
> >> Summary:
> >>  -ROOT- is okay.
> >>    Number of regions: 1
> >>    Deployed on:  search-ddm-test10,60020,1344586183254
> >>  .META. is okay.
> >>    Number of regions: 1
> >>    Deployed on:  search-ddm-test6,60020,1344586183295
> >> Table blog is inconsistent.
> >>    Number of regions: 3
> >>    Deployed on:  search-ddm-test5,60020,1344586183269
> search-ddm-test8,60020,1344586183257 search-ddm-test9,60020,1344586183260
> >> 8 inconsistencies detected.
> >> Status: INCONSISTENT
> >> ---------------
> >>
> >> now, it shows up the different situation for me. (thanks)
> >>
> >> from hbase shell, I could check the existence of the tables I want to
> delete.
> >>
> >> ---------------
> >> hbase(main):002:0> list
> >> TABLE
> >> blog
> >> sidx
> >> 2 row(s) in 0.0180 seconds
> >> ---------------
> >> try to fix it again.
> >>
> >> ---------------
> >> $> hbase hbck -fix
> >> …
> >> Number of empty REGIONINFO_QUALIFIER rows in .META.: 0
> >> 12/08/10 17:29:54 DEBUG util.HBaseFsck: There are 2 region info entries
> >> Summary:
> >>  -ROOT- is okay.
> >>    Number of regions: 1
> >>    Deployed on:  search-ddm-test10,60020,1344586183254
> >>  .META. is okay.
> >>    Number of regions: 1
> >>    Deployed on:  search-ddm-test6,60020,1344586183295
> >> 0 inconsistencies detected.
> >> Status: OK
> >> ---------------
> >>
> >> hbase shell says also
> >>
> >> ---------------
> >> hbase(main):009:0> list
> >> TABLE
> >> 0 row(s) in 0.0160 seconds
> >> ---------------
> >>
> >>
> >> not easy procedures to fix it  for me.
> >> anyway, finally, in the conclusion, I fixed it.
> >>
> >>
> >> 2012. 8. 9., 오후 9:00, Jean-Marc Spaggiari <[EMAIL PROTECTED]> 작성:
> >>
> >>> Hi Henry,
> >>>
> >>> I faced the same issue not so long time ago...
> >>>
> >>> Can you take a look at what you have in zookeeper under /hbase/table ?
> >>>
> >>> If you table is there, that's why you see it on the list. Simply
> >>> remove it from zookeeper.
> >>>
> >>> You can also take a look there: