温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

hbase删除表报错的解决方法

发布时间:2020-07-23 22:56:16 来源:网络 阅读:2110 作者:jingangyh 栏目:关系型数据库

hbase建表时,如果snappy或者其他压缩没有安装好,在建表时会出现挂起的状态,并且这张表也删除不掉,还会给集群带来影响,最明显的影响是无法平衡,下面是报错的现状,和解决方法:

详细内容请参考:http://www.itinit.net/thread-1924-1-1.html


hbase(main):012:0> drop 'T21_0513_201301_bigtable'
ERROR: org.apache.hadoop.hbase.TableNotDisabledException:
org.apache.hadoop.hbase.TableNotDisabledException: T21_0513_201301_bigtable
at
org.apache.hadoop.hbase.master.HMaster.checkTableModifiable(HMaster.java:1240)
at
org.apache.hadoop.hbase.master.handler.TableEventHandler.<init>(TableEventHandler.java:70)
at
org.apache.hadoop.hbase.master.handler.DeleteTableHandler.<init>(DeleteTableHandler.java:42)
at org.apache.hadoop.hbase.master.HMaster.deleteTable(HMaster.java:1099)
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:1345)
 below is the excerpts from webui:
Regions in TransitionRegionStatebd8d2bf3ef04d0f8d3dac5ca2f612f42T21_0513_201301_bigtable,27100750000000000000000000000000000000000000000000000000000,1358994123350.bd8d2bf3ef04d0f8d3dac5ca2f612f42.
state=PENDING_OPEN, ts=Thu Jan 24 16:58:34 CST 2013 (699s ago),
server=hadoop1,60020,1358993820407


四种方法:
 1.) Shut the HBase cluster - go to ZKcli and rmr /hbase - Start HBase

 2.) Move the table, use hbck -fixMeta -fixAssignments, restart the HBase
 (not a great option if there is data on the table)

3.) Force an assign on the region for the table and see if it clears it
 up
 (Should create a new znode)

 4.) Go to ZK Cli and check /hbase for unassigned regions and other data
 correlating with that region and remove it, then restart HBase

disable 'table_name'
drop 'tab-name'
向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI