Page MenuHomePhabricator

RevDel page errors out when selecting ~10+ revisions
Closed, DuplicatePublic

Description

Trying to open the revdel page for 10 revisions will error out:

A database query error has occurred. This may indicate a bug in the software.

Function: RevDelRevisionList::doQuery
Error: 2013 Lost connection to MySQL server during query (10.64.48.28)

Example URL

Event Timeline

lfaraone raised the priority of this task from to Needs Triage.
lfaraone updated the task description. (Show Details)
lfaraone added subscribers: lfaraone, Legoktm.
{"exception":"[Exception DBQueryError] (/srv/mediawiki/php-1.26wmf21/includes/db/Database.php:1131) A connection error occured. \nQuery: SELECT  rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_content_format,rev_content_model,user_name  FROM `revision` INNER JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((rev_user != 0) AND (user_id = rev_user))  WHERE rev_page = '16283969' AND rev_id IN ('679340073','679337192','679336675','679335920','679334110','679334014','679333987','679330491','679330449','679317447')   ORDER BY rev_id DESC \nFunction: RevDelRevisionList::doQuery\nError: 2013 Lost connection to MySQL server during query (10.64.48.28)\n\n[stacktrace]\n#0 /srv/mediawiki/php-1.26wmf21/includes/db/Database.php(1069): DatabaseBase->reportQueryError(string, integer, string, string, boolean)\n#1 /srv/mediawiki/php-1.26wmf21/includes/db/Database.php(1612): DatabaseBase->query(string, string)\n#2 /srv/mediawiki/php-1.26wmf21/includes/revisiondelete/RevDelRevisionList.php(74): DatabaseBase->select(array, array, array, string, array, array)\n#3 /srv/mediawiki/php-1.26wmf21/includes/RevisionList.php(84): RevDelRevisionList->doQuery(DatabaseMysqli)\n#4 /srv/mediawiki/php-1.26wmf21/includes/specials/SpecialRevisiondelete.php(172): RevisionListBase->reset()\n#5 /srv/mediawiki/php-1.26wmf21/includes/specialpage/SpecialPage.php(384): SpecialRevisionDelete->execute(string)\n#6 /srv/mediawiki/php-1.26wmf21/includes/actions/SpecialPageAction.php(77): SpecialPage->run(string)\n#7 /srv/mediawiki/php-1.26wmf21/includes/MediaWiki.php(458): SpecialPageAction->show()\n#8 /srv/mediawiki/php-1.26wmf21/includes/MediaWiki.php(255): MediaWiki->performAction(Article, Title)\n#9 /srv/mediawiki/php-1.26wmf21/includes/MediaWiki.php(682): MediaWiki->performRequest()\n#10 /srv/mediawiki/php-1.26wmf21/includes/MediaWiki.php(476): MediaWiki->main()\n#11 /srv/mediawiki/php-1.26wmf21/index.php(41): MediaWiki->run()\n#12 /srv/mediawiki/w/index.php(3): include(string)\n#13 {main}\n"}
mysql:wikiadmin@db1072 [enwiki]> explain SELECT  rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_content_format,rev_content_model,user_name  FROM `revision` INNER JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((rev_user != 0) AND (user_id = rev_user))  WHERE rev_page = '16283969' AND rev_id IN ('679340073','679337192','679336675','679335920','679334110','679334014','679333987','679330491','679330449','679317447')   ORDER BY rev_id DESC;
+------+-------------+----------+--------+------------------------------------+-------------+---------+--------------------------+------+-------------+
| id   | select_type | table    | type   | possible_keys                      | key         | key_len | ref                      | rows | Extra       |
+------+-------------+----------+--------+------------------------------------+-------------+---------+--------------------------+------+-------------+
|    1 | SIMPLE      | page     | const  | PRIMARY                            | PRIMARY     | 4       | const                    |    1 | Using index |
|    1 | SIMPLE      | revision | ref    | PRIMARY,rev_page_id,page_timestamp | rev_page_id | 4       | const                    |   10 | Using where |
|    1 | SIMPLE      | user     | eq_ref | PRIMARY                            | PRIMARY     | 4       | enwiki.revision.rev_user |    1 | Using where |
+------+-------------+----------+--------+------------------------------------+-------------+---------+--------------------------+------+-------------+
3 rows in set (0.00 sec)