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
Copy link to this message
-
Re: how to drop a table forcefully?
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.
> state=PENDING_OPEN, ts=Thu Jan 17 20:19:13 CST 2013 (945s ago),
> server=hadoop3,60020,1358418770520 c56109758acea3619fb9c656b8b45aa3
> cdrtestsnap,,1358321463618.c56109758acea3619fb9c656b8b45aa3.
> state=PENDING_OPEN, ts=Thu Jan 17 20:15:59 CST 2013 (1138s ago),
> server=null
>
>         masterlog:
>        2013-01-17 20:17:13,630 DEBUG
> org.apache.hadoop.hbase.master.AssignmentManager: Handling
> transition=RS_ZK_REGION_FAILED_OPEN, server=hadoop3,60020,1358418770520,
> region=89d3b8af7181ad8b857ef7f55c3abe46
> 2013-01-17 20:17:13,630 DEBUG
> org.apache.hadoop.hbase.master.handler.ClosedRegionHandler: Handling CLOSED
> event for 89d3b8af7181ad8b857ef7f55c3abe46
> 2013-01-17 20:17:13,630 DEBUG
> org.apache.hadoop.hbase.master.AssignmentManager: Forcing OFFLINE;
> was=cdrtestsnappy,,1358316641849.89d3b8af7181ad8b857ef7f55c3abe46.
> state=CLOSED, ts=1358425018648, server=hadoop3,60020,1358418770520
> 2013-01-17 20:17:13,630 DEBUG org.apache.hadoop.hbase.zookeeper.ZKAssign:
+
hua beatls 2013-01-17, 14:42
+
Jean-Marc Spaggiari 2013-01-17, 14:45