Return-Path: X-Original-To: apmail-hbase-user-archive@www.apache.org Delivered-To: apmail-hbase-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 40785DD46 for ; Fri, 10 Aug 2012 23:09:56 +0000 (UTC) Received: (qmail 77758 invoked by uid 500); 10 Aug 2012 23:09:54 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 77689 invoked by uid 500); 10 Aug 2012 23:09:54 -0000 Mailing-List: contact user-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hbase.apache.org Delivered-To: mailing list user@hbase.apache.org Received: (qmail 77681 invoked by uid 99); 10 Aug 2012 23:09:54 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Aug 2012 23:09:54 +0000 X-ASF-Spam-Status: No, hits=1.8 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FSL_RCVD_USER,HS_INDEX_PARAM,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of anilgupta84@gmail.com designates 209.85.214.169 as permitted sender) Received: from [209.85.214.169] (HELO mail-ob0-f169.google.com) (209.85.214.169) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Aug 2012 23:09:50 +0000 Received: by obhx4 with SMTP id x4so3622607obh.14 for ; Fri, 10 Aug 2012 16:09:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=QjjDAOS6jf5suzT/aPTmGIDHiB+cJBzwFzm3XXECTqQ=; b=NfXkXN5IX734Xc2CJ7iKBjQDdyK+FhdlQtDZibqdE54CMAOMeeIGKrYgf2thWz00MB JIX4tk/fnACq2/Qkk2oRH2jl8jbuvGb7qOoyZNxTRV1BUsn0D2oRde0VFFDdeQZloKY5 9YiH/iKuFiDfKVp/560FGS3eAHycLhvm4DPRztj5DmHziE5wAhOzoFcg8km/aS96VTDA n2gl6QmPcCKSUwjDmnJJSVP30Lww70aIn09b2C7/ySu2S5ZaJyTWkLbSoc/6rKVhcw8T RL7ZP0hb1FgTt7oTwaq39+ze48QK8edZVQBdsMGYF/JXUGtTPu8IHeZXnn4vj+IzXUpj qCFw== Received: by 10.50.15.196 with SMTP id z4mr3189687igc.52.1344640169482; Fri, 10 Aug 2012 16:09:29 -0700 (PDT) MIME-Version: 1.0 Received: by 10.64.37.106 with HTTP; Fri, 10 Aug 2012 16:09:09 -0700 (PDT) In-Reply-To: References: <337C6F38C62740D5BB5893CA2B2F9D0A@gallotta.co.za> <680A0D625EFF468FBDF81FAFC00CE25A@gallotta.co.za> <48F495EE31BB468AB38B38423C03BF43@gallotta.co.za> From: anil gupta Date: Fri, 10 Aug 2012 16:09:09 -0700 Message-ID: Subject: Re: Table listed in "list", but not in .META. To: user@hbase.apache.org Content-Type: multipart/alternative; boundary=14dae9340a33a71ac904c6f16f19 X-Virus-Checked: Checked by ClamAV on apache.org --14dae9340a33a71ac904c6f16f19 Content-Type: text/plain; charset=ISO-8859-1 Is it a standalone installation or pseudo-distributed? I faced a similar problem a few days back in a distributed cluster and used hbck -repair option. You might give it a try. ~Anil On Fri, Aug 10, 2012 at 3:39 PM, Mohammad Tariq wrote: > Could you please share your /etc/hosts file??Meantime, do a manual > compaction and see if ti works. > > Regards, > Mohammad Tariq > > > On Sat, Aug 11, 2012 at 4:07 AM, Marco Gallotta > wrote: > > It's not a distributed cluster. I'm not processing enough data yet. So > the reference to localhost is correct. > > > > -- > > Marco Gallotta | Mountain View, California > > Software Engineer, Infrastructure | Loki Studios > > fb.me/marco.gallotta | twitter.com/marcog > > marco@gallotta.co.za | +1 (650) 417-3313 > > > > Sent with Sparrow (http://www.sparrowmailapp.com/?sig) > > > > > > On Friday 10 August 2012 at 3:30 PM, anil gupta wrote: > > > >> Are you running a distributed cluster? > >> If yes, do you have localhost in /etc/hosts file? > >> > >> You are getting reference to localhost in hbck output: > >> ERROR: Region { meta => null, hdfs => > >> hdfs://localhost:9000/hbase/test2/b0d4a5f294809c94fccb3d4ce10c3b23, > >> deployed => } on HDFS, but not listed in META or deployed on any region > >> server > >> > >> ~Anil > >> > >> On Fri, Aug 10, 2012 at 3:08 PM, Marco Gallotta marco@gallotta.co.za)>wrote: > >> > >> > Here's the output from hbck -details: http://pastebin.com/ZxVZEctY > >> > > >> > Extract: > >> > > >> > 6 inconsistencies detected. > >> > Status: INCONSISTENT > >> > > >> > 6 is the number of tables that appear in "list" but cannot be > operated on > >> > (which btw, includes not being able to run disable/drop on them - > both ops > >> > say table not found). I also just noticed "foo" does not occur in a > table > >> > list, although I did create it at one point but was able to clear it > from > >> > .META. when it also was reporting table not found when trying to > >> > disable/drop it. All these come from when I ^C'ed (i.e. killed) table > >> > creation when I was trying to get lzo compression working and table > >> > creation was hanging. > >> > > >> > Is there any way to repair this? I see hbck has repair options, but I > want > >> > to proceed with caution. > >> > > >> > -- > >> > Marco Gallotta | Mountain View, California > >> > Software Engineer, Infrastructure | Loki Studios > >> > fb.me/marco.gallotta (http://fb.me/marco.gallotta) | > twitter.com/marcog (http://twitter.com/marcog) > >> > marco@gallotta.co.za (mailto:marco@gallotta.co.za) | +1 (650) > 417-3313 > >> > > >> > Sent with Sparrow (http://www.sparrowmailapp.com/?sig) > >> > > >> > > >> > On Friday 10 August 2012 at 2:49 PM, anil gupta wrote: > >> > > >> > > Hi Marco, > >> > > > >> > > Did anything disastrous happen to cluster? > >> > > Can you try using hbck utility of HBase. > >> > > Run: 'hbase hbck -help' to get all the available options. > >> > > > >> > > ~Anil > >> > > > >> > > On Fri, Aug 10, 2012 at 2:22 PM, Marco Gallotta < > marco@gallotta.co.za (mailto:marco@gallotta.co.za)(mailto: > >> > marco@gallotta.co.za (mailto:marco@gallotta.co.za))>wrote: > >> > > > >> > > > Hi there > >> > > > > >> > > > I have a few tables which show up in a "list" in the shell, but > produce > >> > > > "table not found" when performing any operation on them. There is > no > >> > > > reference of them in the .META. table. It seems to be resulting in > >> > > > > >> > > > >> > > > >> > > >> > some of > >> > > > the hbase services being killed every so often. > >> > > > > >> > > > Here are some logs from master (foo is one of the tables not > found): > >> > > > > >> > > > 2012-08-09 20:40:44,301 FATAL > org.apache.hadoop.hbase.master.HMaster: > >> > > > Master server abort: loaded coprocessors are: [] > >> > > > 2012-08-09 20:40:44,301 FATAL > org.apache.hadoop.hbase.master.HMaster: > >> > > > Unexpected state : > foo,,1343175078663.527bb34f4bb5e40dd42e82054d7c5485. > >> > > > state=PENDING_OPEN, ts=1344570044277, > >> > > > > server=ip-10-170-150-10.us-west-1.compute.internal,60020,1344559455110 > >> > > > > >> > > > >> > > >> > .. > >> > > > Cannot transit it to OFFLINE. > >> > > > > >> > > > > >> > > > There are also a number of the following types of error logs: > >> > > > > >> > > > 2012-08-09 20:10:04,308 ERROR > >> > > > org.apache.hadoop.hbase.master.AssignmentManager: Failed > assignment in: > >> > > > ip-10-170-150-10.us-west-1.compute.internal,60020,1344559455110 > due to > >> > > > > >> > > > >> > > >> > > org.apache.hadoop.hbase.regionserver.RegionAlreadyInTransitionException: > >> > > > Received:OPEN for the > >> > > > region:foo,,1343175078663.527bb34f4bb5e40dd42e82054d7c5485. > ,which we > >> > > > > >> > > > >> > > >> > are > >> > > > already trying to OPEN. > >> > > > > >> > > > Any ideas how to find and remove any references to these > non-existent > >> > > > tables? > >> > > > > >> > > > -- > >> > > > Marco Gallotta | Mountain View, California > >> > > > Software Engineer, Infrastructure | Loki Studios > >> > > > fb.me/marco.gallotta (http://fb.me/marco.gallotta) | > >> > > > > >> > > > >> > > >> > twitter.com/marcog (http://twitter.com/marcog) > >> > > > marco@gallotta.co.za (mailto:marco@gallotta.co.za) | +1 (650) > 417-3313 > >> > > > > >> > > > Sent with Sparrow (http://www.sparrowmailapp.com/?sig) > >> > > > >> > > > >> > > -- > >> > > Thanks & Regards, > >> > > Anil Gupta > >> > > > >> > > >> > > >> > >> > >> > >> -- > >> Thanks & Regards, > >> Anil Gupta > >> > >> > > > > > -- Thanks & Regards, Anil Gupta --14dae9340a33a71ac904c6f16f19--