Cloudera Manager op-D log 2018.02.26__cloudera

Landing on the Cloudera manager found that a lot of the newspaper space, hand-cheap will be all deleted/tmp directory, and then restart the server and agent, found that the agent can start normally, but the server does not normally start, view log, found the error

2018-02-23 11:13:05,313 ERRORmain:com.cloudera.enterprise.dbutil.DbUtil:InnoDB engine not found. Showengines reported: [Mrg_myisam, CSV, MYISAM, MEMORY]

2018-02-23 11:13:05,313 ERRORmain:com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean:InnoDb engineisn ' t Present or enabled. SCM requires INNODB MySQL DB engine.

Log meaning is not find the MySQL InnoDB this engine, so login MySQL (mysql-u root-p), use the command show engines, the result is as follows:

+------------+---------+-----------------------------------------------------------+--------------+------+----- -------+

| Engine | Support | Comment | Transactions | XA | savepoints|

+------------+---------+-----------------------------------------------------------+--------------+------+----- -------+

| Mrg_myisam | YES | Collection of identical Myisamtables | NO | NO | NO |

| CSV | YES | CSV Storage Engine |no | NO | NO |

| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |

| MEMORY | YES | Hash based, stored inmemory, useful for temporary tables | NO | NO | NO |

+------------+---------+-----------------------------------------------------------+--------------+------+----- -------+

Indeed there is no innodb engine, suspicion is not normal startup, so quit MySQL, restart mysqld service (servicemysqld restart), re-enter MySQL, found that the original look

So

First of all, under MySQL's ' plugin_dir ' there are ha_innodb_plugin.so and ha_innodb.so two files

The path to query ' Plugin_dir ' can be used with the following command

Mysql> Show variables like ' Plugin_dir ';

+---------------+-------------------------+

| variable_name | Value |

+---------------+-------------------------+

| Plugin_dir |/usr/lib64/mysql/plugin |

+---------------+-------------------------+

1 row in Set (0.01 sec)

If not found, there are the following directory files in the MySQL compilation directory (built-in InnoDB and Innodb_plugin)

Storage/innobase/.libs/ha_innodb.so

Storage/innodb_plugin/.libs/ha_innodb_plugin.so

You need to copy them (ha_innodb_plugin.so and ha_innodb.so) to the MySQL plugin directory.

The next step is to install it on the MySQL command line

# MySQL

Welcome to the MySQL Monitor. Commands End With; or \g.

Your MySQL Connection ID is 18

Server Version:5.1.36-log Source Distribution

Type ' help, ' or ' \h ' for help. Type ' \c ' to clear the current inputstatement.

Mysql> show engines;

The next step is to install it on the MySQL command line

# MySQL

Welcome to the MySQL Monitor. Commands End With; or \g.

Your MySQL Connection ID is 18

Server Version:5.1.36-log Source Distribution

Type ' help, ' or ' \h ' for help. Type ' \c ' to clear the current inputstatement.

Mysql> show engines;

+------------+---------+-----------------------------------------------------------+--------------+------+----- -------+

| Engine | Support | Comment | Transactions | XA | savepoints |

+------------+---------+-----------------------------------------------------------+--------------+------+----- -------+

| Mrg_myisam | YES | Collection of identical Myisamtables | NO |no | NO |

| CSV | YES | CSV Storageengine | NO |no | NO |

| MEMORY | YES | Hash based,stored in memory, useful for temporary tables |no | NO | NO |

| MyISAM | DEFAULT | Default engine as of MySQL 3.23 withgreat Performance |no | NO | NO |

+------------+---------+-----------------------------------------------------------+--------------+------+----- -------+

4 rows in Set (0.00 sec)

mysql> INSTALL PLUGIN InnoDB soname ' ha_innodb_plugin.so ';

Query OK, 0 rows affected (0.69 sec)

Mysql> show engines;

5 rows in Set (0.00 sec)

From

4 rows in Set (0.00 sec)

mysql> INSTALL PLUGIN InnoDB soname ' ha_innodb.so ';

Query OK, 0 rows affected (0.69 sec)

Mysql> show engines;

+------------+---------+------------------------------------------------------------+--------------+------+---- --------+

| Engine | Support | Comment | Transactions | XA | savepoints|

+------------+---------+------------------------------------------------------------+--------------+------+---- --------+

| InnoDB | YES | Supports transactions,row-level locking, and foreign keys | YES | YES | YES |

| CSV | YES | CSV Storageengine | NO | NO | NO |

| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |

| Mrg_myisam | YES | Collection of identical Myisamtables | NO | NO | NO |

| MEMORY | YES | Hash based, stored inmemory, useful for temporary tables |no | NO | NO |

+------------+---------+------------------------------------------------------------+--------------+------+---- --------+

5 rows in Set (0.00 sec)