Home | About | Sematext search-lucene.com search-hadoop.com
 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
Kevin O'dell 2012-10-16, 16:11
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