CDH offline installation is adopted, the database is installed mysql5.6, restart cloudera - SCM - the master node server startup after hang up quickly, always can't find the reason,

CodePudding user response:

See log feel is database connection problem, but don't know where to start, can have a great spirit under the guidance of the

CodePudding user response:

This I also met, check to see if your mysql service service open
Solution: to perform initialization CM5 database command
./scm_prepare_database. Sh mysql cm - hlocalhost - uroot - p - SCM - host localhost SCM SCM SCM
Error message is as follows:


Enter the database password:
JAVA_HOME=/usr/Java/jdk1.7.0 _80
Verifying that we can write to/opt/cm - 5.6.1/etc/cloudera - SCM - server
The 2016-07-07 03:30:55, 447 [main] ERROR com. Cloudera. Enterprise. Dbutil. DbProvisioner - Exception when creating/dropping the database with the user 'root' and the JDBC url "JDBC: mysql://localhost/? useUnicode=true& CharacterEncoding=utf-8 '
Java. SQL. SQLException: Can 't the create database' cm '; The database exists
At com. Mysql. JDBC. SQLError. CreateSQLException (SQLError. Java: 957)
At com. Mysql. JDBC. MysqlIO. CheckErrorPacket (MysqlIO. Java: 3878)
At com. Mysql. JDBC. MysqlIO. CheckErrorPacket (MysqlIO. Java: 3814)
At com. Mysql. JDBC. MysqlIO. SendCommand (MysqlIO. Java: 2478)
At com. Mysql. JDBC. MysqlIO. SqlQueryDirect (MysqlIO. Java: 2625)
At com. Mysql. JDBC. ConnectionImpl. ExecSQL (ConnectionImpl. Java: 2547)
At com. Mysql. JDBC. ConnectionImpl. ExecSQL (ConnectionImpl. Java: 2505)
At com. Mysql. JDBC. StatementImpl. ExecuteInternal (StatementImpl. Java: 840)
At com. Mysql. JDBC. StatementImpl. Execute (StatementImpl. Java: 740)
At com. Cloudera. Enterprise. Dbutil. DbProvisioner. The executeSql (DbProvisioner. Java: 286)
At com. Cloudera. Enterprise. Dbutil. DbProvisioner. DoMain (95) DbProvisioner. Java:
At com. Cloudera. Enterprise. Dbutil. DbProvisioner. Main (110) DbProvisioner. Java:
The 2016-07-07 03:30:55, 453 [main] ERROR com. Cloudera. Enterprise. Dbutil. DbProvisioner - Stack Trace:
Java. SQL. SQLException: Can 't the create database' cm '; The database exists
At com. Mysql. JDBC. SQLError. CreateSQLException (SQLError. Java: 957)

According to the discoveries of the log information, connect the mysql database problems
To perform the service mysql status
See the mysql service service status

Service mysql start

Performed again/opt/cm - 5.6.1/etc/init. D/cloudera - SCM - server start starts the service side,
Performed again/opt/cm - 5.6.1/etc/init. D/cloudera - SCM - agent start starts the client,
Service forever won't die this time