You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hbase.apache.org by Jinsong Hu <ji...@hotmail.com> on 2010/09/09 03:05:43 UTC
how to remove dangling region and table?
Hi,
I created a table and inserted 1.1 TB data, then I tried to drop the table
and data. I understand that current hbase has a bug,
so I renamed the table to a temp name. and then dropped the temp table.
However, I found that some of the regions are not renamed to the temp
table and they are still with the original table name.
I tried to physically remove the HFS dir, and restart master and
regionserver, delete it from HDFS again , and restart master/regionserver
again. the regions just continue to hang there. and I can't create a table
with the original name.
Is there any way I can remove the dangling region and then I can create a
brand new table with original name ?
Jimmy.
Re: how to remove dangling region and table?
Posted by Stack <st...@duboce.net>.
hbase> scan '.META.'
# Look at output for rows w/ your table mentioned
hbase> delete '.META.', 'ROW_FROM_META_WITH_YOUR_TABLE'
Or you could dump scan to a file
echo "scan '.META.'"|./bin/hbase shell &> /tmp/meta.txt
... figure list of rows to delete
Then write script to delete rows.
St.Ack
On Wed, Sep 8, 2010 at 9:29 PM, Jinsong Hu <ji...@hotmail.com> wrote:
> how do I delete the entries from .META. ? Is there a command or utility
> that I can use ?
>
> the table doesn't even appear in "list" command any more.
> if I try to run disable command, the shell says the table doesn't exist.
> if I try to a table with that name, the shell says the table already exists.
>
> Jimmy.
>
> --------------------------------------------------
> From: "Stack" <st...@duboce.net>
> Sent: Wednesday, September 08, 2010 8:54 PM
> To: <us...@hbase.apache.org>
> Subject: Re: how to remove dangling region and table?
>
>> On Wed, Sep 8, 2010 at 6:05 PM, Jinsong Hu <ji...@hotmail.com> wrote:
>>>
>>> Hi,
>>> I created a table and inserted 1.1 TB data, then I tried to drop the
>>> table
>>> and data. I understand that current hbase has a bug,
>>
>>
>> Yeah, enable/disable is kinda flakey in 0.20.x hbase.
>>
>>> so I renamed the table to a temp name. and then dropped the temp table.
>>> However, I found that some of the regions are not renamed to the temp
>>> table
>>> and they are still with the original table name.
>>> I tried to physically remove the HFS dir, and restart master and
>>> regionserver, delete it from HDFS again , and restart master/regionserver
>>> again. the regions just continue to hang there. and I can't create a
>>> table
>>> with the original name.
>>
>> Yes. The table has mention in the .META. table. You'll need to
>> delete the entries here as well as remove the table dir from hdfs.
>>
>> Or, just keep trying to disable. It usually succeeds eventually.
>> Then do drop table.
>>
>>> Is there any way I can remove the dangling region and then I can create
>>> a
>>> brand new table with original name ?
>>>
>>
>> Go through meta and delete each row which has the tablename for a prefix.
>>
>> Or shutdown hbase, remove the hbase.rootdir and restart.
>>
>> St.Ack
>>
>
Re: how to remove dangling region and table?
Posted by Jinsong Hu <ji...@hotmail.com>.
how do I delete the entries from .META. ? Is there a command or utility
that I can use ?
the table doesn't even appear in "list" command any more.
if I try to run disable command, the shell says the table doesn't exist.
if I try to a table with that name, the shell says the table already exists.
Jimmy.
--------------------------------------------------
From: "Stack" <st...@duboce.net>
Sent: Wednesday, September 08, 2010 8:54 PM
To: <us...@hbase.apache.org>
Subject: Re: how to remove dangling region and table?
> On Wed, Sep 8, 2010 at 6:05 PM, Jinsong Hu <ji...@hotmail.com> wrote:
>> Hi,
>> I created a table and inserted 1.1 TB data, then I tried to drop the
>> table
>> and data. I understand that current hbase has a bug,
>
>
> Yeah, enable/disable is kinda flakey in 0.20.x hbase.
>
>> so I renamed the table to a temp name. and then dropped the temp table.
>> However, I found that some of the regions are not renamed to the temp
>> table
>> and they are still with the original table name.
>> I tried to physically remove the HFS dir, and restart master and
>> regionserver, delete it from HDFS again , and restart master/regionserver
>> again. the regions just continue to hang there. and I can't create a
>> table
>> with the original name.
>
> Yes. The table has mention in the .META. table. You'll need to
> delete the entries here as well as remove the table dir from hdfs.
>
> Or, just keep trying to disable. It usually succeeds eventually.
> Then do drop table.
>
>> Is there any way I can remove the dangling region and then I can create
>> a
>> brand new table with original name ?
>>
>
> Go through meta and delete each row which has the tablename for a prefix.
>
> Or shutdown hbase, remove the hbase.rootdir and restart.
>
> St.Ack
>
Re: how to remove dangling region and table?
Posted by Stack <st...@duboce.net>.
On Wed, Sep 8, 2010 at 6:05 PM, Jinsong Hu <ji...@hotmail.com> wrote:
> Hi,
> I created a table and inserted 1.1 TB data, then I tried to drop the table
> and data. I understand that current hbase has a bug,
Yeah, enable/disable is kinda flakey in 0.20.x hbase.
> so I renamed the table to a temp name. and then dropped the temp table.
> However, I found that some of the regions are not renamed to the temp table
> and they are still with the original table name.
> I tried to physically remove the HFS dir, and restart master and
> regionserver, delete it from HDFS again , and restart master/regionserver
> again. the regions just continue to hang there. and I can't create a table
> with the original name.
Yes. The table has mention in the .META. table. You'll need to
delete the entries here as well as remove the table dir from hdfs.
Or, just keep trying to disable. It usually succeeds eventually.
Then do drop table.
> Is there any way I can remove the dangling region and then I can create a
> brand new table with original name ?
>
Go through meta and delete each row which has the tablename for a prefix.
Or shutdown hbase, remove the hbase.rootdir and restart.
St.Ack