Failed to Create Tables When the Region is in FAILED_OPEN State

Question

What should I do if I fail to create tables when the region is in FAILED_OPEN state?

Answer

If a network, HDFS, or Active HMaster fault occurs during the creation of tables, some Regions may fail to go online and therefore enter the FAILED_OPEN state. In this case, tables fail to be created.

The tables that fail to be created due to the preceding mentioned issue cannot be repaired. To solve this problem, perform the following operations to delete and re-create the tables:

To do so, perform the following steps:

1. Run the following command on the cluster client to repair the tables:

   hbase hbck -j ${CLIENT_HOME}/HBase/hbase/tools/hbase-hbck2-1.1.0-h0.cbu.mrs.*.jar setTableState <table_name> ENABLED

2. Go to the HBase Shell and run the following commands to clear the table:

   disable '<table_name>'

   drop '<table_name>'

3. Run the table creation command to create the table again.