Topic on Manual talk:UpdateSearchIndex.php

php rebuild.php

[wikicod@server w]$ php maintenance/updateSearchIndex.php
Updating searchindex between 20191123051521 and 20191124051521
   --- Waiting for lock ---
[3bec6ba4db8187183ebfd1dc] [no req]   Wikimedia\Rdbms\DBQueryError from line 1587 of /home/wikicod/domains/wikicod.ir/public_html/rel_33/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  rev_id,rev_page,rev_timestamp,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,comment_rev_comment.comment_text AS `rev_comment_text`,comment_rev_comment.comment_data AS `rev_comment_data`,comment_rev_comment.comment_id AS `rev_comment_cid`,actor_rev_user.actor_user AS `rev_user`,actor_rev_user.actor_name AS `rev_user_text`,temp_rev_user.revactor_actor AS `rev_actor`,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name  FROM `revision` JOIN `revision_comment_temp` `temp_rev_comment` ON ((temp_rev_comment.revcomment_rev = rev_id)) JOIN `comment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) JOIN `revision_actor_temp` `temp_rev_user` ON ((temp_rev_user.revactor_rev = rev_id)) JOIN `actor` `actor_rev_user` ON ((actor_rev_user.actor_id = temp_rev_user.revactor_actor)) JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((actor_rev_user.actor_user != 0) AND (user_id = actor_rev_user.actor_user))   WHERE rev_page = '156' AND page_id = '156' AND (rev_id=page_latest)  LIMIT 1
Function: MediaWiki\Revision\RevisionStore::fetchRevisionRowFromConds
Error: 1100 Table 'temp_rev_comment' was not locked with LOCK TABLES (localhost)

Backtrace:
#0 /home/wikicod/domains/wikicod.ir/public_html/rel_33/includes/libs/rdbms/database/Database.php(1556): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#1 /home/wikicod/domains/wikicod.ir/public_html/rel_33/includes/libs/rdbms/database/Database.php(1274): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#2 /home/wikicod/domains/wikicod.ir/public_html/rel_33/includes/libs/rdbms/database/Database.php(1784): Wikimedia\Rdbms\Database->query(string, string)
#3 /home/wikicod/domains/wikicod.ir/public_html/rel_33/includes/libs/rdbms/database/Database.php(1875): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#4 /home/wikicod/domains/wikicod.ir/public_html/rel_33/includes/Revision/RevisionStore.php(2225): Wikimedia\Rdbms\Database->selectRow(array, array, array, string, array, array)
#5 /home/wikicod/domains/wikicod.ir/public_html/rel_33/includes/Revision/RevisionStore.php(2154): MediaWiki\Revision\RevisionStore->fetchRevisionRowFromConds(Wikimedia\Rdbms\DatabaseMysqli, array, integer)
#6 /home/wikicod/domains/wikicod.ir/public_html/rel_33/includes/Revision/RevisionStore.php(2033): MediaWiki\Revision\RevisionStore->loadRevisionFromConds(Wikimedia\Rdbms\DatabaseMysqli, array)
#7 /home/wikicod/domains/wikicod.ir/public_html/rel_33/includes/Revision.php(261): MediaWiki\Revision\RevisionStore->loadRevisionFromPageId(Wikimedia\Rdbms\DatabaseMysqli, string, integer)
#8 /home/wikicod/domains/wikicod.ir/public_html/rel_33/maintenance/Maintenance.php(1520): Revision::loadFromPageId(Wikimedia\Rdbms\DatabaseMysqli, string)
#9 /home/wikicod/domains/wikicod.ir/public_html/rel_33/maintenance/updateSearchIndex.php(120): Maintenance->updateSearchIndexForPage(Wikimedia\Rdbms\DatabaseMysqli, string)
#10 /home/wikicod/domains/wikicod.ir/public_html/rel_33/maintenance/Maintenance.php(1501): UpdateSearchIndex->searchIndexUpdateCallback(Wikimedia\Rdbms\DatabaseMysqli, stdClass)
#11 /home/wikicod/domains/wikicod.ir/public_html/rel_33/maintenance/updateSearchIndex.php(114): Maintenance->updateSearchIndex(integer, array, Wikimedia\Rdbms\DatabaseMysqli, Wikimedia\Rdbms\ResultWrapper)
#12 /home/wikicod/domains/wikicod.ir/public_html/rel_33/maintenance/updateSearchIndex.php(80): UpdateSearchIndex->doUpdateSearchIndex(string, string, integer)
#13 /home/wikicod/domains/wikicod.ir/public_html/rel_33/maintenance/doMaintenance.php(96): UpdateSearchIndex->execute()
#14 /home/wikicod/domains/wikicod.ir/public_html/rel_33/maintenance/updateSearchIndex.php(125): require_once(string)
#15 {main}
[wikicod@server w]$

Can you try again? Apparently this can happen if there are other concurrent requests on the wiki querying (and potentially updating) revisions

Thanks for your answer

Unfortunately, trying again has no benefit@Ciencia Al Poder

The only thing I can recommend is to bugreport it

Of course I also reported to the support desk

The full text is available

https://www.mediawiki.org/w/index.php?title=Topic:Vbps68wp2h51ifg6&fromnotif=1#flow-post-vbptd5g6wnhego3k

Please also report

Thanks@Ciencia Al Poder

Most developers don't read the support desk. Bugs should be reported on phabricator.

I'm not sure if reporting the same thing in three different places is a good use of anyone's time... :)

See also https://phabricator.wikimedia.org/T239086 or https://www.mediawiki.org/wiki/Topic:Vbps68wp2h51ifg6

Yes, I'd like to report, but unfortunately I have blocked my username @Ciencia Al Poder

For the records, the Phab account https://phabricator.wikimedia.org/p/SokoteZaman/ got blocked as that account created 20 Phabricator tasks in a short timeframe, and 16 out of those 20 tasks made no sense and hence got closed as invalid by others.

It looks like the sockpuppet Phab account https://phabricator.wikimedia.org/p/Mahdi_Alavi_sokot/ got created to report https://phabricator.wikimedia.org/T239086 and to circumvent that account block.

Did you ever manage to fix this one, I have exactly the same issue ?!

See https://www.mediawiki.org/wiki/Topic:Vbps68wp2h51ifg6 as @Sokote zaman posted this in three different places for no reason.