You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hbase.apache.org by y_...@tsmc.com on 2010/03/24 08:36:02 UTC

How can I drop my table

There is a file CORRUPT in HDFS then hbase can't handle client's request
well.
I want to truncate it but there is a NativeException raised.
How can I handle this problem?
Thanks.

                            
                            
                            


Hadoop 0.20.1
HBase Version 0.20.2, r834515
----------------------------------------

/hbase/FRPD_LCRECIPETECH/990451997/MAJOR/1869647744144904264: CORRUPT block
blk_-2984490753678277755

/hbase/FRPD_LCRECIPETECH/990451997/MAJOR/1869647744144904264: MISSING 1
blocks of total size 67108864 B..........................
......................................Status: CORRUPT


NativeException: org.apache.hadoop.hbase.client.RegionOfflineException:
region offline: FRPD_LCRECIPETECH,,1264688306108
        from org/apache/hadoop/hbase/client/HConnectionManager.java:658:in
`locateRegionInMeta'
        from org/apache/hadoop/hbase/client/HConnectionManager.java:594:in
`locateRegion'
        from org/apache/hadoop/hbase/client/HConnectionManager.java:557:in
`locateRegion'
        from org/apache/hadoop/hbase/client/HTable.java:127:in `<init>'
        from org/apache/hadoop/hbase/client/HTable.java:82:in `<init>'
        from sun/reflect/NativeConstructorAccessorImpl.java:-2:in
`newInstance0'
        from sun/reflect/NativeConstructorAccessorImpl.java:39:in
`newInstance'
        from sun/reflect/DelegatingConstructorAccessorImpl.java:27:in
`newInstance'
        from java/lang/reflect/Constructor.java:513:in `newInstance'
        from org/jruby/javasupport/JavaConstructor.java:226:in
`new_instance'
        from org/jruby/java/invokers/ConstructorInvoker.java:100:in `call'
        from org/jruby/java/invokers/ConstructorInvoker.java:180:in `call'
        from org/jruby/RubyClass.java:372:in `finvoke'
        from org/jruby/javasupport/util/RuntimeHelpers.java:376:in `invoke'
        from org/jruby/java/proxies/ConcreteJavaProxy.java:48:in `call'
        from org/jruby/runtime/callsite/CachingCallSite.java:283:in
`cacheAndCall'


Fleming Chiu(邱宏明)
707-6128
y_823910@tsmc.com
週一無肉日吃素救地球(Meat Free Monday Taiwan)


 --------------------------------------------------------------------------- 
                                                         TSMC PROPERTY       
 This email communication (and any attachments) is proprietary information   
 for the sole use of its                                                     
 intended recipient. Any unauthorized review, use or distribution by anyone  
 other than the intended                                                     
 recipient is strictly prohibited.  If you are not the intended recipient,   
 please notify the sender by                                                 
 replying to this email, and then delete this email and any copies of it     
 immediately. Thank you.                                                     
 --------------------------------------------------------------------------- 




Re: How can I drop my table

Posted by Stack <st...@duboce.net>.
Do you only have one replica for those blocks?

Can you pull those files down local or do you get the corrupt message?

./bin/hadoop fs -get FILENAME /tmp/

You could also remove those files and then reopen the regions hosting
those files.

./bin/hadoop fs -rm FILENAME

... then

./bin/hadoop fs -cat /hbase/FRPD_LCRECIPETECH/990451997/.regioninfo

... to get the region name.  Then in hbase shell

hbase> close_region REGIONNAME

To drop table, disable it and then drop it:

hbase> disable TABLENAME
hbase> drop TABLENAME

The above can be flakey and make take a few attempts.

St.Ack

2010/3/24  <y_...@tsmc.com>:
> There is a file CORRUPT in HDFS then hbase can't handle client's request
> well.
> I want to truncate it but there is a NativeException raised.
> How can I handle this problem?
> Thanks.
>
>
>
>
>
>
> Hadoop 0.20.1
> HBase Version 0.20.2, r834515
> ----------------------------------------
>
> /hbase/FRPD_LCRECIPETECH/990451997/MAJOR/1869647744144904264: CORRUPT block
> blk_-2984490753678277755
>
> /hbase/FRPD_LCRECIPETECH/990451997/MAJOR/1869647744144904264: MISSING 1
> blocks of total size 67108864 B..........................
> ......................................Status: CORRUPT
>
>
> NativeException: org.apache.hadoop.hbase.client.RegionOfflineException:
> region offline: FRPD_LCRECIPETECH,,1264688306108
>        from org/apache/hadoop/hbase/client/HConnectionManager.java:658:in
> `locateRegionInMeta'
>        from org/apache/hadoop/hbase/client/HConnectionManager.java:594:in
> `locateRegion'
>        from org/apache/hadoop/hbase/client/HConnectionManager.java:557:in
> `locateRegion'
>        from org/apache/hadoop/hbase/client/HTable.java:127:in `<init>'
>        from org/apache/hadoop/hbase/client/HTable.java:82:in `<init>'
>        from sun/reflect/NativeConstructorAccessorImpl.java:-2:in
> `newInstance0'
>        from sun/reflect/NativeConstructorAccessorImpl.java:39:in
> `newInstance'
>        from sun/reflect/DelegatingConstructorAccessorImpl.java:27:in
> `newInstance'
>        from java/lang/reflect/Constructor.java:513:in `newInstance'
>        from org/jruby/javasupport/JavaConstructor.java:226:in
> `new_instance'
>        from org/jruby/java/invokers/ConstructorInvoker.java:100:in `call'
>        from org/jruby/java/invokers/ConstructorInvoker.java:180:in `call'
>        from org/jruby/RubyClass.java:372:in `finvoke'
>        from org/jruby/javasupport/util/RuntimeHelpers.java:376:in `invoke'
>        from org/jruby/java/proxies/ConcreteJavaProxy.java:48:in `call'
>        from org/jruby/runtime/callsite/CachingCallSite.java:283:in
> `cacheAndCall'
>
>
> Fleming Chiu(邱宏明)
> 707-6128
> y_823910@tsmc.com
> 週一無肉日吃素救地球(Meat Free Monday Taiwan)
>
>
>  ---------------------------------------------------------------------------
>                                                         TSMC PROPERTY
>  This email communication (and any attachments) is proprietary information
>  for the sole use of its
>  intended recipient. Any unauthorized review, use or distribution by anyone
>  other than the intended
>  recipient is strictly prohibited.  If you are not the intended recipient,
>  please notify the sender by
>  replying to this email, and then delete this email and any copies of it
>  immediately. Thank you.
>  ---------------------------------------------------------------------------
>
>
>
>