My wikidata watchlist is impossible to be emptied
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Luckyz
	Oct 13 2020, 11:45 AM

Description

In wikidata I have a watchlist with more than 150.000 items. I would like to clear it but neither https://www.wikidata.org/wiki/Special:EditWatchlist/raw nor https://www.wikidata.org/wiki/Special:EditWatchlist/clear works properly.
Would it be possible that you delete it for me?

Related Objects

Mentioned In: T309446: EditWatchlist times out when watching 50k pages
Mentioned Here: P12996 Masterwork From Distant Lands
T47380: Clear specific user's watchlist that is too large to load (HTTP Error 500)
T95888: Clear watchlist of Grillitus@eswiktionary

Event Timeline

Luckyz created this task.Oct 13 2020, 11:45 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptOct 13 2020, 11:45 AM

Prior tasks T95888: Clear watchlist of Grillitus@eswiktionary and T47380: Clear specific user's watchlist that is too large to load (HTTP Error 500) suggest that this can be done server-side

Bugreporter added a project: MediaWiki-Watchlist.Oct 13 2020, 12:42 PM

Restricted Application added a project: Growth-Team. · View Herald TranscriptOct 13 2020, 12:42 PM

Lydia_Pintscher added a subscriber: Lydia_Pintscher.Oct 13 2020, 12:43 PM

Kizule added a subscriber: Kizule.Oct 13 2020, 1:37 PM

Per https://www.wikidata.org/w/api.php?action=query&list=allusers&aufrom=Luckyz&aulimit=1, 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@10.192.0.6(wikidatawiki)> 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.

P12996 Masterwork From Distant Lands

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

Your watchlist now should be empty:

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

Calling this resolved.

Urbanecm closed this task as Resolved.Oct 14 2020, 6:34 PM

Urbanecm claimed this task.

Restricted Application added a project: User-Urbanecm. · View Herald TranscriptOct 14 2020, 6:34 PM

Aklapper mentioned this in T309446: EditWatchlist times out when watching 50k pages.May 28 2022, 9:03 PM

My wikidata watchlist is impossible to be emptiedClosed, ResolvedPublicActions

Description

Related Objects

Event Timeline

My wikidata watchlist is impossible to be emptied
Closed, ResolvedPublic
Actions