llooper-dev opened a new issue #10384:
URL: https://github.com/apache/shardingsphere/issues/10384
aused by: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.lang.ClassCastException:
org.apache.shardingsphere.sql.parser.sql.segment.dml.expr.simple.ParameterMarkerExpressionSegment
cannot be cast to
org.apache.shardingsphere.sql.parser.sql.segment.dml.expr.simple.LiteralExpressionSegment
### The error may exist in com/inveno/rrlike/mapper/CommentUserMapper.java
(best guess)
### The error may involve
com.inveno.rrlike.mapper.CommentUserMapper.selectByUgcIdWithLessThanScore-Inline
### The error occurred while setting parameters
### SQL: SELECT *,? AS sortType,? AS loginUserId,5 AS childLimit FROM
t_comment_user t WHERE t.is_delete=0 and t.ugc_id=? and t.root_id=0 and
t.hot_score < ? and (t.comment_status = 1 or (t.comment_status = 2 and t.uid =
?)) and t.ugc_uid=? ORDER BY t.hot_score DESC,t.id DESC limit ?
### Cause: java.lang.ClassCastException:
org.apache.shardingsphere.sql.parser.sql.segment.dml.expr.simple.ParameterMarkerExpressionSegment
cannot be cast to
org.apache.shardingsphere.sql.parser.sql.segment.dml.expr.simple.LiteralExpressionSegment
at
org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
~[mybatis-3.5.0.jar:3.5.0]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
~[mybatis-3.5.0.jar:3.5.0]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
~[mybatis-3.5.0.jar:3.5.0]
at sun.reflect.GeneratedMethodAccessor151.invoke(Unknown Source)
~[?:?]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_252]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_252]
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
~[mybatis-spring-2.0.3.jar:2.0.3]
at com.sun.proxy.$Proxy152.selectList(Unknown Source) ~[?:?]
at
org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)
~[mybatis-spring-2.0.3.jar:2.0.3]
at
org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:144)
~[mybatis-3.5.0.jar:3.5.0]
at
org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:77)
~[mybatis-3.5.0.jar:3.5.0]
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:58)
~[mybatis-3.5.0.jar:3.5.0]
at com.sun.proxy.$Proxy157.selectByUgcIdWithLessThanScore(Unknown
Source) ~[?:?]
at
com.inveno.rrlike.service.impl.CommentUgcService.queryCommentListBySortType(CommentUgcService.java:158)
~[rrlike-1.0.jar:1.0]
at
com.inveno.rrlike.service.impl.CommentUgcService.queryCommentList(CommentUgcService.java:104)
~[rrlike-1.0.jar:1.0]
at
com.inveno.rrlike.service.dubbo.provider.DubboLikeCommentService.buildCommentResponse(DubboLikeCommentService.java:177)
~[rrlike-1.0.jar:1.0]
at
com.inveno.rrlike.service.dubbo.provider.DubboLikeCommentService.lambda$queryLikeAndCommentBriefList$1(DubboLikeCommentService.java:80)
~[rrlike-1.0.jar:1.0]
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
~[?:1.8.0_252]
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
~[?:1.8.0_252]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
~[?:1.8.0_252]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
~[?:1.8.0_252]
... 1 more
Caused by: java.lang.ClassCastException:
org.apache.shardingsphere.sql.parser.sql.segment.dml.expr.simple.ParameterMarkerExpressionSegment
cannot be cast to
org.apache.shardingsphere.sql.parser.sql.segment.dml.expr.simple.LiteralExpressionSegment
at
org.apache.shardingsphere.sql.parser.mysql.visitor.impl.MySQLDMLVisitor.createProjection(MySQLDMLVisitor.java:472)
~[shardingsphere-sql-parser-mysql-4.1.1.jar:4.1.1]
at
org.apache.shardingsphere.sql.parser.mysql.visitor.impl.MySQLDMLVisitor.visitProjection(MySQLDMLVisitor.java:434)
~[shardingsphere-sql-parser-mysql-4.1.1.jar:4.1.1]
at
org.apache.shardingsphere.sql.parser.mysql.visitor.impl.MySQLDMLVisitor.visitProjection(MySQLDMLVisitor.java:127)
~[shardingsphere-sql-parser-mysql-4.1.1.jar:4.1.1]
at
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser$ProjectionContext.accept(MySQLStatementParser.java:5370)
~[shardingsphere-sql-parser-mysql-4.1.1.jar:4.1.1]
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
~[antlr4-runtime-4.7.2.jar:4.7.2]
at
org.apache.shardingsphere.sql.parser.mysql.visitor.impl.MySQLDMLVisitor.visitProjections(MySQLDMLVisitor.java:410)
~[shardingsphere-sql-parser-mysql-4.1.1.jar:4.1.1]
at
org.apache.shardingsphere.sql.parser.mysql.visitor.impl.MySQLDMLVisitor.visitProjections(MySQLDMLVisitor.java:127)
~[shardingsphere-sql-parser-mysql-4.1.1.jar:4.1.1]
at
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser$ProjectionsContext.accept(MySQLStatementParser.java:4865)
~[shardingsphere-sql-parser-mysql-4.1.1.jar:4.1.1]
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
~[antlr4-runtime-4.7.2.jar:4.7.2]
at
org.apache.shardingsphere.sql.parser.mysql.visitor.impl.MySQLDMLVisitor.visitSelectClause(MySQLDMLVisitor.java:329)
~[shardingsphere-sql-parser-mysql-4.1.1.jar:4.1.1]
at
org.apache.shardingsphere.sql.parser.mysql.visitor.impl.MySQLDMLVisitor.visitSelectClause(MySQLDMLVisitor.java:127)
~[shardingsphere-sql-parser-mysql-4.1.1.jar:4.1.1]
at
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser$SelectClauseContext.accept(MySQLStatementParser.java:4551)
~[shardingsphere-sql-parser-mysql-4.1.1.jar:4.1.1]
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
~[antlr4-runtime-4.7.2.jar:4.7.2]
at
org.apache.shardingsphere.sql.parser.mysql.visitor.impl.MySQLDMLVisitor.visitUnionClause(MySQLDMLVisitor.java:322)
~[shardingsphere-sql-parser-mysql-4.1.1.jar:4.1.1]
at
org.apache.shardingsphere.sql.parser.mysql.visitor.impl.MySQLDMLVisitor.visitUnionClause(MySQLDMLVisitor.java:127)
~[shardingsphere-sql-parser-mysql-4.1.1.jar:4.1.1]
at
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser$UnionClauseContext.accept(MySQLStatementParser.java:4446)
~[shardingsphere-sql-parser-mysql-4.1.1.jar:4.1.1]
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
~[antlr4-runtime-4.7.2.jar:4.7.2]
at
org.apache.shardingsphere.sql.parser.mysql.visitor.impl.MySQLDMLVisitor.visitSelect(MySQLDMLVisitor.java:314)
~[shardingsphere-sql-parser-mysql-4.1.1.jar:4.1.1]
at
org.apache.shardingsphere.sql.parser.mysql.visitor.impl.MySQLDMLVisitor.visitSelect(MySQLDMLVisitor.java:127)
~[shardingsphere-sql-parser-mysql-4.1.1.jar:4.1.1]
at
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser$SelectContext.accept(MySQLStatementParser.java:3098)
~[shardingsphere-sql-parser-mysql-4.1.1.jar:4.1.1]
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
~[antlr4-runtime-4.7.2.jar:4.7.2]
at
org.apache.shardingsphere.sql.parser.SQLParserEngine.parse0(SQLParserEngine.java:80)
~[shardingsphere-sql-parser-engine-4.1.1.jar:4.1.1]
at
org.apache.shardingsphere.sql.parser.SQLParserEngine.parse(SQLParserEngine.java:61)
~[shardingsphere-sql-parser-engine-4.1.1.jar:4.1.1]
at
org.apache.shardingsphere.underlying.route.DataNodeRouter.createRouteContext(DataNodeRouter.java:97)
~[shardingsphere-route-4.1.1.jar:4.1.1]
at
org.apache.shardingsphere.underlying.route.DataNodeRouter.executeRoute(DataNodeRouter.java:89)
~[shardingsphere-route-4.1.1.jar:4.1.1]
at
org.apache.shardingsphere.underlying.route.DataNodeRouter.route(DataNodeRouter.java:76)
~[shardingsphere-route-4.1.1.jar:4.1.1]
at
org.apache.shardingsphere.underlying.pluggble.prepare.PreparedQueryPrepareEngine.route(PreparedQueryPrepareEngine.java:54)
~[shardingsphere-pluggable-4.1.1.jar:4.1.1]
at
org.apache.shardingsphere.underlying.pluggble.prepare.BasePrepareEngine.executeRoute(BasePrepareEngine.java:96)
~[shardingsphere-pluggable-4.1.1.jar:4.1.1]
at
org.apache.shardingsphere.underlying.pluggble.prepare.BasePrepareEngine.prepare(BasePrepareEngine.java:83)
~[shardingsphere-pluggable-4.1.1.jar:4.1.1]
at
org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.prepare(ShardingPreparedStatement.java:183)
~[sharding-jdbc-core-4.1.1.jar:4.1.1]
at
org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.execute(ShardingPreparedStatement.java:143)
~[sharding-jdbc-core-4.1.1.jar:4.1.1]
at
org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
~[mybatis-3.5.0.jar:3.5.0]
at
org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
~[mybatis-3.5.0.jar:3.5.0]
at
org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
~[mybatis-3.5.0.jar:3.5.0]
at
org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
~[mybatis-3.5.0.jar:3.5.0]
at
org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
~[mybatis-3.5.0.jar:3.5.0]
at
org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
~[mybatis-3.5.0.jar:3.5.0]
at
org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
~[mybatis-3.5.0.jar:3.5.0]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
~[mybatis-3.5.0.jar:3.5.0]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
~[mybatis-3.5.0.jar:3.5.0]
at sun.reflect.GeneratedMethodAccessor151.invoke(Unknown Source)
~[?:?]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_252]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_252]
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
~[mybatis-spring-2.0.3.jar:2.0.3]
at com.sun.proxy.$Proxy152.selectList(Unknown Source) ~[?:?]
at
org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)
~[mybatis-spring-2.0.3.jar:2.0.3]
at
org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:144)
~[mybatis-3.5.0.jar:3.5.0]
at
org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:77)
~[mybatis-3.5.0.jar:3.5.0]
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:58)
~[mybatis-3.5.0.jar:3.5.0]
at com.sun.proxy.$Proxy157.selectByUgcIdWithLessThanScore(Unknown
Source) ~[?:?]
at
com.inveno.rrlike.service.impl.CommentUgcService.queryCommentListBySortType(CommentUgcService.java:158)
~[rrlike-1.0.jar:1.0]
at
com.inveno.rrlike.service.impl.CommentUgcService.queryCommentList(CommentUgcService.java:104)
~[rrlike-1.0.jar:1.0]
at
com.inveno.rrlike.service.dubbo.provider.DubboLikeCommentService.buildCommentResponse(DubboLikeCommentService.java:177)
~[rrlike-1.0.jar:1.0]
at
com.inveno.rrlike.service.dubbo.provider.DubboLikeCommentService.lambda$queryLikeAndCommentBriefList$1(DubboLikeCommentService.java:80)
~[rrlike-1.0.jar:1.0]
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
~[?:1.8.0_252]
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
~[?:1.8.0_252]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
~[?:1.8.0_252]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
~[?:1.8.0_252]
... 1 more
--
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.
For queries about this service, please contact Infrastructure at:
[email protected]
