Change Details

As stated in T410431#11534001, the `page_id= 69510715 and wiki_id = 'enwiki'` combination that is present in MariaDD, is completely absent in the `wmf_content.mediwiki_content_history_v1`. After some digging the problem is most probably in the [[ https://gitlab.wikimedia.org/repos/data-engineering/mediawiki-content-pipelines/-/blob/main/mediawiki_content_pipelines/content_history/consistency_check.py?ref_type=heads#L375 | reconciliation query ]]. The absence of records in the `wmf_content.mediwiki_content_history_v1` does not allow the query to select any record and therefore the pipeline does not produce any reconciliation. In this task we want to find a solution to the missing reconciliation

As stated in T410431#11534001, the `page_id= 69510715 and wiki_id = 'enwiki'` combination that is present in MariaDB, is completely absent in the `wmf_content.mediwiki_content_history_v1`. After some digging the problem is most probably in the [[ https://gitlab.wikimedia.org/repos/data-engineering/mediawiki-content-pipelines/-/blob/main/mediawiki_content_pipelines/content_history/consistency_check.py?ref_type=heads#L375 | reconciliation query ]]. The absence of records in the `wmf_content.mediwiki_content_history_v1` does not allow the query to select any record and therefore the pipeline does not produce any reconciliation. In this task we want to find a solution to the missing reconciliation

As stated in T410431#11534001, the `page_id= 69510715 and wiki_id = 'enwiki'` combination that is present in MariaDDB, is completely absent in the `wmf_content.mediwiki_content_history_v1`. After some digging the problem is most probably in the [[ https://gitlab.wikimedia.org/repos/data-engineering/mediawiki-content-pipelines/-/blob/main/mediawiki_content_pipelines/content_history/consistency_check.py?ref_type=heads#L375 | reconciliation query ]]. The absence of records in the `wmf_content.mediwiki_content_history_v1` does not allow the query to select any record and therefore the pipeline does not produce any reconciliation. In this task we want to find a solution to the missing reconciliation