ClamJohn opened a new issue, #5806:
URL: https://github.com/apache/seatunnel/issues/5806

   ### 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
   
   jdbc数据同步任务卡住&数据量与日志打印不符
   <img width="1545" alt="image" 
src="https://github.com/apache/seatunnel/assets/53480226/8c60ebc0-0797-4d2f-b158-9281f3df8117";>
   
   
   ### SeaTunnel Version
   
   2.3.3
   
   ### SeaTunnel Config
   
   ```conf
   {
            "env" : {
                "execution.parallelism" : 10,
                "job.mode" : "BATCH",
                "job.name" : "ads.ads_tag_user_pregnant_d_20231106",
                "checkpoint.interval" : 60000
            },
            "source" : [
                {
                    "password" : "xxx",
                    "driver" : "com.mysql.cj.jdbc.Driver",
                    "query" : " select id ,day_time ,user_id ,data_source 
,replace(replace(result,'\n',''),'\r','') result ,pregnant_date 
,report_pregnant_w ,pregnant_w ,pregnant_period ,pregnant_flag 
,pregnant_prepare_flag ,create_time ,update_time from 
shujuzhongxin.ads_user_pregnant_d",
                    "connection_check_timeout_sec" : 100,
                    "fetch_size" : 10000,
                    "partition_column" : "id",
                    "plugin_name" : "Jdbc",
                    "user" : "shujuzhongxin",
                    "url" : 
"jdbc:mysql://10.20.50.29:3306?serverTimezone=GMT%2b8",
                    "partition_num" : 10
                }
            ],
            "transform" : [],
            "sink" : [
                {
                    "password" : "xxx",
                    "database" : "ads",
                    "primary_keys" : [
                        "id"
                    ],
                    "batch_size" : 10000,
                    "driver" : "com.mysql.cj.jdbc.Driver",
                    "max_retries" : 1,
                    "connection_check_timeout_sec" : 100,
                    "generate_sink_sql" : true,
                    "plugin_name" : "Jdbc",
                    "user" : "DolphinScheduler",
                    "url" : 
"jdbc:mysql://xxx:3306?serverTimezone=GMT%2b8&rewriteBatchedStatements=true",
                    "table" : "ads_tag_user_pregnant_d"
                }
            ]
        }
   ```
   
   
   ### Running Command
   
   ```shell
   ${SEATUNNEL_HOME}/seatunnel.sh --config ${st_config_file}
   ```
   
   
   ### Error Exception
   
   ```log
   无异常,任务卡住
   ```
   
   
   ### Zeta or Flink or Spark Version
   
   _No response_
   
   ### Java or Scala Version
   
   _No response_
   
   ### 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]

Reply via email to