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 Threaded View
HBase >> mail # user >> hbase can't drop a table


Copy link to this message
-
Re: hbase can't drop a table
If you get in that situation again:

1.) Verify that you don't have any remnants of the tables in HDFS
     hadoop fs -ls /hbase/

2.) If you do have any remnants and you don't care about these tables
     hadoop fs -mv /hbase/<table_name> /tmp

3.) ./bin/hbase hbck -fixMeta -fixAssignments

This should clean up META to match your HDFS and allow you to move forward.
 If not you may need a restart of HBase in case you had a RIT or something
like that hanging around.

On Tue, Oct 16, 2012 at 5:06 AM, 唐 颖 <[EMAIL PROTECTED]> wrote:

> After checking the .META. table , the ivy test_deu and deu_ivytest entries
> do exist .
>
> ROW                                                 COLUMN+CELL
>  ivytest_deu,,1348821681817.77eb091b4753dd3b713f29c
> column=info:regioninfo, timestamp=1348821682041, value={NAME =>
> 'ivytest_deu,,1348821681817.77eb091b4753dd3b713f29c4c3e0277c.', STARTKEY =>
> '', ENDKEY
>  4c3e0277c.                                          => '', ENCODED =>
> 77eb091b4753dd3b713f29c4c3e0277c,}
>  ivytest_deu,,1348821681817.77eb091b4753dd3b713f29c column=info:server,
> timestamp=1350032968219, value=ELEX-LA-WEB10:61020
>  4c3e0277c.
>  ivytest_deu,,1348821681817.77eb091b4753dd3b713f29c
> column=info:serverstartcode, timestamp=1350032968219, value=1350032549030
>  4c3e0277c.
>
> ROW                                                 COLUMN+CELL
>  deu_ivytest,,1348826121781.985d6ca9986d7d8cfaf82da
> column=info:regioninfo, timestamp=1348826121970, value={NAME =>
> 'deu_ivytest,,1348826121781.985d6ca9986d7d8cfaf82daf523fcd45.', STARTKEY =>
> '', ENDKEY
>  f523fcd45.                                          => '', ENCODED =>
> 985d6ca9986d7d8cfaf82daf523fcd45,}
>  deu_ivytest,,1348826121781.985d6ca9986d7d8cfaf82da column=info:server,
> timestamp=1348826122164, value=ELEX-LA-WEB10:61020
>  f523fcd45.
>  deu_ivytest,,1348826121781.985d6ca9986d7d8cfaf82da
> column=info:serverstartcode, timestamp=1348826122164, value=1348648468768
>  f523fcd45.
>
> And i deleted them from .META. table.Things seem Ok.
>
> The region server won't try to load these regions.
>
> Yes,it seems that the HTableDescriptor  file got deleted but the META is
> having the entry.
>
>
> Thanks!
>
>
> 在 2012-10-16,下午4:52,"Ramkrishna.S.Vasudevan" <
> [EMAIL PROTECTED]> 写道:
>
> > What does the 'list' command show?  Does it say the table exists or not?
> >
> > What I can infer here is that the HTableDescriptor  file got deleted but
> the
> > META is having the entry.  Any chance of the HTD getting accidently
> deleted
> > in your cluster?
> >
> > The hbck tool with -fixOrphanTables should atleast try to create the
> > HTableDescriptor file I suppose.  Then restart the cluster and then see
> what
> > happens.
> > I will not be able to access the logs even if you add it to pastebin.
>  But
> > pls do it so that some one else who has access can look into it.
> >
> > Regards
> > Ram
> >> -----Original Message-----
> >> From: 张磊 [mailto:[EMAIL PROTECTED]]
> >> Sent: Tuesday, October 16, 2012 1:44 PM
> >> To: '[EMAIL PROTECTED]'
> >> Subject: RE: hbase can't drop a table
> >>
> >> Hope this can help you!
> >> https://issues.apache.org/jira/browse/HBASE-
> >> 3432?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-
> >> tabpanel&focusedCommentId=13418790#comment-13418790
> >>
> >> Fowler Zhang
> >>
> >> -----Original Message-----
> >> From: 唐 颖 [mailto:[EMAIL PROTECTED]]
> >> Sent: 2012年10月16日 16:08
> >> To: [EMAIL PROTECTED]
> >> Subject: Re: hbase can't drop a table
> >>
> >> version 0.94.0, r8547
> >>
> >> And the table is ivytest_deu.
> >>
> >>
> >> 在 2012-10-16,下午3:58,"Ramkrishna.S.Vasudevan"
> >> <[EMAIL PROTECTED]> 写道:
> >>
> >>> Which version of HBase?
> >>>
> >>>
> >>> The below logs that you have attached says about a different table
> >> right '
> >>> deu_ivytest,,1348826121781.985d6ca9986d7d8cfaf82daf523fcd45.'
> >>> And the one you are trying to drop is ' ivytest_deu’
> >>>
> >>> Regards
> >>> Ram
> >>>
> >

Kevin O'Dell
Customer Operations Engineer, Cloudera
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