Working on {T104459} (T104459#6048024) The results for s10 (db1133.eqiad.wmnet) really stood out.
This the list of db drifts between core and production that only exists in db1133 (ordered alphabetically):
- categorylinks
- categorylinks cl_collation index-mismatch-prod-extra
- categorylinks cl_collation_ext index-mismatch-code-extra
- categorylinks cl_from index-mismatch-prod-extra
- externallinks
- externallinks el_backlinks_namespace index-mismatch-prod-extra
- externallinks el_from_namespace field-mismatch-prod-extra (one host in s5 has this drift as well)
- imagelinks
- imagelinks il_backlinks_namespace index-columns-mismatch
- imagelinks il_from index-mismatch-prod-extra
- ipblocks_restrictions ir_type_value index-mismatch-code-extra
- iwlinks iwl_from index-mismatch-prod-extra
- langlinks ll_from index-mismatch-prod-extra
- log_search ls_field_val index-mismatch-prod-extra
- module_deps md_module_skin index-mismatch-prod-extra
- pagelinks pl_backlinks_namespace index-columns-mismatch
- querycache_info qci_type index-mismatch-prod-extra
- recentchanges rc_name_type_patrolled_timestamp index-mismatch-code-extra
- searchindex
- searchindex si_text index-mismatch-prod-extra
- searchindex si_title index-mismatch-prod-extra
- ~~site_stats ss_row_id index-mismatch-prod-extra~~
- templatelinks tl_backlinks_namespace index-columns-mismatch
- user user_email index-columns-mismatch
- user_former_groups ufg_user_group index-mismatch-prod-extra
- user_properties user_properties_user_property index-mismatch-prod-extra
This is not good.