hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hua beatls <bea...@gmail.com>
Subject Re: how to drop a table forcefully?
Date Thu, 17 Jan 2013 12:46:02 GMT
On Thu, Jan 17, 2013 at 8:21 PM, Jean-Marc Spaggiari <
jean-marc@spaggiari.org> 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,60020,1358418770520
2013-01-17 20:17:13,664 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,664 DEBUG
org.apache.hadoop.hbase.master.AssignmentManager: Assigning region
cdrtestsnappy,,1358316641849.89d3b8af7181ad8b857ef7f55c3abe46. to
hadoop3,60020,1358418770520
2013-01-17 20:17:13,664 DEBUG org.apache.hadoop.hbase.master.ServerManager:
New connection to hadoop3,60020,1358418770520
2013-01-17 20:17:13,675 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,683 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,684 DEBUG
org.apache.hadoop.hbase.master.handler.ClosedRegionHandler: Handling CLOSED
event for 89d3b8af7181ad8b857ef7f55c3abe46
2013-01-17 20:17:13,684 DEBUG
org.apache.hadoop.hbase.master.AssignmentManager: Forcing OFFLINE;
was=cdrtestsnappy,,1358316641849.89d3b8af7181ad8b857ef7f55c3abe46.
state=CLOSED, ts=1358425018714, server=hadoop3,60020,1358418770520
2013-01-17 20:17:13,684 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,692 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,692 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,692 DEBUG
org.apache.hadoop.hbase.master.AssignmentManager: Assigning region
cdrtestsnappy,,1358316641849.89d3b8af7181ad8b857ef7f55c3abe46. to
hadoop3,60020,1358418770520
2013-01-17 20:17:13,692 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,692 DEBUG org.apache.hadoop.hbase.master.ServerManager:
New connection to hadoop3,60020,1358418770520
2013-01-17 20:17:13,700 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,708 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,709 DEBUG
org.apache.hadoop.hbase.master.handler.ClosedRegionHandler: Handling CLOSED
event for 89d3b8af7181ad8b857ef7f55c3abe46
2013-01-17 20:17:13,709 DEBUG
org.apache.hadoop.hbase.master.AssignmentManager: Forcing OFFLINE;
was=cdrtestsnappy,,1358316641849.89d3b8af7181ad8b857ef7f55c3abe46.
state=CLOSED, ts=1358425018739, server=hadoop3,60020,1358418770520
2013-01-17 20:17:13,709 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,717 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,717 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,717 DEBUG
org.apache.hadoop.hbase.master.AssignmentManager: Assigning region
cdrtestsnappy,,1358316641849.89d3b8af7181ad8b857ef7f55c3abe46. to
hadoop3,60020,1358418770520
2013-01-17 20:17:13,717 DEBUG org.apache.hadoop.hbase.master.ServerManager:
New connection to hadoop3,60020,1358418770520
2013-01-17 20:17:13,717 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,725 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,733 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,733 DEBUG
org.apache.hadoop.hbase.master.handler.ClosedRegionHandler: Handling CLOSED
event for 89d3b8af7181ad8b857ef7f55c3abe46
2013-01-17 20:17:13,734 DEBUG
org.apache.hadoop.hbase.master.AssignmentManager: Forcing OFFLINE;
was=cdrtestsnappy,,1358316641849.89d3b8af7181ad8b857ef7f55c3abe46.
state=CLOSED, ts=1358425018764, server=hadoop3,60020,1358418770520
2013-01-17 20:17:13,734 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,742 DEBUG
org.apache.hadoop.hbase.master.AssignmentManager: Handling
transition=M_ZK_REGION_OFFLINE, server=hadoop1,60000,1358418784101,
region=89d3b8af718
[root@hadoop1 logs]# tail -f hbase-hadoop-master-hadoop1.log
2013-01-17 20:38:25,958 DEBUG
org.apache.hadoop.hbase.catalog.CatalogTracker: Stopping catalog tracker
org.apache.hadoop.hbase.catalog.CatalogTracker@7decd1e2
2013-01-17 20:38:25,962 INFO org.apache.zookeeper.ZooKeeper: Session:
0x23c4806bfd50012 closed
2013-01-17 20:38:25,962 INFO org.apache.zookeeper.ClientCnxn: EventThread
shut down
2013-01-17 20:39:35,138 DEBUG org.apache.hadoop.hbase.master.HMaster: Not
running balancer because 2 region(s) in transition:
{89d3b8af7181ad8b857ef7f55c3abe46=cdrtestsnappy,,1358316641849.89d3b8af7181ad8b857ef7f55c3abe46.
state=PENDING_OPEN, ts=1358425153007, server=hadoop3,60020,1358418770520,
c56109758acea3619fb9c656b8b45aa3=cdrtestsnap,,1358321463618.c56109758acea3619fb9c6...
2013-01-17 20:39:35,139 DEBUG
org.apache.hadoop.hbase.client.HTable$ClientScanner: Creating scanner over
.META. starting at key ''
2013-01-17 20:39:35,139 DEBUG
org.apache.hadoop.hbase.client.HTable$ClientScanner: Advancing internal
scanner to startKey at ''
2013-01-17 20:39:35,212 DEBUG
org.apache.hadoop.hbase.client.HTable$ClientScanner: Finished with scanning
at {NAME => '.META.,,1', STARTKEY => '', ENDKEY => '', ENCODED =>
1028785192,}
2013-01-17 20:39:35,212 DEBUG
org.apache.hadoop.hbase.master.CatalogJanitor: Scanned 130 catalog row(s)
and gc'd 0 unreferenced parent region(s)
2013-01-17 20:40:11,469 INFO org.apache.hadoop.hbase.master.HMaster:
Balance=false
2013-01-17 20:40:13,028 INFO org.apache.hadoop.hbase.master.HMaster:
Balance=true


         use  hbase zkcli to delete the /hbase/unassigned,  still not works.

    Thanks!

beatls






> What do you mean by "the file system is ok"? Have you run both the
> HBase and the Hadoop checks and both of them aren't returning any
> error?
>
> Also, what do you have on the webui? Can yo usee the table? The regions?
>
> When you are trying to delete the table, what do you havae on you
> master logs? Can you share this log?
>
> Thanks,
>
> JM
>
> 2013/1/17, hua beatls <beatls@gmail.com>:
> > Hi,
> >    the file system is ok.
> >
> >     any other idea?
> >
> > beatls
> >
> > On Thu, Jan 17, 2013 at 7:38 PM, Jean-Marc Spaggiari <
> > jean-marc@spaggiari.org> wrote:
> >
> >> Hi Beat,
> >>
> >> Have you tried to check the filesystem using fsck to see if there is
> >> no inconsistencies?
> >>
> >> JM
> >>
> >> 2013/1/17, hua beatls <beatls@gmail.com>:
> >> > hi,
> >> >        A table mistakenly created cannot be dropped?
> >> >        first we create it  with 'hbase shell', below:
> >> >        [hadoop@hadoop3 ~]$
> >> > [hadoop@hadoop3 ~]$ hbase shell
> >> > 13/01/17 15:49:35 WARN conf.Configuration: hadoop.native.lib is
> >> deprecated.
> >> > Instead, use io.native.lib.available
> >> > HBase Shell; enter 'help<RETURN>' for list of supported commands.
> >> > Type "exit<RETURN>" to leave the HBase Shell
> >> > Version 0.92.1-cdh4.1.2, r, Thu Nov  1 17:54:35 PDT 2012
> >> > hbase(main):001:0> create 't111',{NAME=>'CF111',COMPRESSION=>'snappy'}
> >> > 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.
> >> > ^C[hadoop@hadoop3 ~]$
> >> >   (this command hang after i issue "ctrl-c". (please be noted that
> >> 'snappy'
> >> > is not installed/config in this hbase.)
> >> >    second,  we 'describe' this table, below,
> >> >  hbase(main):003:0> describe 't111'
> >> > DESCRIPTION
> >> > ENABLED
> >> >  {NAME => 't111', FAMILIES => [{NAME => 'CF111', BLOOMFILTER =>
> 'NONE',
> >> > REPLICATION_SCOPE => '0', VERSIONS
> >> > true
> >> >  => '3', COMPRESSION => 'SNAPPY', MIN_VERSIONS => '0', TTL =>
> >> '2147483647',
> >> > BLOCKSIZE => '65536',
> >> > IN_MEMORY
> >> >   => 'false', BLOCKCACHE =>
> >> > 'true'}]}
> >> >
> >> > 1 row(s) in 0.0470 seconds
> >> >     3rd,  but this table is in the 'transition' state, and remains in
> >> this
> >> > state.
> >> >     4th,  i want to 'drop' this table, but 'drop'  hang and failed.
> >> >    hbase(main):002:0> disable 't111'
> >> > 0 row(s) in 1.1560 seconds
> >> > hbase(main):005:0> drop 't111'
> >> >
> >> >  'drop' is hang until i 'ctrl-c'.
> >> >
> >> >     is there any other way to drop this table forcefully?
> >> >
> >> >
> >> > Beat R.
> >> >
> >> > beatls
> >> >
> >>
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message