Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Bug]: This following SQL query caused observer crash. #1292

Closed
2 tasks done
imbawenzi opened this issue Feb 2, 2023 · 2 comments
Closed
2 tasks done

[Bug]: This following SQL query caused observer crash. #1292

imbawenzi opened this issue Feb 2, 2023 · 2 comments
Assignees
@caifeizhi
Labels
status: confirmed bug or feature request is confirmed type: bug Something isn't working

Comments

@imbawenzi
Copy link

Please check the issue list for the same bug

  • Please checked issue list and confirm this bug is encountered for the first time.
  • Please try full text in English and attach precise description.

Environment

- Server version: 5.7.25 OceanBase_CE 4.1.0.0 (r1-97d2270c0d7a7aa685220c440ae6b8de9502e989)
- Linux version 3.10.0-1160.76.1.el7.x86_64 
- obclient  Ver  Distrib 10.4.18-MariaDB

Fast Reproduce Steps(Required)

CREATE TABLE v0 ( v1 INT, v2 INT , v3 INT) ;
INSERT INTO v0 VALUES (1, 2, 3);
INSERT INTO v0 VALUES (3, 2, 1);
CREATE TABLE v4 ( v5 INT, v6 INT , v7 INT) ;
INSERT INTO v4 VALUES (4, 5, 6);
INSERT INTO v4 VALUES (6, 5, 4);
WITH x1 AS ( SELECT x2 FROM ( SELECT 32130093.000000 AS x2 FROM v4 AS x3 NATURAL JOIN v0 WHERE v5 = ( ( SELECT v1 FROM v0 WHERE ( SELECT v6 = ( SELECT v1 FROM v0 WHERE v3 IS NULL AND v3 IS NULL ) FROM v4 ) AND v2 = 77 ) NOT IN ( 'x' , 'x' ) ) ) AS x4 , v0 AS x5 , v0 AS x6 , v4 AS x7 JOIN v0 , v0 AS x8 , v0 AS x9 JOIN v0 AS x10 ) SELECT DISTINCT 'x' FROM x1 AS x11 , v4 AS x12 , v0 AS x13 , v4 AS x14 , x1 AS x15 JOIN x1 AS x16 , v4 AS x17 , x1 NATURAL JOIN v4 AS x18 , x1 AS x19 , x1 AS x20 , x1 AS x21 , x1 AS x22 JOIN x1 AS x23 , v0 AS x24 , v0 WHERE -1 = 83 ;

Actual Behavior

observer crashed

Expected Behavior

No response

other information

