Exception while executing batch statements

[arun4a]

Exception occured while saving into Tracker table, rolling back any changes
java.sql.BatchUpdateException: Error reading results -1
at org.mariadb.jdbc.MariaDbStatement.executeBatchExceptionEpilogue(MariaDbStatement.java:275) ~[mariadb-java-client-2.2.6.jar:?]
at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeBatch(MariaDbPreparedStatementClient.java:286) ~[mariadb-java-client-2.2.6.jar:?]
at com.highradius.scheduler.launcher.AutoScaleSchedulerLauncher.main(AutoScaleSchedulerLauncher.java:80) [classes/:?]
Caused by: java.sql.SQLException: Error reading results -1
at org.mariadb.jdbc.internal.protocol.AbstractMultiSend.executeBatchStandard(AbstractMultiSend.java:291) ~[mariadb-java-client-2.2.6.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractMultiSend.executeBatch(AbstractMultiSend.java:192) ~[mariadb-java-client-2.2.6.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchMulti(AbstractQueryProtocol.java:594) ~[mariadb-java-client-2.2.6.jar:?]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchClient(AbstractQueryProtocol.java:354) ~[mariadb-java-client-2.2.6.jar:?]
at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternalBatch(MariaDbPreparedStatementClient.java:346) ~[mariadb-java-client-2.2.6.jar:?]
at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeBatch(MariaDbPreparedStatementClient.java:280) ~[mariadb-java-client-2.2.6.jar:?]
... 5 more
[22-05-24 12:20:02:951 IST] [main] [] [ERROR] [utils.ScheduledAgentTrackerUtil:125] - Error setting autoCommit back to true
java.sql.SQLNonTransientConnectionException: (conn=636921) Connection is closed

[arun4a]

we had a proxysql setup with ProxySQL version 2.4.0-3-g6fc9c45, codename Truls version

previously we raised same issue #3819

@mirostauder and @renecannao suggested upgrading the version.

After upgrading also we are getting same issue

[arun4a]

@renecannao and @mirostauder can you please help here once this resolved we need to implement proxysql in our applications

[arun4a]

HI @renecannao ,
Can you please help here.

[arun4a]

Anyone please help here and let me know if any more details required

[arun4a]

** Caused by: java.sql.SQLNonTransientConnectionException: (conn=2110974) Broken pipe (Write failed)

HHH000315: Exception executing batch [java.sql.BatchUpdateException: (conn=2110974) Broken pipe (Write failed)], SQL:
[26-05-22 06:35:06,484 CDT] ramScheduler_Worker-8 70574 ERROR spi.SqlExceptionHelper:131 - (conn=2110974) Broken pipe (Write failed)
[26-05-22 06:35:06,485 CDT] ramScheduler_Worker-8 70574 ERROR internal.ExceptionMapperStandardImpl:39 - HHH000346: Error during managed flush [org.hibernate.exception.JDBCConnectionException: could not execute batch]
[26-05-22 06:35:06,487 CDT] ramScheduler_Worker-8 70574 ERROR fieldmapping.DmsCommonHelper:609 - Failed to save current batch. Going to retry with chunkSize = 1 **

[arun4a]

@renecannao and @mirostauder what is the global variable name in proxysql to increase the buffer size same as net_buffer_length in mariadb.

[arun4a]

Can I expect any response here?

[renecannao]

Hi @arun4a , probably #3880 is relevant to you

[arun4a]

Hi @renecannao ,
Thank you for the response.
I have gone through the comments, but I don't see any solution for the issue. In my code, changes will not accept by management.
Is the anything we can configure from proxysql side to work batch statements without any issue,