You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/12/31 09:31:52 UTC

[GitHub] [shardingsphere] ReyYang commented on issue #14429: binlog_row_image option should not be required for all MySQL versions in scaling, verify it and improve it if necessary

ReyYang commented on issue #14429:
URL: https://github.com/apache/shardingsphere/issues/14429#issuecomment-1003322881


   Hi,Can I take this?
   The problems found after testing are as follows:
   - Exception stack
   ``` java
   org.apache.shardingsphere.data.pipeline.core.exception.PipelineJobPrepareFailedException: Source data source check variables failed.
   	at org.apache.shardingsphere.data.pipeline.mysql.check.datasource.MySQLDataSourceChecker.checkVariable(MySQLDataSourceChecker.java:96)
   	at org.apache.shardingsphere.data.pipeline.mysql.check.datasource.MySQLDataSourceChecker.checkVariable(MySQLDataSourceChecker.java:86)
   	at org.apache.shardingsphere.data.pipeline.scenario.rulealtered.RuleAlteredJobPreparer.checkSourceDataSources(RuleAlteredJobPreparer.java:104)
   	at org.apache.shardingsphere.data.pipeline.scenario.rulealtered.RuleAlteredJobPreparer.checkDataSource(RuleAlteredJobPreparer.java:93)
   	at org.apache.shardingsphere.data.pipeline.scenario.rulealtered.RuleAlteredJobPreparer.prepare(RuleAlteredJobPreparer.java:63)
   	at org.apache.shardingsphere.data.pipeline.scenario.rulealtered.RuleAlteredJob.execute(RuleAlteredJob.java:48)
   	at org.apache.shardingsphere.elasticjob.simple.executor.SimpleJobExecutor.process(SimpleJobExecutor.java:33)
   	at org.apache.shardingsphere.elasticjob.simple.executor.SimpleJobExecutor.process(SimpleJobExecutor.java:29)
   	at org.apache.shardingsphere.elasticjob.executor.ElasticJobExecutor.process(ElasticJobExecutor.java:172)
   	at org.apache.shardingsphere.elasticjob.executor.ElasticJobExecutor.lambda$process$0(ElasticJobExecutor.java:153)
   	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
   	at com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:125)
   	at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:69)
   	at com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:78)
   	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
   	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
   	at java.lang.Thread.run(Thread.java:748)
   Caused by: java.sql.SQLException: Illegal operation on empty result set.
   	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.checkRowPos(ResultSetImpl.java:790)
   	at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5213)
   	at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5136)
   	at com.zaxxer.hikari.pool.HikariProxyResultSet.getString(HikariProxyResultSet.java)
   	at org.apache.shardingsphere.data.pipeline.mysql.check.datasource.MySQLDataSourceChecker.checkVariable(MySQLDataSourceChecker.java:105)
   	at org.apache.shardingsphere.data.pipeline.mysql.check.datasource.MySQLDataSourceChecker.checkVariable(MySQLDataSourceChecker.java:93)
   	... 16 common frames omitted
   ```
   - Cause Analysis
   In MySQL5.5, the "BINLOG_ROW_IMAGE" variable does not exist, so an exception is thrown in `resultSet.next()`


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

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