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

bzimport added a subscriber: wikibugs-l.
bzimport set Reference to bz45380.
bzimport created this task.Via LegacyFeb 25 2013, 8:58 PM
Reedy added a comment.Via ConduitFeb 28 2013, 12:12 AM

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

Jarekt added a comment.Via ConduitFeb 28 2013, 3:38 PM

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

Aklapper added a comment.Via ConduitFeb 28 2013, 6:40 PM

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

Jarekt added a comment.Via ConduitMar 1 2013, 2:21 PM

Max Semenik cleared my watchlist on Commons

Add Comment

Column Prototype
This is a very early prototype of a persistent column. It is not expected to work yet, and leaving it open will activate other new features which will break things. Press "\" (backslash) on your keyboard to close it now.