Hi,
I recently updated my Wiki from version 1.17 to 1.19. Since then, I have problems with the generation of the search index for MWSearch: very often and at random points after the Lucene build-script called dumpBackup.php, the database (mysql) 'stalls', the script stops with "A database error has occurred." and the wiki is not working anymore. I have to restart the mysql server to get the wiki running again.
Code: echo "Dumping $dbname..." cd $mediawiki && php maintenance/dumpBackup.php \ $dbname \ --conf $mediawiki/LocalSettings.php \ --aconf $mediawiki/AdminSettings.php \ --current \ --server=$slave > $dumpfile
All extensions (incl. MWSearch) are up-to-date, the Lucene scripts are updated, I updated the database after the upgrade (update.php) and the database is fine, no errors reported by the appropriate tools.
Running dumpBackup.php (without slave and conf) from the command line works fine.
Thanks for any help, Udo
On 22/07/12 14:39, Udo wrote:
Hi,
I recently updated my Wiki from version 1.17 to 1.19. Since then, I have problems with the generation of the search index for MWSearch: very often and at random points after the Lucene build-script called dumpBackup.php, the database (mysql) 'stalls', the script stops with "A database error has occurred." and the wiki is not working anymore. I have to restart the mysql server to get the wiki running again.
What's the listed database error? What's shown wen you issue SHOW PROCESSLIST to the stalled mysqld?
Hi,
unfortunatly, I have only limited access to log files. I can only find a PHP Fatal error: Call to a member function isDisabled() on a non-object in xyz/includes/db/DatabaseError.php on line 231 (not sure, whether taht is result of me restarting mysql) and dumpBackup.php shows: A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org /wiki/Manual:Upgrading#Run_the_update_script Query: SELECT page_id,page_len,page_is_redirect,page_latest FROM `page` WHERE page_namespace = '0' AND page_title = 'E15' LIMIT 1 Function: LinkCache::addLinkObj
Of course, I did run update.php (a few times).
Well, when Lucene/dumpBackup stalls, the mysql server obviously is not out completely; a forum and another wiki on the same server still work fine. Just the wiki with MWSearch does not work at all and I have to restart mysql to get it working again.
Udo
On 22/07/12 20:55, Udo wrote:
Hi,
unfortunatly, I have only limited access to log files. I can only find a PHP Fatal error: Call to a member function isDisabled() on a non-object in xyz/includes/db/DatabaseError.php on line 231 (not sure, whether taht is result of me restarting mysql) and dumpBackup.php shows: A database error has occurred.
That is a call to $wgOut->isDisabled(). Seems $wgOut wasn't set at that point.
Query: SELECT page_id,page_len,page_is_redirect,page_latest FROM `page` WHERE page_namespace = '0' AND page_title = 'E15' LIMIT 1 Function: LinkCache::addLinkObj
That sentence should be perfectly fine. Don't you have an error code and/or description? (such as 'server timeout')
Of course, I did run update.php (a few times).
Most SQL errors are due to having an old database schema (thus the suggestion of update.php), but it's not your case.
Well, when Lucene/dumpBackup stalls, the mysql server obviously is not out completely; a forum and another wiki on the same server still work fine. Just the wiki with MWSearch does not work at all and I have to restart mysql to get it working again.
I suspect there is some deadlock there. Can you please run SHOW PROCESSLIST to the database when it doesn't answer to the wiki?
mediawiki-l@lists.wikimedia.org