Page MenuHomePhabricator

Error 2006 from MediaWiki\Extension\Notifications\UserLocator::getArticleAuthorByArticleId
Closed, ResolvedPublicPRODUCTION ERROR

Description

Error
message
	
Error 2006 from MediaWiki\Extension\Notifications\UserLocator::getArticleAuthorByArticleId, MySQL server has gone away SELECT  actor_rev_user.actor_user AS `rev_user`  FROM `revision` JOIN `actor` `actor_rev_user` ON ((actor_rev_user.actor_id = rev_actor)) JOIN `comment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = rev_comment_id))   WHERE rev_page = 62750956  ORDER BY rev_timestamp,rev_id LIMIT 1   db2170
trace
Impact

~200 events per week

Notes

It started months ago, first occurrence in wmf.19

Details

Request URL
/w/index.php?action=submit&title=The_Amazing_Race_Canada
Related Changes in Gerrit:

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

It uses rev_timestamp instead of rev_page_timestamp which is a bad decision in this case.

wikiadmin2023@10.192.0.225(enwiki)> explain SELECT  actor_rev_user.actor_user AS `rev_user`  FROM `revision` JOIN `actor` `actor_rev_user` ON ((actor_rev_user.actor_id = rev_actor)) JOIN `comment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = rev_comment_id))   WHERE rev_page = 62750956  ORDER BY rev_timestamp,rev_id LIMIT 1;
+------+-------------+---------------------+--------+-----------------------------------------------------------------+---------------+---------+--------------------------------+-------+-------------+
| id   | select_type | table               | type   | possible_keys                                                   | key           | key_len | ref                            | rows  | Extra       |
+------+-------------+---------------------+--------+-----------------------------------------------------------------+---------------+---------+--------------------------------+-------+-------------+
|    1 | SIMPLE      | revision            | index  | rev_actor_timestamp,rev_page_actor_timestamp,rev_page_timestamp | rev_timestamp | 14      | NULL                           | 17980 | Using where |
|    1 | SIMPLE      | actor_rev_user      | eq_ref | PRIMARY                                                         | PRIMARY       | 8       | enwiki.revision.rev_actor      | 1     |             |
|    1 | SIMPLE      | comment_rev_comment | eq_ref | PRIMARY                                                         | PRIMARY       | 8       | enwiki.revision.rev_comment_id | 1     | Using index |
+------+-------------+---------------------+--------+-----------------------------------------------------------------+---------------+---------+--------------------------------+-------+-------------+
3 rows in set (0.001 sec)

wikiadmin2023@10.192.0.225(enwiki)>

Change #1197729 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/extensions/Echo@master] Force correct index on revision table

https://gerrit.wikimedia.org/r/1197729

Change #1197729 merged by jenkins-bot:

[mediawiki/extensions/Echo@master] Force correct index on revision table

https://gerrit.wikimedia.org/r/1197729