[00:00:43] Sure. I'm especially curious regarding how a bot was using it anyway, and perhaps we could tag that with the bot's maintainer, etc. That could help me and joakino think about creating solutions for this kind of thing that other people can use...also someone else might jump on the ticket with better ideas lol [00:00:59] bstorm:https://github.com/greencardamom/Shadows [00:01:14] I assume it's okay to link github repositories for bot in here? [00:01:39] bstorm: https://github.com/greencardamom/Shadows/blob/master/shadows.sql [00:01:42] being the code [00:01:45] I see, yeah [00:01:53] for the query [00:02:04] Somewhoe that needs to be split into 2 queries [00:02:14] One for Commons and One for Wikipedia [00:02:20] With some code in between to link them [00:02:21] yeah [00:02:37] Or you need to be build one table on the fly [00:02:49] If you can create the ticket and add me as a subscriber, that would be great (I'm bstorm on there as well) [00:03:21] I'm thinking it might be a nice example in the long run [00:04:09] Bots aren't generally in scope on Phabriactor though [00:04:18] On toolforge they totally are [00:04:28] We have a "Tool" project tag for them [00:04:46] And then I can add my team's project tags after that [00:04:47] The use case of comparing local media on wiki X to media on Commons is the most likely and legitimate cross db join that I can think of. [00:04:53] Okay which Phabricator do you mean? [00:05:06] phabricator.wikimedia.org [00:07:08] ShakespeareFan00: https://phabricator.wikimedia.org/tag/tools/ [00:07:15] That's the tag I'd use [00:07:43] There's also "tool" which might be better, but we can change that once the ticket is up [00:11:34] https://phabricator.wikimedia.org/T267992 [00:11:43] Add any projects you need to [00:13:08] th [00:13:09] thx [00:13:29] I you can tidy up by provding additional context appreciated [00:13:40] I tried to be a consice as possible [00:16:24] bd808: Please take further discussion to the Phabricator ticket [00:16:27] Thanks :) [00:34:43] My bot uses cross database joins and I need help devising a new method/query since this feature will no longer be supported as of January. [00:34:51] The SQL is at https://github.com/greencardamom/Shadows/blob/master/shadows.sql [00:35:47] I did not create this query and do not really understand it so am at a loss how to approach the problem. [00:36:38] Thanks for any suggestions. [00:47:18] greenc: ShakespeareFan00 made T267992 for your issue. We don't have an answer yet, but the right folks are aware. [00:47:18] T267992: Provide mechanism to detect name clashed media between Commons and a Local project, without needing to join tables across wiki-db's - https://phabricator.wikimedia.org/T267992 [00:48:34] greenc: I would suggest that you subscribe to that task so you can help answer questions when they come up and hopefully eventually get a working answer [00:49:12] @bd808 thank you got it! [03:36:35] HI, I keep getting emails of "User sXXX already has more than max_user_connections" errors though my email-based error handling setup, but running qstat on the bastion reveals no active jobs [03:36:45] how can I shut down the errant script? [08:54:03] !log toolsbeta etcd-4,5 and 6 are up and running, removing 1,2 and 3 (T267140) [08:54:06] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Toolsbeta/SAL [08:54:06] T267140: [toolsbeta] Rebuild servers to learn how to take down the services without downtime - https://phabricator.wikimedia.org/T267140 [08:58:53] !log toolsbeta etcd hosts reimaged (T267140) [08:58:55] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Toolsbeta/SAL [10:40:09] !log toolsbeta hand-edited /etc/kubernetes/manifests/kube-apiserver.yaml in all 3 k8s control nodes to account for new etcd servers (T267140) [10:40:12] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Toolsbeta/SAL [10:40:13] T267140: [toolsbeta] Rebuild servers to learn how to take down the services without downtime - https://phabricator.wikimedia.org/T267140 [11:59:36] !log toolbeta up and running again, documented on the live doc for now, apsrever had the wrong config (T267140) [11:59:36] dcaro: Unknown project "toolbeta" [11:59:37] T267140: [toolsbeta] Rebuild servers to learn how to take down the services without downtime - https://phabricator.wikimedia.org/T267140 [12:06:02] dcaro: ^^^ [12:09:08] !log toolsbeta 11:59:36 UTC – toolbeta up and running again, documented on the live doc for now, apsrever had the wrong config (T267140) [12:09:12] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Toolsbeta/SAL [12:09:12] T267140: [toolsbeta] Rebuild servers to learn how to take down the services without downtime - https://phabricator.wikimedia.org/T267140 [14:07:51] thanks Lucas_WMDE :) [15:32:01] !log toolsbeta Creating new toolsbeta-test-k8s-control-4 node and adding it to the cluster (T267140) [15:32:05] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Toolsbeta/SAL [15:32:05] T267140: [toolsbeta] Rebuild servers to learn how to take down the services without downtime - https://phabricator.wikimedia.org/T267140 [19:21:14] !log admin draining cloudvirt1012 to experiment with libvirt/cpu things [19:21:16] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Admin/SAL