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

Switch to Plain View
HBase, mail # user - how to drop a table forcefully?


+
hua beatls 2013-01-17, 09:23
+
Jean-Marc Spaggiari 2013-01-17, 11:38
+
hua beatls 2013-01-17, 12:15
+
Jean-Marc Spaggiari 2013-01-17, 12:21
+
hua beatls 2013-01-17, 12:46
+
Jean-Marc Spaggiari 2013-01-17, 13:40
Copy link to this message
-
Re: how to drop a table forcefully?
hua beatls 2013-01-17, 14:42
Hi JM,
    sorry, the table name is 'cdrtestsnappy' and 'cdrtestsnap'.
    i can see them from 'list'.
    hbase(main):001:0> list
TABLE

SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in
[jar:file:/app/hbase/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/app/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an
explanation.
cdrtest

cdrtest1

cdrtestGZ

cdrtestsnap

cdrtestsnappy

filelog

merge_bigtable

zlytest

zlytest1

9 row(s) in 0.6050 seconds
hbase(main):002:0>

    Many Thanks!
beatls
On Thu, Jan 17, 2013 at 9:40 PM, Jean-Marc Spaggiari <
[EMAIL PROTECTED]> wrote:

> Ok.
>
> So. You HBase system is inconsistent. And I can't see you table "
> t111" anywhere. On the shell, if you do a "list", which tables are you
> getting? I guess t111 will not be there. First thing to do is to fix
> that.
>
> Can you provide more logs from the hbase check? It might tell you what
> the issues are. You can past it on pastebin.com
>
> JM
>
> 2013/1/17, hua beatls <[EMAIL PROTECTED]>:
> > On Thu, Jan 17, 2013 at 8:21 PM, Jean-Marc Spaggiari <
> > [EMAIL PROTECTED]> wrote:
> >
> >> Hi,
> >>
> >        *below is snapshot of webui,* tabel 'cdrtestsnap' and
> > 'cdrtestsnappy' is on the list , as well as their regions.
> >
> >  cdrtestGZ <http://192.168.250.106:60010/table.jsp?name=cdrtestGZ>
> {NAME =>
> > 'cdrtestGZ', FAMILIES => [{NAME => 'cf', COMPRESSION => 'GZ',
> MIN_VERSIONS
> > => '0'}]}
> > cdrtestsnap<http://192.168.250.106:60010/table.jsp?name=cdrtestsnap>
> > {NAME
> > => 'cdrtestsnap', FAMILIES => [{NAME => 'cf', COMPRESSION => 'SNAPPY',
> > MIN_VERSIONS => '0'}]}
> > cdrtestsnappy<http://192.168.250.106:60010/table.jsp?name=cdrtestsnappy>
> > {NAME
> > => 'cdrtestsnappy', FAMILIES => [{NAME => 'cf', COMPRESSION => 'SNAPPY',
> > MIN_VERSIONS => '0'}]}
> >
> >      region information of table 'cdrtestsnap' show below:
> >       Table Attributes  Attribute Name Value Description Enabled true Is
> > the table enabled Compaction
> >
> > ------------------------------
> >
> > Actions:
> >
> >      Region Key (optional): This action will force a compaction of all
> > regions of the table, or, if a key is supplied, only the region
> containing
> > the given key.     Region Key (optional): This action will force a split
> of
> > all eligible regions of the table, or, if a key is supplied, only the
> > region containing the given key. An eligible region is one that does not
> > contain any references to other regions. Split requests for noneligible
> > regions will be ignored.
> >
> >
> >     *below is excerption  hbase hbck:*
> >      Summary:
> >   -ROOT- is okay.
> >     Number of regions: 1
> >     Deployed on:  hadoop2,60020,1358418770574
> >   .META. is okay.
> >     Number of regions: 1
> >     Deployed on:  hadoop2,60020,1358418770574
> >   cdrtest is okay.
> >     Number of regions: 122
> >     Deployed on:  hadoop3,60020,1358418770520
> >   cdrtest1 is okay.
> >     Number of regions: 1
> >     Deployed on:  hadoop3,60020,1358418770520
> >   cdrtestGZ is okay.
> >     Number of regions: 1
> >     Deployed on:  hadoop2,60020,1358418770574
> >   filelog is okay.
> >     Number of regions: 1
> >     Deployed on:  hadoop3,60020,1358418770520
> >   merge_bigtable is okay.
> >     Number of regions: 1
> >     Deployed on:  hadoop1,60020,1358418784993
> >   zlytest is okay.
> >     Number of regions: 1
> >     Deployed on:  hadoop1,60020,1358418784993
> >   zlytest1 is okay.
> >     Number of regions: 1
> >     Deployed on:  hadoop3,60020,1358418770520
> > 2 inconsistencies detected.
> > Status: INCONSISTENT
> > [hadoop@hadoop2 ~]$ d
> >
> >  *   these two table are in the transition state.*
> >     Regions in Transition  Region State
> > 89d3b8af7181ad8b857ef7f55c3abe46
> > cdrtestsnappy,,1358316641849.89d3b8af7181ad8b857ef7f55c3abe46.
+
Jean-Marc Spaggiari 2013-01-17, 14:45