#0 0x00000000075497d2 in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff11d51040, out_join_path_op=@0x7fff6f57aa88: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4399
#1 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff11d51040, out_plan_tree=@0x7fff6f57bc98: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#2 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff1183a3b0, out_join_path_op=@0x7fff6f57bdb8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#3 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff1183a3b0, out_plan_tree=@0x7fff6f57cfc8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#4 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff1170fbc0, out_join_path_op=@0x7fff6f57d0e8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#5 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff1170fbc0, out_plan_tree=@0x7fff6f57e2f8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#6 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff115d9720, out_join_path_op=@0x7fff6f57e418: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#7 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff115d9720, out_plan_tree=@0x7fff6f57f628: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#8 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff110964e0, out_join_path_op=@0x7fff6f57f748: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#9 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff110964e0, out_plan_tree=@0x7fff6f580958: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#10 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff10f3f230, out_join_path_op=@0x7fff6f580a78: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#11 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff10f3f230, out_plan_tree=@0x7fff6f581c88: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#12 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff10ddbbb0, out_join_path_op=@0x7fff6f581da8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#13 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff10ddbbb0, out_plan_tree=@0x7fff6f582fb8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#14 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff1086eb40, out_join_path_op=@0x7fff6f5830d8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#15 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff1086eb40, out_plan_tree=@0x7fff6f5842e8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#16 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff106ead10, out_join_path_op=@0x7fff6f584408: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#17 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff106ead10, out_plan_tree=@0x7fff6f585618: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#18 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff10557820, out_join_path_op=@0x7fff6f585738: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#19 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff10557820, out_plan_tree=@0x7fff6f586948: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#20 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff103b2ca0, out_join_path_op=@0x7fff6f586a68: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#21 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff103b2ca0, out_plan_tree=@0x7fff6f587c78: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
---Type to continue, or q to quit---
#22 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0fe05710, out_join_path_op=@0x7fff6f587d98: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#23 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0fe05710, out_plan_tree=@0x7fff6f588fa8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#24 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0fc422b0, out_join_path_op=@0x7fff6f5890c8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#25 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0fc422b0, out_plan_tree=@0x7fff6f58a2d8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#26 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0fa6fb70, out_join_path_op=@0x7fff6f58a3f8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#27 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0fa6fb70, out_plan_tree=@0x7fff6f58b608: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#28 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0f88cd80, out_join_path_op=@0x7fff6f58b728: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#29 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0f88cd80, out_plan_tree=@0x7fff6f58c938: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#30 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0f69ba40, out_join_path_op=@0x7fff6f58ca58: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#31 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0f69ba40, out_plan_tree=@0x7fff6f58dc68: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#32 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0f49b090, out_join_path_op=@0x7fff6f58dd88: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#33 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0f49b090, out_plan_tree=@0x7fff6f58ef98: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#34 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0f28b5c0, out_join_path_op=@0x7fff6f58f0b8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#35 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0f28b5c0, out_plan_tree=@0x7fff6f5902c8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#36 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0f071720, out_join_path_op=@0x7fff6f5903e8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#37 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0f071720, out_plan_tree=@0x7fff6f5915f8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#38 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0ee449d0, out_join_path_op=@0x7fff6f591718: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#39 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0ee449d0, out_plan_tree=@0x7fff6f592928: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#40 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0ec09960, out_join_path_op=@0x7fff6f592a48: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#41 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0ec09960, out_plan_tree=@0x7fff6f593c58: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#42 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0edbc240, out_join_path_op=@0x7fff6f593d78: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#43 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0edbc240, out_plan_tree=@0x7fff6f594f88: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
---Type to continue, or q to quit---
#44 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0eb676f0, out_join_path_op=@0x7fff6f5950a8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#45 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0eb676f0, out_plan_tree=@0x7fff6f5962b8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#46 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0e903470, out_join_path_op=@0x7fff6f5963d8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#47 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0e903470, out_plan_tree=@0x7fff6f5975e8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#48 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0e6916d0, out_join_path_op=@0x7fff6f597708: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#49 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0e6916d0, out_plan_tree=@0x7fff6f598918: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#50 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0e412b20, out_join_path_op=@0x7fff6f598a38: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#51 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0e412b20, out_plan_tree=@0x7fff6f599c48: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#52 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0e5813c0, out_join_path_op=@0x7fff6f599d68: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#53 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0e5813c0, out_plan_tree=@0x7fff6f59af78: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#54 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0e2e7930, out_join_path_op=@0x7fff6f59b098: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#55 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0e2e7930, out_plan_tree=@0x7fff6f59c2a8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#56 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0e0405e0, out_join_path_op=@0x7fff6f59c3c8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#57 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0e0405e0, out_plan_tree=@0x7fff6f59d5d8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#58 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0e188160, out_join_path_op=@0x7fff6f59d6f8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#59 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0e188160, out_plan_tree=@0x7fff6f59e908: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#60 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0dec8510, out_join_path_op=@0x7fff6f59ea28: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#61 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0dec8510, out_plan_tree=@0x7fff6f59fc38: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#62 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0dff70a0, out_join_path_op=@0x7fff6f59fd58: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#63 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0dff70a0, out_plan_tree=@0x7fff6f5a0f68: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#64 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0dd1e910, out_join_path_op=@0x7fff6f5a1088: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#65 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0dd1e910, out_plan_tree=@0x7fff6f5a2298: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
---Type to continue, or q to quit---
#66 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0da3d160, out_join_path_op=@0x7fff6f5a23b8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#67 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0da3d160, out_plan_tree=@0x7fff6f5a35c8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#68 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0db46c60, out_join_path_op=@0x7fff6f5a36e8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#69 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0db46c60, out_plan_tree=@0x7fff6f5a48f8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#70 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0d84a070, out_join_path_op=@0x7fff6f5a4a18: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#71 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0d84a070, out_plan_tree=@0x7fff6f5a5c28: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#72 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0d93d220, out_join_path_op=@0x7fff6f5a5d48: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#73 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0d93d220, out_plan_tree=@0x7fff6f5a6f58: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#74 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0d629070, out_join_path_op=@0x7fff6f5a7078: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#75 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0d629070, out_plan_tree=@0x7fff6f5a8288: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#76 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0d704b00, out_join_path_op=@0x7fff6f5a83a8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#77 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0d704b00, out_plan_tree=@0x7fff6f5a95b8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#78 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0d7d6030, out_join_path_op=@0x7fff6f5a96d8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#79 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0d7d6030, out_plan_tree=@0x7fff6f5aa8e8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#80 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0d4a42d0, out_join_path_op=@0x7fff6f5aaa08: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#81 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0d4a42d0, out_plan_tree=@0x7fff6f5abc18: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#82 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0d55f210, out_join_path_op=@0x7fff6f5abd38: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#83 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0d55f210, out_plan_tree=@0x7fff6f5acf48: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#84 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0d214720, out_join_path_op=@0x7fff6f5ad068: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#85 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0d214720, out_plan_tree=@0x7fff6f5ae278: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#86 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0d2ba4d0, out_join_path_op=@0x7fff6f5ae398: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#87 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0d2ba4d0, out_plan_tree=@0x7fff6f5af5a8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
---Type to continue, or q to quit---
#88 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0d356ba0, out_join_path_op=@0x7fff6f5af6c8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#89 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0d356ba0, out_plan_tree=@0x7fff6f5b08d8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#90 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0d3e84a0, out_join_path_op=@0x7fff6f5b09f8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#91 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0d3e84a0, out_plan_tree=@0x7fff6f5b1c08: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#92 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0d078580, out_join_path_op=@0x7fff6f5b1d28: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#93 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0d078580, out_plan_tree=@0x7fff6f5b2f38: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#94 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0d0f6490, out_join_path_op=@0x7fff6f5b3058: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#95 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0d0f6490, out_plan_tree=@0x7fff6f5b4268: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#96 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0d16b560, out_join_path_op=@0x7fff6f5b4388: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#97 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0d16b560, out_plan_tree=@0x7fff6f5b5598: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#98 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0d1d6540, out_join_path_op=@0x7fff6f5b56b8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#99 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0d1d6540, out_plan_tree=@0x7fff6f5b68c8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#100 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0ce3d060, out_join_path_op=@0x7fff6f5b69e8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#101 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0ce3d060, out_plan_tree=@0x7fff6f5b7bf8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#102 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0ce959b0, out_join_path_op=@0x7fff6f5b7d18: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#103 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0ce959b0, out_plan_tree=@0x7fff6f5b8f28: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#104 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0cee55e0, out_join_path_op=@0x7fff6f5b9048: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#105 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0cee55e0, out_plan_tree=@0x7fff6f5ba258: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#106 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0cf2c580, out_join_path_op=@0x7fff6f5ba378: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#107 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0cf2c580, out_plan_tree=@0x7fff6f5bb588: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#108 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0cf6b810, out_join_path_op=@0x7fff6f5bb6a8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#109 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0cf6b810, out_plan_tree=@0x7fff6f5bc8b8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
---Type to continue, or q to quit---
#110 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0cfa18c0, out_join_path_op=@0x7fff6f5bc9d8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#111 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0cfa18c0, out_plan_tree=@0x7fff6f5bdbe8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#112 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0cfcf4f0, out_join_path_op=@0x7fff6f5bdd08: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#113 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0cfcf4f0, out_plan_tree=@0x7fff6f5bef18: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#114 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0cff5170, out_join_path_op=@0x7fff6f5bf038: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#115 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0cff5170, out_plan_tree=@0x7fff6f5c0248: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#116 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0cc18a50, out_join_path_op=@0x7fff6f5c0368: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#117 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0cc18a50, out_plan_tree=@0x7fff6f5c1578: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#118 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0cc2eb40, out_join_path_op=@0x7fff6f5c1698: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#119 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0cc2eb40, out_plan_tree=@0x7fff6f5c28a8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#120 0x00000000075499de in oceanbase::sql::ObLogPlan::allocate_join_path (this=0x7fff33c1b500, join_path=0x7fff0cc3d490, out_join_path_op=@0x7fff6f5c29c8: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:4417
#121 0x000000000754b61a in oceanbase::sql::ObLogPlan::create_plan_tree_from_path (this=0x7fff33c1b500, path=0x7fff0cc3d490, out_plan_tree=@0x7fff6f5c2b30: 0x0)
at ./src/sql/optimizer/ob_log_plan.cpp:5440
#122 0x000000000755b792 in oceanbase::sql::ObLogPlan::init_candidate_plans (this=0x7fff33c1b500) at ./src/sql/optimizer/ob_log_plan.cpp:5488
#123 0x000000000757e96a in oceanbase::sql::ObLogPlan::generate_plan_tree (this=0x7fff33c1b500) at ./src/sql/optimizer/ob_log_plan.cpp:7307
#124 0x000000000a3ed1f7 in oceanbase::sql::ObSelectLogPlan::generate_raw_plan_for_plain_select (this=0x7fff33c1b500) at ./src/sql/optimizer/ob_select_log_plan.cpp:3953
#125 0x000000000a3ec62a in oceanbase::sql::ObSelectLogPlan::generate_normal_raw_plan (this=0x7fff33c1b500) at ./src/sql/optimizer/ob_select_log_plan.cpp:3853
#126 0x0000000007541a2c in oceanbase::sql::ObLogPlan::generate_raw_plan (this=0x7fff33c1b500) at ./src/sql/optimizer/ob_log_plan.cpp:11145
#127 0x00000000075b6fc2 in oceanbase::sql::ObLogPlan::generate_plan (this=0x7fff33c1b500) at ./src/sql/optimizer/ob_log_plan.cpp:11109

