Page MenuHomePhabricator

Clear specific user's watchlist that is too large to load (HTTP Error 500)
Closed, ResolvedPublic

Description

Author: mattbisanz

Description:
Please clear the watchlist of user Carlossuarez46 at en.wp because it has become too large for him to load the page and edit it. See http://en.wikipedia.org/w/index.php?title=Wikipedia:Village_pump_%28technical%29&oldid=540347817#Cannot_edit_watchlist


Version: wmf-deployment
Severity: normal
URL: http://en.wikipedia.org/w/index.php?title=Wikipedia:Village_pump_%28technical%29&oldid=540347817#Cannot_edit_watchlist

Details

Reference
bz45380

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 1:24 AM
bzimport set Reference to bz45380.
bzimport added a subscriber: Unknown Object (MLST).

mysql:wikiadmin@db1017 [enwiki]> select count(*) from watchlist where wl_user=23407;
+----------+

count(*)

+----------+

221044

+----------+
1 row in set (0.12 sec)

Seriously?

mysql:wikiadmin@db1017 [enwiki]> delete from watchlist where wl_user=23407;
Query OK, 221044 rows affected (1 min 53.68 sec)

mysql:wikiadmin@db1017 [enwiki]> select count(*) from watchlist where wl_user=23407;
+----------+

count(*)

+----------+

0

+----------+
1 row in set (0.07 sec)

mysql:wikiadmin@db1017 [enwiki]>

Can you also do the same for Jarekt on Commons. I am also unable to edit my watchlist.

For future reference, please file a separate request to track, otherwise this specific bug report would never be closed.

Max Semenik cleared my watchlist on Commons