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

   ### 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
   
   ### Background
   When using Apache SeaTunnel with MySQL CDC as the source, parallelism > 1, 
and multiple sinks (e.g., OceanBase and MySQL), an intermittent issue was 
observed where the `Write Count So Far` in the Job Progress Information 
consistently showed 0, despite data being successfully written to the target 
databases.
   
   ### Symptom
   ```
   Job Progress Information 
    *********************************************** 
    Job Id                    : 1064431526965411841 
    Read Count So Far         :             1343176 
    Write Count So Far        :                   0 
    Average Read Count        :              6539/s 
    Average Write Count       :                 0/s 
    Last Statistic Time       : 2026-01-16 14:33:55 
    Current Statistic Time    : 2026-01-16 14:34:55 
    *********************************************** 
   ```
   
   ### Reproducibility
   - Not consistently reproducible
   - Occurs in multi-sink scenarios
   
   ### Json example
   ```json
     SourceReaders JSON: [
     
{"tags":{"jobId":"1065907369516466177","taskGroupId":"3","address":"[localhost]:5801","service":"TaskExecutionService","taskGroupLocation":"TaskGroupLocation{jobId=1065907369516466177,
 pipelineId=1, 
taskGroupId=3}","member":"f8c47ea3-88f6-4cfa-a299-79ab8f4ea9f3","taskName":"SourceSeaTunnelTask","taskID":"1000300000001","pipelineId":"1"},"metric":"SourceReceivedCount","value":0,"timestamp":1768896964860},
     
{"tags":{"jobId":"1065907369516466177","taskGroupId":"2","address":"[localhost]:5801","service":"TaskExecutionService","taskGroupLocation":"TaskGroupLocation{jobId=1065907369516466177,
 pipelineId=1, 
taskGroupId=2}","member":"f8c47ea3-88f6-4cfa-a299-79ab8f4ea9f3","taskName":"SourceSeaTunnelTask","taskID":"1000200000000","pipelineId":"1"},"metric":"SourceReceivedCount","value":232003,"timestamp":1768896964860}]
   
     SinkWriters JSON: [
     
{"tags":{"jobId":"1065907369516466177","taskGroupId":"3","address":"[localhost]:5801","service":"TaskExecutionService","taskGroupLocation":"TaskGroupLocation{jobId=1065907369516466177,
 pipelineId=1, 
taskGroupId=3}","member":"f8c47ea3-88f6-4cfa-a299-79ab8f4ea9f3","taskName":"TransformSeaTunnelTask","taskID":"1000300010001","pipelineId":"1"},"metric":"SinkWriteCount","value":0,"timestamp":1768896964860},
     
{"tags":{"jobId":"1065907369516466177","taskGroupId":"3","address":"[localhost]:5801","service":"TaskExecutionService","taskGroupLocation":"TaskGroupLocation{jobId=1065907369516466177,
 pipelineId=1, 
taskGroupId=3}","member":"f8c47ea3-88f6-4cfa-a299-79ab8f4ea9f3","taskName":"TransformSeaTunnelTask","taskID":"1000300020001","pipelineId":"1"},"metric":"SinkWriteCount","value":0,"timestamp":1768896964860},
     
{"tags":{"jobId":"1065907369516466177","taskGroupId":"2","address":"[localhost]:5801","service":"TaskExecutionService","taskGroupLocation":"TaskGroupLocation{jobId=1065907369516466177,
 pipelineId=1, 
taskGroupId=2}","member":"f8c47ea3-88f6-4cfa-a299-79ab8f4ea9f3","taskName":"TransformSeaTunnelTask","taskID":"1000200010000","pipelineId":"1"},"metric":"SinkWriteCount","value":232003,"timestamp":1768896964860},
     
{"tags":{"jobId":"1065907369516466177","taskGroupId":"2","address":"[localhost]:5801","service":"TaskExecutionService","taskGroupLocation":"TaskGroupLocation{jobId=1065907369516466177,
 pipelineId=1, 
taskGroupId=2}","member":"f8c47ea3-88f6-4cfa-a299-79ab8f4ea9f3","taskName":"TransformSeaTunnelTask","taskID":"1000200020000","pipelineId":"1"},"metric":"SinkWriteCount","value":232003,"timestamp":1768896964860}]
   ```
   
   ### SeaTunnel Version
   
   2.3.12
   
   ### SeaTunnel Config
   
   ```conf
   env {
     parallelism = 2
     job.mode = "STREAMING"
     checkpoint.interval = 5000
   }
   source {
     MySQL-CDC {
       url = 
"jdbc:mysql://host:port/database1?useUnicode=true&characterEncoding=UTF-8&rewriteBatchedStatements=true"
       
       username = "username"
       password = "password"
       
       
       table-names = ["database1.table1","database1.table2"]
       
       startup.mode = "latest"
       plugin_output = "test"
     }
   
   }
   transform {
   }
   sink {
   
     Jdbc {
       driver = "com.oceanbase.jdbc.Driver"
       plugin_input = "test"
       
       url = 
"jdbc:oceanbase://host:port/database2?useUnicode=true&characterEncoding=UTF-8&rewriteBatchedStatements=true"
       
       username = "username"
       password = "password"
       compatible_mode = "mysql"
       
       database = "database2"
       table = "${table_name}"
    
       generate_sink_sql = true
     }
     Jdbc {
       driver = "com.mysql.jdbc.Driver"
       plugin_input = "test"
      
       url = 
"jdbc:mysql://host:port/database3?useUnicode=true&characterEncoding=UTF-8&rewriteBatchedStatements=true"
       username = "username"
       password = "password"
       
       database = "database3"
       table = "${table_name}"
       generate_sink_sql = true
     }
   }
   ```
   
   ### Running Command
   
   ```shell
   bash bin/seatunnel.sh --config config/test.cfg -e local
   ```
   
   ### Error Exception
   
   ```log
   This issue is not an exception.
   ```
   
   ### Zeta or Flink or Spark Version
   
   _No response_
   
   ### Java or Scala Version
   
   _No response_
   
   ### Screenshots
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [x] 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