Page MenuHomePhabricator

Random drifts on s3 part 2
Closed, ResolvedPublic

Description

This doesn't include master drifts (or codfw drifts) but you can safely assume lots of them happen on the master as well.

Most wikis here are tiny, we probably can fix them with replication enabled on master

bot_passwords bp_user field-unsigned-mismatch s3 db1112:chairwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:chairwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:chairwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:chairwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:chairwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:internalwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:internalwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:internalwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:internalwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:internalwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:donatewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:donatewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:donatewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:donatewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:donatewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:wg_enwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:wg_enwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:wg_enwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:wg_enwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:wg_enwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:boardgovcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:boardgovcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:boardgovcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:boardgovcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:boardgovcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:arbcom_fiwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:arbcom_fiwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:arbcom_fiwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:arbcom_fiwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:arbcom_fiwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:arbcom_dewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:arbcom_dewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:arbcom_dewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:arbcom_dewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:arbcom_dewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:movementroleswiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:movementroleswiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:movementroleswiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:movementroleswiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:movementroleswiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:execwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:execwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:execwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:execwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:execwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:boardwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:boardwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:boardwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:boardwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:boardwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:collabwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:collabwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:collabwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:collabwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:collabwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:wikimaniateamwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:wikimaniateamwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:wikimaniateamwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:wikimaniateamwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:wikimaniateamwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:ilwikimedia
bot_passwords bp_user field-unsigned-mismatch s3 db1157:ilwikimedia
bot_passwords bp_user field-unsigned-mismatch s3 db1166:ilwikimedia
bot_passwords bp_user field-unsigned-mismatch s3 db1175:ilwikimedia
bot_passwords bp_user field-unsigned-mismatch s3 db1179:ilwikimedia
bot_passwords bp_user field-unsigned-mismatch s3 db1112:chapcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:chapcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:chapcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:chapcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:chapcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:transitionteamwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:transitionteamwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:transitionteamwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:transitionteamwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:transitionteamwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:otrs_wikiwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:otrs_wikiwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:otrs_wikiwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:otrs_wikiwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:otrs_wikiwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:legalteamwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:legalteamwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:legalteamwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:legalteamwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:legalteamwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:iegcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:iegcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:iegcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:iegcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:iegcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:officewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:officewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:officewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:officewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:officewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:arbcom_nlwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:arbcom_nlwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:arbcom_nlwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:arbcom_nlwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:arbcom_nlwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:stewardwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:stewardwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:stewardwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:stewardwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:stewardwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:votewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:votewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:votewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:votewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:votewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:ombudsmenwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:ombudsmenwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:ombudsmenwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:ombudsmenwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:ombudsmenwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:searchcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:searchcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:searchcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:searchcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:searchcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:noboard_chapterswikimedia
bot_passwords bp_user field-unsigned-mismatch s3 db1157:noboard_chapterswikimedia
bot_passwords bp_user field-unsigned-mismatch s3 db1166:noboard_chapterswikimedia
bot_passwords bp_user field-unsigned-mismatch s3 db1175:noboard_chapterswikimedia
bot_passwords bp_user field-unsigned-mismatch s3 db1179:noboard_chapterswikimedia
bot_passwords bp_user field-unsigned-mismatch s3 db1112:checkuserwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:checkuserwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:checkuserwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:checkuserwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:checkuserwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:fdcwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:fdcwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:fdcwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:fdcwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:fdcwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:arbcom_enwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:arbcom_enwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:arbcom_enwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:arbcom_enwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:arbcom_enwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:spcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:spcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:spcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:spcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:spcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:rswikimedia
bot_passwords bp_user field-unsigned-mismatch s3 db1157:rswikimedia
bot_passwords bp_user field-unsigned-mismatch s3 db1166:rswikimedia
bot_passwords bp_user field-unsigned-mismatch s3 db1175:rswikimedia
bot_passwords bp_user field-unsigned-mismatch s3 db1179:rswikimedia
bot_passwords bp_user field-unsigned-mismatch s3 db1112:nostalgiawiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:nostalgiawiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:nostalgiawiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:nostalgiawiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:nostalgiawiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:auditcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:auditcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:auditcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:auditcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:auditcomwiki
bot_passwords bp_user field-unsigned-mismatch s3 db1112:cnwikimedia
bot_passwords bp_user field-unsigned-mismatch s3 db1157:cnwikimedia
bot_passwords bp_user field-unsigned-mismatch s3 db1166:cnwikimedia
bot_passwords bp_user field-unsigned-mismatch s3 db1175:cnwikimedia
bot_passwords bp_user field-unsigned-mismatch s3 db1179:cnwikimedia
bot_passwords bp_user field-unsigned-mismatch s3 db1112:grantswiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:grantswiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:grantswiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:grantswiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:grantswiki
change_tag ct_tag_id field-nullable-mismatch s3 db1157:advisorswiki
change_tag ct_tag_id field-nullable-mismatch s3 db1166:advisorswiki
change_tag ct_tag_id field-nullable-mismatch s3 db1175:advisorswiki
change_tag ct_tag_id field-nullable-mismatch s3 db1179:advisorswiki
interwiki iw_trans field-nullable-mismatch s3 db1112:jawikinews
interwiki iw_trans field-nullable-mismatch s3 db1157:jawikinews
interwiki iw_trans field-nullable-mismatch s3 db1166:jawikinews
interwiki iw_trans field-nullable-mismatch s3 db1175:jawikinews
interwiki iw_trans field-nullable-mismatch s3 db1179:jawikinews
oldimage oi_timestamp index-mismatch-code-extra s3 db1166:alswiki
templatelinks tl_backlinks_namespace_target_id index-mismatch-code-extra s3 db1179:aawikibooks
templatelinks tl_backlinks_namespace_target_id index-mismatch-code-extra s3 db1179:aawiktionary
templatelinks tl_backlinks_namespace_target_id index-mismatch-code-extra s3 db1179:abwiktionary
templatelinks tl_backlinks_namespace_target_id index-mismatch-code-extra s3 db1179:aawiki
templatelinks tl_backlinks_namespace_target_id index-mismatch-code-extra s3 db1179:abwiki
templatelinks tl_target_id index-mismatch-code-extra s3 db1179:aawikibooks
templatelinks tl_target_id index-mismatch-code-extra s3 db1179:aawiktionary
templatelinks tl_target_id index-mismatch-code-extra s3 db1179:abwiktionary
templatelinks tl_target_id index-mismatch-code-extra s3 db1179:aawiki
templatelinks tl_target_id index-mismatch-code-extra s3 db1179:abwiki
user_former_groups ufg_group field-size-mismatch s3 db1112:aswikisource
user_former_groups ufg_group field-size-mismatch s3 db1157:aswikisource
user_former_groups ufg_group field-size-mismatch s3 db1166:aswikisource
user_former_groups ufg_group field-size-mismatch s3 db1175:aswikisource
user_former_groups ufg_group field-size-mismatch s3 db1179:aswikisource
user_former_groups ufg_group field-size-mismatch s3 db1112:ptwikivoyage
user_former_groups ufg_group field-size-mismatch s3 db1157:ptwikivoyage
user_former_groups ufg_group field-size-mismatch s3 db1166:ptwikivoyage
user_former_groups ufg_group field-size-mismatch s3 db1175:ptwikivoyage
user_former_groups ufg_group field-size-mismatch s3 db1179:ptwikivoyage
user_former_groups ufg_group field-size-mismatch s3 db1112:eswikivoyage
user_former_groups ufg_group field-size-mismatch s3 db1157:eswikivoyage
user_former_groups ufg_group field-size-mismatch s3 db1166:eswikivoyage
user_former_groups ufg_group field-size-mismatch s3 db1175:eswikivoyage
user_former_groups ufg_group field-size-mismatch s3 db1179:eswikivoyage
user_groups ug_group field-size-mismatch s3 db1112:aswikisource
user_groups ug_group field-size-mismatch s3 db1157:aswikisource
user_groups ug_group field-size-mismatch s3 db1166:aswikisource
user_groups ug_group field-size-mismatch s3 db1175:aswikisource
user_groups ug_group field-size-mismatch s3 db1179:aswikisource
user_groups ug_group field-size-mismatch s3 db1112:ptwikivoyage
user_groups ug_group field-size-mismatch s3 db1157:ptwikivoyage
user_groups ug_group field-size-mismatch s3 db1166:ptwikivoyage
user_groups ug_group field-size-mismatch s3 db1175:ptwikivoyage
user_groups ug_group field-size-mismatch s3 db1179:ptwikivoyage
user_groups ug_group field-size-mismatch s3 db1112:eswikivoyage
user_groups ug_group field-size-mismatch s3 db1157:eswikivoyage
user_groups ug_group field-size-mismatch s3 db1166:eswikivoyage
user_groups ug_group field-size-mismatch s3 db1175:eswikivoyage
user_groups ug_group field-size-mismatch s3 db1179:eswikivoyage

Event Timeline

alter table bot_passwords modify bp_user int unsigned NOT NULL;
alter table change_tag modify ct_tag_id INT UNSIGNED NOT NULL;

All user_former_groups drifts fixed

Marostegui claimed this task.

All user_groups drifts fixed.
This is all done

@Ladsgroup can you re-run the script for s3 so we can be fully sure?

I ran it again:

bot_passwords bp_user field-unsigned-mismatch s3 db1112:arbcom_dewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:arbcom_dewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:arbcom_dewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:arbcom_dewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:arbcom_dewiki

I ran it again:

bot_passwords bp_user field-unsigned-mismatch s3 db1112:arbcom_dewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1157:arbcom_dewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1166:arbcom_dewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1175:arbcom_dewiki
bot_passwords bp_user field-unsigned-mismatch s3 db1179:arbcom_dewiki
mysql:root@localhost [arbcom_dewiki]> alter table bot_passwords modify bp_user int unsigned NOT NULL;
Query OK, 0 rows affected (0.031 sec)
Records: 0  Duplicates: 0  Warnings: 0

Done on the master with replication.