Unable to test database connection for host not in good state.

CDH Add Cloudera Management Service Service失败，连接不上数据库

mysql> show processlist;
+----+------+------------+------+---------+------+----------+------------------+
| Id | User | Host       | db   | Command | Time | State    | Info             |
+----+------+------------+------+---------+------+----------+------------------+
|  4 | scm  | cdh1:50588 | scm  | Sleep   |  230 |          | NULL             |
|  5 | scm  | cdh1:50587 | scm  | Sleep   |  230 |          | NULL             |
|  6 | scm  | cdh1:50589 | scm  | Sleep   |  230 |          | NULL             |
|  7 | scm  | cdh1:50590 | scm  | Sleep   |    0 |          | NULL             |
|  8 | scm  | cdh1:50591 | scm  | Sleep   |  163 |          | NULL             |
|  9 | cdh  | localhost  | am   | Query   |    0 | starting | show processlist |
+----+------+------------+------+---------+------+----------+------------------+
6 rows in set (0.00 sec)


cloudera-scm-server.log日志
2017-06-26 18:00:00,073 INFO com.cloudera.cmf.scheduler-1_Worker-1:com.cloudera.cmf.scheduler.CommandDispatcherJob: Skipping scheduled command 'GlobalPoolsRefresh' since it is a noop.
2017-06-26 18:02:31,917 INFO 309033449@scm-web-7:com.cloudera.cmf.model.DbCommand: Command null(RepMgrTestDatabaseConnection) has completed. finalstate:FINISHED, success:false, msg:Unable to test database connection for host not in good state.

1)看下 CM agent的日志默认路径是 /var/log/cloudera-scm-agent/cloudera-scm-agent.log
2) 还有CM server的日志，默认路径是 /var/log/cloudera-scm-server/cloudera-scm-server.log