Page MenuHomePhabricator

RESTBase-Cassandra wide partitions: period of 2016-11-06 to 2016-11-13
Closed, ResolvedPublic

Description

The spreadsheet linked below contains the top 25 entries from this weeks report wide partition report (emailed to services@wikimedia.org).

https://docs.google.com/spreadsheets/d/1sLW-RxbOv3Chs07Xw2XGl4fzIuOPUexgnw4pT9gd_i4

Most of these overlap previous efforts, and I expect it may take some time to see them all GC'd. To keep things simple, I plan to issue deletes for all 25 anyway.

1BEGIN BATCH;
2DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'sv.wikipedia.org' AND key = 'Användare:Lsjbot/Anomalier-PRIVAT'
3DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'sv.wikipedia.org' AND key = 'Användare:Lsjbot/Anomalier-PRIVAT'
4DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'sv.wikipedia.org' AND key = 'Användare:Lsjbot/Anomalier-PRIVAT'
5
6DELETE FROM "local_group_default_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'www.wikidata.org' AND key = 'Q21521423'
7DELETE FROM "local_group_default_T_parsoid_html".data WHERE "_domain" = 'www.wikidata.org' AND key = 'Q21521423'
8DELETE FROM "local_group_default_T_parsoid_section_offsets".data WHERE "_domain" = 'www.wikidata.org' AND key = 'Q21521423'
9
10DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Wikipedia_Diskussion:Hauptseite/Schon_gewusst'
11DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Wikipedia_Diskussion:Hauptseite/Schon_gewusst'
12DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Wikipedia_Diskussion:Hauptseite/Schon_gewusst'
13
14DELETE FROM "local_group_default_T_parsoid_html".data WHERE "_domain" = 'www.wikidata.org' AND key = 'Q21706541'
15DELETE FROM "local_group_default_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'www.wikidata.org' AND key = 'Q21706541'
16DELETE FROM "local_group_default_T_parsoid_section_offsets".data WHERE "_domain" = 'www.wikidata.org' AND key = 'Q21706541'
17
18DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'sv.wikipedia.org' AND key = 'Användare:Lsjbot/Namnkonflikter-PRIVAT'
19DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'sv.wikipedia.org' AND key = 'Användare:Lsjbot/Namnkonflikter-PRIVAT'
20DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'sv.wikipedia.org' AND key = 'Användare:Lsjbot/Namnkonflikter-PRIVAT'
21
22DELETE FROM "local_group_default_T_parsoid_html".data WHERE "_domain" = 'www.wikidata.org' AND key = 'Q21559757'
23DELETE FROM "local_group_default_T_parsoid_html".data WHERE "_domain" = 'www.wikidata.org' AND key = 'Q21481859'
24DELETE FROM "local_group_default_T_parsoid_html".data WHERE "_domain" = 'www.wikidata.org' AND key = 'Q21706513'
25DELETE FROM "local_group_default_T_parsoid_html".data WHERE "_domain" = 'www.wikidata.org' AND key = 'Q21521427'
26DELETE FROM "local_group_default_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'www.wikidata.org' AND key = 'Q21559757'
27DELETE FROM "local_group_default_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'www.wikidata.org' AND key = 'Q21481859'
28DELETE FROM "local_group_default_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'www.wikidata.org' AND key = 'Q21706513'
29DELETE FROM "local_group_default_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'www.wikidata.org' AND key = 'Q21521427'
30DELETE FROM "local_group_default_T_parsoid_section_offsets".data WHERE "_domain" = 'www.wikidata.org' AND key = 'Q21559757'
31DELETE FROM "local_group_default_T_parsoid_section_offsets".data WHERE "_domain" = 'www.wikidata.org' AND key = 'Q21481859'
32DELETE FROM "local_group_default_T_parsoid_section_offsets".data WHERE "_domain" = 'www.wikidata.org' AND key = 'Q21706513'
33DELETE FROM "local_group_default_T_parsoid_section_offsets".data WHERE "_domain" = 'www.wikidata.org' AND key = 'Q21521427'
34
35DELETE FROM "local_group_wiktionary_T_parsoid_html".data WHERE "_domain" = 'hy.wiktionary.org' AND key = 'Վիքիբառարան:Կրթական_ծրագիր/Արևածագի_վիքիակումբ/Գլխավոր'
36DELETE FROM "local_group_wiktionary_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'hy.wiktionary.org' AND key = 'Վիքիբառարան:Կրթական_ծրագիր/Արևածագի_վիքիակումբ/Գլխավոր'
37DELETE FROM "local_group_wiktionary_T_parsoid_section_offsets".data WHERE "_domain" = 'hy.wiktionary.org' AND key = 'Վիքիբառարան:Կրթական_ծրագիր/Արևածագի_վիքիակումբ/Գլխավոր'
38
39DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'ru.wikipedia.org' AND key = 'Википедия:Список_Википедий/TableBig'
40DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'Wikipedia:Training/For_students/Training_feedback'
41DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:Wartungsstube/Musik'
42DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'ru.wikipedia.org' AND key = 'Википедия:Список_Википедий/Table'
43DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:Verum/ege'
44DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:Wartungsstube/Sakralbauten'
45DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Wikipedia:Defekte_Weblinks/Bot2015-Problem'
46DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'User:JamesR/AdminStats'
47DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Wikipedia:Redaktion_Religion/Wartung/Gesamtübersicht'
48DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'Wikipedia:Requested_moves/Current_discussions'
49DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:Ilja_Lorek/Hochschulschriften'
50DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:Harry8/Historisches_Verzeichnis_der_Postleitzahlen'
51DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'Wikipedia:Teahouse/Questions'
52DELETE FROM "local_group_wikipedia_T_parsoid_dataW4ULtxs1oMqJ".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:Wartungsstube/Unternehmen'
53
54DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'ru.wikipedia.org' AND key = 'Википедия:Список_Википедий/TableBig'
55DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'Wikipedia:Training/For_students/Training_feedback'
56DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:Wartungsstube/Musik'
57DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'ru.wikipedia.org' AND key = 'Википедия:Список_Википедий/Table'
58DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:Verum/ege'
59DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:Wartungsstube/Sakralbauten'
60DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Wikipedia:Defekte_Weblinks/Bot2015-Problem'
61DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'User:JamesR/AdminStats'
62DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Wikipedia:Redaktion_Religion/Wartung/Gesamtübersicht'
63DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'Wikipedia:Requested_moves/Current_discussions'
64DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:Ilja_Lorek/Hochschulschriften'
65DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:Harry8/Historisches_Verzeichnis_der_Postleitzahlen'
66DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'Wikipedia:Teahouse/Questions'
67DELETE FROM "local_group_wikipedia_T_parsoid_html".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:Wartungsstube/Unternehmen'
68
69DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'ru.wikipedia.org' AND key = 'Википедия:Список_Википедий/TableBig'
70DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'Wikipedia:Training/For_students/Training_feedback'
71DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:Wartungsstube/Musik'
72DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'ru.wikipedia.org' AND key = 'Википедия:Список_Википедий/Table'
73DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:Verum/ege'
74DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:Wartungsstube/Sakralbauten'
75DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Wikipedia:Defekte_Weblinks/Bot2015-Problem'
76DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'User:JamesR/AdminStats'
77DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Wikipedia:Redaktion_Religion/Wartung/Gesamtübersicht'
78DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'Wikipedia:Requested_moves/Current_discussions'
79DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:Ilja_Lorek/Hochschulschriften'
80DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:Harry8/Historisches_Verzeichnis_der_Postleitzahlen'
81DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'en.wikipedia.org' AND key = 'Wikipedia:Teahouse/Questions'
82DELETE FROM "local_group_wikipedia_T_parsoid_section_offsets".data WHERE "_domain" = 'de.wikipedia.org' AND key = 'Benutzer:Wartungsstube/Unternehmen'
83
84APPLY BATCH;

NOTE: All 25 are from parsoid tables, and so all include deletes from the html, data, and section-offsets tables to keep things sane.

See also: T94121: Understand and solve wide row issues for frequently edited and re-rendered pages

Event Timeline

Eevans triaged this task as Medium priority.Nov 14 2016, 9:19 PM
Eevans claimed this task.

Complete