Topic on Talk:Quarry

Is site_stats protected now?

3
Summary by BDavis (WMF)

The site_stats view was broken by a column change in the backing table, but this has been fixed. See phab:T210481 for more details.

Andreyyshore (talkcontribs)

Since my statistics bot failed to run today, I noticed that I can't access the site_stats table on any wiki.

Here's a simple query that doesn't work anymore as of today:

USE rowiki_p;

DESCRIBE site_stats;

This yields the following error: View 'rowiki_p.site_stats' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

If I use SHOW TABLES FROM rowiki_p;, I can see that the table still exists. I was using it to get the total number of edits on rowiki.

Any idea why it's suddenly inaccessible?

Framawiki (talkcontribs)

Hi, that is not limited to Quarry but to the whole wmf labs replicas, and the restriction was not intentional. See phab:T210481.

Andreyyshore (talkcontribs)

Thanks for clarifying where the problem was.

Like the other commenters, I can also confirm that the problem is gone now.