cqiwencom commented on issue #11746:
URL:
https://github.com/apache/shardingsphere/issues/11746#issuecomment-897342018
> @cqiwencom Can you try the master branch? I used the master branch to test
and the routing results were normal.
>
> ```
> [INFO ] 2021-08-11 11:53:59.301 [ShardingSphere-Command-1]
ShardingSphere-SQL - Logic SQL: select * from actor for update
> [INFO ] 2021-08-11 11:53:59.301 [ShardingSphere-Command-1]
ShardingSphere-SQL - SQLStatement: MySQLSelectStatement(limit=Optional.empty,
lock=Optional[org.apache.shardingsphere.sql.parser.sql.common.segment.dml.predicate.LockSegment@137e13b5],
window=Optional.empty)
> [INFO ] 2021-08-11 11:53:59.301 [ShardingSphere-Command-1]
ShardingSphere-SQL - Actual SQL: write_ds ::: select * from actor for update
> ```
在我的日志文件中没有看到您上面的这种信息。但有如下的报错信息显示在日志中：
[ERROR] 2021-08-12 12:31:20.828 [Connection-3-ThreadExecutor]
o.a.s.p.f.c.CommandExecutorTask - Exception occur:
java.lang.ClassCastException:
org.apache.shardingsphere.sql.parser.sql.common.segment.dml.expr.BinaryOperationExpression
cannot be cast to
org.apache.shardingsphere.sql.parser.sql.common.statement.SQLStatement
at
org.apache.shardingsphere.infra.parser.sql.SQLStatementParserExecutor.parse(SQLStatementParserExecutor.java:47)
at
org.apache.shardingsphere.infra.parser.sql.SQLStatementParserEngine.parse(SQLStatementParserEngine.java:48)
at
org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.parse0(ShardingSphereSQLParserEngine.java:67)
at
org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.parse(ShardingSphereSQLParserEngine.java:56)
at
org.apache.shardingsphere.proxy.backend.text.TextProtocolBackendHandlerFactory.newInstance(TextProtocolBackendHandlerFactory.java:86)
at
org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.<init>(MySQLComQueryPacketExecutor.java:52)
at
org.apache.shardingsphere.proxy.frontend.mysql.command.MySQLCommandExecutorFactory.newInstance(MySQLCommandExecutorFactory.java:73)
at
org.apache.shardingsphere.proxy.frontend.mysql.command.MySQLCommandExecuteEngine.getCommandExecutor(MySQLCommandExecuteEngine.java:60)
at
org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:96)
at
org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:72)
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)
--
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]