#128 0x00000000076e5857 in oceanbase::sql::ObOptimizer::optimize (this=0x7fff6f5c39f0, stmt=..., logical_plan=@0x7fff6f5c39e0: 0x0)
at ./src/sql/optimizer/ob_optimizer.cpp:57
#129 0x000000000a65aa94 in oceanbase::sql::ObSql::optimize_stmt (optimizer=..., session_info=..., stmt=..., logical_plan=@0x7fff6f5c39e0: 0x0) at ./src/sql/ob_sql.cpp:3246
#130 0x000000000a654b80 in oceanbase::sql::ObSql::generate_plan (this=0x12bda840 oceanbase::observer::ObServer::get_instance()::THE_ONE+1153792, parse_result=...,
pc_ctx=0x7fff6f5c5ee0, sql_ctx=..., result=..., mode=oceanbase::sql::PC_TEXT_MODE, basic_stmt=0x7fff6b815fb0, stmt_need_privs=..., stmt_ora_need_privs=...)
at ./src/sql/ob_sql.cpp:2991
#131 0x000000000a64e27b in oceanbase::sql::ObSql::generate_physical_plan (this=0x12bda840 oceanbase::observer::ObServer::get_instance()::THE_ONE+1153792,
parse_result=..., pc_ctx=0x7fff6f5c5ee0, sql_ctx=..., result=..., is_begin_commit_stmt=false, mode=oceanbase::sql::PC_TEXT_MODE, outline_parse_result=0x7fff6f5c5830)
at ./src/sql/ob_sql.cpp:2802
#132 0x000000000a644d6e in oceanbase::sql::ObSql::handle_physical_plan (this=0x12bda840 oceanbase::observer::ObServer::get_instance()::THE_ONE+1153792, trimed_stmt=...,
context=..., result=..., pc_ctx=..., get_plan_err=-5138) at ./src/sql/ob_sql.cpp:4437
#133 0x0000000003ba3d12 in oceanbase::sql::ObSql::handle_text_query (this=0x12bda840 oceanbase::observer::ObServer::get_instance()::THE_ONE+1153792, stmt=...,
context=..., result=...) at ./src/sql/ob_sql.cpp:2374
#134 oceanbase::sql::ObSql::stmt_query (this=0x12bda840 oceanbase::observer::ObServer::get_instance()::THE_ONE+1153792, stmt=..., context=..., result=...)
---Type to continue, or q to quit---
at ./src/sql/ob_sql.cpp:202
#135 0x0000000003b9f486 in oceanbase::observer::ObMPQuery::do_process (this=0x7fff6b804060, session=..., has_more_result=false, force_sync_resp=false,
async_resp_used=@0x7fff6f5ccd19: false, need_disconnect=@0x7fff6f5ccd1a: true) at ./src/observer/mysql/obmp_query.cpp:771
#136 oceanbase::observer::ObMPQuery::process_single_stmt (this=0x7fff6b804060, multi_stmt_item=..., session=..., has_more_result=false, force_sync_resp=false,
async_resp_used=@0x7fff6f5ccd19: false, need_disconnect=@0x7fff6f5ccd1a: true) at ./src/observer/mysql/obmp_query.cpp:544
#137 0x0000000003b9aa20 in oceanbase::observer::ObMPQuery::process (this=0x7fff6b804060) at ./src/observer/mysql/obmp_query.cpp:354
#138 0x0000000003b98531 in oceanbase::rpc::frame::ObSqlProcessor::run (this=0x7fff6b804060) at ./deps/oblib/src/rpc/frame/ob_sql_processor.cpp:41
#139 0x00000000062c02da in oceanbase::omt::ObWorkerProcessor::process_one (this=0x7fff919ab2d0, req=...) at ./src/observer/omt/ob_worker_processor.cpp:67
#140 0x0000000003b952ff in oceanbase::omt::ObWorkerProcessor::process (this=0x7fff919ab2d0, req=...) at ./src/observer/omt/ob_worker_processor.cpp:126
#141 0x0000000003b92758 in oceanbase::omt::ObThWorker::process_request (this=0x7fff919ab1b0, req=...) at ./src/observer/omt/ob_th_worker.cpp:284
#142 0x0000000003b91983 in oceanbase::omt::ObThWorker::worker (this=0x7fff919ab1b0, tenant_id=@0x7fff6f5cde88: 1, req_recv_timestamp=@0x7fff6f5cde80: 1675327593115883,
worker_level=@0x7fff6f5cde7c: 0) at ./src/observer/omt/ob_th_worker.cpp:445
#143 0x00000000062be76c in oceanbase::omt::ObThWorker::run (this=0x7fff919ab1b0, idx=0) at ./src/observer/omt/ob_th_worker.cpp:484
#144 0x0000000010082e14 in oceanbase::lib::Threads::start()::$_156::operator()() const (this=0x7fff89f95e00) at ./deps/oblib/src/lib/thread/threads.cpp:187
#145 0x0000000010082c9d in std::_Function_handler<void (), oceanbase::lib::Threads::start()::$_156>::_M_invoke(std::_Any_data const&) (__functor=...)
at ./deps/3rd/usr/local/oceanbase/devtools/lib/gcc/x86_64-redhat-linux/9/../../../../include/c++/9/bits/std_function.h:300
#146 0x000000000628036e in std::function<void ()>::operator()() const (this=0x7fff89f95e00)
at ./deps/3rd/usr/local/oceanbase/devtools/lib/gcc/x86_64-redhat-linux/9/../../../../include/c++/9/bits/std_function.h:688
#147 0x0000000010076327 in oceanbase::lib::Thread::__th_start (arg=0x7fff89f95df0) at ./deps/oblib/src/lib/thread/thread.cpp:272
#148 0x00007ffff720f6db in start_thread (arg=0x7fff6f5ef300) at pthread_create.c:463
#149 0x00007ffff6f3861f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
@imbawenzi imbawenzi added the type: bug Something isn't working label Feb 2, 2023
@hnwyllmm
Copy link
Contributor

hnwyllmm commented Feb 2, 2023

Thanks for your message!

@hnwyllmm hnwyllmm added status: confirmed bug or feature request is confirmed developing and removed status: confirmed bug or feature request is confirmed labels Feb 2, 2023
@caifeizhi
Copy link
Contributor

fix it: 1676249

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@caifeizhi caifeizhi

Labels
status: confirmed bug or feature request is confirmed type: bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@hnwyllmm @caifeizhi @imbawenzi