Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Increase value of max_statement_time in DB #6

Open
cicalese opened this issue Apr 1, 2023 · 0 comments
Open

Increase value of max_statement_time in DB #6

cicalese opened this issue Apr 1, 2023 · 0 comments

Comments

@cicalese
Copy link
Contributor

cicalese commented Apr 1, 2023

https://wikiapiary.com/w/api.php?action=query&format=json&meta=siteinfo&siprop=statistics reports that WikiApiary has 937,634 pages and 2,530,184 articles. It does not make sense that articles > pages. So, I tried to run maintenance/initSiteStats.php, in the hopes that it is the correct script to run in this condition and that it might help. However, I get:

php maintenance/initSiteStats.php 
Refresh Site Statistics

Counting total edits...10121971
Counting number of articles...Wikimedia\Rdbms\DBQueryTimeoutError from line 1614 of /var/www/wikiapiary/www/mediawiki/public_html/w/includes/libs/rdbms/database/Database.php: A database query timeout has occurred. 
Query: SELECT  COUNT(DISTINCT page_id)  FROM `page`,`pagelinks`    WHERE page_namespace IN (0,800,802,804,808,810,812)  AND page_is_redirect = 0 AND (pl_from=page_id)  LIMIT 1  
Function: SiteStatsInit::articles
Error: 1969 Query execution was interrupted (max_statement_time exceeded)

The same error is seen in the logs frequently for Semantic MediaWiki queries.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant