Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (nike.apache.org: domain of nanhengwu@gmail.com designates
 209.85.160.41 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=syjlXSNXpHDZCKGxq+k/ciK8tmm8Yfygo6tJqn93wZm1+v0vI+eFWtb+sfl3PSda+T
         lRdBMTdSIZ2PDU0rLGIhajBv71wTPi9nxwC1m2/UzBq9vWjbvosg27jgvFjD0ewyoOz4
         rC7E5atRWPwoDkCKVQM6BrefSkN8dCoBuNZDQ=
MIME-Version: 1.0
In-Reply-To: <AANLkTikx9cyvutp3QCJ8SRFRHH2DR-osWOb3VSAgqORL@mail.gmail.com>
References: <AANLkTimHxjHEzdcXGU=5UGsdT5LLrqyUJn+tNBTDQOPK@mail.gmail.com>
	<AANLkTikx9cyvutp3QCJ8SRFRHH2DR-osWOb3VSAgqORL@mail.gmail.com>
Date: Wed, 16 Feb 2011 16:26:35 -0800
Message-ID: <AANLkTikDk1gPs7AUeoFrQoDusDV_euPqov_muQfd=xX6@mail.gmail.com>
Subject: Re: Disabling a table taking very long time
From: Nanheng Wu <nanhengwu@gmail.com>
To: user@hbase.apache.org
Content-Type: text/plain; charset=ISO-8859-1

Actually I wanted to disable the table so I can drop it. It would be
nice to be able to disable the table without flushing memstore. It's
not possible in 0.20.6 is it?

On Wed, Feb 16, 2011 at 2:30 PM, Jean-Daniel Cryans <jdcryans@apache.org> wrote:
> To disable a region, it's memstore must first be flushed. That's done
> sequentially for all regions that must be disabled inside a table.
> There's not really a way around it unless you don't need that data.
>
> If you're planning to disable a table but at the same time need it to
> be unavailable for the shortest time possible, I recommend calling a
> flush on the table from the shell first and then some time later doing
> the disable. How much later you ask? Well there's currently no easy
> way to tell, I usually just tail any region server log file until I
> see they're done.
>
> J-D
>
> On Wed, Feb 16, 2011 at 2:21 PM, Nanheng Wu <nanhengwu@gmail.com> wrote:
>> From time to time I run into issues where disabling a table pretty
>> much hangs. I am simply calling the disableTable method fo HBaseAdmin.
>> The table has ~ 500 regions with default region file size. I couldn't
>> tell anything abnormal from the master's log. When I click on the
>> region from Master's web UI I get the "RegionOfflineException". I am
>> using HBase 0.20.6 + Hadoop 0.20.2. My cluster has ~10 nodes with one
>> node running Master/ZK/NameNode. Can someone help me understand what's
>> wrong? Thanks!
>>
>