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 created this task.Sep 4 2015, 12:35 AM
lfaraone raised the priority of this task from to Needs Triage.
lfaraone updated the task description. (Show Details)
lfaraone added subscribers: lfaraone, Legoktm.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 4 2015, 12:35 AM
{"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)
Legoktm set Security to None.Sep 4 2015, 12:45 AM
Legoktm added a subscriber: Anomie.
demon triaged this task as Normal priority.Sep 4 2015, 4:54 PM
Restricted Application added a subscriber: JEumerus. · View Herald TranscriptFeb 24 2016, 5:24 PM