>> Also several times I got some sort of internal database errors when using >> Special:WhatLinksHere.
>That shouldn't happen. What sort of things were you doing when the error >happened? I found how to reproduce the database errors I mentioned earlier. Both https://commons.wikimedia.org/w/index.php?title=Special%3AWhatLinksHere&target=Template%3ALocation%2Flayout&namespace=10 and https://commons.wikimedia.org/w/index.php?title=Special%3AWhatLinksHere&target=Module%3AFallbacklist&namespace=828 gave me Database error A database query error has occurred. This may indicate a bug in the software. Function: SpecialWhatLinksHere::showIndirectLinks Error: 0 Jarek T. (user:jarekt <http://commons.wikimedia.org/wiki/User:Jarekt> ) -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of bawolff Sent: Monday, January 27, 2014 6:50 PM To: Wikimedia developers Subject: Re: [Wikitech-l] Template transclusion on Wikimedia Commons On Mon, Jan 27, 2014 at 2:12 PM, Tuszynski, Jaroslaw W. <[email protected] <mailto:[email protected]> > wrote: > I lately switched Commons coordinate template > https://commons.wikimedia.org/wiki/Template:Location > <https://commons.wikimedia.org/wiki/Template:Location> from using dozens > of subtemplates to much cleaner Lua code. Everything works great, > except for Special:WhatLinksHere links. The no longer used > subtemplates like > https://commons.wikimedia.org/wiki/Template:Location/layout > <https://commons.wikimedia.org/wiki/Template:Location/layout> still show > over 3M files transcluding it and files, like > https://commons.wikimedia.org/wiki/File:Estadio_Pacaembu.jpg > <https://commons.wikimedia.org/wiki/File:Estadio_Pacaembu.jpg> which > still claims to transclude [[Template:Location/layout]] ("Templates > used on this page:" section in edit mode). The transclusion > dependencies do not correct themselves even with a Purge, but page > edit fixes it. Also several times I got some sort of internal database errors > when using Special:WhatLinksHere. > > > > In the past when I run into this kind of trouble I waited, but in some > cases it took over half a year for the database to update itself. In > other cases those issues never clear (or I did not wait long enough), > like with Category:Pages with malformed coordinate tags > <https://commons.wikimedia.org/wiki/Category:Pages_with_malformed_coor > di nate_tags> , which due to a long fixed bug in {{#coordinates: > <https://www.mediawiki.org/wiki/Extension:GeoData > <https://www.mediawiki.org/wiki/Extension:GeoData> > }} was filled with > 40k files which did not have any issues. Then the only solution I know > is Pywikibot/touch.py > (https://www.mediawiki.org/wiki/Manual:Pywikipediabot/touch.py > <https://www.mediawiki.org/wiki/Manual:Pywikipediabot/touch.py> ), > which I recently used to clear {{#coordinates: > <https://www.mediawiki.org/wiki/Extension:GeoData > <https://www.mediawiki.org/wiki/Extension:GeoData> > }} issues. > > > > Is there a better way to synchronize database with reality? > > > > > > Jarek T. > > (user:jarekt <http://commons.wikimedia.org/wiki/User:Jarekt > <http://commons.wikimedia.org/wiki/User:Jarekt> > ) > > > > > > _______________________________________________ > Wikitech-l mailing list > [email protected] <mailto:[email protected]> > https://lists.wikimedia.org/mailman/listinfo/wikitech-l > <https://lists.wikimedia.org/mailman/listinfo/wikitech-l> It takes a lot of work to reparse 4 million pages. If it makes you feel better, the toolserver transclusion count you linked to is about 20000 pages higher than the real number of transclusions. >but in some > cases it took over half a year for the database to update itself If something is taking 6 months, it probably means that some sort of bug happened, and the pages aren't being refreshed at all. > The transclusion dependencies do > not correct themselves even with a Purge, but page edit fixes it. Yes, null edits update links tables (e.g. Categories, whatlinkshere, Special:LinkSearch, etc) purges do not. > Also > several times I got some sort of internal database errors when using > Special:WhatLinksHere. That shouldn't happen. What sort of things were you doing when the error happened? --bawolff _______________________________________________ Wikitech-l mailing list [email protected] <mailto:[email protected]> https://lists.wikimedia.org/mailman/listinfo/wikitech-l <https://lists.wikimedia.org/mailman/listinfo/wikitech-l> _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
