Page MenuHomePhabricator

Normalize imagelinks table
Closed, ResolvedPublic

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
operations/mediawiki-configmaster+0 -5
mediawiki/coremaster+20 -101
mediawiki/coremaster+210 -48
mediawiki/corewmf/1.46.0-wmf.18+2 -2
mediawiki/coremaster+2 -2
mediawiki/coremaster+34 -17
mediawiki/coremaster+9 -20
mediawiki/coremaster+10 -22
mediawiki/extensions/GlobalUsagemaster+7 -19
mediawiki/coremaster+78 -198
mediawiki/coremaster+17 -0
mediawiki/coremaster+6 -10
mediawiki/coremaster+266 -11
mediawiki/coremaster+31 -3
operations/puppetproduction+1 -0
mediawiki/coremaster+79 -33
operations/mediawiki-configmaster+5 -0
mediawiki/coremaster+38 -29
mediawiki/coremaster+11 -15
mediawiki/coremaster+2 -1
mediawiki/coremaster+62 -34
mediawiki/extensions/GlobalUsagemaster+34 -19
mediawiki/coremaster+9 -1
mediawiki/coremaster+35 -11
mediawiki/coremaster+20 -9
mediawiki/coremaster+104 -33
mediawiki/coremaster+269 -0
Show related patches Customize query in gerrit

Related Objects

StatusSubtypeAssignedTask
ResolvedLadsgroup
ResolvedZabe
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedZabe
ResolvedZabe
ResolvedZabe
ResolvedZabe
DeclinedPRODUCTION ERRORNone
DeclinedPRODUCTION ERRORNone
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedMarostegui
ResolvedZabe
ResolvedSnwachukwu
ResolvedZabe
ResolvedPRODUCTION ERRORZabe
OpenFCeratto-WMF
OpenFCeratto-WMF

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes

Change #1222593 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] Also write to il_target_id when imagelinks is set to write both

https://gerrit.wikimedia.org/r/1222593

Change #1222595 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] Add imagelinks read new support to query pages

https://gerrit.wikimedia.org/r/1222595

Change #1222596 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] maintenance: Add support for imagelinks read new

https://gerrit.wikimedia.org/r/1222596

Change #1222593 merged by jenkins-bot:

[mediawiki/core@master] Also write to il_target_id when imagelinks is set to write both

https://gerrit.wikimedia.org/r/1222593

Change #1222602 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] Run imagelinks migration for third parties

https://gerrit.wikimedia.org/r/1222602

Change #1222603 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] Update imagelinks primary key

https://gerrit.wikimedia.org/r/1222603

Change #1221092 merged by jenkins-bot:

[mediawiki/core@master] ApiQueryBacklinksprop: Add support for imagelinks read new

https://gerrit.wikimedia.org/r/1221092

Change #1222596 merged by jenkins-bot:

[mediawiki/core@master] maintenance: Add support for imagelinks read new

https://gerrit.wikimedia.org/r/1222596

Change #1221096 merged by jenkins-bot:

[operations/mediawiki-config@master] Pin imagelinks migration to old schema

https://gerrit.wikimedia.org/r/1221096

