Page MenuHomePhabricator

XTools:500 error
Closed, ResolvedPublicBUG REPORT

Description

/var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php: 110 - An exception occurred while executing 'SET STATEMENT max_statement_time = 600 FORSELECT page_namespace, COUNT(rev_id) AS total            FROM `zhwiktionary_p`.`page` p JOIN `zhwiktionary_p`.`revision_userindex` r ON (r.rev_page = p.page_id)                        WHERE r.rev_actor = ?            GROUP BY page_namespace' with params [117869]:SQLSTATE[HY000]: General error: 1356 View 'zhwiktionary_p.page' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

URL: https://xtools.wmflabs.org/ec-namespacetotals/zh.wiktionary.org/DinoWP

Please provide any further details here

XTools version: 3.15.0-fd260c37

Event Timeline

/var/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php: 110 - An exception occurred while executing 'SET STATEMENT max_statement_time = 600 FOR            SELECT YEAR(rev_timestamp) AS `year`,                MONTH(rev_timestamp) AS `month`,                page_namespace,                COUNT(rev_id) AS `count`            FROM `zhwikivoyage_p`.`revision_userindex` JOIN `zhwikivoyage_p`.`page` ON (rev_page = page_id)                        WHERE rev_actor = ?            GROUP BY YEAR(rev_timestamp), MONTH(rev_timestamp), page_namespace' with params [27266]:SQLSTATE[HY000]: General error: 1356 View 'zhwikivoyage_p.page' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

URL: https://xtools.wmflabs.org/ec-yearcounts/zh.wikivoyage.org/SD_hehua

Please provide any further details here

XTools version: 3.15.0-fd260c37

Another error (seems similar) happened on my page of zh.wikivoyage.

SD_hehua renamed this task from XTools met a 500 error on a user's page of zh.wiktionary to XTools:500 error.May 30 2022, 1:18 PM
SD_hehua changed the subtype of this task from "Task" to "Bug Report".
MariaDB [zhwiktionary_p]> select * from page limit 10;
ERROR 1356 (HY000): View 'zhwiktionary_p.page' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

Similar to T309439

Stang closed this task as a duplicate of T309530: XTools 500: Internal Server Error.
Stang added a subscriber: Butko.

I am recreating all the views on s3 for the page table

For what is worth this is caused by a schema change that is being run in production: T60674