dataroaring opened a new issue, #43576: URL: https://github.com/apache/doris/issues/43576
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Description Fullsync means sync all data via backup and restore again. It happens when ccr can not handle binlog incrementally, then it starts from beginning again. Internally, fullsync using bakcup with alias and atomic restore to reuse data as mush as possible , thus avoid sync all data again. So we should let fullsync happen frequently to test it thoughroughly. ### Solution 1. add cases for some operations listed by experience as below. <!DOCTYPE html><figure class="md-table-fig table-figure md-expand md-focus" cid="n5161" mdtype="table" style="box-sizing: border-box; margin: 1.2em 0px; overflow-x: auto; max-width: calc(100% + 16px); padding: 0px; cursor: default; caret-color: rgb(51, 51, 51); color: rgb(51, 51, 51); font-family: "Open Sans", "Clear Sans", "Helvetica Neue", Helvetica, Arial, "Segoe UI Emoji", sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration: none;"> Resource | Operation | Db sync case | Table sync case | Table sync with alias case | Comment -- | -- | -- | -- | -- | -- Database | | | | | Table | Create + Drop | | - | - | Create + Alter | | - | - | | Drop + Create | | - | - | Schemas are same | Drop + Create | | - | - | Schemas are different | Drop | | - | - | | Truncate | test_ds_tbl_truncate | | | | Rename | | - | - | | Replace | | | | | Alter properties | | | | | Alter comment | | | | | Partition | Add | | | | | Drop | | | | | Replace | | | | | Modify | | | | | Rename | | | | | Add + Drop | | | | | Drop + Add | | | | | Add + rename | | | | Column | Add key | | | | Drop key | | | | | Add value | | | | | Drop value | | | | | Order by | | | | | Rename | | | | | Modify comment | | | | | Add key + drop | | | | | Drop key + add | | | | | Add value + drop | | | | | Drop value + add | | | | | Add column value + modify | | | | | Add key column + modify | | | | | Rollup | Add | | | | Drop | | | | | Rename | | - | - | | Add column | | | | | Drop column | | | | | Modify column | | | | | Rename column | | | | | View | Create | | | | Alter | | | | | Drop | | | | | Drop + Create | | | | | Create + Drop | | | | | Index | Add inverted index | | | | Drop inverted index | | | | | Add bloom filter | | | | | Drop bloom filter | | | | | Add NG bloom filter | | | | | Drop NG bloom filter | | | | | MV | Create | | | | Drop | | | | | DML | INSERT INTO OVERWRITE | | | | explicit transaction | | | | | </figure> 2. writing a test tool which generate random operation and ccr syncer take full sync in action randomly. ### 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: [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]