Mentioned in SAL (#wikimedia-operations) [2026-01-05T09:15:41Z] <zabe@deploy2002> Started scap sync-world: Backport for [[gerrit:1221096|Pin imagelinks migration to old schema (T299953)]]

Mentioned in SAL (#wikimedia-operations) [2026-01-05T09:17:47Z] <zabe@deploy2002> zabe: Backport for [[gerrit:1221096|Pin imagelinks migration to old schema (T299953)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Mentioned in SAL (#wikimedia-operations) [2026-01-05T09:22:36Z] <zabe@deploy2002> Finished scap sync-world: Backport for [[gerrit:1221096|Pin imagelinks migration to old schema (T299953)]] (duration: 06m 55s)

Change #1222595 merged by jenkins-bot:

[mediawiki/core@master] Add imagelinks read new support to query pages

https://gerrit.wikimedia.org/r/1222595

Change #1229221 had a related patch set uploaded (by Zabe; author: Zabe):

[operations/puppet@production] Add il_target_id to wiki replicas

https://gerrit.wikimedia.org/r/1229221

Change #1229221 merged by FNegri:

[operations/puppet@production] maintain-views: Show il_target_id references in linktarget

https://gerrit.wikimedia.org/r/1229221

Change #1230569 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] Drop support for imagelinks read old

https://gerrit.wikimedia.org/r/1230569

Change #1222602 merged by jenkins-bot:

[mediawiki/core@master] Run imagelinks migration for third parties

https://gerrit.wikimedia.org/r/1222602

Change #1222603 merged by jenkins-bot:

[mediawiki/core@master] Update imagelinks primary key

https://gerrit.wikimedia.org/r/1222603

Change #1237593 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] SpecialUnusedImages: Add missing file/imagelinks table support

https://gerrit.wikimedia.org/r/1237593

Change #1237593 merged by jenkins-bot:

[mediawiki/core@master] SpecialUnusedImages: Add missing file/imagelinks table support

https://gerrit.wikimedia.org/r/1237593

Change #1238066 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] LinksUpdate: Override fetchExistingRows for imagelinks

https://gerrit.wikimedia.org/r/1238066

Change #1238066 merged by jenkins-bot:

[mediawiki/core@master] LinksUpdate: Override fetchExistingRows for imagelinks

https://gerrit.wikimedia.org/r/1238066

Change #1230569 merged by jenkins-bot:

[mediawiki/core@master] Drop support for imagelinks read old

https://gerrit.wikimedia.org/r/1230569

Change #1239962 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/extensions/GlobalUsage@master] Drop support for imagelinks read old

https://gerrit.wikimedia.org/r/1239962

Change #1239962 merged by jenkins-bot:

[mediawiki/extensions/GlobalUsage@master] Drop support for imagelinks read old

https://gerrit.wikimedia.org/r/1239962

Change #1240322 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] ApiQueryBacklinksprop: Cleanup index handling

https://gerrit.wikimedia.org/r/1240322

Change #1240334 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] ApiQueryAllLinks: Post links migration cleanup

https://gerrit.wikimedia.org/r/1240334

Change #1240322 merged by jenkins-bot:

[mediawiki/core@master] ApiQueryBacklinksprop: Cleanup index handling

https://gerrit.wikimedia.org/r/1240322

Change #1240392 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] Set imagelinks migration to SCHEMA_COMPAT_NEW

https://gerrit.wikimedia.org/r/1240392

Change #1240393 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] Drop remaining imagelinks migration code

https://gerrit.wikimedia.org/r/1240393

Change #1240334 merged by jenkins-bot:

[mediawiki/core@master] ApiQueryAllLinks: Post links migration cleanup

https://gerrit.wikimedia.org/r/1240334

Change #1240392 merged by jenkins-bot:

[mediawiki/core@master] Set imagelinks migration to SCHEMA_COMPAT_NEW

https://gerrit.wikimedia.org/r/1240392

Change #1248165 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] SpecialWantedFiles: Use lt_title instead of lt_to

https://gerrit.wikimedia.org/r/1248165

Change #1248165 merged by jenkins-bot:

[mediawiki/core@master] SpecialWantedFiles: Use lt_title instead of lt_to

https://gerrit.wikimedia.org/r/1248165

Change #1248483 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@wmf/1.46.0-wmf.18] SpecialWantedFiles: Use lt_title instead of lt_to

https://gerrit.wikimedia.org/r/1248483

Change #1248483 merged by jenkins-bot:

[mediawiki/core@wmf/1.46.0-wmf.18] SpecialWantedFiles: Use lt_title instead of lt_to

https://gerrit.wikimedia.org/r/1248483

Mentioned in SAL (#wikimedia-operations) [2026-03-05T22:28:49Z] <zabe@deploy2002> Started scap sync-world: Backport for [[gerrit:1248483|SpecialWantedFiles: Use lt_title instead of lt_to (T299953)]]

Mentioned in SAL (#wikimedia-operations) [2026-03-05T22:30:37Z] <zabe@deploy2002> zabe: Backport for [[gerrit:1248483|SpecialWantedFiles: Use lt_title instead of lt_to (T299953)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Mentioned in SAL (#wikimedia-operations) [2026-03-05T22:35:01Z] <zabe@deploy2002> Finished scap sync-world: Backport for [[gerrit:1248483|SpecialWantedFiles: Use lt_title instead of lt_to (T299953)]] (duration: 06m 12s)

Change #1248863 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] Drop il_to from imagelinks table

https://gerrit.wikimedia.org/r/1248863

Change #1240393 merged by jenkins-bot:

[mediawiki/core@master] Drop remaining imagelinks migration code

https://gerrit.wikimedia.org/r/1240393

Change #1248863 merged by jenkins-bot:

[mediawiki/core@master] Drop il_to from imagelinks table

https://gerrit.wikimedia.org/r/1248863

Change #1250117 had a related patch set uploaded (by Zabe; author: Zabe):

[operations/mediawiki-config@master] Stop setting $wgImageLinksSchemaMigrationStage

https://gerrit.wikimedia.org/r/1250117

Change #1250117 merged by jenkins-bot:

[operations/mediawiki-config@master] Stop setting $wgImageLinksSchemaMigrationStage

https://gerrit.wikimedia.org/r/1250117

Mentioned in SAL (#wikimedia-operations) [2026-03-11T00:24:18Z] <zabe@deploy2002> Started scap sync-world: Backport for [[gerrit:1250117|Stop setting $wgImageLinksSchemaMigrationStage (T299953)]]

Mentioned in SAL (#wikimedia-operations) [2026-03-11T00:26:27Z] <zabe@deploy2002> zabe: Backport for [[gerrit:1250117|Stop setting $wgImageLinksSchemaMigrationStage (T299953)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Mentioned in SAL (#wikimedia-operations) [2026-03-11T00:33:56Z] <zabe@deploy2002> Finished scap sync-world: Backport for [[gerrit:1250117|Stop setting $wgImageLinksSchemaMigrationStage (T299953)]] (duration: 09m 38s)

FYI Extension:QuickInstantCommons is querying imagelinks directly and has started failing in patchdemo.

image.png (2×3 px, 1 MB)

We don't and won't update extension that are not deployed to wikimedia production. It is responsibility of people who maintain those to update their extensions. See also T299951#11520482

Zabe moved this task from In progress to Done on the DBA board.
Zabe removed a project: Patch-For-Review.

I see this nice task is resolved, and I see the column imagelinks.il_target_id in place in the replicas,

but I see no mention here:

https://www.mediawiki.org/wiki/Manual:Imagelinks_table

Is it known/desired? Thanks hackers :3

I see this nice task is resolved, and I see the column imagelinks.il_target_id in place in the replicas,

but I see no mention here:

https://www.mediawiki.org/wiki/Manual:Imagelinks_table

Is it known/desired? Thanks hackers :3

No it is not desired. Updated. :)

In the long-term, I really like to produce the documentation on-the-fly from the schema itself. https://going-merry.toolforge.org/?table=imagelinks has been my attempt of doing that. Maybe eventually in doc.wikimedia.org. One day.