[00:18:27] 06Labs, 10wikitech.wikimedia.org: Document cassandra-metrics-collector - https://phabricator.wikimedia.org/T133396#2231799 (10Laberkiste) [00:23:32] RECOVERY - Puppet run on tools-exec-1407 is OK: OK: Less than 1.00% above the threshold [0.0] [00:23:46] RECOVERY - Puppet run on tools-webgrid-lighttpd-1206 is OK: OK: Less than 1.00% above the threshold [0.0] [00:24:49] 06Labs, 07Documentation: Document cassandra-metrics-collector - https://phabricator.wikimedia.org/T133396#2231804 (10Krenair) not a wikitech operational issue, this relates to the wiki's contents speaking of which, is cassandra-metrics-collector used by the labs infrastructure in any way? [00:24:56] RECOVERY - Puppet run on tools-webgrid-generic-1401 is OK: OK: Less than 1.00% above the threshold [0.0] [02:28:56] RECOVERY - Puppet run on tools-webgrid-lighttpd-1401 is OK: OK: Less than 1.00% above the threshold [0.0] [06:56:11] PROBLEM - Puppet run on tools-webgrid-lighttpd-1204 is CRITICAL: CRITICAL: 44.44% of data above the critical threshold [0.0] [07:31:20] RECOVERY - Puppet run on tools-webgrid-lighttpd-1204 is OK: OK: Less than 1.00% above the threshold [0.0] [07:32:18] RECOVERY - Puppet run on tools-exec-1220 is OK: OK: Less than 1.00% above the threshold [0.0] [08:20:27] 06Labs, 10Tool-Labs: Convert tomcat-starter to python - https://phabricator.wikimedia.org/T98442#2231959 (10yuvipanda) I just tested this again, for the isbn tool. ``` webservice-new generic start '/data/project/isbn/tomcat-starter isbn' ``` Seems to do the trick. I'd rather us do that than support tomcat f... [09:40:25] 06Labs, 10Beta-Cluster-Infrastructure, 13Patch-For-Review, 07Puppet: /etc/puppet/puppet.conf keeps getting double content - first for labs-wide puppetmaster, then for the correct puppetmaster - https://phabricator.wikimedia.org/T132689#2232007 (10hashar) Seems `10-self.conf` varies the hostname fqdn :( ```... [12:36:09] 06Labs, 10Horizon: Horizon dashboard for managing instance puppet config - https://phabricator.wikimedia.org/T91990#2232231 (10yuvipanda) [13:30:05] 06Labs, 10Horizon: Horizon dashboard for managing instance puppet config - https://phabricator.wikimedia.org/T91990#2232262 (10yuvipanda) [14:35:42] 06Labs, 10Horizon: Create puppet backend with REST api for labs instance configuration - https://phabricator.wikimedia.org/T133412#2232287 (10yuvipanda) [14:53:18] 06Labs, 10Horizon: Create puppet backend with REST api for labs instance configuration - https://phabricator.wikimedia.org/T133412#2232293 (10yuvipanda) [15:25:56] !log ores sudden disruption due to an unexpected deploy [15:25:59] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Ores/SAL, Master [16:43:31] 06Labs, 10Labs-Kubernetes, 10Tool-Labs: Upgrade to Kubernetes 1.2.3 - https://phabricator.wikimedia.org/T133458#2232436 (10yuvipanda) [17:20:54] PROBLEM - Host tools-worker-1011 is DOWN: PING CRITICAL - Packet loss = 100% [17:27:21] brion: You know, I *would* have expected most communities to only want this turned on for NS_TEMPLATE. User infoboxen and such are trivially handled by making, say, a {{Userbox style}} template. It would seem to me to be wiser to make it more immediately obvious where styles might be coming from from a vandalism pov. [17:29:20] (Wheras the any-page-can-style-itself side effect feels to me like a genuinely useful feature) [17:29:56] YMMV. It's be trivial to patch the code so that if there are no $wgTemplateStylesNamespaces specified it allows all namespaces. [17:51:56] Coren: templates from other namespaces are still listed alongside the other templates, so shouldn't in theory be harder to find them ... In theory ;) [17:52:05] What does templatedata do? [17:52:48] We could of course make it a requirement to use template ns if we want to push people away from using non-template-ns templates [17:53:22] But I worry that kf the style works on the page, it'll be extremely confusing that it doesn't work when transxluded [17:54:11] *if [17:54:18] Typing JS hard on phone [17:54:23] *is [17:54:34] I love how autocorrect keeps turning is into JS [17:55:19] Hm. It might be easier to default the namespaces to those that can be transcluded then. [17:59:12] (i.e., all but $wgNonincludableNamespaces) [17:59:25] But then they aren't transcluded. [17:59:29] * Coren ponders. [19:56:57] I need help!. [19:57:08] ASammour: ask away. [19:57:39] I have a problem in a code that get the stats of sysops in a specific wiki. [19:58:05] The problem is that the code doesn't list all the sysop's names. [19:58:56] Is this a tool on tool labs, something you write yourself, ...? [19:59:08] Yes [19:59:18] Here is the code: https://ar.wikipedia.org/w/index.php?title=user:Elph/adminstat&oldid=19414118 [20:00:11] The query used is correct, and the strange thing is that this query give the exact results, when execute it on quarry. [20:00:40] ASammour: if there's a discrepancy between quarry and your own execution, please file a bug with the example query on phabricator [20:01:04] because that means two database servers are returning different results [20:02:31] I've never used phabricator, can you give the url?. [20:02:40] https://phabricator.wikimedia.org/ [20:02:57] I used Bugzilla, but that was before years :) [20:03:17] use the 'login with mediawiki' button on the login page (button on the top right) to login, then 'create task' under the '+' button [20:03:36] https://phabricator.wikimedia.org/maniphest/task/edit/form/1/?tags=tool-labs,dba [20:06:01] Is accessing external services, e.g. APIs, etc. allowed from the server-side in Tool Labs? [20:06:14] Are there any specific users, I can assign the task to? [20:07:55] ASammour: if the task is tagged with #tool-labs and #dba the right people will see it [20:08:11] tom29739: yes, as long as you abide by their terms of service [20:08:44] tom29739: and it has to pass through tool labs (the users' browser may not make direct requests to an external service without explicit permission) [20:09:18] So it has to be from Tool Labs, and not from the user's browser? [20:09:42] yes [20:09:50] So I can't source javascript libraries, etc from external servers? [20:09:52] OK. [20:10:18] https://tools.wmflabs.org/cdnjs/ :-) [20:11:18] That's handy. [20:11:22] Thanks valhallasw`cloud! [20:16:52] 06Labs, 10Tool-Labs, 10DBA: Discrepancy between quarry results, and toolabs. - https://phabricator.wikimedia.org/T133469#2232679 (10ASammour) [20:20:53] ASammour: The only thing that connect between the two users is that they get the sysop's rights in the same day!. <-- which day was that? [20:21:34] 06Labs, 10Tool-Labs, 10DBA: Discrepancy between quarry results, and toolabs. - https://phabricator.wikimedia.org/T133469#2232679 (10valhallasw) The same query on `arwiki.labsdb`: ``` MariaDB [arwiki_p]> SELECT -> user_name, -> COUNT(log_timestamp) -> FROM logging... [20:21:44] 06Labs, 10Tool-Labs, 10DBA: Discrepancy between quarry results, and toolabs. - https://phabricator.wikimedia.org/T133469#2232679 (10Krenair) On labsdb1001 I get 35 rows from that query (`SELECT user_name, COUNT(log_timestamp) FROM logging JOIN user ON user_id = log_user WHERE log_type = 'delete' AND log_acti... [20:23:08] 06Labs, 10Tool-Labs, 10DBA: Discrepancy between quarry results, and toolabs. - https://phabricator.wikimedia.org/T133469#2232701 (10Krenair) ```krenair@tools-bastion-03:~$ echo "SELECT user_name, COUNT(log_timestamp) FROM logging JOIN user ON user_id = log_user WHERE log_type = 'delete' AND log_action = 'del... [20:24:34] 06Labs, 10DBA: Discrepancy between quarry results, and toolabs. - https://phabricator.wikimedia.org/T133469#2232702 (10Krenair) Quarry always uses labsdb1001 IIRC, whereas your code is most likely using labsdb1003: ```krenair@tools-bastion-03:~$ host arwiki.labsdb arwiki.labsdb has address 10.64.37.5 krenair@t... [20:30:03] RECOVERY - Puppet run on tools-exec-1221 is OK: OK: Less than 1.00% above the threshold [0.0] [20:39:41] 06Labs, 10DBA: Discrepancy between labsdb replicas of arwiki_p.user_groups - https://phabricator.wikimedia.org/T133469#2232723 (10Krenair) [20:42:12] 06Labs, 10DBA: Discrepancy between labsdb replicas of arwiki_p.user_groups - https://phabricator.wikimedia.org/T133469#2232724 (10Krenair) specifically the row with ug_user=396026 and ug_group=sysop is missing on labsdb1003 [21:16:25] 10Tool-Labs-tools-stewardbots, 10Continuous-Integration-Config, 13Patch-For-Review: Implement jenkins tests on labs/tools/stewardbots - https://phabricator.wikimedia.org/T128503#2232740 (10MarcoAurelio) 05Open>03stalled [22:32:20] (03CR) 10BryanDavis: "Zuul barfed on this somehow. I'd +2 myself to push it through but apparently I don't have +2 on this repo." [labs/toollabs] - 10https://gerrit.wikimedia.org/r/283378 (owner: 10BryanDavis) [22:37:39] I ve got a question to labs terms of use: Is it allowed to run bots for non Wikimedia wikis at Tool labs? [22:57:27] MGC|mobil: no, that would be against the TOU for all of Labs. The free resources that Labs provides are for the support and enhancement of the Wikimedia movement. [23:03:23] Okay [23:03:42] 10PAWS: PAWS Configuration for Running Scripts - https://phabricator.wikimedia.org/T133473#2232786 (10Dave_Braunschweig) [23:07:03] Bit in my opinion every bot that supports collection of free knowledge at any place would support the Wikimedia movement [23:09:28] yes, It does, in my opinion too [23:21:24] bd808: ping [23:22:11] MGC|mobil: what wiki? How does Wikimedia movement benefit? [23:26:23] I think every wiki benefits the movement, because a wiki by definition collects free knowledge and as such shares the intentions of the movement. [23:28:15] that's a pretty broad definition [23:32:14] but it complies with the TOU [23:33:34] because it provides the wikimedia movement enhancement [23:34:03] I think that would be the debatable point [23:34:28] Well, you can run a wiki and make it private [23:34:31] How does that help WMF? [23:34:52] s/WMF/WM/ [23:34:53] https://wikitech.wikimedia.org/wiki/Wikitech:Labs_Terms_of_use#What_uses_of_Labs_do_we_like.3F [23:35:16] its is a bit vague in "run bots" [23:35:37] There's various free/nearly shell hosting and such that will let you do what you want [23:35:41] but I think that would be easily connected to "related to a Wikimedia Project or to MediaWiki software development or testing"