Last modified: 2014-10-25 13:16:47 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T65594, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 63594 - Global usage shows file usage on deleted pages
Global usage shows file usage on deleted pages
Status: REOPENED
Product: Wikimedia
Classification: Unclassified
Media storage (Other open bugs)
wmf-deployment
All All
: Normal major (vote)
: ---
Assigned To: Nobody - You can work on this!
: shell
: 72510 (view as bug list)
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-04-06 15:21 UTC by Steinsplitter
Modified: 2014-10-25 13:16 UTC (History)
12 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Steinsplitter 2014-04-06 15:21:37 UTC
Example:
https://beta.wikiversity.org/wiki/USA:s_presidenter is deleted, but See https://commons.wikimedia.org/w/index.php?title=Special%3AGlobalUsage&limit=500&target=Harry-truman.jpg says that it is "IN USE".

Pleas purge the Database.

Thank you.
Comment 1 Bawolff (Brian Wolff) 2014-04-06 18:23:29 UTC
Usually this is not an issue for other link tables, since we inner join on page, so its not noticeable.

As it stands, the only way to address the issue is to recreate the page in question, and then delete it.

We should probably
* Make the refreshlinks option of API purge kill all links if the page doesn't exist
* Possibly make normal purge on non-existent pages also do that (Not sure, normally we do not have purge touch the link tables, but to be fair purging images does really complex (and expensive) cache clearing, so it wouldn't be that different)
Comment 2 Steinsplitter 2014-04-07 08:35:28 UTC
This was a example. All databases are affected. This is a problem and should be fixed.
Comment 3 Steinsplitter 2014-04-08 09:14:18 UTC
A other exaple:
https://commons.wikimedia.org/w/index.php?title=Special%3AGlobalUsage&limit=50&target=Flag+of+Veneto.png

But the page on incubator.wikimedia.org is deleted.

A lotos of files are affected...
Comment 4 Steinsplitter 2014-04-08 09:29:08 UTC
MariaDB [commonswiki_p]> SELECT * FROM globalimagelinks WHERE gil_page_title = "USA:s_presidenter" AND gil_wiki = "betawikiversity";
I see only on this page ~50 affected files...
Global are thousands of files affected
Comment 5 Tisza Gergő 2014-05-14 18:43:01 UTC
Please see https://www.mediawiki.org/wiki/Bugzilla/Fields#Severity
If this is obstructing work in a major way, it is more helpful to give an explanation of how that happens.
Comment 6 Steinsplitter 2014-05-14 18:47:18 UTC
How long time do we need to wait @Tisza Gergő ...?

Restored prio, CC Erik. Major loss of function in an important area.
Comment 7 Tisza Gergő 2014-05-14 19:05:46 UTC
As I said, explaining how this is hindering your work or causing you problems is more helpful than playing around with severity flags (which does not cause bugs to magically fix themselves).
Comment 8 Steinsplitter 2014-05-14 19:07:16 UTC
It is a problem in DeletionRequests if nonexisting usage is schown, it is a problem for the GlobalBot Commons Delinker (flooding the error log)...

etc etc.  A experienced wikimedian schold know this.
Comment 9 Gerrit Notification Bot 2014-05-14 20:02:38 UTC
Change 133351 had a related patch set uploaded by Aaron Schulz:
Added a links refresh mode to fix links to deleted pages

https://gerrit.wikimedia.org/r/133351
Comment 10 Gerrit Notification Bot 2014-05-14 21:39:19 UTC
Change 133351 merged by jenkins-bot:
Added a links refresh mode to fix links to deleted pages

https://gerrit.wikimedia.org/r/133351
Comment 11 Aaron Schulz 2014-05-15 10:46:14 UTC
The script needs to actually be run. This bug can track that.
Comment 12 Steinsplitter 2014-10-25 13:16:47 UTC
*** Bug 72510 has been marked as a duplicate of this bug. ***

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links