Some wikis still have rev_id,rev_user as PK.
That is wrong and can also lead to errors as: T238966#6356483
frwiktionary is definitely affected on some hosts (not all).
Affected wikis/hosts:
s1 nothing
s2 nothing
s3 nothing
s4 nothing
s5 nothing
s6 nothing
s7 (only frwiktionary):
s8 nothing
s10 nothing
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | daniel | T161671 Compacting the revision table | |||
| Resolved | None | T227047 Complete actor table and comment table migration | |||
| Resolved | None | T215466 Remove revision_comment_temp and revision_actor_temp | |||
| Resolved | RLazarus | T243314 FY2020-2021 Q1 DC switchover and switchback | |||
| Resolved | RLazarus | T243318 FY2020-2021 Q1 codfw -> eqiad switchback | |||
| Resolved | Marostegui | T238966 Apply updates for MCR, actor migration, and content migration, to production wikis. | |||
| Resolved | Marostegui | T259524 Review revision table and make sure that the PK is always rev_id |
Mentioned in SAL (#wikimedia-operations) [2020-08-03T15:27:36Z] <marostegui> Change PK on frwiktionary.revision on db2087:3317, db2129, db2121 db2086:3317 T259524
@Marostegui the timing of this issue seems to match T259520: Lots of Wikimedia\Rdbms\LoadBalancer::pickReaderIndex: all replica DBs lagged. Switch to read-only mode
Do you think this was the cause?
Mentioned in SAL (#wikimedia-operations) [2020-08-04T10:00:35Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depool db1101:3317 for MCR and PK change T259524', diff saved to https://phabricator.wikimedia.org/P12156 and previous config saved to /var/cache/conftool/dbconfig/20200804-100035-marostegui.json
This is all done
# /home/marostegui/section s7 | while read host port; do mysql.py -h$host:$port frwiktionary -e "show create table revision\G" | grep PRIMARY | grep rev_user ; done #