Manual talk:UpdateSearchIndex.php

please help me

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]$

Sokote zaman (talk) 05:25, 24 November 2019 (UTC)

Can you try again? Apparently this can happen if there are other concurrent requests on the wiki querying (and potentially updating) revisions Ciencia Al Poder (talk) 10:16, 25 November 2019 (UTC)

Thanks for your answer

Unfortunately, trying again has no benefit@Ciencia Al Poder Sokote zaman (talk) 10:19, 25 November 2019 (UTC)

The only thing I can recommend is to bugreport it Ciencia Al Poder (talk) 10:20, 25 November 2019 (UTC)

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 Sokote zaman (talk) 10:25, 25 November 2019 (UTC)

Note added by Pppery - the above Flow post link was not converted to wikitext because it is corrupt and not pointing to a valid post. * Pppery * _{it has begun} 01:34, 27 March 2025 (UTC)

Most developers don't read the support desk. Bugs should be reported on phabricator. Ciencia Al Poder (talk) 10:38, 25 November 2019 (UTC)

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/Project%3ASupport%20desk/Flow/2019/11#h-Search_error_creating_custom_namespaces-2019-11-24T17%3A40%3A00.000Z AKlapper (WMF) (talk) 18:23, 25 November 2019 (UTC)

Yes, I'd like to report, but unfortunately I have blocked my username @Ciencia Al Poder Sokote zaman (talk) 10:54, 25 November 2019 (UTC)

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. AKlapper (WMF) (talk) 18:22, 25 November 2019 (UTC)

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

J garrard (talk) 15:11, 22 December 2019 (UTC)

See https://www.mediawiki.org/wiki/Project%3ASupport%20desk/Flow/2019/11#h-Search_error_creating_custom_namespaces-2019-11-24T17%3A40%3A00.000Z as @Sokote zaman posted this in three different places for no reason. AKlapper (WMF) (talk) 15:24, 22 December 2019 (UTC)

Bug fix

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?

Farvardyn (talk) 13:35, 10 May 2020 (UTC)

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 (talk) 13:38, 10 May 2020 (UTC)

@Ciencia Al Poder Right now I am getting that error message with the latest clean and un-customized version. So this bug still exists. Farvardyn (talk) 16:45, 10 May 2020 (UTC)