Givo29 opened a new issue, #3166: URL: https://github.com/apache/hop/issues/3166
### Apache Hop version? 2.3.0 - 2.5.0 ### Java version? Openjdk version 11.0.17 ### Operating system Linux ### What happened? Mysql database version: 8.0.21 Mysql jar version: mysql-connector-java-8.0.21.jar Intermittently, our pipelines will fail with mysql errors when loading data into mysql with the following error message, this is the case for multiple versions of apache hop and multiple versions of the mysql connector. The pipeline will work correctly 8/10 times, but 2/10 it will fail and stop our data from syncing correctly. This bug is also preventing us from moving more data jobs to Apache Hop. ``` 2023/08/22 10:06:45 - copy_ad_mstr.0 - Connected to database [dbw_warehouse] (commit=1000) 2023/08/22 10:07:00 - copy_ad_mstr.0 - ERROR: Because of an error, this transform can't continue: 2023/08/22 10:07:00 - copy_ad_mstr.0 - ERROR: org.apache.hop.core.exception.HopException: 2023/08/22 10:07:00 - copy_ad_mstr.0 - Error batch inserting rows into table [copy_ad_mstr]. 2023/08/22 10:07:00 - copy_ad_mstr.0 - Errors encountered (first 10): 2023/08/22 10:07:00 - copy_ad_mstr.0 - 2023/08/22 10:07:00 - copy_ad_mstr.0 - 2023/08/22 10:07:00 - copy_ad_mstr.0 - Error updating batch 2023/08/22 10:07:00 - copy_ad_mstr.0 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''EXT' at line 1 2023/08/22 10:07:00 - copy_ad_mstr.0 - 2023/08/22 10:07:00 - copy_ad_mstr.0 - 2023/08/22 10:07:00 - copy_ad_mstr.0 - at org.apache.hop.pipeline.transforms.tableoutput.TableOutput.writeToTable(TableOutput.java:340) 2023/08/22 10:07:00 - copy_ad_mstr.0 - at org.apache.hop.pipeline.transforms.tableoutput.TableOutput.processRow(TableOutput.java:117) 2023/08/22 10:07:00 - copy_ad_mstr.0 - at org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:55) 2023/08/22 10:07:00 - copy_ad_mstr.0 - at java.base/java.lang.Thread.run(Thread.java:829) 2023/08/22 10:07:00 - copy_ad_mstr.0 - Caused by: org.apache.hop.core.exception.HopDatabaseBatchException: 2023/08/22 10:07:00 - copy_ad_mstr.0 - Error updating batch 2023/08/22 10:07:00 - copy_ad_mstr.0 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''EXT' at line 1 2023/08/22 10:07:00 - copy_ad_mstr.0 - 2023/08/22 10:07:00 - copy_ad_mstr.0 - at org.apache.hop.core.database.Database.createHopDatabaseBatchException(Database.java:1296) 2023/08/22 10:07:00 - copy_ad_mstr.0 - at org.apache.hop.pipeline.transforms.tableoutput.TableOutput.writeToTable(TableOutput.java:285) 2023/08/22 10:07:00 - copy_ad_mstr.0 - ... 3 more 2023/08/22 10:07:00 - copy_ad_mstr.0 - Caused by: java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''EXT' at line 1 2023/08/22 10:07:00 - copy_ad_mstr.0 - at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2023/08/22 10:07:00 - copy_ad_mstr.0 - at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 2023/08/22 10:07:00 - copy_ad_mstr.0 - at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 2023/08/22 10:07:00 - copy_ad_mstr.0 - at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) 2023/08/22 10:07:00 - copy_ad_mstr.0 - at com.mysql.cj.util.Util.handleNewInstance(Util.java:192) 2023/08/22 10:07:00 - copy_ad_mstr.0 - at com.mysql.cj.util.Util.getInstance(Util.java:167) 2023/08/22 10:07:00 - copy_ad_mstr.0 - at com.mysql.cj.util.Util.getInstance(Util.java:174) 2023/08/22 10:07:00 - copy_ad_mstr.0 - at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224) 2023/08/22 10:07:00 - copy_ad_mstr.0 - at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:853) 2023/08/22 10:07:00 - copy_ad_mstr.0 - at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:435) 2023/08/22 10:07:00 - copy_ad_mstr.0 - at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:796) 2023/08/22 10:07:00 - copy_ad_mstr.0 - at org.apache.hop.pipeline.transforms.tableoutput.TableOutput.writeToTable(TableOutput.java:281) 2023/08/22 10:07:00 - copy_ad_mstr.0 - ... 3 more 2023/08/22 10:07:00 - copy_ad_mstr.0 - Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''EXT' at line 1 2023/08/22 10:07:00 - copy_ad_mstr.0 - at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) 2023/08/22 10:07:00 - copy_ad_mstr.0 - at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) 2023/08/22 10:07:00 - copy_ad_mstr.0 - at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) 2023/08/22 10:07:00 - copy_ad_mstr.0 - at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) 2023/08/22 10:07:00 - copy_ad_mstr.0 - at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092) 2023/08/22 10:07:00 - copy_ad_mstr.0 - at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:832) 2023/08/22 10:07:00 - copy_ad_mstr.0 - ... 6 more ``` ### Issue Priority Priority: 2 ### Issue Component Component: Hop Gui, Component: Hop Run -- 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]
