[01:53:29] 10Quarry, 5Patch-For-Review: Quarry does not respect ORDER BY sort order in result set - https://phabricator.wikimedia.org/T87829#1461714 (10Huji) Yuvi I hope you documented somewhere how one can set up Quarry on vagrant. Quarry has a tone of dependencies, so having that documentation somewhere would really help. [01:54:44] 10Quarry, 5Patch-For-Review: Quarry does not respect ORDER BY sort order in result set - https://phabricator.wikimedia.org/T87829#1461715 (10Huji) PS: (and sorry for spamming, I just realized I cannot edit this task anymore) I think you should remove the "patch for review" once the issue is fixed. [02:06:09] Hello, I'm new to Labs, and I was wondering if I could get some help. I recently a) created a labs account b) added a public SSH key (and can SSH into the bastion hosts) c) Got access to Tools project, and d) created 2 tools using the link on https://tools.wmflabs.org/ . My problem is that neither tool has the ~/replica.my.cnf file (after running become ), so I cannot access the databases. Is there something I'm missing [02:58:43] PROBLEM - Free space - all mounts on tools-webgrid-lighttpd-1404 is CRITICAL tools.tools-webgrid-lighttpd-1404.diskspace.root.byte_percentfree (<30.00%) [03:33:06] 6Labs, 10Labs-Infrastructure: Set up second DNS server for Labs instances - https://phabricator.wikimedia.org/T90234#1461752 (10coren) [03:33:08] 6Labs, 10Labs-Infrastructure, 5Patch-For-Review: Internal DNS look-ups fail every once in a while - https://phabricator.wikimedia.org/T72076#1461749 (10coren) 5Open>3Resolved a:3coren That should no longer be an issue as the DNS server has been replaced and appears to be working correctly. Reopen if i... [03:48:29] 6Labs, 10wikitech.wikimedia.org: Wikitech may fail to add the project-bastion group when shell access is granted - https://phabricator.wikimedia.org/T89667#1461753 (10coren) 5Open>3Resolved a:3coren This has not recurred in some weeks, pointing to T89001 as the culprit. [03:50:33] 6Labs: Wikitech creates broken LDAP entry for new instances and users - https://phabricator.wikimedia.org/T89001#1461756 (10coren) 5Open>3Resolved a:3coren No such symptom has been observed at least since the wikitech move to new hardware, so it's reasonable to presume that Andrew's assessment of the cause... [03:59:51] 10Quarry, 5Patch-For-Review: Quarry does not respect ORDER BY sort order in result set - https://phabricator.wikimedia.org/T87829#1461760 (10yuvipanda) @Huji: Just running 'vagrant up' on a quarry checkout works :) I'll write up a README soon [05:59:01] 10Quarry: Quarry does not respect ORDER BY sort order in result set - https://phabricator.wikimedia.org/T87829#1461793 (10yuvipanda) [06:11:12] halfak: go to sleep! :P [06:11:28] YuviPanda, I think I got it [06:11:31] I had an idea [06:11:33] w000 [06:11:35] Sleepdea [06:22:00] YuviPanda, https://github.com/wiki-ai/ores-wikimedia-config/pull/15 [06:22:03] Should work. [06:22:12] I blame sleepiness for not noticing the issue sooner. [06:22:19] Thanks for all your help. [06:22:22] * halfak runs to bed. [06:23:46] halfak: cya! [06:25:42] i have a user table with a primary key. since some days there are two rows with the same primary key value. how can this happen? [06:43:43] RECOVERY - Free space - all mounts on tools-webgrid-lighttpd-1404 is OK All targets OK [08:22:56] 10Quarry: Number of queries shown in profile is wrong - https://phabricator.wikimedia.org/T86512#1461838 (10Schnark) a:3yuvipanda There is now an empty draft query titled "None" in my profile (and some other profiles I checked), but the number of the queries is now always the number of all shown queries, inclu... [08:23:03] 10Quarry: Number of queries shown in profile is wrong - https://phabricator.wikimedia.org/T86512#1461840 (10Schnark) 5Open>3Resolved [09:55:56] PROBLEM - Puppet failure on tools-static-02 is CRITICAL 100.00% of data above the critical threshold [0.0] [10:07:32] PROBLEM - Puppet failure on tools-static-01 is CRITICAL 100.00% of data above the critical threshold [0.0] [11:06:44] 6Labs, 10Tool-Labs: Rename revision_userindex to revision - https://phabricator.wikimedia.org/T68786#1461872 (10Ricordisamoa) [11:33:46] Hello! [11:49:04] o/ CristianCantoro [11:52:11] halfak: :) [11:54:31] Just dragged myself out of bed to get started on a presentation. ughh. :S [11:54:36] PROBLEM - Puppet failure on tools-webgrid-lighttpd-1402 is CRITICAL 22.22% of data above the critical threshold [0.0] [12:34:39] RECOVERY - Puppet failure on tools-webgrid-lighttpd-1402 is OK Less than 1.00% above the threshold [0.0] [14:10:55] halfak: hey (sorry disconnected... I'm experimenting with VPNs) [14:11:00] andrewbogott: hi! [14:11:06] No worries :) [14:13:03] I have a question: how can I get an IP for my project/instance? [14:13:09] *a public IP [14:37:53] CristianCantoro, good Q. I believe you can, but andrewbogott or YuviPanda will know the details [14:37:54] Bah [14:37:57] Just too late [15:33:25] CristianCantoro: halfak re: public IP, if all you want is to expose https/http services, you can use the 'manage web proxies' link on the wikitech sidebar [15:34:09] YuviPanda: ... ok.. I have install nginx on my instance [15:34:15] YuviPanda, good point. I should have brought that up. I assumed actual public IP was necessary. Proxies solves most needs. [15:35:03] halfak: your sudo issue should be fixed now. [15:35:13] Cool. I'll give it a try [15:35:15] halfak: I fear that I have lost your explanation (I have disconnected again) [15:35:26] No worries. [15:35:36] (would like to read it, though ;-)) [15:35:37] Look for "manage web proxies" on the left side. [15:36:12] If your server will respond to port 80, the proxy should direct traffic appropriately. [15:37:29] For "DNS hostname" I should use something I like (say "wikidataldf") [15:37:42] (the project being named "Wikidata LDF") [15:37:47] ? [15:40:32] CristianCantoro: yes, that will give you wikidataldf.wmflabs.org [15:40:57] I get a "504 Gateway Time-out" [15:41:02] YuviPanda: ^^ [15:41:17] CristianCantoro: you have to modify the security groups to open up port 80 [15:41:24] default firewall rules do not have it open unforutnately [15:42:31] YuviPanda: ok... (adding range 80:80 on tcp) [15:42:41] * CristianCantoro notes to google for CIDR ranges [15:43:32] YuviPanda: Failed to add rule. [15:43:33] :( [15:43:40] you need to give it a description [15:43:44] we have terrible UI [15:43:51] CIDR use 10.0.0.0/8 [15:44:23] what should I use as source group? [15:44:44] nothing [15:44:47] also... I am trying to add it to the default rules [15:44:50] yeah, that's ok [15:45:36] Ok, I see something! http://wikidataldf.wmflabs.org/ [15:46:30] :D [15:46:32] congrats! [15:46:34] * YuviPanda gtg now [16:30:36] (03PS1) 10Sitic: Serve material-design-icons from cdnjs [labs/tools/crosswatch] - 10https://gerrit.wikimedia.org/r/225551 (https://phabricator.wikimedia.org/T105980) [16:30:49] (03CR) 10Sitic: [C: 032 V: 032] Serve material-design-icons from cdnjs [labs/tools/crosswatch] - 10https://gerrit.wikimedia.org/r/225551 (https://phabricator.wikimedia.org/T105980) (owner: 10Sitic) [16:34:31] 6Labs, 6Discovery: Upgrade postgres on labsdb1004 / 1005 to 9.4, and PostGis 2.1 - https://phabricator.wikimedia.org/T101233#1462105 (10madhuvishy) [16:43:57] 6Labs, 6Discovery: Upgrade postgres on labsdb1004 / 1005 to 9.4, and PostGis 2.1 - https://phabricator.wikimedia.org/T101233#1462116 (10yuvipanda) This is being done right now :) [17:03:31] 6Labs, 10wikitech.wikimedia.org: Get rid of SMW/SRF/SF - https://phabricator.wikimedia.org/T53642#1462166 (10Bugreporter) [17:24:54] I need to make the url http://wikidataldf.wmflabs.org/data/ point to the port 5000 of the machine where wikidataldf.wmflabs.org is hosted [17:25:09] I am using nginx, and I have tried using proxy_pass with no success [17:25:34] http://data.wikidataldf.wmflabs.org point to port 5000 of the same machine as well [17:25:37] and it works [17:29:24] this is the configuration I am using http://pastebin.com/smnvGr94 [17:35:39] Hi. My tool labs bot (danmicholobot) has been denied access to the db since July 10th. Any ideas what I can do? Is it possible to generate a new replica.my.cnf ? [17:42:47] danmichaelo: replica.my.cnf creation is currently broken, either copy it from a different account (e.g. your personal account) or file a subtask for https://phabricator.wikimedia.org/T104453 [17:43:13] sitic: ok, thx [18:43:06] 10Tool-Labs-tools-Other: tools.wmflabs.org/cdnjs is outdated - https://phabricator.wikimedia.org/T106228#1462341 (10Sitic) 3NEW [18:46:49] 10Tool-Labs-tools-Other, 7Epic: Convert all Labs tools to use cdnjs for static libraries - https://phabricator.wikimedia.org/T103934#1462369 (10Sitic) https://github.com/simonwhitaker/github-fork-ribbon-css is in cndjs and is a recreation of the Fork me on GitHub ribbon in CSS. [18:49:45] 10Tool-Labs-tools-Other: Edits by user results - https://phabricator.wikimedia.org/T106040#1462397 (10Sitic) 5Open>3Resolved a:3Sitic [18:50:15] 10Tool-Labs-tools-Other: Edits by user results - https://phabricator.wikimedia.org/T106040#1457500 (10Sitic) a:5Sitic>3Sigma [18:53:29] 10Tool-Labs-tools-Other: usersearch on Tool-Labs lists invalid URLs for Contributions by User to a page - https://phabricator.wikimedia.org/T104812#1462412 (10Sitic) [18:53:31] 10Tool-Labs-tools-Other: Edits by user results - https://phabricator.wikimedia.org/T106040#1462413 (10Sitic) [18:56:14] 10Tool-Labs-tools-Other: tools.wmflabs.org/cdnjs is outdated - https://phabricator.wikimedia.org/T106228#1462416 (10yuvipanda) Broken because no space left on device! I shall fix this shortly :) [19:08:42] PROBLEM - Host tools-static-02 is DOWN: CRITICAL - Host Unreachable (10.68.16.216) [19:09:10] ^ is ok [19:09:11] that's me [19:15:46] RECOVERY - Host tools-static-02 is UPING OK - Packet loss = 0%, RTA = 1.10 ms [19:16:48] PROBLEM - Host tools-static-02 is DOWN: CRITICAL - Host Unreachable (10.68.16.216) [19:17:51] 10Quarry: Quarry does not respect ORDER BY sort order in result set - https://phabricator.wikimedia.org/T87829#1462447 (10yuvipanda) @Huji Readme is here! https://github.com/wikimedia/analytics-quarry-web/blob/master/README.md [20:04:06] PROBLEM - Puppet failure on tools-web-static-01 is CRITICAL 100.00% of data above the critical threshold [0.0] [20:23:49] 10Tool-Labs-tools-Other: tools.wmflabs.org/cdnjs is outdated - https://phabricator.wikimedia.org/T106228#1462630 (10yuvipanda) I recreated them as Large instances with more Disk space, should be good. [20:24:06] RECOVERY - Puppet failure on tools-web-static-01 is OK Less than 1.00% above the threshold [0.0] [20:48:42] 10Tool-Labs-tools-Other: tools.wmflabs.org/cdnjs is outdated - https://phabricator.wikimedia.org/T106228#1462662 (10yuvipanda) 5Open>3Resolved a:3yuvipanda Thanks for reporting! [21:30:44] 10Quarry: Ideas for reports - https://phabricator.wikimedia.org/T78597#1462701 (10Sitic) [21:30:47] 10Tool-Labs-tools-Other: Non technical: "Database reports" - status query - https://phabricator.wikimedia.org/T92353#1462700 (10Sitic) [21:52:52] 10Tool-Labs-tools-Other: Some geolocated photos not shown - https://phabricator.wikimedia.org/T105593#1462760 (10Sitic) The OSM link goes to [wiwosm](https://tools.wmflabs.org/wiwosm/osm-on-ol/commons-on-osm.php), to Google Earth link goes geocommons. Both seem to miss a lot of images compared to https://geoloca... [22:21:04] !log mediawiki-core-team Made Dduvall a project admin [22:21:07] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Mediawiki-core-team/SAL, Master [22:22:16] marxarel_: gilded-yak.mediawiki-core-team.eqiad.wmflabs [22:28:49] SMalyshev: https://wikitech.wikimedia.org/wiki/Trebuchet#Using_Trebuchet_in_Labs [22:29:32] I tried all kinds of crap and I believe this is the subset of it that was actually useful, but no guarantees :) [23:05:05] 6Labs, 6Discovery, 5Patch-For-Review: Upgrade postgres on labsdb1004 / 1005 to 9.4, and PostGis 2.1 - https://phabricator.wikimedia.org/T101233#1462894 (10yuvipanda) This seems to be done. [23:11:02] 6Labs, 6Discovery, 5Patch-For-Review: Upgrade postgres on labsdb1004 / 1005 to 9.4, and PostGis 2.1 - https://phabricator.wikimedia.org/T101233#1462905 (10yuvipanda) @akosiaris I've manually granted all of labs access with: `host all all 10.0.0.0/8 md5` We should puppetize this.