Manual talk:UpdateSearchIndex.php

I came here to report the bug but I see too many other people reported it already.

When this bug will be fixed? Any estimated time?

There's only one message in addition to the one you posted, and the bug in Phabricator linked from the other thread is closed as invalid, so apparently there's no bug here.

@Ciencia Al Poder Right now I am getting that error message with the latest clean and un-customized version. So this bug still exists.

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.