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 7B6C6DF7C for ; Thu, 5 Jul 2012 12:23:41 +0000 (UTC) Received: (qmail 41446 invoked by uid 500); 5 Jul 2012 12:23:39 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 41400 invoked by uid 500); 5 Jul 2012 12:23:39 -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 41389 invoked by uid 99); 5 Jul 2012 12:23:39 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Jul 2012 12:23:39 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=FSL_RCVD_USER,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [209.85.161.169] (HELO mail-gg0-f169.google.com) (209.85.161.169) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Jul 2012 12:23:32 +0000 Received: by ggm4 with SMTP id 4so9072617ggm.14 for ; Thu, 05 Jul 2012 05:23:12 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type:x-gm-message-state; bh=A4T+T+X4KxH3FRdi7QCXnD8f/tMm0XSaQw5YTD4WdFk=; b=Vh31nYST6qigDSVGJh8G6tLbNLfRpel5SDS0RB2Oo2kjdUa3licdFQkAGojfkRljj5 Zol7C4byeokHFJ3DDok/5LIzoFg1r4YiLtG6nGhs5tPOlxQlXWDutdh40Ce5o/nDiz8R Iv09857piBE2i5DAD0zfNNouDJhW86/r4n53B+qAr/EMX8dhiWUMaolVpkPF/3rdcDVW hphgWsM+2js3NZx2zvzoWNmB7XmhhSypukgzSrD5gdzkIzpbSYvF5iY+B00s2ptIXmq1 LEGlg+DHRbZfUy9/w58rhscELVgzILAoAoFZk5c1UaUkdt+Web6uygzOOhbDmjiUWEOb Rdwg== MIME-Version: 1.0 Received: by 10.42.199.5 with SMTP id eq5mr13140079icb.40.1341490991735; Thu, 05 Jul 2012 05:23:11 -0700 (PDT) Received: by 10.64.33.203 with HTTP; Thu, 5 Jul 2012 05:23:11 -0700 (PDT) In-Reply-To: <889EF6D0-1E93-4E02-9665-7E1EA319D638@gmail.com> References: <889EF6D0-1E93-4E02-9665-7E1EA319D638@gmail.com> Date: Thu, 5 Jul 2012 08:23:11 -0400 Message-ID: Subject: Re: Table exist and not exist at the same time. From: Jean-Marc Spaggiari To: user@hbase.apache.org Content-Type: text/plain; charset=UTF-8 X-Gm-Message-State: ALoCoQnTk1KsovW6438dtkYMAMOkNZCspgbGSmBUaNztZLmOIJXtOncHRdR+t1AVibsMNm6kR8k0 X-Virus-Checked: Checked by ClamAV on apache.org Hi Lars, For for pointing me to the right direction. I have already restarted ZK but I did not removed anything on its server. Here is the output of the ZK ls. There is few tables I already removed (test3, work, etc.)... [zk: cube(CONNECTED) 8] ls /hbase/table [work, work_sent, .META., -ROOT-, work_proposed, test3] I removed the table using rmr /hbase/table/work is that safe? Or am I still better to restart everything? JM 2012/7/5, Lars George : > Hi JM, > > So you already wiped everything on the HDFS level? The only thing left is > ZooKeeper. It should not hold you back, but it could be having an entry in > /hbase/table? Could you try the ZK shell and do an ls on that znode? > > If at all, if you wipe HDFS anyways, please also try wiping the ZK data and > try again. > > Lars > > On Jul 5, 2012, at 1:06 PM, Jean-Marc Spaggiari wrote: > >> Hi, >> >> Yesterday I stopped my cluster because of a storm. It did not went up >> well so I have formated the hadoop FS and restarted it. >> >> Now, when I'm trying to re-create my schema, I'm facing some issues. >> It's telling me that the table don't exist when I want to delete it, >> but that the table exist when I try to create it. >> >> Here is the simple code. >> >> HBaseAdmin admin = new HBaseAdmin(config); >> if (admin.tableExists(Constants.TABLE_WORK)) >> { >> admin.disableTable(Constants.TABLE_WORK); >> admin.deleteTable(Constants.TABLE_WORK); >> } >> admin.createTable(table_work); >> admin.close(); >> >> tableExists return true. But createTable return the expection below. >> >> I have done a rm -rf on the hadoop storage directory and formated the >> namenode. So what did I missed? If I try to put some data into this >> table I get org.apache.hadoop.hbase.TableNotFoundException: Cannot >> find row in .META. for table: work, row=work,,99999999999999 but if I >> look at the web interface, there is no table anywhere except META and >> ROOT. >> >> Do you have any idea where I should look at? >> >> Thanks, >> >> JM >> >> org.apache.hadoop.hbase.TableExistsException: >> org.apache.hadoop.hbase.TableExistsException: work >> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >> at >> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) >> at >> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >> at java.lang.reflect.Constructor.newInstance(Constructor.java:532) >> at >> org.apache.hadoop.ipc.RemoteException.instantiateException(RemoteException.java:95) >> at >> org.apache.hadoop.ipc.RemoteException.unwrapRemoteException(RemoteException.java:79) >> at >> org.apache.hadoop.hbase.client.HBaseAdmin.createTableAsync(HBaseAdmin.java:492) >> at >> org.apache.hadoop.hbase.client.HBaseAdmin.createTable(HBaseAdmin.java:394) >> at >> org.apache.hadoop.hbase.client.HBaseAdmin.createTable(HBaseAdmin.java:330) >> at >> org.spaggiari.distparser.servlet.GetWorkload.main(GetWorkload.java:1071) >> Caused by: org.apache.hadoop.ipc.RemoteException: >> org.apache.hadoop.hbase.TableExistsException: work >> at >> org.apache.hadoop.hbase.master.handler.CreateTableHandler.(CreateTableHandler.java:103) >> at org.apache.hadoop.hbase.master.HMaster.createTable(HMaster.java:1102) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:601) >> at >> org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:364) >> at >> org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1376) >> >> at org.apache.hadoop.hbase.ipc.HBaseClient.call(HBaseClient.java:918) >> at >> org.apache.hadoop.hbase.ipc.WritableRpcEngine$Invoker.invoke(WritableRpcEngine.java:150) >> at $Proxy1.createTable(Unknown Source) >> at >> org.apache.hadoop.hbase.client.HBaseAdmin.createTableAsync(HBaseAdmin.java:490) >> ... 3 more > >