It seems to me that certain changes on transcluded modules do not trigger cache invalidation properly on the stuff these modules are transcluded in.
See https://commons.wikimedia.org/wiki/Special:WantedCategories with a list of non existing categories following scheme 'Files with coordinates missing SDC location of creation (g° N, g°E)'. These cats contain altogether 1390000 Files that are not categorized correctly. The miscategorization was caused by changes in Module:Coordinates (see https://commons.wikimedia.org/w/index.php?title=Module:Coordinates&action=history) in May 2024, the first change it seems did trigger recategorization, while consecutive changes didn't. I would expect that the cache invalidation runs through these some million files in some days at most.
Proper categorization is done via Template:Location and Module:Coordinates, but is not reflected in the content of those categories. Touching files will solve the problem, but is quite tedious.
Something seems to be blocked.
Two requests:
- Can somebody invalidate cache directly on the database (for the files in the above mentioned categories)
- Fix the problem in the core software so that it works properly for future changes.