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

Warm Tip: to see the high-definition no-code picture, please open it with your mobile phone and click the picture to enlarge.

1. Problem description

The cloudera-scm-server service failed to start. The log error is as follows:

2017-09-10 10 ERROR main:com.cloudera.enterprise.dbutil.DbUtil: InnoDB engine not found. Show engines reported: [MRG_MYISAM, CSV, MyISAM, MEMORY] 2017-09-10 10 CSV 23 CSV 47268 ERROR main:com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean: InnoDb engine isn't present or enabled. SCM requires InnoDb MySQL db engine.

two。 Problem recurrence

The test ring is CDH5.12.1, and the following is the reproduction step.

Modify the / tmp directory to have permission [root@ip-172-31-6-148 /] # chmod 755 tmp/ [root @ ip-172-31-6-148 /] # lltotal 116drwxr-xr-x. 231 root root 20480 Sep 10 15:48 TMP [root @ ip-172-31-6-148 /] #

two。 Restart the mysql service

[root@ip-172-31-6-148 /] # service mysqld restartStopping mysqld: [OK] Starting mysqld: [OK] [root@ip-172-31-6-148 /] #

3. Start the cloudera-scm-server service

[root@ip-172-31-6-148 /] # service cloudera-scm-server restartStopping cloudera-scm-server: [OK] Starting cloudera-scm-server: [OK] [root@ip-172-31-6-148 /] #

4. Check the startup log and report an error as described in the problem.

3. Solution method

Change the permissions of the / tmp directory to 777 and restart the mysql and cloudera-scm-server services

Modify the / tmp directory to 777 [root@ip-172-31-6-148 /] # chmod 777 tmp/ [ip-172-31-6-148 /] # lltotal 116drwxrwxrwx. 231 root root 20480 Sep 10 15:48 TMP [root @ ip-172-31-6-148 /] #

two。 Restart the msyql service

[root@ip-172-31-6-148 /] # service mysqld restartStopping mysqld: [OK] Starting mysqld: [OK] [root@ip-172-31-6-148 /] #

3. Restart the cloudera-scm-server service

[root@ip-172-31-6-148 /] # service cloudera-scm-server restartStopping cloudera-scm-server: [OK] Starting cloudera-scm-server: [OK] [root@ip-172-31-6-148 /] #

CM starts normally and the problem is resolved.

4. Remarks

InnoDBengines not found appears

Log in to mysql and view the mysql engine with the show engines command

Mysql > show engines +-+ | Engine | Support | Comment | Transactions | XA | Savepoints | +-- -- + | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | | CSV | YES | CSV storage engine | NO | NO | | NO | | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | | InnoDB | YES | Supports transactions | Row-level locking, and foreign keys | YES | | MEMORY | YES | Hash based, stored in memory Useful for temporary tables | NO | +-+ -+-+ 5 rows in set (0.00 sec) mysql >

Note: if InnoDB Engine is not shown, it may be caused by insufficient permissions in the / tmp directory, or it may be that the InnoDB engine is not compiled when the source code is compiled

You can view the plug-ins supported by mysql mysql > showplugins through the showplugins command +-+ | Name | Status | Type | Library | License | +-- -+-+ | binlog | ACTIVE | STORAGE ENGINE | NULL | GPL | partition | ACTIVE | STORAGE ENGINE | NULL | GPL | CSV | ACTIVE | STORAGE ENGINE | NULL | GPL | | MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL | InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL | MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL | MRG_MYISAM | ACTIVE | STORAGE ENGINE | | NULL | GPL | +-+ 7 rows in set (0.00 sec) mysql > |

If you do not have InnoDB, you can install it through the INSTALL command

Use the INSTALL command to install InnoDB

View the mysql plug-in installation directory

Mysql > show variables like 'plugin_dir' +-+-+ | Variable_name | Value | +-+-+ | plugin_dir | / usr/lib64/mysql/plugin | +- -+-+ 1 row in set (0.00 sec)

Check to see if there are ha_innodb*.so files in the linux directory

# cd / usr/lib64/mysql/plugin [root@ip-172-31-6-148plugin] # lltotal 1416lrwxrwxrwx 1 root root 25 Sep 10 15:47 ha_innodb_plugin.so-> ha_innodb_plugin.so.0.0.0lrwxrwxrwx 1 root root 25 Sep 10 15:47 ha_innodb_plugin.so.0-> ha_innodb_plugin.so.0.0.0-rwxr-xr-x 1 root root 1259136 Jan 26 2017 ha_innodb_ plugin.so.0.0.0 [root @ ip-172-31-6-148root] #

Execute the Install command to install the InnoDB engine

Mysql > INSTALL PLUGIN InnoDB SONAME 'ha_innodb_plugin.so';Query OK, 0 rows affected (0.23 sec) mysql >

If you don't have a ha_innodb_plugin.so file, you need to consider recompiling the InnoDB engine.

Drunken whips are famous horses, and teenagers are so pompous! Lingnan Huan Xisha, under the vomiting liquor store! The best friend refuses to let go, the flower of data play!

Warm Tip: to see the high-definition no-code picture, please open it with your mobile phone and click the picture to enlarge.

It is recommended to follow Hadoop practice, the first time, share more Hadoop practical information, welcome to forward and share.

Original article, welcome to reprint, reprint please indicate: reproduced from the official account of Wechat Hadoop

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.