yinshaohua77 opened a new issue, #5016: URL: https://github.com/apache/seatunnel/issues/5016
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22bug%22) and found no similar issues. ### What happened env { # You can set flink configuration here execution.parallelism = 4 job.mode = "STREAMING" #checkpoint.interval = 20000 #execution.checkpoint.interval = 10000 #execution.checkpoint.data-uri = "file:///opt/soft/seatunnel/defaultfs" } source { MySQL-CDC { parallelism = 1 server-id = 5656-5670 username = "xxxxx" password = "xxxxx" table-names = ["xxxxx.xxxxx] base-url = "jdbc:mysql://xxxxxx:3306/xxxxxx" startup.mode = "initial" #server-time-zone = "UTC+8" } } sink { jdbc { url = "jdbc:oracle:thin:@xxxxx:1521/dbcenter" driver = "oracle.jdbc.OracleDriver" user = "xxxx" password = "xxxx" connection_check_timeout_sec = 90 max_retries = 10 table = jxxxxx database = xxxxx generate_sink_sql = true primary_keys = ["account","group_id"] } } 对于mysql cdc timestamp 字段，无论是加不加server-time-zone = "UTC+8"，或者jdbc串里面加不加serverTimezone 的情况，都会出现全量阶段和增量阶段timestamp字段类型同步问题，相差时区的时间 ### SeaTunnel Version 2.3.2 ### SeaTunnel Config ```conf env { # You can set flink configuration here execution.parallelism = 4 job.mode = "STREAMING" #checkpoint.interval = 20000 #execution.checkpoint.interval = 10000 #execution.checkpoint.data-uri = "file:///opt/soft/seatunnel/defaultfs" } source { MySQL-CDC { parallelism = 1 server-id = 5656-5670 username = "xxxxx" password = "xxxxx" table-names = ["xxxxx.xxxxx] base-url = "jdbc:mysql://xxxxxx:3306/xxxxxx" startup.mode = "initial" #server-time-zone = "UTC+8" } } sink { jdbc { url = "jdbc:oracle:thin:@xxxxx:1521/dbcenter" driver = "oracle.jdbc.OracleDriver" user = "xxxx" password = "xxxx" connection_check_timeout_sec = 90 max_retries = 10 table = jxxxxx database = xxxxx generate_sink_sql = true primary_keys = ["account","group_id"] } } ``` ### Running Command ```shell zeta engine ``` ### Error Exception ```log none ``` ### Flink or Spark Version _No response_ ### Java or Scala Version java 8 ### Screenshots _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
