rotkang opened a new issue, #26152:
URL: https://github.com/apache/doris/issues/26152

   ### 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
   
   Doris version doris-2.0.2-rc05-ae923f7
   
   Problems that have arisen in history
   [close wait failed coz rpc 
error](https://github.com/apache/doris/issues/20025)
   
   ### What's Wrong?
   
   An error occurred while writing the data query to the target table. The 
error message is as follows:
   
   ERROR 1105 (HY000): errCode = 2, detailMessage = 
(172.18.34.26)[INTERNAL_ERROR][INTERNAL_ERROR]close wait failed coz rpc error
   0. /root/src/doris-2.0/be/src/common/stack_trace.cpp:302: 
StackTrace::tryCapture() @ 0x000000000ba1f197 in 
/opt/app/apache-doris-2.0.2/be/lib/doris_be
   1. /root/src/doris-2.0/be/src/common/stack_trace.h:0: 
doris::get_stack_trace[abi:cxx11]() @ 0x000000000ba1d72d in 
/opt/app/apache-doris-2.0.2/be/lib/doris_be
   2. 
/var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/
   
   【Execute statement】
   MySQL [cml]> insert into cml.ads_rollup_agg2
       -> select
       ->  *
       ->  from cml.ads_rollup_agg1 a
       -> where p_dt = '2023-10-25'
       -> and p_hr = '06'
       -> ;
   
   
   Source Table DDL
   MySQL [cml]> desc cml.ads_rollup_agg1;
   +--------------+-------------+------+-------+---------+--------------+
   | Field        | Type        | Null | Key   | Default | Extra        |
   +--------------+-------------+------+-------+---------+--------------+
   | p_dt         | DATE        | No   | true  | NULL    |              |
   | p_hr         | VARCHAR(2)  | Yes  | true  | NULL    |              |
   | billing_id   | VARCHAR(*)  | Yes  | true  | NULL    |              |
   | media_id     | VARCHAR(*)  | Yes  | true  | NULL    |              |
   | stgy_id      | VARCHAR(*)  | Yes  | true  | NULL    |              |
   | main_advs_id | VARCHAR(*)  | Yes  | true  | NULL    |              |
   | ad_src_id    | VARCHAR(*)  | Yes  | true  | NULL    |              |
   | evt_nm       | VARCHAR(50) | Yes  | true  | NULL    |              |
   | evt_state    | VARCHAR(10) | Yes  | true  | NULL    |              |
   | rqst_cnt     | BIGINT      | Yes  | false | 0       | SUM          |
   | estd_inc     | DOUBLE      | Yes  | false | 0       | SUM          |
   | rqst_id      | BITMAP      | No   | false |         | BITMAP_UNION |
   +--------------+-------------+------+-------+---------+--------------+
   
   Target Table DDL
   MySQL [cml]> desc cml.ads_rollup_agg2;
   +--------------+-------------+------+-------+---------+--------------+
   | Field        | Type        | Null | Key   | Default | Extra        |
   +--------------+-------------+------+-------+---------+--------------+
   | p_dt         | DATE        | No   | true  | NULL    |              |
   | p_hr         | VARCHAR(2)  | Yes  | true  | NULL    |              |
   | billing_id   | VARCHAR(*)  | Yes  | true  | NULL    |              |
   | media_id     | VARCHAR(*)  | Yes  | true  | NULL    |              |
   | stgy_id      | VARCHAR(*)  | Yes  | true  | NULL    |              |
   | main_advs_id | VARCHAR(*)  | Yes  | true  | NULL    |              |
   | ad_src_id    | VARCHAR(*)  | Yes  | true  | NULL    |              |
   | evt_nm       | VARCHAR(50) | Yes  | true  | NULL    |              |
   | evt_state    | VARCHAR(10) | Yes  | true  | NULL    |              |
   | rqst_cnt     | BIGINT      | Yes  | false | 0       | SUM          |
   | estd_inc     | DOUBLE      | Yes  | false | 0       | SUM          |
   | rqst_id      | BITMAP      | No   | false |         | BITMAP_UNION |
   +--------------+-------------+------+-------+---------+--------------+
   
   
   
   
   ### What You Expected?
   
   Write data to the target table normally
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [X] 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

Reply via email to