Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

The solution to the error report of deleting table in hbase

2025-01-19 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

When hbase builds a table, if snappy or other compression is not installed, it will hang when the table is created, and the table cannot be deleted, and it will also have an impact on the cluster. The most obvious impact is that it cannot be balanced. The following is the status quo of error reporting and solutions:

For more information, please refer to http://www.itinit.net/thread-1924-1-1.html

Hbase (main): 012ERROR 0 > drop 'T21mm 0513 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. (TableEventHandler.java:70) at org.apache.hadoop.hbase.master.handler.DeleteTableHandler. (DeleteTableHandler.java:42) at org.apache.hadoop.hbase .master.HMaster.deleteTable (HMaster.java:1099) at sun.reflect.NativeMethodAccessorImpl.invoke0 (NativeMethod) 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

Four methods: 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'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report