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

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


Copy link to this message
-
Re: how to drop a table forcefully?
hua beatls 2013-01-17, 12:46
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:
master:60000-0x33c48075af00003 Creating (or updating) unassigned node for
89d3b8af7181ad8b857ef7f55c3abe46 with OFFLINE state
2013-01-17 20:17:13,639 DEBUG
org.apache.hadoop.hbase.master.AssignmentManager: Found an existing plan
for cdrtestsnappy,,1358316641849.89d3b8af7181ad8b857ef7f55c3abe46.
destination server is hadoop3,60020,1358418770520
2013-01-17 20:17:13,639 DEBUG
org.apache.hadoop.hbase.master.AssignmentManager: Handling
transition=M_ZK_REGION_OFFLINE, server=hadoop1,60000,1358418784101,
region=89d3b8af7181ad8b857ef7f55c3abe46
2013-01-17 20:17:13,639 DEBUG
org.apache.hadoop.hbase.master.AssignmentManager: Using pre-existing plan
for region cdrtestsnappy,,1358316641849.89d3b8af7181ad8b857ef7f55c3abe46.;
plan=hri=cdrtestsnappy,,1358316641849.89d3b8af7181ad8b857ef7f55c3abe46.,
src=, dest=hadoop3,60020,1358418770520
2013-01-17 20:17:13,639 DEBUG
org.apache.hadoop.hbase.master.AssignmentManager: Assigning region
cdrtestsnappy,,1358316641849.89d3b8af7181ad8b857ef7f55c3abe46. to
hadoop3,60020,1358418770520
2013-01-17 20:17:13,639 DEBUG org.apache.hadoop.hbase.master.ServerManager:
New connection to hadoop3,60020,1358418770520
2013-01-17 20:17:13,648 DEBUG
org.apache.hadoop.hbase.master.AssignmentManager: Handling
transition=RS_ZK_REGION_OPENING, server=hadoop3,60020,1358418770520,
region=89d3b8af7181ad8b857ef7f55c3abe46
2013-01-17 20:17:13,656 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,656 DEBUG
org.apache.hadoop.hbase.master.handler.ClosedRegionHandler: Handling CLOSED
event for 89d3b8af7181ad8b857ef7f55c3abe46
2013-01-17 20:17:13,656 DEBUG
org.apache.hadoop.hbase.master.AssignmentManager: Forcing OFFLINE;
was=cdrtestsnappy,,1358316641849.89d3b8af7181ad8b857ef7f55c3abe46.
state=CLOSED, ts=1358425018687, server=hadoop3,60020,1358418770520
2013-01-17 20:17:13,656 DEBUG org.apache.hadoop.hbase.zookeeper.ZKAssign:
master:60000-0x33c48075af00003 Creating (or updating) unassigned node for
89d3b8af7181ad8b857ef7f55c3abe46 with OFFLINE state
2013-01-17 20:17:13,664 DEBUG
org.apache.hadoop.hbase.master.AssignmentManager: Handling
transition=M_ZK_REGION_OFFLINE, server=hadoop1,60000,1358418784101,
region=89d3b8af7181ad8b857ef7f55c3abe46
2013-01-17 20:17:13,664 DEBUG
org.apache.hadoop.hbase.master.AssignmentManager: Found an existing plan
for cdrtestsnappy,,1358316641849.89d3b8af7181ad8b857ef7f55c3abe46.
destination server is hadoop3