Manual talk:FixDoubleRedirects.php

From mediawiki.org
Latest comment: 6 years ago by Varlin in topic Database error when using this script

I have read this manual, and I'm not really helped. Is there a way for users, admins, or anyone who doesn't have direct access to the server to use this script to fix double redirects?Joeytje50 (talk) 09:31, 31 May 2012 (UTC)Reply

Extension:MaintenanceShell --wargo (talk) 15:06, 31 May 2012 (UTC)Reply

Database error when using this script[edit]

Hi, I have lots of double redirections on my wiki, and I'm trying to use this script via maintenance shell extension, but I get databse errors. For example, when launching the script on the page "Blanquisme", I get this output.

[WiWExuI7zJQcDMbmg4Q7ZwAAAU4] /Sp%C3%A9cial:MaintenanceShell Wikimedia\Rdbms\DBQueryError from line 1075 of /var/www/vhosts/wikirouge.net/public_html/wiki/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 
Query: SELECT page_latest FROM `page` WHERE page_id = '2490' AND page_namespace = '0' AND page_title = 'Blanquiste' LIMIT 1 FOR UPDATE 
Function: WikiPage::lockAndGetLatest 
Error: 1205 Lock wait timeout exceeded; try restarting transaction (sql-10.proxgroup.fr:3306) 

Backtrace: 
#0 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/libs/rdbms/database/Database.php(933): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean) 
#1 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/libs/rdbms/database/Database.php(1269): Wikimedia\Rdbms\Database->query(string, string) 
#2 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/libs/rdbms/database/Database.php(1095): Wikimedia\Rdbms\Database->select(string, string, array, string, array) 
#3 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/page/WikiPage.php(2930): Wikimedia\Rdbms\Database->selectField(string, string, array, string, array) 
#4 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/page/WikiPage.php(1701): WikiPage->lockAndGetLatest() 
#5 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/page/WikiPage.php(1619): WikiPage->doModify(WikitextContent, integer, User, string, array) 
#6 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/jobqueue/jobs/DoubleRedirectJob.php(171): WikiPage->doEditContent(WikitextContent, string, integer, boolean, User) 
#7 /var/www/vhosts/wikirouge.net/public_html/wiki/maintenance/fixDoubleRedirects.php(108): DoubleRedirectJob->run() 
#8 /var/www/vhosts/wikirouge.net/public_html/wiki/extensions/MaintenanceShell/includes/SpecialMaintenanceShell.php(159): FixDoubleRedirects->execute() 
#9 /var/www/vhosts/wikirouge.net/public_html/wiki/extensions/MaintenanceShell/includes/SpecialMaintenanceShell.php(94): SpecialMaintenanceShell->mainshellExec(string, string) 
#10 [internal function]: SpecialMaintenanceShell->onSubmit(array, HTMLForm) 
#11 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/htmlform/HTMLForm.php(663): call_user_func(array, array, HTMLForm) 
#12 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/htmlform/HTMLForm.php(555): HTMLForm->trySubmit()
#13 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/htmlform/HTMLForm.php(570): HTMLForm->tryAuthorizedSubmit() 
#14 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/specialpage/FormSpecialPage.php(155): HTMLForm->show() 
#15 /var/www/vhosts/wikirouge.net/public_html/wiki/extensions/MaintenanceShell/includes/SpecialMaintenanceShell.php(19): FormSpecialPage->execute(NULL) 
#16 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/specialpage/SpecialPage.php(522): SpecialMaintenanceShell->execute(NULL) 
#17 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/specialpage/SpecialPageFactory.php(578): SpecialPage->run(NULL) 
#18 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/MediaWiki.php(287): SpecialPageFactory::executePath(Title, RequestContext) 
#19 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/MediaWiki.php(862): MediaWiki->performRequest() 
#20 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/MediaWiki.php(523): MediaWiki->main() 
#21 /var/www/vhosts/wikirouge.net/public_html/wiki/index.php(43): MediaWiki->run() 
#22 {main}

Any idea ? I already tried to launch update.php, but it did not help. --Varlin (talk) 18:29, 4 December 2017 (UTC)Reply