Page MenuHomePhabricator

My wikidata watchlist is impossible to be emptied
Closed, ResolvedPublic


In wikidata I have a watchlist with more than 150.000 items. I would like to clear it but neither nor works properly.
Would it be possible that you delete it for me?

Event Timeline

Per, wl_user should be 104889 and this should do job:

mwscript runBatchedQuery.php --wiki wikidatawiki "DELETE FROM watchlist WHERE wl_user = 104889 LIMIT 5000;"

Adding Wikimedia-maintenance-script-run...

Mentioned in SAL (#wikimedia-operations) [2020-10-14T18:28:22Z] <Urbanecm> wikiadmin@> DELETE FROM watchlist WHERE wl_user=104889; # T265347

I deleted 600784 pages from your watchlist. I downloaded your watchlist to mwmaint2001:/home/urbanecm/watched_pages_T265347.txt, but I'm unable to upload it anywhere, since Phabricator's pastebin apparently doesn't allow for textfiles that have 7 MBs. Please ping me if you want it, otherwise, I'll delete it in a few days.

1Script started on Wed 14 Oct 2020 06:25:55 PM UTC
2urbanecm@mwmaint2001:~$ sql wikidatawiki --write
3Reading table information for completion of table and column names
4You can turn off this feature to get a quicker startup with -A
6Welcome to the MariaDB monitor. Commands end with ; or \g.
7Your MariaDB connection id is 466660331
8Server version: 10.1.44-MariaDB MariaDB Server
10Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
12Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
14wikiadmin@> SELECT user_id FROM user where user_name="Luckyz";
16| user_id |
18| 104889 |
201 row in set (0.00 sec)
22wikiadmin@> DELETE FROM watchlist WHERE wl_user=104889;
23Query OK, 599384 rows affected (12.39 sec)
25wikiadmin@> select count(*) from watchlist where wl_user=104889;
27| count(*) |
29| 0 |
311 row in set (0.00 sec)
33wikiadmin@> Bye
34urbanecm@mwmaint2001:~$ exit
36Script done on Wed 14 Oct 2020 06:27:20 PM UTC

Your watchlist now should be empty:

wikiadmin@> select count(*) from watchlist where wl_user=104889;
| count(*) |
|        0 |
1 row in set (0.00 sec)

Calling this resolved.

Urbanecm claimed this task.