Last modified: 2014-05-09 07:25:51 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 T65782, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 63782 - querycache and querycachetwo tables aren't available on labs sql dbs
querycache and querycachetwo tables aren't available on labs sql dbs
Status: NEW
Product: Wikimedia Labs
Classification: Unclassified
tools (Other open bugs)
unspecified
All All
: Unprioritized normal
: ---
Assigned To: Marc A. Pelletier
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-04-10 18:15 UTC by Bawolff (Brian Wolff)
Modified: 2014-05-09 07:25 UTC (History)
4 users (show)

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


Attachments

Description Bawolff (Brian Wolff) 2014-04-10 18:15:02 UTC
It would be cool if those tables could be made available. They essentially contain cached versions of special pages, which mostly isn't useful to people, but on occasion can be.


entries in querycache table with qc_type = Unwatchedpages, may be considered sensitive. Nothing else in these two tables is sensitive afaik.
Comment 1 Marc A. Pelletier 2014-05-06 01:36:30 UTC
This will require an okay from legal (though I do not anticipate difficulties).
Comment 2 Luis Villa (personal-for work use lvilla@wikimedia.org) 2014-05-07 18:03:27 UTC
Only concern that I can see is how often these get stale? is there any risk that a page with sensitive content would be suppressed or reverted but still available through the cache?
Comment 3 Bawolff (Brian Wolff) 2014-05-08 07:28:58 UTC
(In reply to Luis Villa (personal-for work use lvilla@wikimedia.org) from comment #2)
> Only concern that I can see is how often these get stale? is there any risk
> that a page with sensitive content would be suppressed or reverted but still
> available through the cache?

Yes. Most are updated once every 4 days, some take longer. But in that case i believe it would still be visible on main site (not 100% sure about that, but pretty sure)
Comment 4 Luis Villa (WMF Legal) 2014-05-08 16:49:21 UTC
You mean, we're still showing suppressed stuff on the main site in some cases? Or that more generally we may just have some stale caching around?
Comment 5 Bawolff (Brian Wolff) 2014-05-09 07:25:51 UTC
(In reply to Luis Villa (WMF Legal) from comment #4)
> You mean, we're still showing suppressed stuff on the main site in some
> cases? Or that more generally we may just have some stale caching around?

If someone deletes a page, (and then suppresses it or whatever) the page name may still appear on some list special pages for a bit of time - e.g. mostlinkedtopages and the like. However nobody can view the content of such a page, just that it was on the list

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


Navigation
Links