问题描述:
ERROR main:com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean: Tables have unsupported engine type [MyISAM]. InnoDB is required.
1.查看cm服务运行情况:
service cloudera-scm-server status
cloudera-scm-server 已死,但 pid 文件仍存
2. 查看日志
vim /var/log/cloudera-scm-server/cloudera-scm-server.log
ERROR main:com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean: Tables have unsupported engine type [MyISAM]. InnoDB is required.
数据库要求INNODB
3.修改Mysql数据库引擎
# vim /etc/my.cnf
[mysqld]
default-storage-engine=INNODB
#修改后重启
service mysqld restart
4.将Mysql的相关库备份下来(用的Navicat)
5.重新初始化CM库
/usr/share/cmf/schema/scm_prepare_database.sh mysql cm -h127.0.0.1 -uroot -ppasswd --scm-host 127.0.0.1 scm scm scm
6.将Mysql的相关库的数据还原(用的Navicat)
7.重启CM服务
service cloudera-scm-server start