[00:08:09] YuviPanda - what did you mean with "could be worse" in the channel topic? [00:27:43] !worstcase [00:27:56] [16:27:49] !worstcase [00:27:56] [16:27:50] Generally, the worst that can happen is that someone compromises your site, steals your data, deletes it and replaces it with kiddy porn. Then they start a spam service on your server advertising the kiddy porn to twenty million email addresses, daily. Then your home gets raided, you get fired and your wife leaves you. Then you get killed in your sleep by ninjas. [00:28:00] doctaxon: that ^ I suppose. [00:29:00] that's what i want to paste every time i see "what could possibly go wrong" as a commit comment [02:30:16] 6Labs, 10MediaWiki-extensions-SemanticForms, 10wikitech.wikimedia.org: "Edit with form" missing on a Tools access request page - https://phabricator.wikimedia.org/T118136#1917281 (10Krenair) That just made it return array(0){} in both cases. [02:33:42] 6Labs, 10Tool-Labs, 7Documentation: Create a wiki documentation page for each tool - https://phabricator.wikimedia.org/T122865#1917283 (10Pengo) > another burden on developers' backs just when they create a tool The initial page could be generated or copy-and-paste, and should contain very basic information... [03:06:16] Change on 12wikitech.wikimedia.org a page Nova Resource:Tools/Access Request/Thparkth was created, changed by Thparkth link https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Thparkth edit summary: Created page with "{{Tools Access Request |Justification=Develop SQL query to identify users eligible for "autopatrolled" on en-wiki. Currently performing this task remotely in Perl via the API...." [03:43:11] I got a tools cron mail about a job being finished that's still running … [04:51:24] and now the /tmp dir on the database replica seems full, grrr [07:34:00] 6Labs, 10MediaWiki-extensions-SemanticForms, 10wikitech.wikimedia.org: "Edit with form" missing on a Tools access request page - https://phabricator.wikimedia.org/T118136#1917537 (10Yaron_Koren) Oh well. I just looked again and noticed something unusual: the offending page (https://wikitech.wikimedia.org/wik... [08:11:08] 6Labs, 10MediaWiki-extensions-SemanticForms, 10wikitech.wikimedia.org: "Edit with form" missing on a Tools access request page - https://phabricator.wikimedia.org/T118136#1917540 (10Krenair) I used https://wikitech.wikimedia.org/w/api.php?action=purge&forcelinkupdate=true&titles=Nova_Resource:Tools/Access_Re... [08:15:14] 6Labs, 6operations, 10wikitech.wikimedia.org: Rename specific account in LDAP, Wikitech, Gerrit and Phabricator - https://phabricator.wikimedia.org/T85913#1917543 (10demon) If somebody can give me the rename user rights on wikitech I can do this. As I've said before, that's the piece I lack. [09:01:12] Change on 12wikitech.wikimedia.org a page Nova Resource:Tools/Access Request/Thparkth was modified, changed by Tim Landscheidt link https://wikitech.wikimedia.org/w/index.php?diff=248839 edit summary: [09:20:31] 6Labs, 7Shinken: Labs Shinken complains about no more existing host integration-t102459 is DOWN - https://phabricator.wikimedia.org/T121767#1917546 (10hashar) 5Open>3Resolved a:3hashar I haven't received any email notification from Shinken overnight. I am assuming the configuration has been properly reco... [09:21:38] 6Labs, 10Continuous-Integration-Infrastructure, 7Shinken, 7WorkType-Maintenance: Labs Shinken complains about no more existing host integration-t102459 is DOWN - https://phabricator.wikimedia.org/T121767#1917549 (10hashar) [09:24:51] 6Labs, 10Beta-Cluster-Infrastructure, 6operations: deployment-mediawiki03 : apt broken trying to reach out webproxy.eqiad.wmnet - https://phabricator.wikimedia.org/T122953#1917550 (10hashar) 3NEW [09:25:30] 6Labs, 10Beta-Cluster-Infrastructure, 6operations: deployment-mediawiki03 : apt broken trying to reach out webproxy.eqiad.wmnet - https://phabricator.wikimedia.org/T122953#1917557 (10hashar) [09:28:44] 6Labs, 10Beta-Cluster-Infrastructure, 6operations: deployment-mediawiki03 : apt broken trying to reach out webproxy.eqiad.wmnet - https://phabricator.wikimedia.org/T122953#1917559 (10hashar) Command to mass check: `root@deployment-salt:~ # salt -v '*' file.find /etc/apt grep=webproxy` [09:35:39] 6Labs, 10Beta-Cluster-Infrastructure, 10Continuous-Integration-Infrastructure, 6operations: deployment-mediawiki03 : apt broken trying to reach out webproxy.eqiad.wmnet - https://phabricator.wikimedia.org/T122953#1917560 (10hashar) The`apt` puppet class has a `$use_proxy` parameter that would create the fi... [09:36:00] 6Labs, 10Beta-Cluster-Infrastructure, 10Continuous-Integration-Infrastructure, 6operations: deployment-mediawiki03 : apt broken trying to reach out webproxy.eqiad.wmnet - https://phabricator.wikimedia.org/T122953#1917562 (10hashar) 5Open>3Resolved a:3hashar [10:16:01] 6Labs, 10Tool-Labs, 7Documentation: Create a wiki documentation page for each tool - https://phabricator.wikimedia.org/T122865#1917567 (10scfc) When a tool is created, only the tool's name and the name of the initial developer who created it is known. All subsequent changes (creating a `toolinfo.json`, addi... [10:28:14] 6Labs, 10MediaWiki-extensions-SemanticForms, 10wikitech.wikimedia.org: "Edit with form" missing on a Tools access request page - https://phabricator.wikimedia.org/T118136#1917571 (10scfc) So to summarize: The problem was that when https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Edodero... [10:32:22] 6Labs, 10Tool-Labs, 7Documentation: Create a wiki documentation page for each tool - https://phabricator.wikimedia.org/T122865#1917573 (10valhallasw) >>! In T122865#1917283, @Pengo wrote: > Rather than be a burden, it removes the burden of having to find somewhere to add documentation I'm not sure if that's... [16:17:48] (03CR) 10Jean-Frédéric: [C: 032] "Thanks!" [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/262102 (https://phabricator.wikimedia.org/T122754) (owner: 10Florianschmidtwelzow) [16:20:23] (03Merged) 10jenkins-bot: Replace Title::userIsWatching [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/262102 (https://phabricator.wikimedia.org/T122754) (owner: 10Florianschmidtwelzow) [16:21:21] 6Labs, 6operations, 10wikitech.wikimedia.org: Rename specific account in LDAP, Wikitech, Gerrit and Phabricator - https://phabricator.wikimedia.org/T85913#1918059 (10bd808) >>! In T85913#1917543, @demon wrote: > If somebody can give me the rename user rights on wikitech I can do this. As I've said before, th... [16:34:23] hello... I'm trying to optimize a fairly heavy query against the enwiki database replica, but I don't seem to have permission to run EXPLAIN. Is that intentional? [16:35:25] MariaDB [enwiki_p]> explain select page_id from page where page_id=123456; [16:35:31] ERROR 1345 (HY000): EXPLAIN/SHOW can not be issued; lacking privileges for underlying table [16:35:40] obviously that isn't the actual query in question :D [16:53:39] thparkth: I get the same error.. [16:55:02] thparkth: and https://bugs.mysql.com/bug.php?id=64198 seems to explain it.. "We therefore now also require the SHOW VIEW privilege on the view in order to do EXPLAIN SELECT." .. [16:58:08] any idea what it would take to be granted SHOW VIEW? I can't imagine it would reveal anything super-sensitive :) [17:02:22] 6Labs, 10Tool-Labs, 10DBA: Assign "SHOW VIEW" privileges to labs-users on the replica databases - https://phabricator.wikimedia.org/T122966#1918086 (10Stigmj) 3NEW [17:02:33] Stigmj, thparkth: you also need SELECT privileges on the underlying database [17:02:39] which you can't get, for obvious reasons [17:03:16] valhallasw`cloud: ok then.. if you say so.. :) [17:03:37] unless they changed this again [17:03:56] the reasoning being that the estimated number of rows is privileged information [17:04:53] it is pretty much impossible to optimize a query then if that is the case [17:05:21] thparkth: you can, however, explain a running query. There's a tool that does that for you -- lemme see if I can find it [17:05:55] EXPLAIN FOR CONNECTION? [17:06:29] thparkth: https://phabricator.wikimedia.org/T50875 [17:07:05] that looks really useful, thanks [17:07:05] 6Labs, 10Tool-Labs, 10DBA: Assign "SHOW VIEW" privileges to labs-users on the replica databases - https://phabricator.wikimedia.org/T122966#1918105 (10valhallasw) [17:07:07] 6Labs, 10Tool-Labs, 7Upstream: Unable to explain queries on replicated databases - https://phabricator.wikimedia.org/T50875#1918106 (10valhallasw) [18:26:56] 6Labs, 10Labs-Infrastructure: Setup an apt proxy for labs - https://phabricator.wikimedia.org/T122819#1918266 (10Andrew) When I asked for this I was thinking that labs boxes couldn't reach apt on Carbon at all, which seems not to be true. So I pretty much don't care about this anymore unless you think there a... [19:02:20] https://etherpad.wikimedia.org/p/yuvidump [19:16:09] (what are you documenting?) [19:16:28] valhallasw`cloud: everything yuvi knows about the grid engine [19:16:44] or, I guess, more generally: trying to make yuvi less of a spof [19:16:55] ah. Shall I also dump everything I know there? [19:17:37] sure :) [19:17:43] sounds good to me [19:18:02] hopefully we will feed things back into the wiki eventually [19:50:53] 6Labs, 10Labs-Infrastructure: Flood "Mail delivery failed: returning message to sender" - https://phabricator.wikimedia.org/T122700#1918607 (10Nemo_bis) >>! In T122700#1911628, @valhallasw wrote: > Did you get the same email ten times (same ID, 1aDCon-0003Gk-MV), or did this person just upload ten files? The... [19:57:01] 6Labs, 10Tool-Labs: Limit webservice manifest restarts - https://phabricator.wikimedia.org/T107878#1918634 (10valhallasw) Note that this causes large amounts of outgoing mail (one per 20 seconds, to the same destination), which is not very nice. [20:04:30] 6Labs, 10Labs-Infrastructure: Flood "Mail delivery failed: returning message to sender" - https://phabricator.wikimedia.org/T122700#1918662 (10valhallasw) Right, so as I understand it, tools.bub sends out ten e-mails (either because the user submitted the request multiple times, or because for some reason the... [21:04:40] https://etherpad.wikimedia.org/p/toolssupport [21:11:28] bd808: is that for labs tools or a tools team ? ;D [21:11:49] hashar: tools lab end user [21:16:34] 6Labs, 10wikitech.wikimedia.org: Exclude nova resource pages from wikitech search - https://phabricator.wikimedia.org/T122993#1918805 (10Andrew) 3NEW [21:20:52] 6Labs, 10wikitech.wikimedia.org: Exclude nova resource pages from wikitech search - https://phabricator.wikimedia.org/T122993#1918818 (10valhallasw) The namespace was added for {T67132}, but the tool labs docs have been moved now. I also use have used this to match names to instances and the corresponding pro... [21:21:25] 6Labs, 10wikitech.wikimedia.org: Exclude nova resource pages from *default* wikitech search - https://phabricator.wikimedia.org/T122993#1918820 (10yuvipanda) [21:22:02] 6Labs, 10wikitech.wikimedia.org: Exclude nova resource pages from *default* wikitech search - https://phabricator.wikimedia.org/T122993#1918805 (10yuvipanda) Yeah, I think having it just off the default list is good enough. [21:22:36] YuviPanda: note thta 'off the default list' effectively means 'switch to google if you want this' [21:22:53] because now suddenly you have to think about which namespaces to include [21:22:53] valhallasw`cloud: it means 'hit advanced search and check that checkbox' [21:22:56] that's what I do for Hiera [21:23:01] still in meeting tho [21:23:20] so on and off [21:23:33] YuviPanda: yes, that's four clicks more than google :P [21:24:09] I guess I could just write a userscript to make it easier [21:24:25] there's also the everything button which I guess does what I want [21:26:53] 6Labs, 10wikitech.wikimedia.org: Exclude nova resource pages from *default* wikitech search - https://phabricator.wikimedia.org/T122993#1918848 (10valhallasw) I just realized this also excludes SALs (and project index pages!) from search, and SALs tend to be provide useful contextual information. Would it be p... [21:33:56] 6Labs, 10Tool-Labs, 7Documentation: Create a wiki documentation page for each tool - https://phabricator.wikimedia.org/T122865#1918903 (10Pengo) > Example of this: pywikibot documentation. There's the official documentation on mediawiki.org, there's books on wikibooks (outdated), there's tutorials on differe... [22:10:27] 6Labs: labs (labvirt/labservices) in "misc" ganglia cluster - https://phabricator.wikimedia.org/T123000#1918974 (10fgiunchedi) 3NEW [22:19:51] 6Labs, 10WikiProject-X, 7Tracking: New Labs project: WPX - https://phabricator.wikimedia.org/T122534#1919011 (10Harej) [22:21:22] 6Labs, 10Labs-Infrastructure: Flood "Mail delivery failed: returning message to sender" - https://phabricator.wikimedia.org/T122700#1919017 (10Nemo_bis) 5Open>3Invalid a:3Nemo_bis That doesn't match my understanding of how the emailing by bub works, but I can't disprove your interpretation and I don't re... [22:33:10] 6Labs, 10Labs-Infrastructure: Enable memory cgroups for default Jessie image - https://phabricator.wikimedia.org/T122734#1919038 (10Andrew)