You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Moredespicablethananyoneelse (via GitHub)" <gi...@apache.org> on 2024/02/05 09:57:45 UTC
[I] [bug] .analysis.ExistsPredicate.toThrift Error [doris]
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 <se...@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-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [bug] .analysis.ExistsPredicate.toThrift Error [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman closed issue #30862: [bug] .analysis.ExistsPredicate.toThrift Error
URL: https://github.com/apache/doris/issues/30862
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [bug] .analysis.ExistsPredicate.toThrift Error [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #30862:
URL: https://github.com/apache/doris/issues/30862#issuecomment-3287226344
We're closing this issue because it hasn't been updated in a while.
If you'd like to revive this issue, please reopen it and feel free a maintainer to remove the Stale tag!
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org