|Marostegui added a comment.|
This is not an easy change as it needs to be done directly on the master, or otherwise ids will not match.
The table is pretty small (23M on disk - 16224 rows) so it can probably be done directly on the master. I would still prefer to go for the approach we took for other similar changes like: change_tag, tag_summary and watchlist tables which is:
- Do the alter on codfw
- Wait for the DC failover
- Reimport the tables on eqiad.
I prefer that approach because:
-It is not an urgent request and failover might be happening on Q4, so not far away from now.
- I prefer avoid doing such changes (adding auto_inc columns) directly on the master and getting it replicated thru all the replication chain if there is an alternative way.
Cc: Marostegui, Ladsgroup, Aklapper, Jonas, thiemowmde, hoo, aude, gerritbot, Lucas_Werkmeister_WMDE, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Agabi10, Luke081515, Wikidata-bugs, Mbch331, Krenair
_______________________________________________ Wikidata-bugs mailing list Wikidataemail@example.com https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs