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
Thanks for the write up Kevin.  Many users will be benefited by this.

Regards
Ram

> -----Original Message-----
> From: Kevin O'dell [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 16, 2012 9:42 PM
> To: [EMAIL PROTECTED]
> Subject: 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