Page MenuHomePhabricator

Manually purge obsolete entites from WDQS
Closed, ResolvedPublic

Description

As T237502 seems to be already stalled and the dev team is busy troubleshooting other WDQS problems, I'd like to request a manually triggered re-load of a list of Wikidata entites that have been deleted or redirected during the past months, but this was not done on WDQS. User:Smalyshev_(WMF) has done this several times in the past for me, roughly every couple of months. These entities are affected:

  • Deleted items that still reside on WDQS: Q9488709, Q17053133, Q22866888, Q6677897, Q25809019, Q66500406, Q4434305, Q1860304, Q6653678, Q8957508, Q25982427, Q25856828, Q22745333, Q6706183, Q25775982, Q25950985, Q25770821, Q6569418, Q25983031, Q22706445, Q24944042, Q25805639, Q22227137, Q20701921, Q852302, Q6660013, Q25982568, Q6595635, Q26071898, Q26077705, Q26066838, Q25982466, Q22864486, Q26146984, Q22227126, Q22874663, Q25968791, Q25977873, Q26169435, Q4763312, Q20065303, Q22834013, Q22833570, Q22864113, Q22847133, Q5962291, Q12053633, Q25897939, Q22873482, Q7654988, Q26174966, Q25879571, Q22864495, Q25806309, Q22846633, Q22839665, Q7654961, Q64759959, Q24938622, Q25773857, Q6575212, Q6812464, Q10537055, Q13277330, Q26003049, Q18480793, Q6652799, Q20755639, Q8263645, Q8850361, Q22711951, Q22745231, Q6655550, Q25812272, Q25955305, Q18476092, Q32124523, Q22878761, Q25982731, Q22708838, Q18129218, Q22849095, Q25806506, Q17099595, Q22227120, Q26139757, Q22743556, Q22864544, Q4433803, Q6816333, Q13305595, Q25728537, Q26170531, Q6655902, Q19773826, Q25806029, Q25982408, Q22855059, Q7768087, Q15910857, Q20701409, Q20351654, Q4433802, Q22881364, Q25852615, Q4433789, Q6569420, Q26174622, Q22864529, Q8568485, Q6716462, Q22227122, Q25773393, Q22743251, Q6653674, Q18481634, Q6656020, Q3745411, Q6640180, Q18480546, Q25982478, Q25982473, Q14447839, Q25810824, Q6619727, Q22227121, Q17509725, Q25982334, Q26177522, Q22830582, Q22736822, Q22864549, Q22861615, Q6604473, Q4433793, Q22705140, Q25982442, Q25779929, Q8424121, Q27999403, Q4433790, Q25983236, Q66058184, Q22864593, Q739279, Q20364075, Q22877585, Q25982491, Q6656015, Q25983192, Q17986329, Q25978111, Q22873193, Q17444826, Q25340579, Q20327184, Q25954234, Q4433791, Q22846707, Q7654990, Q25810888, Q18128257, Q8387993, Q25855862, Q20158210, Q6716460, Q8809373, Q7654968, Q7655011, Q20047872, Q25770135, Q6816099, Q20701948, Q22864625, Q22714830, Q3833699, Q25990269, Q13751987, Q32759246, Q22227138, Q22815887, Q66372254, Q22849222, Q22773429, Q25774794, Q22092252, Q20346743, Q25776676, Q26266949, Q25810415, Q22840362, Q25808234, Q25982406, Q22883616, Q18127071, Q44370922, Q22864658, Q25982344, Q6655832, Q22227128, Q22708820, Q6573636, Q22227116, Q6716463, Q6656018, Q6812233, Q25813629, Q8871852, Q25983148, Q22711495, Q66789304, Q18480655, Q6598243, Q32760444, Q25778106, Q66084766, Q25982456, Q22864670, Q6655831, Q18354650, Q22869981, Q7768084, Q26174615, Q6573002, Q22841314, Q25808809, Q59315405, Q22838289, Q22864648, Q8853676, Q7768088, Q18479570, Q4433788, Q8686740, Q4436754, Q6816340, Q25983150, Q22707194, Q22866397, Q26178438, Q31888351, Q8599905, Q25982395, Q22716259, Q20065302, Q25982360, Q20693337, Q18480559, Q22864613, Q26174620, Q22879047, Q25983068, Q26087063, Q22741867, Q22846832, Q26174915, Q18476438, Q25982461, Q25946656, Q20701402, Q25808502, Q26174611, Q22764833, Q22760280, Q22879056, Q7682112, Q7409230, Q25982362, Q20338515, Q22707183, Q22858550, Q33280334, Q3603056, Q25904144, Q4435851, Q26063838, Q20165915, Q6659718, Q6653676, Q22864603, Q25976458, Q22867618, Q6619825, Q22899112, Q66058182, Q25982340, Q20160117, Q20048971, Q25982398, Q22831042, Q22705649, Q2206292, Q22834661, Q25982514, Q25355641, Q49834454, Q22864511, Q25776522, Q20695143, Q20701937, Q6655411, Q22876086, Q22853812, Q13363111, Q25982351, Q22864522, Q3250790, Q22864566, Q6934762, Q25982369, Q26132219, Q17022145, Q6655829, Q3248945, Q25952732, Q22864860, Q66789462, Q22839654, Q6629376, Q20336981, Q6655833, Q26144599, Q56373893, Q2164830, Q76576923, Q65216698, Q12906192, Q76482129, Q65161037, Q67934127, Q69523205, Q65281132, Q65214809, Q65318428, Q12194106, Q67934365, Q61079619, Q25389125, Q65053938, Q75839926, Q12211369, Q65165414, Q60690919, Q76384841, Q55731234, Q25436883, Q73417963, Q20569235, Q30082265, Q63121573, Q69523190, Q65194701, Q12221765, Q54092604, Q3731421, Q8041502, Q18210498, Q74820417, Q65160564, Q73287897, Q60695802, Q16914014, Q56402768, Q69523187, Q68201689, Q12224800, Q65154415, Q20421337, Q65214346, Q24943555, Q32705680, Q55730555, Q57071945, Q63122442, Q55705641, Q72948922, Q20944292, Q56374511, Q18995379, Q61358618, Q57071835, Q75840487, Q65294020, Q65160276, Q61177076, Q68283787, Q76395468, Q68201698, Q32707356, Q63122731, Q12222577, Q12216882, Q67934133, Q12202227, Q65158704, Q31351096, Q60687778, Q32707350, Q12188575, Q32683430, Q10500995, Q25436674, Q30920988, Q65398053, Q74811322, Q16140708, Q32705546, Q7834144, Q63469590, Q74798263, Q56314344, Q61064394, Q76574584, Q32694882, Q61365934, Q12140773, Q12239509, Q65956683, Q13478504, Q6816211, Q65277093, Q5528414, Q30920404, Q60691247, Q73183246, Q75570129, Q12234314, Q57512988, Q65331874, Q75930957, Q4067014, Q6692868, Q25652862, Q39082772, Q65318237, Q54965440, Q65166653, Q7834185, Q65198640, Q72350238, Q72965268, Q74907829, Q7505981, Q25702075, Q76462905, Q32705813, Q68201699, Q65280270, Q25648150, Q65058724, Q65153252, Q76164726, Q28724453, Q16965844, Q21661208, Q3119197, Q70088334, Q31308412, Q32693361, Q30081493, Q10341271, Q65171733, Q47232054, Q13047710, Q73921526, Q60691212, Q7040798, Q61116393, Q38301336, Q22934182, Q65923140, Q65238263, Q30920727, Q10830668, Q72762329, Q61175661, Q68403945, Q68170831, Q65194704, Q12183329, Q56275397, Q65263036, Q6539001, Q60573500, Q65289754, Q6729014, Q68615021, Q20045176, Q65324811, Q22662560, Q68221645, Q74391093, Q62027250, Q57072020, Q76453903, Q12214052, Q17080471, Q20566895, Q25648120, Q65248666, Q12183330, Q59784864, Q32705585, Q6794899, Q74250060, Q65210794, Q65203650, Q73741417, Q12244863, Q28746337, Q6540322, Q12183788, Q6917882, Q12238546, Q60997702, Q3720996, Q63033046, Q71121240, Q25648119, Q62267426, Q32705582, Q72849167, Q32705588, Q12191844, Q60573976, Q65284841, Q7015469, Q20056112, Q12207222, Q60690928, Q12184513, Q72935593, Q32705549, Q28715986, Q65281048, Q12189967, Q12219475, Q54965886, Q16124725, Q63122113, Q7424236, Q25678134, Q74803500, Q68168064, Q6194202, Q6194324, Q6212889, Q6220023, Q6252217, Q6258585, Q6275584, Q6275640, Q6275643, Q6275804, Q6275806, Q6275898, Q6275917, Q6275968, Q6276001, Q6276003, Q6283251, Q6283384, Q6283687, Q6320377, Q6337246, Q6343146, Q7671380, Q7674334, Q7768706, Q7768709, Q7768711, Q7768713, Q7768717, Q7959457, Q8185624, Q8216650, Q8216655, Q8237400, Q8236076, Q8273781, Q8271026, Q8306542, Q8308571, Q8355405, Q8368045, Q8375648, Q8391361, Q8394047, Q8394281, Q8429248, Q8441234, Q8441296, Q8442603, Q8443133, Q8475885, Q8479696, Q8502382, Q8503435, Q8561485, Q8558486, Q8566965, Q8594441, Q8594495, Q8605278, Q8651761, Q8654932, Q8655006, Q8663164, Q8675139, Q8694367, Q8694646, Q8700501, Q8714715, Q8782032, Q8789324, Q8792059, Q8823770, Q8877943, Q8897317, Q8912253, Q8912255, Q8922044, Q8922307, Q8922327, Q8922338, Q8922356, Q8922361, Q8924174, Q8924388, Q8924390, Q8924678, Q8924753, Q8924783, Q8924907, Q8924925, Q8924968, Q8925177, Q8925221, Q8925237, Q8923603, Q8923877, Q8923879, Q8923896, Q8923929, Q8924048, Q8924050, Q8945746, Q8993779, Q9034448, Q9040537, Q9144075, Q9194887, Q9214952, Q9224944, Q9229689, Q9236866, Q9236868, Q9294283, Q9303409, Q9303414, Q9321992, Q9401642, Q9401694, Q9401716, Q9401735, Q9401769, Q9402814, Q9416236, Q9418092, Q9418731, Q9418989, Q9419070, Q9415501, Q9419216, Q9419251, Q9419621, Q9421040, Q9430516, Q9446088, Q9448461, Q9450088, Q9451016, Q9451798, Q9451854, Q9454731, Q9454930, Q9456359, Q9458027, Q9471721, Q9488590, Q9506241, Q9508144, Q9508163, Q9508173, Q9532453, Q9569652, Q9627233, Q9700156, Q9708076, Q9710313, Q9713923, Q9723508, Q9751065, Q9755375, Q9761374, Q9776011, Q9882120, Q9886729, Q9889855, Q9894699, Q9897437, Q9899697, Q9899908, Q9910993, Q9931151, Q9943490, Q9943552, Q9965246, Q9971738, Q9994395, Q10020790, Q10109084, Q10109670, Q10116979, Q10145924, Q10154629, Q10165399, Q10169032, Q10173234, Q10173676, Q10176650, Q10190941, Q10190950, Q10192149, Q10198495, Q10207882, Q10219851, Q10222024, Q10224088, Q10258058, Q10259201, Q13091374, Q13261345, Q13288164, Q13298983, Q13305087, Q13305090, Q13305113, Q13304161, Q13305011, Q14920075, Q15100673, Q15102071, Q15127413, Q15140129, Q15177498, Q15282313, Q15296384, Q17160422, Q17273981, Q17311169, Q17477782, Q18016548, Q18513547, Q18568617, Q18681293, Q18686776, Q18686836, Q19121345, Q19479822, Q19591731, Q20187469, Q20654516, Q20884247, Q20896383, Q20896486, Q20946812, Q20964077, Q21797927, Q21926696, Q22012824, Q22156348, Q22667798, Q24230177, Q24230502, Q24903537, Q24903538, Q24901257, Q24984095, Q25009666, Q25013972, Q25027980, Q25029103, Q25034071, Q25078878, Q25079599, Q25087625, Q25167651, Q25170277, Q25186740, Q25187892, Q25216747, Q25225603, Q25244341, Q25264031, Q25264450, Q25337995, Q25342688, Q25342967, Q25349234, Q25350910, Q25358869, Q25361537, Q25362939, Q25713293, Q27077462, Q27500217, Q27589460, Q27884666, Q27885164, Q28053947, Q28153077, Q28153093, Q28461587, Q28467981, Q28815574, Q29587510, Q30598521, Q30646829, Q30799811, Q30808870, Q30820463, Q30861389, Q30876699, Q31066186, Q31088560, Q31881796, Q31935461, Q31956554, Q31968821, Q31978305, Q32006719, Q32092078, Q32106321, Q32111084, Q32115106, Q32115271, Q32206378, Q32245934, Q32248651, Q32347801, Q32347906, Q32350657, Q32352839, Q32362972, Q32362974, Q32362976, Q32362982, Q32362984, Q32375117, Q32375338, Q32375675, Q32376989, Q32382265, Q32377884, Q32383458, Q32383747, Q32403640, Q32419206, Q32419211, Q32419223, Q32455225, Q32470405, Q32489612, Q32512187, Q32527053, Q32539694, Q32543521, Q32538378, Q32540562, Q32550171, Q32556239, Q32562980, Q32582190, Q32586329, Q32597748, Q32597820, Q32597963, Q32595842, Q32611227, Q32612697, Q32613464, Q32615179, Q32615602, Q32616253, Q32631205, Q32656158, Q32657285, Q32653869, Q32659429, Q32680126, Q32707917, Q32713170, Q32741575, Q32760388, Q32760390, Q32760405, Q32760408, Q32760413, Q32760421, Q32760423, Q32760430, Q32760447, Q32760449, Q32759602, Q32759606, Q32759609, Q32759615, Q32759617
  • Redirected items which are not redirected on WDQS: Q2486447, Q3254594, Q25811478, Q26175541, Q22884926, Q19271616, Q2791646, Q21810692, Q18359069, Q55962542, Q69202424, Q3685441, Q60892068, Q25812499, Q68754857, Q66649509, Q32870572, Q68437354, Q69177906, Q32688352, Q32874982, Q32670032, Q33047875, Q30814419, Q68699336, Q25746895, Q65685521, Q69169002, Q28199373, Q68115692, Q32599038, Q28199367, Q32730692, Q15254602, Q10092155, Q55928325, Q32369138, Q34524548, Q12219839, Q66710351, Q41801753, Q25035092, Q65745743, Q41801527, Q69181340, Q69200058, Q65676058, Q5115151, Q22885558, Q68724017, Q68448402, Q32486035, Q32665738, Q22669296, Q65649702, Q32483997, Q65684889, Q66361983, Q32427431, Q32957787, Q20892527, Q22884925, Q61216683, Q69358613, Q32283259, Q68156606, Q68967833, Q44618613, Q68946919, Q32864970, Q32888183, Q64153592, Q65607628, Q68061674, Q66470422, Q65798080, Q28399773, Q32082342, Q61021131, Q9473838, Q72999101, Q50619818, Q22902599, Q68377363, Q55959136, Q68963498, Q65607587, Q32493857, Q30805639, Q30952868, Q69163127, Q32342759, Q28199384, Q32186483, Q27070157, Q32452581, Q66470557, Q33003119, Q73234214, Q25211979, Q32701291, Q68951469, Q26046878, Q68771228, Q60892876, Q33640060, Q61216338, Q55976321, Q61372752, Q33064085, Q24858690, Q32539440, Q50616327, Q69022377, Q68124193, Q28199379, Q55976310, Q31963801, Q32667211, Q65608945, Q32601527, Q25192909, Q60889429, Q68752307, Q25720069, Q29593849, Q32454253, Q31948997, Q28199377, Q28971777, Q32429488, Q32455144, Q68665573, Q69151976, Q32444118, Q13281999, Q68960716, Q68122355, Q65748072, Q28653303, Q32604577, Q32371690, Q44419191, Q28037971, Q65762742, Q32452782, Q18730961, Q15354573, Q68788346, Q32157914, Q55976309, Q13371743, Q32283385, Q16723426, Q68123187, Q32378778, Q55976308, Q49836057, Q10204811, Q50614705, Q6079751, Q60804620, Q55928307, Q68723120, Q32366918, Q68189178, Q68962985, Q24861186, Q27555609, Q32979839, Q68180497, Q26088139, Q61216618, Q68148241, Q68996046, Q32439930, Q49806064, Q58435216, Q68576471, Q36639298, Q9913847, Q32377044, Q32470112, Q16354455, Q54887948, Q65607150, Q65607115, Q69206161, Q26088266, Q24903789, Q68721976, Q32123824, Q68146682, Q32714049, Q33022505, Q32361308, Q60866060, Q68497355, Q32388144, Q62619741, Q69180659, Q32957912, Q50619685, Q29648658, Q55745410, Q68999186, Q32519219, Q68957110, Q67181442, Q61216729, Q49763151, Q32995968, Q69179535, Q68154458, Q26023394, Q61216482, Q69205782, Q10187000, Q68415986, Q65664877, Q68212748, Q61191674, Q68146950, Q65607991, Q68347922, Q68754262, Q55659017, Q65634223, Q24262134, Q32112100, Q32670025, Q65664452, Q32957880, Q50619614, Q30964373, Q32367380, Q61216580, Q22876120, Q26009831, Q44101499, Q31065125, Q32154680, Q69005617, Q68446063, Q32431221, Q61191808, Q65608181, Q32119330, Q8276868, Q65684846, Q68111682, Q61403188, Q32470759, Q32427777, Q60875224, Q26212339, Q10063798, Q25754098, Q68113090, Q25968368, Q28199375, Q25746139, Q25013572, Q32957813, Q65607506, Q63088029, Q68598381, Q11345795, Q66362236, Q9024178, Q55928323, Q32883320, Q60868617, Q7779446, Q26018458, Q68990701, Q32157961, Q68409537, Q50275066, Q60956944, Q65607559, Q32657857, Q69170579, Q32488859, Q60937548, Q32368942, Q55215841, Q32961891, Q68370359, Q68971254, Q32623850, Q28979427, Q69048029, Q13327465, Q68398236, Q68946480, Q68789104, Q28199380, Q49808881, Q32335454, Q26210908, Q68238598, Q68427031, Q50619415, Q68440999, Q32801637, Q16036940, Q68949871, Q65652167, Q68628154, Q4419884, Q30600569, Q32618287, Q32496697, Q32987022, Q32957679, Q50615886, Q69168279, Q68637206, Q69055856, Q50619493, Q33712136, Q26465310, Q32607710, Q15046626, Q25755207, Q32957909, Q60868624, Q32361656, Q69023657, Q28199369, Q9477944, Q9483227, Q9490778, Q9544084, Q9640813, Q9876629, Q10051868, Q16660638, Q24857108, Q26246597

As a user, I cannot trigger the re-loading by myself, and the items are polluting query results and show up as unremovable entries on several worklists. Particularly for deleted items, there is also a possibility that WDQS delivers sensitive data which was intenionally removed from Wikidata.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

Q27114756, Q27102803, Q27118010, Q27088080, Q27125687, Q27110383, Q27110384, Q27108619, Q27149746

Please delete/redirect them on WDQS.

dcausse triaged this task as Medium priority.Dec 11 2019, 6:23 PM
dcausse moved this task from Incoming to Needs Reporting on the Discovery-Search (Current work) board.