[00:20:27] !log devtools - on phorge1001, enable general query log in mysql (mariadb), to learn about database scheme, don't forget to turn that off so VM doesn't run out of disk (SET GLOBAL general_log=1;) T328595 [00:20:31] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Devtools/SAL [00:20:31] T328595: create a phorge instance in the devtools project in wmcs - https://phabricator.wikimedia.org/T328595 [01:54:45] Seem something is broken in the replica DBs. I can connect with my own user, but tools.anomiebot has been getting "access denied" since around 2023-03-10 13:52:24. It can still connect to toolsdb. [02:24:35] Guess no one is around at the moment. Not too surprising. Opened T331763 for the issue. [02:24:35] T331763: tools.anomiebot cannot access wiki replica DBs - https://phabricator.wikimedia.org/T331763 [02:26:59] hmm, I can reproduce on legobot too [02:27:30] also hi :) [02:27:47] Hello (: [02:33:10] I can't immediately find any obvious change that would have caused this [02:34:29] The other two tools I have access to seem to work with `sql enwiki`. 🤷 [02:39:00] yeah, my other tools seem fine [02:39:28] legobot and anomiebot are also some of the earliest tools judging by the mysql account names and my memory [02:41:14] ok, I pinged WMCS but not paging since not everything is broken? [02:42:18] anomie: you could probably get away with having anomiebot use one of the other replica.my.cnf files you have access to temporarily if it's urgent [02:43:37] Fortunately most of AnomieBOT's tasks only the the API, just a few use the replicas. [02:44:58] not surprised :p [03:07:47] mutante, I haven't deleted anything from the project purge. I did delete some Stretch VMs many weeks ago, after they'd been shut down for a long time. [18:27:17] taavi - re: our discussion the other day around job 301389 being stuck in "dt" - `qdel -f` _appeared_ to work, but the job now shows up in the "dt" state again [18:27:27] Is it possible to clear it out some other way? [18:27:43] firefly_wp: give me a second to have a look [18:27:55] thx! [18:31:13] the job is fully gone now [18:31:31] !log tools reboot misbehaving tools-sgeexec-10-11 [18:31:34] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL [18:31:54] thx taavi :) [18:32:38] hmm that's the second reboot of 10-11 in a couple of weeks [18:33:41] yeah and it's one of some older nodes with less swap space than what we provision for new nodes, so maybe I'll just get rid of it [18:34:27] thankfully I automated that process a while ago :-P [23:20:17] I am not sure if this is the right channel for this question, but my Petscan queries are timing out because they are too large. I'm trying to replicate a query I ran successfully in March 2021: https://petscan.wmflabs.org/?project=wikipedia&categories=People+by+ethnicity&wikidata_prop_item_use=Q5&depth=6 I am publishing an article in early April, and the publication is doing a rigorous fact check, which I apprec [23:20:58] OK, take two. In chunks: [23:21:00] I am not sure if this is the right channel for this question, but my Petscan queries are timing out because they are too large. [23:21:08] I'm trying to replicate a query I ran successfully in March 2021: https://petscan.wmflabs.org/?project=wikipedia&categories=People+by+ethnicity&wikidata_prop_item_use=Q5&depth=6 [23:21:19] I am publishing an article in early April, and the publication is doing a rigorous fact check, which I appreciate, but I am unable to update this one number. [23:21:34] Questions: [23:22:01] Is there some magic way of getting petscan to not time out? (I can't do an LIMIT/OFFSET like on quarry). [23:22:14] Is there a way to access petscan on toolforge? [23:22:37] I can see a path to using a local dump of page, category, categorylinks (per https://stackoverflow.com/questions/27279649/how-to-build-wikipedia-category-hierarchy) [23:22:49] but that will essentially be reinventing the simple version of the petscan wheel, which seems like a lot of work for something I was able to query a year ago. [23:23:01] If this is not the right place for this, please direct me to the correct channel/forum. Thanks.