After T163337: Job queue corruption after codfw switch over (Queue growth, duplicate runs) I think it's important to deploy these constraints.
- The patch
- Wikis to run: enwiki, wikidatawiki, fawiki, ruwiki, plwiki, nlwiki, trwiki, ptwiki (cswiki, etwiki, hewiki already have them)
- Before running it, we should run a maintenance script to clean up possible duplicates otherwise the alter table might fail.
- The change is backward compatible and tested
- The whole table is public so no need to worry about data leak in labs replicas
One thing that I'm worried about is if we apply these changes and jobrunner goes crazy again we might end up with a huge pile of log spam of database error. How to address that, I don't know