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
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
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