mycat集成mysql读写分离异常,标准查询sql,大量跑批偶尔出现ResultSet is from UPDATE. No Data,导致整个跑批过程报废,直连mysql没问题

ERROR ***** org.springframework.dao.TransientDataAccessResourceException: StatementCallback; SQL [SELECT b.ds AS ds, b.template_sql AS 'sql', a.status,template_id, a.create_user, a.file_path, a.condition, a.create_time, b.can_use_condition, a.apply_id, b.ds FROM export_file_apply AS a LEFT JOIN export_file_template AS b ON a.exp_template_id = b.template_id WHERE a.status in('S', 'F') AND notify_status IN ('W')]; ResultSet is from UPDATE. No Data.; nested exception is java.sql.SQLException: ResultSet is from UPDATE. No Data. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:110) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:388) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:452) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:462) at org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:490) at com.dtroad.ieasweb.excel.ExcelService.getApplyInfo(ExcelService.java:88) at com.dtroad.ieasweb.common.run.Runnable_notifyDownloadExcel.run(Runnable_notifyDownloadExcel.java:35) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: ResultSet is from UPDATE. No Data. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861) at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:6292) at com.alibaba.druid.pool.DruidPooledResultSet.next(DruidPooledResultSet.java:69) at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:93) a

MyCATApache / Mycat-Server

mycat集成mysql读写分离异常,标准查询sql,大量跑批偶尔出现ResultSet is from UPDATE. No Data,导致整个跑批过程报废,直连mysql没问题 #2568