com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean: Tables have unsuppo
2022-10-08 17:22:18
257
{{single.collect_count}}

问题描述:

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


 

回帖
全部回帖({{commentCount}})
{{item.user.nickname}} {{item.user.group_title}} {{item.friend_time}}
{{item.content}}
{{item.comment_content_show ? '取消' : '回复'}} 删除
回帖
{{reply.user.nickname}} {{reply.user.group_title}} {{reply.friend_time}}
{{reply.content}}
{{reply.comment_content_show ? '取消' : '回复'}} 删除
回帖
收起
没有更多啦~
{{commentLoading ? '加载中...' : '查看更多评论'}}