These columns were added, but we need a maintenance script to backfill this data from the existing information if we want to make use of these columns.
Description
Details
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Restricted Task | |||||
| Open | None | T350816 Special:Transcode_statistics is very slow to load on Commons, cuts off lots of info | |||
| Open | None | T112931 Improve readability, reliability of Special:TimedMediaHandler reports | |||
| Open | Feature | None | T43867 Show active transcodes counts on Special:TimedMediaHandler | ||
| Open | None | T414419 Transcode table should refer to file id | |||
| Open | bvibber | T362123 Retool transcode table with a status column | |||
| Resolved | Zabe | T415064 Backfill new status and touched columns |
Event Timeline
Change #1229613 had a related patch set uploaded (by Zabe; author: Zabe):
[mediawiki/extensions/TimedMediaHandler@master] Add script for populating transcode state columns
Change #1229613 had a related patch set uploaded (by Zabe; author: Zabe):
[mediawiki/extensions/TimedMediaHandler@master] Add script for populating transcode state columns
Change #1229613 merged by jenkins-bot:
[mediawiki/extensions/TimedMediaHandler@master] Add script for populating transcode state columns
Mentioned in SAL (#wikimedia-operations) [2026-02-16T19:07:35Z] <zabe> zabe@deploy2002:~$ mwscript extensions/TimedMediaHandler/maintenance/migrateTranscodeStates.php testwiki --force # T415064
Change #1239759 had a related patch set uploaded (by Zabe; author: Zabe):
[mediawiki/extensions/TimedMediaHandler@master] migrateTranscodeStates: Avoid skipping rows
Change #1239759 merged by jenkins-bot:
[mediawiki/extensions/TimedMediaHandler@master] migrateTranscodeStates: Avoid skipping rows
hmm. why are these new columns not available in quarry ? maintain views seems to not have anything specific for this table as far as I can see... does the cookbook simply have to be run for it to be aware ?
I'd assume. @fnegri could you run the update-views cookbook for the transcode table?
Cookbook cookbooks.sre.wikireplicas.update-views run by ladsgroup: Started updating wiki replica views
Cookbook cookbooks.sre.wikireplicas.update-views started by ladsgroup completed:
- an-redacteddb1001.eqiad.wmnet (PASS)
- Ran Puppet agent
- Ran 'maintain-views --replace --auto-depool --all-databases --table transcode'
- clouddb1017.eqiad.wmnet (PASS)
- Ran Puppet agent
- Ran 'maintain-views --replace --auto-depool --all-databases --table transcode'
- clouddb1018.eqiad.wmnet (PASS)
- Ran Puppet agent
- Ran 'maintain-views --replace --auto-depool --all-databases --table transcode'
- clouddb1019.eqiad.wmnet (PASS)
- Ran Puppet agent
- Ran 'maintain-views --replace --auto-depool --all-databases --table transcode'
- clouddb1020.eqiad.wmnet (PASS)
- Ran Puppet agent
- Ran 'maintain-views --replace --auto-depool --all-databases --table transcode'
- clouddb1023.eqiad.wmnet (PASS)
- Ran Puppet agent
- Ran 'maintain-views --replace --auto-depool --all-databases --table transcode'
- clouddb1025.eqiad.wmnet (PASS)
- Ran Puppet agent
- Ran 'maintain-views --replace --auto-depool --all-databases --table transcode'
- clouddb1013.eqiad.wmnet (PASS)
- Ran Puppet agent
- Ran 'maintain-views --replace --auto-depool --all-databases --table transcode'
- clouddb1014.eqiad.wmnet (PASS)
- Ran Puppet agent
- Ran 'maintain-views --replace --auto-depool --all-databases --table transcode'
- clouddb1015.eqiad.wmnet (PASS)
- Ran Puppet agent
- Ran 'maintain-views --replace --auto-depool --all-databases --table transcode'
- clouddb1016.eqiad.wmnet (PASS)
- Ran Puppet agent
- Ran 'maintain-views --replace --auto-depool --all-databases --table transcode'
- clouddb1022.eqiad.wmnet (PASS)
- Ran Puppet agent
- Ran 'maintain-views --replace --auto-depool --all-databases --table transcode'
- clouddb1024.eqiad.wmnet (PASS)
- Ran Puppet agent
- Ran 'maintain-views --replace --auto-depool --all-databases --table transcode'
Change #1240292 had a related patch set uploaded (by Zabe; author: Zabe):
[mediawiki/extensions/TimedMediaHandler@master] Add migrateTranscodeStates.php to schema updates
Mentioned in SAL (#wikimedia-operations) [2026-02-18T15:36:59Z] <zabe> zabe@deploy2002:~$ mwscript extensions/TimedMediaHandler/maintenance/migrateTranscodeStates.php mediawikiwiki # T415064
Change #1240292 merged by jenkins-bot:
[mediawiki/extensions/TimedMediaHandler@master] Add migrateTranscodeStates.php to schema updates
Mentioned in SAL (#wikimedia-operations) [2026-02-25T00:11:46Z] <zabe> zabe@deploy2002:~$ foreachwiki extensions/TimedMediaHandler/maintenance/migrateTranscodeStates.php # T415064
There are a handful of cases which are currently not handled by the migration script.
Change #1246098 had a related patch set uploaded (by Zabe; author: Zabe):
[mediawiki/extensions/TimedMediaHandler@master] migrateTranscodeStates: Set status for bugged edge cases
Change #1246098 merged by jenkins-bot:
[mediawiki/extensions/TimedMediaHandler@master] migrateTranscodeStates: Set status for bugged edge cases
Mentioned in SAL (#wikimedia-operations) [2026-03-06T02:21:44Z] <zabe> zabe@deploy2002:/srv/mediawiki-staging$ foreachwiki extensions/TimedMediaHandler/maintenance/migrateTranscodeStates.php --force # T415064
wikiadmin2023@10.192.16.46(commonswiki)> select count(*) from transcode where transcode_state is null; +----------+ | count(*) | +----------+ | 0 | +----------+ 1 row in set (0.001 sec) wikiadmin2023@10.192.16.46(commonswiki)>
