This is an automated email from the ASF dual-hosted git repository.
wenjun pushed a commit to branch dev
in repository https://gitbox.apache.org/repos/asf/dolphinscheduler.git
The following commit(s) were added to refs/heads/dev by this push:
new f4646cef33 [Doc-17574] Add timezone configuration notice for MySQL
datasource (#17598)
f4646cef33 is described below
commit f4646cef338d81cc21536be0409cd67e42d00d0b
Author: qjin <[email protected]>
AuthorDate: Fri Oct 24 20:53:31 2025 +0800
[Doc-17574] Add timezone configuration notice for MySQL datasource (#17598)
---
docs/docs/en/guide/installation/datasource-setting.md | 8 +++++++-
docs/docs/zh/guide/installation/datasource-setting.md | 8 +++++++-
2 files changed, 14 insertions(+), 2 deletions(-)
diff --git a/docs/docs/en/guide/installation/datasource-setting.md
b/docs/docs/en/guide/installation/datasource-setting.md
index 106dfd77f4..ad60970aa4 100644
--- a/docs/docs/en/guide/installation/datasource-setting.md
+++ b/docs/docs/en/guide/installation/datasource-setting.md
@@ -75,13 +75,19 @@ pg_ctl reload
Then, set the database configurations by exporting the following environment
variables, change {user} and {password} to what you set in the previous step.
+> **⚠️ Timezone Configuration Notice**
+>
+> Avoid using ambiguous timezone identifiers like `CST`, which may cause
scheduling time errors.
+>
+> Use explicit timezone like: `serverTimezone=Asia/Shanghai`
+
For MySQL:
```shell
# for mysql
export DATABASE=${DATABASE:-mysql}
export SPRING_PROFILES_ACTIVE=${DATABASE}
-export
SPRING_DATASOURCE_URL="jdbc:mysql://127.0.0.1:3306/dolphinscheduler?useUnicode=true&characterEncoding=UTF-8&useSSL=false"
+export
SPRING_DATASOURCE_URL="jdbc:mysql://127.0.0.1:3306/dolphinscheduler?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone={your_timezone}"
export SPRING_DATASOURCE_USERNAME={user}
export SPRING_DATASOURCE_PASSWORD={password}
```
diff --git a/docs/docs/zh/guide/installation/datasource-setting.md
b/docs/docs/zh/guide/installation/datasource-setting.md
index 36d2d7ba18..0feba41aac 100644
--- a/docs/docs/zh/guide/installation/datasource-setting.md
+++ b/docs/docs/zh/guide/installation/datasource-setting.md
@@ -74,13 +74,19 @@ pg_ctl reload
然后设置以下环境变量，将username和password改成你在上一步中设置的用户名{user}和密码{password}
+> **⚠️ 时区配置提醒**
+>
+> 避免使用 `CST` 等模糊时区标识符，可能造成调度时间错误。
+>
+> 推荐使用明确的时区，如：`serverTimezone=Asia/Shanghai`
+
对于 MySQL：
```shell
# for mysql
export DATABASE=${DATABASE:-mysql}
export SPRING_PROFILES_ACTIVE=${DATABASE}
-export
SPRING_DATASOURCE_URL="jdbc:mysql://127.0.0.1:3306/dolphinscheduler?useUnicode=true&characterEncoding=UTF-8&useSSL=false"
+export
SPRING_DATASOURCE_URL="jdbc:mysql://127.0.0.1:3306/dolphinscheduler?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone={your_timezone}"
export SPRING_DATASOURCE_USERNAME={user}
export SPRING_DATASOURCE_PASSWORD={password}
```
