[02:19:31] Hello and good 2am UTC everyone. I have a bit of a database puzzler! On the enwiki DB related to page_id=65773124... [02:19:32] select * from page where page_id = 65773124; [02:19:32] Returns page_title = Shikaripara,_Dumka [02:19:33] On that page are two coordinate links to geohack... [02:20:59] ...but [02:20:59] select * from externallinks where el_from=65773124 and el_to like '%geohack%'; [02:21:00] Returns 45 rows of geohack links?!!! [02:23:14] (my mediawiki DB schema knowledge might be a bit rusty... But this is weird. And that page is only an example of many...) [02:25:55] dschwen: pretty sure you will get answers if you put that on a ticket but right now live on this channel is kind of unlikely. DBAs in Europe are sleeping and US is at dinner [02:26:30] Gee, I just finished my dinner;-)  Get back behind that keyboard. [02:27:19] Thanks for the tip though. I'm leaning more toward me being dumb than this being a bug, but maybe I should risk a ticket [02:29:34] dschwen: it will work better just because more people will see it and can answer in their own timezone, yep. I even looked at the schema if there is an addtional timestamp field but no [02:35:01] no, my bad [02:35:20] There is an osm map template in there with a ton of coord templates [02:35:46] IMO it is polluting the location data, as those coord are not directly associated with the article [11:30:18] !log admin merging core router firewall changes https://gerrit.wikimedia.org/r/c/operations/homer/public/+/657358 (T272486, T209082) [11:30:22] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Admin/SAL [11:30:22] T272486: cloudcontrol1003/Check for VMs leaked by the nova-fullstack test is CRITICAL - https://phabricator.wikimedia.org/T272486 [11:35:21] !log admin merging core router firewall changes https://gerrit.wikimedia.org/r/c/operations/homer/public/+/657439 (T209082) [11:35:23] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Admin/SAL [15:29:47] !log toolsbeta pushed the maintain-kubeusers:beta tag with the new code to the docker repo T271847 [15:29:51] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Toolsbeta/SAL [15:29:53] T271847: Improve cleanup behavior on failure for maintain-kubeusers - https://phabricator.wikimedia.org/T271847 [17:19:22] paladox: you around? did you help me in the past with some gerrit permission things? [17:19:32] hi [17:19:40] i think i did [17:20:12] ok! [17:20:32] dcaro and I are probably going to need your help again soon :-) [17:20:45] ok :) [17:26:10] paladox: oh yep, I have a gerrit project to which I want to add right to review/commit/push/etc. https://gerrit.wikimedia.org/r/c/cloud/wmcs-ansible/+/657648 , would you mind to review? (not sure if I did it correctly xd) [17:28:29] do you want to directly push? otherwise that looks fine to me. [17:29:40] dcaro [17:30:16] paladox: not really, though being able in case something goes wrong can be useful (I trust the group not to mess up) [17:31:08] you can do " push = group cloud-instance-puppet" [17:32:27] nice [17:41:52] paladox: did it here https://gerrit.wikimedia.org/r/c/cloud/wmcs-ansible/+/657649, added also labels, though I suspect that that comes by default with owner? anyhow, can you merge it? I don't have rights xd... yet [17:42:46] dcaro done [17:42:51] paladox: thanks! [17:59:46] hey Urbanecm, sorry to ping you but I had an unfortunate problem when emailing for T269609 and I'm not sure if all the emails went through. Did you get an email from me? [17:59:47] T269609: Ensure all ToolsDB databases comply with current naming conventions - https://phabricator.wikimedia.org/T269609 [18:00:50] joakino: hi, I can't find any recent email from you, if you can tell me the subject (or the from email), I can check once again. [18:04:15] joakino: and also, I fail to see any instructions on how to fix. As a tool maintainer, do I have permissions to rename a database? Or is there any other recommended way to fix this? [18:07:44] Urbanecm: the email should be called "ToolsDB databases with legacy naming convention" [18:09:44] with regards to the renaming, I'm not sure what the best way is since I haven't tried, but I would try making a new DB with the new name, and then renaming the tables like `RENAME TABLE old_db.table TO new_db.table;`, hopefully that does the trick without having to mysqldump the db and re-import it [18:11:09] joakino: I didn't receive any email with that subject [18:11:58] grr, damn. I'll have to figure out where the sending stopped [18:12:18] thanks Urbanecm [18:12:22] no problem :) [18:12:39] or just resend it i guess (provided you know _why_ it stopped) [18:14:08] !log tools.stewardbots Stopping StewardBot and SULWatcher for maintenance (T269609) [18:14:10] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.stewardbots/SAL [18:14:10] T269609: Ensure all ToolsDB databases comply with current naming conventions - https://phabricator.wikimedia.org/T269609 [18:20:29] !log tools.stewardbots Start StewardBot and SULWatcher again, maintenance over (T269609) [18:20:33] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.stewardbots/SAL [18:20:33] T269609: Ensure all ToolsDB databases comply with current naming conventions - https://phabricator.wikimedia.org/T269609 [18:23:14] joakino: migration should be done for tools.stewardbots, I dropped the old databases, hopefully that's all i need to do [18:24:27] thanks Urbanecm, yep that should do it [18:24:42] great :) [20:03:54] !log tools.refill-api deleted pods again T272483 [20:03:57] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.refill-api/SAL [20:03:57] T272483: Refill tool stuck "waiting for an available worker" - https://phabricator.wikimedia.org/T272483 [20:22:51] good night to everybody [20:23:25] could someone help me? my botis stuck [20:23:43] *my bot is stuck [20:24:02] and when I use the replace function [20:24:24] it throws to me this error: File "/data/project/shared/pywikibot/core/scripts/replace.py", line 1098, in [20:24:24]     main() [20:24:25]   File "/data/project/shared/pywikibot/core/scripts/replace.py", line 841, in main [20:24:25]     if genFactory.handle_arg(arg): [20:24:26] AttributeError: 'GeneratorFactory' object has no attribute 'handle_arg' [20:24:26] CRITICAL: Exiting due to uncaught exception [20:24:35] thanks in advance [20:24:56] please don't paste multiple lines of text here, the anti-spam bots get angry. Use a pastebin instead (https://phabricator.wikimedia.org/paste/ is one option) [20:26:57] that error sounds like a bug in the Pywikibot script. I'm not familiar with the built-in scripts, but someone else might be. You might also get more assistance at https://www.mediawiki.org/wiki/Manual:Pywikibot/Communication [20:27:55] https://phabricator.wikimedia.org/P13882 [20:28:24] Thanks! [23:58:38] !log tools deployed new maintain-kubeusers to tools T271847 [23:58:42] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL [23:58:42] T271847: Improve cleanup behavior on failure for maintain-kubeusers - https://phabricator.wikimedia.org/T271847