Cloudera Manager op-D log 2018.02.26__cloudera

Source: Internet
Author: User
Tags mysql command line

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)


Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.