hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Harsh J <ha...@cloudera.com>
Subject Re: Not able to remove entries from .META. table
Date Tue, 18 Oct 2011 05:09:38 GMT
Stuti,

Sorry for the late reply, but Jon's second comment about deletall usage is right. It would
not work with a specific column "info:regioninfo", but rather with just family name "info".

On 18-Oct-2011, at 9:45 AM, Stuti Awasthi wrote:

> Hi Jon,
> 
> Thanks for the pointers. I figured out that in my case bad table created some missing
and under replicated blocks in HDFS which was causing the problem. Once I removed those under
replicated blocks from HDFS and retried to delete the entries from .META. table , I was successful.
> 
> Stuti
> 
> -----Original Message-----
> From: Jonathan Hsieh [mailto:jon@cloudera.com] 
> Sent: Monday, October 17, 2011 11:06 PM
> To: user@hbase.apache.org
> Subject: Re: Not able to remove entries from .META. table
> 
> Stuti,
> 
> I've in the process of completing a offline meta rebuilder.  An early version is here:
https://issues.apache.org/jira/browse/HBASE-4377
> 
> It assumes that your file system data is good, so using it would require "sidelining"
or deleting the regions from the bad table.
> 
> Jon.
> 
> 
> On Fri, Oct 14, 2011 at 5:42 AM, Stuti Awasthi <stutiawasthi@hcl.com> wrote:
> 
>> Hi Harsh,
>> 
>> I check the entries by the 'get' command :
>> 
>> hbase(main):001:0> get
>> '.META.','system_mappings,,1318585995582.bded23240ed1a28c2b80ece0cbfb73b8.','info'
>> COLUMN                             CELL
>> info:regioninfo                   timestamp=1318606241130, value=REGION =>
>> {NAME => 'system_mappings,,1318585995582.bded23240ed1a28c2
>>                                       b80ece0cbfb73b8.', STARTKEY => 
>> '', ENDKEY => '', ENCODED => bded23240ed1a28c2b80ece0cbfb73b8, TABLE
>>                                       => {{NAME => 'system_mappings', 
>> FAMILIES => [{NAME => 'f1', BLOOMFILTER => 'NONE', REPLICATION_SCO
>>                                       PE => '0', COMPRESSION => 
>> 'NONE', VERSIONS => '1', TTL => '2147483647', BLOCKSIZE => '65536', IN_ME
>>                                       MORY => 'false', BLOCKCACHE => 
>> 'true'}]}}
>> info:server                             timestamp=1318606241185,
>> value=slave2:60020
>> info:serverstartcode       timestamp=1318606241185, value=1316689293206
>> 3 row(s) in 0.3520 seconds
>> 
>> I tried 'deleteall' command :
>> hbase(main):002:0> deleteall
>> '.META.','system_mappings,,1318585995582.bded23240ed1a28c2b80ece0cbfb73b8.','info'
>> 0 row(s) in 0.0120 seconds
>> 
>> Again 'get' command  output :
>> hbase(main):003:0> get
>> '.META.','system_mappings,,1318585995582.bded23240ed1a28c2b80ece0cbfb73b8.','info'
>> COLUMN                             CELL
>> info:regioninfo                   timestamp=1318606241130, value=REGION =>
>> {NAME => 'system_mappings,,1318585995582.bded23240ed1a28c2
>>                                         b80ece0cbfb73b8.', STARTKEY 
>> => '', ENDKEY => '', ENCODED => bded23240ed1a28c2b80ece0cbfb73b8, TABLE
>>                                        => {{NAME => 
>> 'system_mappings', FAMILIES => [{NAME => 'f1', BLOOMFILTER => 'NONE', REPLICATION_SCO
>>                                             PE => '0', COMPRESSION => 
>> 'NONE', VERSIONS => '1', TTL => '2147483647', BLOCKSIZE => '65536', IN_ME
>>                                            MORY => 'false', 
>> BLOCKCACHE => 'true'}]}}
>> info:server                       timestamp=1318606241185,
>> value=slave2:60020
>> info:serverstartcode              timestamp=1318606241185,
>> value=1316689293206
>> 3 row(s) in 0.0130 seconds
>> 
>> 
>> -----Original Message-----
>> From: Dejan Menges [mailto:dejan.menges@gmail.com]
>> Sent: Friday, October 14, 2011 6:00 PM
>> To: user@hbase.apache.org
>> Subject: Re: Not able to remove entries from .META. table
>> 
>> Or you can format your namenode and prior to that manually clean your 
>> folders hosting HDFS data.
>> 
>> On Fri, Oct 14, 2011 at 2:27 PM, Harsh J <harsh@cloudera.com> wrote:
>> 
>>> Stuti,
>>> 
>>> What was your deleteall command for deleting the .META. entry exactly?
>>> You generally have to pass the whole region ID string to it to 
>>> remove the entry properly. If you can provide the entry from your 
>>> .META., I can churn out the exact command you're required to run to 
>>> properly remove
>> away the entry.
>>> 
>>> On 14-Oct-2011, at 5:35 PM, Stuti Awasthi wrote:
>>> 
>>>> Hi,
>>>> I am stuck in a problem that I created some table which was not 
>>>> created
>>> properly. Its entries are added in .Meta. table but the regions are 
>>> offline so I wanted to delete the table.
>>>> I tried to first delete table with 'disable' and 'drop ' commands 
>>>> but the
>>> table is not deleted.
>>>> Then I tried to remove the rows entry containing corrupt table 
>>>> name from
>>> .META. table using 'delete', 'deleteall' utilities but the row 
>>> entries are not getting deleted.
>>>> 
>>>> I also found out that when I 'list' the tables , it shows me the 
>>>> corrupt
>>> table but in HDFS , there is no directory created with corrupt table
>> name.
>>>> 
>>>> I tried this again by restarting the Hbase server but same issue. 
>>>> I am
>>> able to access all other tables properly.
>>>> 
>>>> Please help
>>>> 
>>>> 
>>>> ::DISCLAIMER::
>>>> 
>>> --------------------------------------------------------------------
>>> --
>>> -------------------------------------------------
>>>> 
>>>> The contents of this e-mail and any attachment(s) are confidential 
>>>> and
>>> intended for the named recipient(s) only.
>>>> It shall not attach any liability on the originator or HCL or its
>>> affiliates. Any views or opinions presented in
>>>> this email are solely those of the author and may not necessarily 
>>>> reflect
>>> the opinions of HCL or its affiliates.
>>>> Any form of reproduction, dissemination, copying, disclosure,
>>> modification, distribution and / or publication of
>>>> this message without the prior written consent of the author of 
>>>> this
>>> e-mail is strictly prohibited. If you have
>>>> received this email in error please delete it and notify the 
>>>> sender
>>> immediately. Before opening any mail and
>>>> attachments please check them for viruses and defect.
>>>> 
>>>> 
>>> --------------------------------------------------------------------
>>> --
>>> -------------------------------------------------
>>> 
>>> 
>> 
> 
> 
> 
> --
> // Jonathan Hsieh (shay)
> // Software Engineer, Cloudera
> // jon@cloudera.com


Mime
View raw message