Moredespicablethananyoneelse opened a new issue, #30862: URL: https://github.com/apache/doris/issues/30862
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version commit 48d7df205f7c57980a44e3f14e84d731e0e7cabb Author: zhiqiang <seuhezhiqi...@163.com> Date: Fri Dec 1 11:59:47 2023 +0800 [chore](log) Add more detail msg for waitRPC exception #27771 ### What's Wrong? // exist报错信息 **### there is an error when execute a select clause** 2024-02-05 08:48:40,568 INFO (mysql-nio-pool-48|182311) [NereidsPlanner.rewrite():280] Start rewrite plan 2024-02-05 08:48:40,590 WARN (mysql-nio-pool-48|182311) [StmtExecutor.executeByLegacy():816] execute Exception. stmt[213, c13e634c7de4593-be9f0c832dec9d33] java.lang.IllegalStateException: null at com.google.common.base.Preconditions.checkState(Preconditions.java:496) ~[guava-32.1.2-jre.jar:?] at org.apache.doris.analysis.ExistsPredicate.toThrift(ExistsPredicate.java:56) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.analysis.Expr.treeToThriftHelper(Expr.java:1054) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.analysis.Expr.treeToThrift(Expr.java:1029) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.PlanNode.treeToThriftHelper(PlanNode.java:628) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.PlanNode.treeToThriftHelper(PlanNode.java:659) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.PlanNode.treeToThriftHelper(PlanNode.java:659) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.PlanNode.treeToThrift(PlanNode.java:611) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.PlanFragment.toThrift(PlanFragment.java:300) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.Coordinator$FragmentExecParams.toTPipelineParams(Coordinator.java:3544) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.Coordinator.sendPipelineCtx(Coordinator.java:829) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.Coordinator.exec(Coordinator.java:640) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.sendResult(StmtExecutor.java:1492) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.handleQueryStmt(StmtExecutor.java:1462) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.handleQueryWithRetry(StmtExecutor.java:645) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.executeByLegacy(StmtExecutor.java:734) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:460) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:430) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:240) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.handleQuery(MysqlConnectProcessor.java:160) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.dispatch(MysqlConnectProcessor.java:187) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:240) ~[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:1149) ~[?:1.8.0_392] 23150,2-9 97% ### What You Expected? is it a bug ? wait for it be fixed ### How to Reproduce? ### here is the sqls of "create tables" clause, and the sql that throw this error above ### table01 CREATE TABLE RECURSIVE_DIM_BAI_02_number ( ID VARCHAR(20), A_INT INT, B_DOUBLE DOUBLE, C_VARCHAR_1 VARCHAR(25), C_VARCHAR_2 VARCHAR(25), D_NUMBER DECIMAL(10), re_number1 DECIMAL(2,1), re_number2 DECIMAL(3,2) ) ENGINE=OLAP DUPLICATE KEY( ID ) COMMENT "OLAP" DISTRIBUTED BY HASH( ID ) BUCKETS auto PROPERTIES ( "replication_num" = "3" ) ### table02 CREATE TABLE RECURSIVE_FACT_BAI_01_number ( ID VARCHAR(20), A_INT_1 INT, A_INT_2 INT, B_DATE_1 DATE, B_DATE_2 DATE, C_DOUBLE_1 DOUBLE, C_DOUBLE_2 DOUBLE, D_TIMESTAMP_1 DATETIME (6), D_TIMESTAMP_2 DATETIME (6), E_VARCHAR_1 VARCHAR(22), E_VARCHAR_2 VARCHAR(22), F_LONG_1 BIGINT, F_LONG_2 BIGINT, G_CHAR_1 CHAR(10), G_CHAR_2 CHAR(10), H_DATE_1 DATE, H_DATE_2 DATE, H_DATE_3 DATE, H_TIMESTAMP_4 DATETIME (6), H_TIMESTAMP_5 DATETIME (6), H_TIMESTAMP_6 DATETIME (6), I_INTERVAL_YEAR_1 varchar(1000), I_INTERVAL_YEAR_2 varchar(1000), J_INTERVAL_DAY_1 varchar(1000), J_INTERVAL_DAY_2 varchar(1000), k_number DECIMAL(10), re_number1 DECIMAL(2,1), re_number2 DECIMAL(3,2), re_int_1 int, re_int_2 int, re_int_3 int, re_int_4 int, re_long_1 BIGINT, re_long_2 BIGINT, re_long_3 BIGINT, re_long_4 BIGINT, re_double_1 double, re_double_2 double, re_double_3 double, re_double_4 double, re_double_5 double, re_double_6 double, re_double_7 double, re_double_8 double, re_number_1 DECIMAL(38,0), re_number_2 DECIMAL(38,0), re_number_3 DECIMAL(38,0), re_number_4 DECIMAL(38,0), re_number_5 DECIMAL(38,2), re_number_6 DECIMAL(38,1), re_number_7 DECIMAL(38,2), re_number_8 DECIMAL(38,3) ) ENGINE=OLAP DUPLICATE KEY( ID ) COMMENT "OLAP" DISTRIBUTED BY HASH( ID ) BUCKETS auto PROPERTIES ( "replication_num" = "3" ) ### table03 create table extreme_table_number ( ord_id bigint, a_int int, b_int int, c_int int, d_long bigint, e_long bigint, f_long bigint, g_double double, h_double double, j_double double, k_date date, l_date date, m_date date, n_timestamp DATETIME(6), o_timestamp DATETIME(6), p_timestamp DATETIME(6), q_interval varchar(1000), r_interval varchar(1000), s_interval varchar(1000), t_interval varchar(1000), u_interval varchar(1000), v_interval varchar(1000), w_number double , x_number double, y_number decimal(38,25), z_number double, a_decima double , b_decima double, c_decima decimal(38,25), d_decima decimal(38,25), e_char char(1), f_char char(10), g_char char(255), h_varchar varchar(1), i_varchar varchar(20), j_varchar varchar(500), n_date date, m_timestamp datetime(6), o_number DECIMAL(3), p_number DECIMAL(10,2), q_number DECIMAL(5,3), ex_int int, ex_long bigint, ex_double8 double, ex_double14 double, ex_double15 double, ex_number1 DECIMAL(10), ex_number2 DECIMAL(16), ex_number3 DECIMAL(5,3), ex_number4 DECIMAL(36,14), ex_number5 DECIMAL(20), ex_number6 DECIMAL(28), ext_number1 DECIMAL(2,1), ext_number2 DECIMAL(3,2)) ENGINE=OLAP DUPLICATE KEY( ord_id ) COMMENT "OLAP" DISTRIBUTED BY HASH( ord_id ) BUCKETS auto PROPERTIES ( "replication_num" = "3" ) ### table04 CREATE TABLE RECURSIVE_DIM_BAI_01_number ( ID VARCHAR(20) , A_CHAR_1 CHAR(10), A_CHAR_2 CHAR(10), A_number DECIMAL(10,0), re_number1 DECIMAL(3,2), re_int_1 int, re_int_2 int, re_int_3 int, re_int_4 int, re_long_1 BIGINT, re_long_2 BIGINT, re_long_3 BIGINT, re_long_4 BIGINT, re_double_1 double, re_double_2 double, re_double_3 double, re_double_4 double, re_double_5 double, re_double_6 double, re_double_7 double, re_double_8 double, re_number_1 DECIMAL(38,0), re_number_2 DECIMAL(38,0), re_number_3 DECIMAL(38,0), re_number_4 DECIMAL(38,0), re_number_5 DECIMAL(38,1), re_number_6 DECIMAL(38,1), re_number_7 DECIMAL(38,2), re_number_8 DECIMAL(38,3) ) ENGINE=OLAP DUPLICATE KEY( ID ) COMMENT "OLAP" DISTRIBUTED BY HASH( ID ) BUCKETS auto PROPERTIES ( "replication_num" = "3" ) ### table05 **this may an replicated create-table-clause, you may skip this clause** CREATE TABLE RECURSIVE_FACT_BAI_01_number ( ID VARCHAR(20), A_INT_1 INT, A_INT_2 INT, B_DATE_1 DATE, B_DATE_2 DATE, C_DOUBLE_1 DOUBLE, C_DOUBLE_2 DOUBLE, D_TIMESTAMP_1 DATETIME (6), D_TIMESTAMP_2 DATETIME (6), E_VARCHAR_1 VARCHAR(22), E_VARCHAR_2 VARCHAR(22), F_LONG_1 BIGINT, F_LONG_2 BIGINT, G_CHAR_1 CHAR(10), G_CHAR_2 CHAR(10), H_DATE_1 DATE, H_DATE_2 DATE, H_DATE_3 DATE, H_TIMESTAMP_4 DATETIME (6), H_TIMESTAMP_5 DATETIME (6), H_TIMESTAMP_6 DATETIME (6), I_INTERVAL_YEAR_1 varchar(1000), I_INTERVAL_YEAR_2 varchar(1000), J_INTERVAL_DAY_1 varchar(1000), J_INTERVAL_DAY_2 varchar(1000), k_number DECIMAL(10), re_number1 DECIMAL(2,1), re_number2 DECIMAL(3,2), re_int_1 int, re_int_2 int, re_int_3 int, re_int_4 int, re_long_1 BIGINT, re_long_2 BIGINT, re_long_3 BIGINT, re_long_4 BIGINT, re_double_1 double, re_double_2 double, re_double_3 double, re_double_4 double, re_double_5 double, re_double_6 double, re_double_7 double, re_double_8 double, re_number_1 DECIMAL(38,0), re_number_2 DECIMAL(38,0), re_number_3 DECIMAL(38,0), re_number_4 DECIMAL(38,0), re_number_5 DECIMAL(38,2), re_number_6 DECIMAL(38,1), re_number_7 DECIMAL(38,2), re_number_8 DECIMAL(38,3) ) ENGINE=OLAP DUPLICATE KEY( ID ) COMMENT "OLAP" DISTRIBUTED BY HASH( ID ) BUCKETS auto PROPERTIES ( "replication_num" = "3" ) ### the sql which throw the error above // 报exist错误 SELECT b.re_number1 cc1 from RECURSIVE_DIM_BAI_02_number b group by b.re_number1 HAVING (b.re_number1) in(SELECT ext_number1 from extreme_table_number inner join RECURSIVE_DIM_BAI_01_number on ord_id=a_number where exists(SELECT re_number1 from RECURSIVE_FACT_BAI_01_number WHERE re_number2=ext_number2 group by re_number1 HAVING count(re_number1)>9 )) ### the error stack // exist报错信息 2024-02-05 08:48:40,568 INFO (mysql-nio-pool-48|182311) [NereidsPlanner.rewrite():280] Start rewrite plan 2024-02-05 08:48:40,590 WARN (mysql-nio-pool-48|182311) [StmtExecutor.executeByLegacy():816] execute Exception. stmt[213, c13e634c7de4593-be9f0c832dec9d33] java.lang.IllegalStateException: null at com.google.common.base.Preconditions.checkState(Preconditions.java:496) ~[guava-32.1.2-jre.jar:?] at org.apache.doris.analysis.ExistsPredicate.toThrift(ExistsPredicate.java:56) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.analysis.Expr.treeToThriftHelper(Expr.java:1054) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.analysis.Expr.treeToThrift(Expr.java:1029) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.PlanNode.treeToThriftHelper(PlanNode.java:628) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.PlanNode.treeToThriftHelper(PlanNode.java:659) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.PlanNode.treeToThriftHelper(PlanNode.java:659) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.PlanNode.treeToThrift(PlanNode.java:611) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.PlanFragment.toThrift(PlanFragment.java:300) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.Coordinator$FragmentExecParams.toTPipelineParams(Coordinator.java:3544) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.Coordinator.sendPipelineCtx(Coordinator.java:829) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.Coordinator.exec(Coordinator.java:640) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.sendResult(StmtExecutor.java:1492) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.handleQueryStmt(StmtExecutor.java:1462) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.handleQueryWithRetry(StmtExecutor.java:645) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.executeByLegacy(StmtExecutor.java:734) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:460) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:430) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:240) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.handleQuery(MysqlConnectProcessor.java:160) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.dispatch(MysqlConnectProcessor.java:187) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:240) ~[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:1149) ~[?:1.8.0_392] 23150,2-9 97% ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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
