CHD11用二进制安装MySQL遇到Table 'scm.CM_VERSION' doesn't exist

二进制安装MySQL后cloudera-scm-server status启动几秒后就挂掉
/opt/cm-5.11.0/etc/init.d/cloudera-scm-server status
clouderascmserver dead but pid file exists
删除pid重启依旧，查看日志
[root@cdh1 log]# cat /opt/cm-5.11.0/log/cloudera-scm-server/log/cloudera-scm-server.log|grep ERROR
2017-06-17 07:27:55,888 ERROR main:org.hibernate.engine.jdbc.spi.SqlExceptionHelper: Table 'scm.CM_VERSION' doesn't exist

用rpm包安装MySQL就能正常运行

二进制安装mysql导致的这个问题，原因尚不清楚，初始化是一样的

/opt/cm-5.11.0/share/cmf/schema/scm_prepare_database.shmysql -hcdh1 -uroot -p123456 --scm-host cdh1 scm scm scm

yaojiank 发表于 2017-6-17 12:42
楼主为何没用默认设置，原先修改这个原因是什么

我们线上mysql都采用的这种sql_mode,配置my.cnf的时候就顺便拷过来了

2017-06-17 07:28:11,864 ERROR main:com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean: Unable to upgrade schema to latest version.
java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to yo
ur MySQL server version for the right syntax to use near '"default" not null' at line 2

2017-06-17 07:28:11,851 FATAL main:org.hsqldb.cmdline.SqlFile: SQL Error at 'UTF-8' line 3:
"alter table SETTINGS
    add column SYSTEM_IDENTIFIER varchar(255) default "default" not null"
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"default" not null' at line 2
2017-06-17 07:28:11,851 FATAL main:org.hsqldb.cmdline.SqlFile: Rolling back SQL transaction.
2017-06-17 07:28:11,857 ERROR main:com.cloudera.enterprise.dbutil.SqlFileRunner: Exception while executing ddl scripts.

g Cloudera Manager for the first time. Please also ignore any error messages about missing tables. Moving ahead assuming no upgrade: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
2017-06-17 07:27:55,897 INFO main:com.cloudera.enterprise.dbutil.DbUtil: Schema version table doesn't exist.
2017-06-17 07:27:55,909 INFO main:com.cloudera.enterprise.dbutil.DbUtil: Schema version table doesn't exist.
2017-06-17 07:27:55,910 INFO main:com.cloudera.enterprise.dbutil.DbUtil: Current database schema version: 0

lieb 发表于 2017-6-17 11:56
g Cloudera Manager for the first time. Please also ignore any error messages about missing tables. M ...

他们的版本是否一致。

出现错误，是因为这个表scm.CM_VERSION找不到

yaojiank 发表于 2017-6-17 12:08
他们的版本是否一致。

出现错误，是因为这个表scm.CM_VERSION找不到

找到原因了，原来是我的my.cnfsql_mode设置成了sql_mode='ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,PIPES_AS_CONCAT,ANSI_QUOTES'
导致CDH运行sql的时候报错

lieb 发表于 2017-6-17 12:28
找到原因了，原来是我的my.cnfsql_mode设置成了sql_mode='ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO,STR ...

楼主为何没用默认设置，原先修改这个原因是什么