bengdywu opened a new issue, #49340: URL: https://github.com/apache/doris/issues/49340
My Environment： Doris version：apache-doris-3.0.3-rc04-bin-x64 OS：Ubuntu 22.04.5 LTS Doris Cluster：1FE + 2BE mysql driver：v8.0.3 I used the optimization suggestions provided in the Doris 3.0 manual as examples for testing：https://doris.incubator.apache.org/zh-CN/docs/2.0/query/high-concurrent-point-query?_highlight=prepare#%E4%BD%BF%E7%94%A8-preparedstatement url = jdbc:mysql://127.0.0.1:9030/ycsb?useServerPrepStmts=true My code snippet // use `?` for placement holders, readStatement should be reused PreparedStatement readStatement = conn.prepareStatement("select * from tbl_point_query where k1 = ?"); ... readStatement.setInt(1,1234); ResultSet resultSet = readStatement.executeQuery(); ... readStatement.setInt(1,1235); resultSet = readStatement.executeQuery(); ... When I execute the above code, I get the following error message: “2025-03-21 09:45:16,564 WARN (mysql-nio-pool-1233|228) [StmtExecutor.execute():618] Analyze failed. stmt[44176, f0b22f03021a4a8b-adc3d6684adfe224] org.apache.doris.common.NereidsException: errCode = 2, detailMessage = Cannot read field "originStmt" because the return value of "org.apache.doris.analysis.StatementBase.getOrigStmt()" is null at org.apache.doris.qe.StmtExecutor.executeByNereids(StmtExecutor.java:783) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:603) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.queryRetry(StmtExecutor.java:566) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:556) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.handleExecute(MysqlConnectProcessor.java:151) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.handleExecute(MysqlConnectProcessor.java:196) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.dispatch(MysqlConnectProcessor.java:240) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:414) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?] at java.lang.Thread.run(Thread.java:840) ~[?:?] Caused by: org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Cannot read field "originStmt" because the return value of "org.apache.doris.analysis.StatementBase.getOrigStmt()" is null ... 12 more Caused by: java.lang.NullPointerException: Cannot read field "originStmt" because the return value of "org.apache.doris.analysis.StatementBase.getOrigStmt()" is null at org.apache.doris.qe.StmtExecutor.handleCacheStmt(StmtExecutor.java:1777) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.handleQueryStmt(StmtExecutor.java:1885) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.handleQueryWithRetry(StmtExecutor.java:916) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.executeByNereids(StmtExecutor.java:831) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:603) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.queryRetry(StmtExecutor.java:566) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:556) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.nereids.trees.plans.commands.ExecuteCommand.run(ExecuteCommand.java:85) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.executeByNereids(StmtExecutor.java:752) ~[doris-fe.jar:1.2-SNAPSHOT] ... 11 more” 我不确定是否遗漏了什么重要信息导致我没有成功运行这个例子，或者是我使用的doris版本存在这方面的缺陷，请指正 -- 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
