shannxisj opened a new issue, #4789:
URL: https://github.com/apache/incubator-seatunnel/issues/4789

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/incubator-seatunnel/issues?q=is%3Aissue+label%3A%22bug%22)
 and found no similar issues.
   
   
   ### What happened
   
   I had the same problem, the version is the same as his, but I added 
rewriteBatchStatements=true in the url, which did not solve it
   [issues_4658](https://github.com/apache/incubator-seatunnel/issues/4658)
   
   
   
   ### SeaTunnel Version
   
   apache-seatunnel-incubating-2.3.1
   
   ### SeaTunnel Config
   
   ```conf
   env {
   job.mode = "BATCH",
   execution.parallelism = 10
   }
   source {
   Jdbc {
   url = "jdbc:mysql://192.168.0.4:3307/sql?rewriteBatchStatements=true"
   driver = "com.mysql.cj.jdbc.Driver"
   user = "root"
   password = "root"
   query = "select * from test1"
   }
   }
   
   sink {
   Jdbc {
   url = "jdbc:mysql://192.168.0.4:3307/sql?rewriteBatchStatements=true"
   driver = "com.mysql.cj.jdbc.Driver"
   user = "root"
   password = "root"
   query = "insert into test1_copy2(brand,stt,edt) values(?,?,?)"
   }
   }
   ```
   
   
   ### Running Command
   
   ```shell
   Job Progress Information
   seatunnel.sh --config env.config -e local
   ```
   
   
   ### Error Exception
   
   ```log
   Job Id : 711925978242220033
   Read Count So Far : 6048
   Write Count So Far : 3999
   Average Read Count : 100/s
   Average Write Count : 66/s
   Last Statistic Time : 2023-05-19 20:59:42
   Current Statistic Time : 2023-05-19 21:00:42
   
   ***********************************************
              Job Progress Information
   ***********************************************
   Job Id                    :  711925978242220033
   Read Count So Far         :                9048
   Write Count So Far        :                6999
   Average Read Count        :                50/s
   Average Write Count       :                50/s
   Last Statistic Time       : 2023-05-19 21:00:42
   Current Statistic Time    : 2023-05-19 21:01:42
   ***********************************************
   ```
   
   
   ### Flink or Spark Version
   
   _No response_
   
   ### Java or Scala Version
   
   1.8
   
   ### 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