Apache DolphinScheduler 报错 : java.sql.SQLException: HOUR_OF_DAY: 2 -＞ 3

报错信息

org.springframework.dao.TransientDataAccessResourceException: Error attempting to get column 'update_time' from result set.  Cause: java.sql.SQLException: HOUR_OF_DAY: 2 -> 3
; HOUR_OF_DAY: 2 -> 3; nested exception is java.sql.SQLException: HOUR_OF_DAY: 2 -> 3
	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:110)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)

处理办法

首先 排除mysql驱动版本的问题
将mysql驱动版本从8.X降至5.X后启动失败…

有大佬提出mysql时间时区不对,转换失败.尝试一下
将DolphinScheduler 各个模块的配置文件中 mysql链接修改

cd /apache-dolphinscheduler-3.1.5-bin/master-server/conf
vim dolphinscheduler_env.sh
export SPRING_DATASOURCE_URL= # 添加serverTimezone=Asia/Shanghai
export SPRING_DATASOURCE_URL="jdbc:mysql://x.x.x.x:3306/dolphinscheduler?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai"

因不知具体是哪个文件生效,遂将涉及的文件都修改了

/apache-dolphinscheduler-3.1.5-bin/master-server/conf/dolphinscheduler_env.sh
/apache-dolphinscheduler-3.1.5-bin/alert-server/conf/dolphinscheduler_env.sh
/apache-dolphinscheduler-3.1.5-bin/api-server/conf/dolphinscheduler_env.sh
/apache-dolphinscheduler-3.1.5-bin/worker-server/conf/dolphinscheduler_env.sh

重启,成功! ! ! 记录一下下