[11:27:47] hey, is test wikidata config broken? [11:28:05] I'm trying to add statements and I'm getting the following from the console: [11:28:16] Access to XMLHttpRequest at 'https://www.wikidata.org/w/api.php?action=wbsgetsuggestions&search=instance%20of&context=item&format=json&language=en&entity=Q42877' from origin 'https://test.wikidata.org' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource. [11:28:40] It looks like it's calling the wrong api, wikidata instead of test.wikidata [11:43:53] PROBLEM - High lag on wdqs1004 is CRITICAL: 3633 ge 3600 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [11:46:12] PROBLEM - High lag on wdqs1004 is CRITICAL: 3662 ge 3600 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [11:50:42] PROBLEM - High lag on wdqs1005 is CRITICAL: 3662 ge 3600 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [12:09:41] someone did a quickstatements batch a few months ago and has apparently left wikidata since then [12:09:56] but there are a lot of mistakes in that batch [12:10:21] do we have any way of undoing all the edits? [12:12:32] We can use revertbot.py, from Pywikibot, but I've never tried [12:13:14] doesn't that only work if it's the most recent revision? [12:13:19] (which it's often not, since the edits were months ago) [12:13:48] No idea [12:13:50] This script can be used for reverting certain edits. [12:13:50] The following command line parameters are supported: [12:13:50] -username Edits of which user need to be reverted. [12:13:50] -rollback Rollback edits instead of reverting them. [12:13:52] Note that in rollback, no diff would be shown. [12:14:04] ah [12:14:12] Maybe it would work without -rollback (?) [12:15:19] hm... but how does it know which edits to undo? [12:16:10] You should use the global options for that [12:16:11] https://www.mediawiki.org/wiki/Manual:Pywikibot/Global_Options [12:16:49] Hmmm... but I don't see some options to retrieve certain pages there [12:16:54] I was about to say :P [12:16:59] :/ [12:17:42] RECOVERY - High lag on wdqs1005 is OK: (C)3600 ge (W)1200 ge 273 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [12:17:47] it's annoying as well because not all of the edits are bad, but I don't see any way of distinguishing the good ones from the bad ones without checking them all manually >_< [12:19:03] Yeah, for these cases it's good to sample the edits and, if the ratio of good edits isn't high enough, to undo everything [12:19:39] I'm not sure how many edits have been done in total, but I've already removed hundreds [12:19:59] and those are just the ones I've been able to find [12:21:29] https://tools.wmflabs.org/editgroups/ [12:21:40] Do those edits appear here? [12:22:44] Otherwise, we can look for them with https://tools.wmflabs.org/wikidata-todo/user_edits.php [12:26:51] PROBLEM - High lag on wdqs1005 is CRITICAL: 4413 ge 3600 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [12:29:33] nikki: smart rollback script and filter user contributions on label? :) [12:29:48] hm? [12:30:17] https://meta.wikimedia.org/w/index.php?title=User:Hoo_man/smart_rollback.js [12:31:38] doesn't rollback need it to be the most recent revision? [12:31:46] example: https://www.wikidata.org/w/index.php?limit=50&title=Special%3AContributions&contribs=user&target=Nikki&namespace=&tagfilter=OAuth+CID%3A+378&start=&end= [12:31:46] hmmm [12:31:51] right [12:32:15] I would ask Pasleim. [12:32:45] I'm currently trying to see if I can filter them with petscan somehow, but petscan is such a mystery to me, it never seems to do what I expect >_< [12:34:08] also my browsers aren't happy with me [13:41:21] oh I forgot that petscan can't remove statements any more >_< [13:41:33] that was a bit pointless then [13:53:46] can't you generate a pagepile and do something with quick statements [14:01:00] Technical Advice IRC meeting starting in 60 minutes in channel #wikimedia-tech, hosts: @Thiemo_WMDE & @chiborg - all questions welcome, more infos: https://www.mediawiki.org/wiki/Technical_Advice_IRC_Meeting [14:42:34] RECOVERY - High lag on wdqs1005 is OK: (C)3600 ge (W)1200 ge 170 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [14:44:45] RECOVERY - High lag on wdqs1004 is OK: (C)3600 ge (W)1200 ge 306 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [14:50:52] Technical Advice IRC meeting starting in 10 minutes in channel #wikimedia-tech, hosts: @Thiemo_WMDE & @chiborg - all questions welcome, more infos: https://www.mediawiki.org/wiki/Technical_Advice_IRC_Meeting