You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/07/26 01:47:41 UTC

[GitHub] [doris] ChPi opened a new issue, #11191: [Bug] (alter)alter unique table schema bug

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: 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