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 yuzhihong@gmail.com designates
 209.85.210.41 as permitted sender)
References: 
 <CAP+59w_ko5KGFSgwD_nY6RR_cd6u-F7yhGi-aqnBnnZF_D9-sw@mail.gmail.com>
In-Reply-To: 
 <CAP+59w_ko5KGFSgwD_nY6RR_cd6u-F7yhGi-aqnBnnZF_D9-sw@mail.gmail.com>
Mime-Version: 1.0 (1.0)
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
	charset=us-ascii
Message-Id: <11927721-2ACB-4085-B281-705BF6CD02DD@gmail.com>
Cc: "user@hbase.apache.org" <user@hbase.apache.org>
From: yuzhihong@gmail.com
Subject: Re: Problem with recreation of a phantom table
Date: Tue, 2 Oct 2012 16:07:43 -0700
To: "user@hbase.apache.org" <user@hbase.apache.org>

Can you try using hbck ?

In the future, don't remove anything before using hbck. 

Thanks


On Oct 2, 2012, at 3:55 PM, Shumin Wu <shumin.wu@gmail.com> wrote:

> Hi,
> 
> I am using HBase 0.92 and got stuck with deletion/recreation of a phantom
> table. The table became "phantom" because hbase server went offline during
> the first time when it got deleted. Since then I cannot recreate the table
> because of the inconsistency catalog information.
> 
> Below is what I got from the hbase shell (I replaced the table name with a
> fake name).
> 
> 
> =============================================
> *
> hbase(main):005:0> create 'phantom_table','cf'*
> 
> ERROR: Table already exists: phantom_table!
> 
> Here is some help for this command:
> Create table; pass table name, a dictionary of specifications per
> column family, and optionally a dictionary of table configuration.
> Dictionaries are described below in the GENERAL NOTES section.
> Examples:
> 
>  hbase> create 't1', {NAME => 'f1', VERSIONS => 5}
>  hbase> create 't1', {NAME => 'f1'}, {NAME => 'f2'}, {NAME => 'f3'}
>  hbase> # The above in shorthand would be the following:
>  hbase> create 't1', 'f1', 'f2', 'f3'
>  hbase> create 't1', {NAME => 'f1', VERSIONS => 1, TTL => 2592000,
> BLOCKCACHE => true}
>  hbase> create 't1', 'f1', {SPLITS => ['10', '20', '30', '40']}
>  hbase> create 't1', 'f1', {SPLITS_FILE => 'splits.txt'}
> 
> *
> hbase(main):006:0> disable 'phantom_table'*
> 
> ERROR: Table phantom_table does not exist.'
> 
> Here is some help for this command:
> Start disable of named table: e.g. "hbase> disable 't1'"
> 
> =============================================
> 
> Here are the attempts I already did for investigation.
> 
> - I did a fsck on /hbase. It reported healthy.
> 
> - I did a scan on .META.. The phantom table is not listed there.
> 
> - I checked zookeeper's hbase directory and found the phantom table. I
> deleted the entry but the problem reported above still persistent.
> 
> Any comments or suggestions are highly appreciated!
> 
> Thanks,
> 
> Shumin