CDH-CDH .InvalidConnectionAttributeException: The server time zone value 'EDT' is unrecognized

最新推荐文章于 2022-10-03 17:05:02 发布

高达一号

最新推荐文章于 2022-10-03 17:05:02 发布

阅读量902

点赞数

分类专栏： CDH

本文链接：https://blog.csdn.net/u010003835/article/details/88974898

版权

CDH 专栏收录该内容

6 篇文章 1 订阅

订阅专栏

今天，我启动了 cdh 遇到了启动不起来的问题，我通过排查日志，定位到了出错的原因。

日志目录： /var/log/cloudera-scm-server

出错的异常日志：

Caused by: com.mysql.cj.core.exceptions.InvalidConnectionAttributeException: The server time zone value 'EDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
	at sun.reflect.GeneratedConstructorAccessor37.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54)
	at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)
	at com.mysql.cj.jdbc.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:118)
	at com.mysql.cj.mysqla.MysqlaSession.configureTimezone(MysqlaSession.java:293)
	at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:2399)
	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:1739)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1596)
	... 12 more

可以看到是时区不能识别的问题，我们通过这篇博客

https://community.cloudera.com/t5/Cloudera-Manager-Installation/Embedded-to-External-mysql-Cloudera-Manager-is-not-starting/td-p/77219

受到了一定的启发，最终定位是系统的时区与 cdh 外部存储的时区不一致导致的。

我们看下本地的系统时区：

[root@cdh-manager cloudera-scm-server]# date
Tue Apr  2 16:25:07 CST 2019

可以看到是 cst 时区，东八区，而 MySQL 默认是 EDT 时区，我们这里修改下 MySQL 的时区，

我们通过修改配置文件的方式，永久修改MySQL 时区。

[root@cdh-manager log]# vim /etc/my.cnf

[mysqld]
#设置时区
default-time-zone = '+8:00'

修改过后，在MySQL 执行如下查询：

mysql> show variables like '%time_zone%';    
+------------------+--------+
| Variable_name    | Value  |
+------------------+--------+
| system_time_zone | EDT    |
| time_zone        | +08:00 |
+------------------+--------+

可以看到时区修改为了CST 时区。最终再次启动 server 服务：

systemctl restart cloudera-scm-server

最终服务启动：

[root@cdh-manager mysql]# netstat -nptl
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
tcp        0      0 192.168.75.133:9000     0.0.0.0:*               LISTEN      11081/python2       
tcp        0      0 192.168.75.133:9868     0.0.0.0:*               LISTEN      18752/java          
tcp        0      0 0.0.0.0:7180            0.0.0.0:*               LISTEN      18158/java          
tcp        0      0 0.0.0.0:5678            0.0.0.0:*               LISTEN      18691/java          
tcp        0      0 192.168.75.133:9870     0.0.0.0:*               LISTEN      18779/java          
tcp        0      0 0.0.0.0:7182            0.0.0.0:*               LISTEN      18158/java          
tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN      1/systemd           
tcp        0      0 0.0.0.0:7184            0.0.0.0:*               LISTEN      18675/java          
tcp        0      0 0.0.0.0:7185            0.0.0.0:*               LISTEN      18675/java          
tcp        0      0 192.168.75.133:8083     0.0.0.0:*               LISTEN      18691/java          
tcp        0      0 0.0.0.0:8084            0.0.0.0:*               LISTEN      18675/java          
tcp        0      0 192.168.75.133:8020     0.0.0.0:*               LISTEN      18779/java          
tcp        0      0 0.0.0.0:10101           0.0.0.0:*               LISTEN      18689/java          
tcp        0      0 192.168.122.1:53        0.0.0.0:*               LISTEN      10295/dnsmasq       
tcp        0      0 127.0.0.1:7190          0.0.0.0:*               LISTEN      21246/python2       
tcp        0      0 192.168.75.133:8022     0.0.0.0:*               LISTEN      18779/java          
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      9700/sshd           
tcp        0      0 0.0.0.0:7191            0.0.0.0:*               LISTEN      21246/python2       
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN      9695/cupsd          
tcp        0      0 192.168.75.133:8088     0.0.0.0:*               LISTEN      18617/java          
tcp        0      0 127.0.0.1:19001         0.0.0.0:*               LISTEN      9703/python2        
tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN      10260/master        
tcp        0      0 0.0.0.0:9083            0.0.0.0:*               LISTEN      18628/java          
tcp        0      0 192.168.75.133:8030     0.0.0.0:*               LISTEN      18617/java          
tcp        0      0 192.168.75.133:8031     0.0.0.0:*               LISTEN      18617/java          
tcp        0      0 192.168.75.133:8032     0.0.0.0:*               LISTEN      18617/java          
tcp        0      0 192.168.75.133:8033     0.0.0.0:*               LISTEN      18617/java          
tcp6       0      0 127.0.0.1:46471         :::*                    LISTEN      18764/java          
tcp6       0      0 :::24042                :::*                    LISTEN      18764/java          
tcp6       0      0 :::3306                 :::*                    LISTEN      18060/mysqld        
tcp6       0      0 :::111                  :::*                    LISTEN      1/systemd           
tcp6       0      0 127.0.0.1:9393          :::*                    LISTEN      18764/java          
tcp6       0      0 :::22                   :::*                    LISTEN      9700/sshd           
tcp6       0      0 :::7191                 :::*                    LISTEN      21246/python2       
tcp6       0      0 ::1:631                 :::*                    LISTEN      9695/cupsd          
tcp6       0      0 ::1:25                  :::*                    LISTEN      10260/master        
tcp6       0      0 192.168.75.133:9092     :::*                    LISTEN      18764/java          
tcp6       0      0 :::42468                :::*                    LISTEN      18764/java          
You have new mail in /var/spool/mail/root