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