[I] [Bug] [Clickhouse to localfile] export Data rows error，need 1000,000 but actual 2000,000 [seatunnel]

[via GitHub]

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

   ### 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
   
   
![Image](https://github.com/user-attachments/assets/e3153719-e6ee-44f5-8eda-613f152d95d7)
   
   
![Image](https://github.com/user-attachments/assets/cff2a3cf-25e6-4115-a3a9-0e7814463846)
   
   
![Image](https://github.com/user-attachments/assets/5e4e778c-6195-472b-af42-3f8373ff3440)
   
   
![Image](https://github.com/user-attachments/assets/215f320d-98a0-482e-9490-df5ae5fe6aa8)
   
   I want to export 100 or 1000,000 datas,but actual export 200 or 2000,000，it 
will  happens every 10-20 times
   
   ### SeaTunnel Version
   
   2.3.9
   
   ### SeaTunnel Config
   
   ```conf
   env {
     parallelism = 4
     job.mode = "BATCH"
     checkpoint.interval = 100000
   }
   
   source {
     Clickhouse {
       host = "192.168.0.22:8123"
       database = "default"
       sql = "select * from argus.test limit 100"
       username = "default"
       password = "xxx"
       clickhouse.config = {
         "socket_timeout": "300000"
       }
     }
   }
   
   sink {
   
     LocalFile {
       path = "/home/zhaohy/seatunnel/output/"
       file_format_type = "csv"
       field_delimiter = ","
       row_delimiter = "\n"
     }
   
   }
   ```
   
   ### Running Command
   
   ```shell
   ./bin/seatunnel.sh --config config/argus_clickhouse_2_csv_100.conf -m local
   ```
   
   ### Error Exception
   
   ```log
   no error
   ```
   
   ### Zeta or Flink or Spark Version
   
   zeta
   
   ### Java or Scala Version
   
   1.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: commits-unsubscr...@seatunnel.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org