[I] [Bug] Select count(*) return 2 results during stream load 2w rows/per seconds [doris]

[via GitHub]

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

   ### 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
   
   2.1.5 rc02
   
   ### What's Wrong?
   
   back ground:  stream load within  2w rows/per seconds. 
   case: 
   1 select count(*) return 2 results and select(__dt__) get one result
   2. sum results in select count(*)  which equals to select(__dt__) 
   3. all stream load label has commit and visible matched, suppose data is all 
really visible.
   4. after stop stream for about 20min, select count(*) return one result.
   
   
![Image](https://github.com/user-attachments/assets/ef6b69bd-09ed-47ff-839f-edc8f4e2a6e1)
   
   Transation like :
   
![Image](https://github.com/user-attachments/assets/7804e4cf-75ea-4c33-974d-0cf3d16536bd)
   
   ddl like:
   
   CREATE TABLE IF NOT EXISTS xxxx
   ( 
       `__time__`              DATETIME default CURRENT_TIMESTAMP,
       `trace_id`              VARCHAR(200),        
       `instance`              VARCHAR(500),    
       `span_id`               STRING,              
       `service_name`          VARCHAR(200),        
       `duration`              BIGINT,         
       `__dt__`                DATE      , 
       `resource_attributes`   MAP<STRING, STRING>,           
       `events`                ARRAY<STRUCT<__time__:DATETIME, name:STRING, 
attributes:MAP<STRING, STRING>>>     
       INDEX idx_service_name(service_name) USING INVERTED,        
       INDEX idx_timestamp(__time__) USING INVERTED,        
       INDEX idx_trace_id(trace_id) USING INVERTED,        
       INDEX idx_instance(instance) USING INVERTED,        
       INDEX idx_span_id(span_id) USING INVERTED
   ) ENGINE = OLAP        
   DUPLICATE KEY(__time__,  trace_id)   
   PARTITION BY RANGE(__dt__) ()        
   DISTRIBUTED BY HASH(trace_id) BUCKETS AUTO
   
   ### What You Expected?
   
   select count(*) got 1 result 
   
   ### How to Reproduce?
   
   _No response_
   
   ### 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