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

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and 
found no similar issues.
   
   
   ### Version
   
   1.1
   
   ### What's Wrong?
   
   alter schema job is failed.
   be log
   ```
   I0725 11:16:24.719820 24073 task_worker_pool.cpp:483] get alter table task, 
signature: 1348500
   I0725 11:16:24.719913 24073 schema_change.cpp:1407] begin to do request 
alter tablet: base_tablet_id=1348495, base_schema_hash=1918244580, 
new_tablet_id=13485
   00, new_schema_hash=571505762, alter_version=2
   I0725 11:16:24.719944 24073 schema_change.cpp:1462] finish to validate alter 
tablet request. begin to convert data from base tablet to new tablet 
base_tablet=
   1348495.1918244580.c343975d68b9af29-b45b0de30b633094 
new_tablet=1348500.571505762.994643e77c9a4da6-4e3e19dc01bbb2ab
   I0725 11:16:24.720063 24073 schema_change.cpp:1532] begin to remove all data 
from new tablet to prevent rewrite. 
new_tablet=1348500.571505762.994643e77c9a4da6
   -4e3e19dc01bbb2ab
   I0725 11:16:24.781093 24073 schema_change.cpp:1841] begin to convert 
historical rowsets for new_tablet from base_tablet. 
base_tablet=1348495.1918244580.c34397
   5d68b9af29-b45b0de30b633094, 
new_tablet=1348500.571505762.994643e77c9a4da6-4e3e19dc01bbb2ab
   I0725 11:16:24.781180 24073 schema_change.cpp:1877] doing schema change 
directly for base_tablet 1348495.1918244580.c343975d68b9af29-b45b0de30b633094
   W0725 11:16:28.401537 24073 schema_change.cpp:1088] fail to check row num! 
source_rows=1000000, merged_rows=0, filtered_rows=0, new_index_rows=726592
   I0725 11:16:28.401716 24073 schema_change.cpp:1096] all row nums. 
source_rows=1000000, merged_rows=0, filtered_rows=0, new_index_rows=726592
   W0725 11:16:28.401744 24073 schema_change.cpp:1933] failed to process the 
version. version=2-2
   ```
   
   
https://github.com/apache/doris/blob/2dbd70bf92ed8944d60f38cb43ef556feb73b41d/be/src/olap/schema_change.cpp#L1752
   it should be added that the code `reader_context.merged_rows = 
&_merged_rows;`,but I'm not very sure。
   
   
   ### What You Expected?
   
   alter schema job is successful.
   
   ### How to Reproduce?
   
   insert duplicate rows into a unique table. then alter table, it will be 
failed.
   
   ### 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to