[
https://issues.apache.org/jira/browse/FLINK-35408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Xiao Huang updated FLINK-35408:
-------------------------------
Description:
Now, MySQL CDC connector will retrieve the offset seconds between the
configured timezone and UTC by executing the SQL statement below, and then
compare it with the configured timezone.
{code:java}
SELECT TIME_TO_SEC(TIMEDIFF(NOW(), UTC_TIMESTAMP())) {code}
For some MySQL instances, the validating for time-zone is too strict. We can
add 30min tolerance value.
was:
Now, MySQL CDC connector will retrieve the number of seconds the
database-configured timezone is offset from UTC by executing SQL statement
below, and then compare it with the configured timezone.
{code:java}
SELECT TIME_TO_SEC(TIMEDIFF(NOW(), UTC_TIMESTAMP())) {code}
For some MySQL instances, the validating for time-zone is too strict. We can
add 30min tolerance value.
> Add 30 min tolerance value when validating the time-zone setting
> ----------------------------------------------------------------
>
> Key: FLINK-35408
> URL: https://issues.apache.org/jira/browse/FLINK-35408
> Project: Flink
> Issue Type: Improvement
> Components: Flink CDC
> Reporter: Xiao Huang
> Priority: Minor
> Labels: pull-request-available
>
> Now, MySQL CDC connector will retrieve the offset seconds between the
> configured timezone and UTC by executing the SQL statement below, and then
> compare it with the configured timezone.
> {code:java}
> SELECT TIME_TO_SEC(TIMEDIFF(NOW(), UTC_TIMESTAMP())) {code}
> For some MySQL instances, the validating for time-zone is too strict. We can
> add 30min tolerance value.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
