Mailing-List: contact dev-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hbase.apache.org
Received-SPF: pass (athena.apache.org: domain of yuzhihong@gmail.com
 designates 209.85.161.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=SyJhnRnc4yc4vZx59DqxAmflR9Vf9X1XnMqkXyU6ju5QXU6KTAhL6sUH/eMNKiW9sL
         EmEHBaQAdtk2NRAKHNTgp752rZA6iKoDF9a+PQscDPKCWMbB/uPuzslMFw+ilOi8F91Z
         dbYPoXE72KjKytqoHVBkf38uFpM1VNMM/6Ibs=
MIME-Version: 1.0
In-Reply-To: <AANLkTinmNPuiNdpFhds15079qvMXyVPHG0Dt0JYqw2Up@mail.gmail.com>
References: <AANLkTimjS1U4na5DOKp1XCcPpWaN87qmbour0To23Y5L@mail.gmail.com>
	<AANLkTi=oRCYD9LcwZd2aPQEaxsq4KDz6hdKmf0jYvZWR@mail.gmail.com>
	<AANLkTinmNPuiNdpFhds15079qvMXyVPHG0Dt0JYqw2Up@mail.gmail.com>
Date: Fri, 19 Nov 2010 11:37:25 -0800
Message-ID: <AANLkTim7D=1SN-Zw_-LMct5-nJAfZHrROM5E=Wx2M8kg@mail.gmail.com>
Subject: Re: table not shown on master UI but creating same table fails
From: Ted Yu <yuzhihong@gmail.com>
To: dev@hbase.apache.org
Content-Type: multipart/alternative; boundary=20cf3054a7153c5cdd04956d098c

--20cf3054a7153c5cdd04956d098c
Content-Type: text/plain; charset=ISO-8859-1

You can find more detail in https://issues.apache.org/jira/browse/HBASE-3251

On Fri, Nov 19, 2010 at 10:44 AM, Ted Yu <yuzhihong@gmail.com> wrote:

> Here is a summary of what I did:
> echo "scan '.META.', {COLUMNS => 'info:regioninfo'}" |
> $HBASE_HOME/bin/hbase shell > result
> then find the row for packageindex table in result
> then:
> hbase(main):001:0> deleteall '.META.',
> 'packageindex,E70888DD48276DFAD4D26FEB08DC7045,1290163034864'
>
> Now I can create the table again.
>
>
> On Fri, Nov 19, 2010 at 10:01 AM, Jean-Daniel Cryans <jdcryans@apache.org>wrote:
>
>> Seems like a classic .META. issue from 0.20, I would suggest that you
>> look at the master's state (regions in transition, etc), and that you
>> scan .META. for that table.
>>
>> Also, looking at the code that lists the table, I see one case where a
>> row would be in .META. but not listed:
>>
>>            byte[] value = result.getValue(CATALOG_FAMILY,
>> REGIONINFO_QUALIFIER);
>>            HRegionInfo info = null;
>>            if (value != null) {
>>              info = Writables.getHRegionInfo(value);
>>            }
>>            // Only examine the rows where the startKey is zero length
>>            if (info != null && info.getStartKey().length == 0) {
>>              uniqueTables.add(info.getTableDesc());
>>            }
>>
>>
>> Could it be that the first region isn't in .META.?
>>
>> J-D
>> On Fri, Nov 19, 2010 at 9:56 AM, Ted Yu <yuzhihong@gmail.com> wrote:
>> > Hi,
>> > We use hbase 0.20.6
>> > We're facing weird state for a particular table:
>> >
>> > 2010-11-19 09:25:08,350 Thread-20 ERROR [StripedHBaseTable] Could not
>> > create packageindex
>> > org.apache.hadoop.hbase.TableExistsException:
>> > org.apache.hadoop.hbase.TableExistsException: packageindex
>> >        at
>> org.apache.hadoop.hbase.master.HMaster.createTable(HMaster.java:799)
>> >        at
>> org.apache.hadoop.hbase.master.HMaster.createTable(HMaster.java:763)
>> >        at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
>> >        at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>> >        at java.lang.reflect.Method.invoke(Method.java:597)
>> >        at
>> org.apache.hadoop.hbase.ipc.HBaseRPC$Server.call(HBaseRPC.java:657)
>> >        at
>> org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:998)
>> >
>> >        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>> Method)
>> >        at
>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>> >        at
>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>> >        at
>> java.lang.reflect.Constructor.newInstance(Constructor.java:513)
>> >        at
>> org.apache.hadoop.hbase.RemoteExceptionHandler.decodeRemoteException(RemoteExceptionHandler.java:94)
>> >        at
>> org.apache.hadoop.hbase.client.HBaseAdmin.createTableAsync(HBaseAdmin.java:283)
>> >        at
>> org.apache.hadoop.hbase.client.HBaseAdmin.createTable(HBaseAdmin.java:240)
>> >        at
>> org.apache.hadoop.hbase.client.HBaseAdmin.createTable(HBaseAdmin.java:206)
>> > ...
>> > 2010-11-19 09:25:08,352 Thread-20 INFO
>> > [HBasePackageIndexTableMapperNew] Creating table packageindex - Done
>> > 2010-11-19 09:25:08,374 Thread-20 INFO  [CodecPool] Got brand-new
>> decompressor
>> > 2010-11-19 09:25:08,396 Thread-20 INFO
>> > [HBasePackageIndexTableMapperNew] OnClose called
>> > 2010-11-19 09:25:08,397 Thread-20 WARN  [LocalJobRunner] job_local_0001
>> > org.apache.hadoop.hbase.TableNotFoundException: packageindex
>> >        at
>> org.apache.hadoop.hbase.client.HConnectionManager$TableServers.locateRegionInMeta(HConnectionManager.java:698)
>> >        at
>> org.apache.hadoop.hbase.client.HConnectionManager$TableServers.locateRegion(HConnectionManager.java:634)
>> >        at
>> org.apache.hadoop.hbase.client.HConnectionManager$TableServers.locateRegion(HConnectionManager.java:601)
>> >        at org.apache.hadoop.hbase.client.HTable.<init>(HTable.java:134)
>> >        at org.apache.hadoop.hbase.client.HTable.<init>(HTable.java:112)
>> >
>> > Can someone suggest what I should do so that I can create this table
>> again ?
>> >
>> > Thanks
>> >
>>
>
>

--20cf3054a7153c5cdd04956d098c--