[00:00:34] mutante: yeah... :p [00:00:59] JohnLewis: we are getting closer since you found the newer version :) [00:01:19] yeah, its harder for me though as I don't have a schema at all, you do :p (kinda) [00:01:35] just one thing to skip as opposed to like 3 or 4 [00:02:02] well.. we just gotta know what we could leak when not doing "delete_deleted_comments" [00:03:14] there's the "isprivate" field, checking what that has [00:04:16] isprivate would be a 0 / 1 field. [00:04:19] *should be [00:04:28] good news, there are none that are 1 [00:04:37] select count(bug_id) from longdescs where isprivate=0; [00:04:42] 390980 [00:04:51] where isprivate!=0; [00:04:53] 0 [00:04:57] sweet [00:06:18] be careful guys there is some weirdness where a ticket can be private, but not have private comments [00:06:31] though they are private by extension it's not notated [00:06:44] 7Blocked-on-Operations, 6operations, 10Citoid, 6Scrum-of-Scrums, 6Services: Zotero not running in production - https://phabricator.wikimedia.org/T76308#1055831 (10GWicke) Also worth considering, especially on jessie: https://packages.debian.org/sid/xulrunner-24.0 [00:07:07] Is git review hanging for everyone or just me? [00:07:22] andrewbogott: was hanging for me big time a bit ago [00:07:28] eventually finished [00:07:29] chasemp: private tickets are being dealt with separately [00:07:40] chasemp: 1 minute? 10 minutes? [00:07:42] 90? [00:07:47] okay not 90 [00:07:57] JohnLewis: no worries just a thought as I lived through bz pain [00:08:00] <^demon|away> lol git review [00:08:11] I can’t imagine what it’s doing. I fetched a minute ago, so it’s not that... [00:08:41] <^demon|away> It has a --verbose mode or something where it spits out what it's doing [00:09:21] so it does! [00:09:28] ' Running: git remote update gerrit' [00:10:01] I kind of expected it to just have a line item “sleeping: just to fuck with you” [00:10:20] Well, I guess I’ll go get my laundry and see if it’s still ‘git remove update gerrit’ when I get back [00:11:29] I'm getting hung up on a git pull too [00:12:26] the ssh session it rides over itself is fine (checked with ssh debug options), it's the git part where it does upload-pack or whatever that's taking forever [00:12:40] it’s a race! [00:13:44] <^demon|away> Well that'd explain sluggishness [00:14:21] the machine doesn't seem busy [00:14:30] <^demon|away> https://phabricator.wikimedia.org/P319 [00:14:34] wow, i'm finding bugs now that have been imported TO old Bugzilla [00:14:36] Migrated from sf.net bugtracker [00:14:41] Originally opened 2002-07-18 08:48 [00:15:35] I notice gerrit is running w/ -Xmx20g but has 33.2g VM mapped one way or another. it could be that it needs a restart due to some kind of resource issue [00:17:21] I've never debugged our gerrit before. is it normal and reasonably-nondestructive to restart the service daemon? [00:17:55] <^demon|away> Nope, which is why it's good to check the queue before restarting. [00:18:07] <^demon|away> there's no safe "drain all existing work and then restart" option [00:18:21] I cancelled my pull [00:18:42] yet, if you merge a config change you have to restart it too [00:18:50] what's up with the 907M for jar files and such in /var/lib/gerrit2/review_site/tmp [00:19:41] <^demon|away> gerrit caching stuff and not clearing it, likely [00:20:04] <^demon|away> Those all look like plugin jars [00:20:39] wow the storage setup on that box is... interesting :p [00:21:08] <^demon|away> Yeah, it's rather odd [00:21:22] the standard two disks are setup with 2x partitions each for the normal linux md-raid mirroring with /dev/md0 as rootfs and /dev/md1 as the rest [00:21:34] JohnLewis: "longdescs: The meat of bugzilla -- here is where all user comments are stored! [00:21:37] You've only got 2^24 bytes per comment (it's a mediumtext field), so speak [00:21:40] sparingly -- that's only the amount of space the Old Testament from the Bible [00:21:43] would take" [00:21:48] and then /dev/md1 is a PV for LVM, where it's the only PV in the only VG on the box, which only has one volume, which is the gerrit fs (and doesn't even use all the space avail) [00:22:05] why not just put the gerrit fs on /dev/md1 and kill LVM? :p [00:22:08] mutante: kay :p [00:22:32] <^demon|away> bblack: Honestly, I don't know why it's setup that way. [00:22:57] JohnLewis: seems like this is the closest we get to a schema http://www.bugzilla.org/docs/2.18/html/dbdoc.html [00:23:01] I'm gonna log out and pretend I never logged in there, it will make my weekend better :p [00:23:21] 2.18? jeez that 2 major releases away [00:23:51] <^demon|away> bblack: I wouldn't touch it so late on a friday either :) [00:24:08] JohnLewis: and doesn't mention the "tag" field [00:24:49] mutante: which confused me [00:25:07] yea, they stopped writing dbdoc.html later .. meh [00:25:28] Badzilla [00:25:35] oh I guess there was a swap LV in that VG too, but still, those could be /dev/md[012] [00:25:57] anyways, I'm not touching shit. I'm pretty much done for the day, gonna go start binging my way through some Dexter on netflix :) [00:26:44] <^demon|away> I'm going to make $adult_beverage and start my weekend as well [00:30:14] JohnLewis: there's actually some interesting discussion i found where they discussed if comments should ever be editable/deletable or not. like ""has several undesirable effects. The rationale for decisions often gets lost by people “tidying up”. You can’t be certain that you are reading what someone else read before they said what they said." [00:30:22] that's actually true for phab [00:30:47] maybe the "tag" thing is new instead of old [00:31:19] but its not in the db schema for longdescs [00:31:21] ok! I have picked up my laundry and am back from a pleasant stroll. And yet... [00:31:23] “git remote update gerrit" [00:31:25] well table for it [00:32:44] andrewbogott: works for me [00:32:50] also, git pull origin/production [00:33:05] cancel and try again? [00:33:24] (without the / , sry) [00:34:04] * andrewbogott has cancelled and tried again many times [00:34:07] but I will, once more! [00:34:45] real 0m5.179s [00:34:53] for git remote update gerrit [00:38:12] 90 minutes ago I thought, ‘I’ll just push this demo patch in gerrit so I can link to it from the bug’ [00:38:20] What has happened since then? I have no idea [00:39:07] JohnLewis: "DESTROY(DBI::db=HASH(0x25f3b70))= ( undef ) [1 items] during global destruction" gotta love [00:39:10] bblack: you didn’t actually restart gerrit, right? Just looked at it and backed away, hands up? [00:40:24] i dont think he did, he said touched nothing [00:41:20] Hm, this time ‘git fetch origin’ returned 406. [00:41:27] I’m not sure I’ve ever seen a 406 before [00:42:40] (03PS1) 10Dzahn: fix some indentation and test if gerrit works [dns] - 10https://gerrit.wikimedia.org/r/192040 [00:42:45] andrewbogott: ^ i can use it just normal [00:42:50] wouldn't have noticed it [00:42:54] (03CR) 10jenkins-bot: [V: 04-1] fix some indentation and test if gerrit works [dns] - 10https://gerrit.wikimedia.org/r/192040 (owner: 10Dzahn) [00:43:18] you happen to be on comcast? [00:43:35] nah, att [00:43:51] DSL has that retro charm that I can’t resist [00:44:42] does it only happen on the puppet repo? how about another one [00:44:51] that was dns up there [00:46:22] just puppet, it seems [00:46:49] Why the hell is Wikipedia loading so slow [00:47:08] https://en.wikipedia.org/wiki/Wikipedia:Long_term_abuse/MascotGuy is taking forever to load in Wikipedia [00:47:10] er [00:47:14] Firefox [00:47:15] :P [00:47:37] If you go to https://en.wikipedia.org/wiki/User:MascotGuy and click on that link, it takes a long time [00:47:42] for me at least [00:50:56] 6operations, 6Phabricator, 10Wikimedia-Bugzilla: Sanitise a Bugzilla database dump - https://phabricator.wikimedia.org/T85141#1055958 (10Dzahn) made this modification: https://phabricator.wikimedia.org/transactions/detail/PHID-XACT-PSTE-laovvu2r7b335db/ to work around the missing "tag" field, supposing it... [00:51:16] well, that’s not helping [00:54:01] andrewbogott: and if you do it from a different host, not at home..a labs instance or so [00:54:13] Bsadowski1: can't confirm it's slow for me [00:54:58] Well https://bits.wikimedia.org/en.wikipedia.org/load.php?debug=false&lang=en&modules=startup&only=scripts&skin=monobook&* took 3 seconds to load [00:55:53] And https://bits.wikimedia.org/en.wikipedia.org/load.php?debug=false&lang=en&modules=ext.centralNotice.bannerChoiceData[...] took 18 seconds [00:56:11] Does that help some? :P [00:56:18] yeah, it works for me on a labs box. So I think it’s probably chugging along on my local machine, just VERY slowly [00:56:21] sorry 28 [00:56:25] not 18 [00:56:33] Bsadowski1: do you happen to be on comcast? [00:56:42] nope [00:56:44] AT&T [00:56:50] heh, like andrewbogott [00:56:55] and both things are fast for me [00:56:57] And it's failing to load at all [00:57:05] The actual page I mean [00:57:22] hm, weird that it was comcast yesterday and att torday [00:57:49] Forbidding scripts loads the page fine [00:58:01] I have NoScript [00:58:17] But if I allow "wikimedia.org".... [00:58:35] nothing [00:58:37] :/ [00:58:43] It must be due to bits [01:00:14] i also have noscript but wikimedia.org on the whitelist [01:17:40] 6operations, 6Phabricator, 10Wikimedia-Bugzilla: Sanitise a Bugzilla database dump - https://phabricator.wikimedia.org/T85141#1056039 (10Dzahn) file:///home/dzahn/wmf/bz_schema.sql [01:21:07] 6operations, 6Phabricator, 10Wikimedia-Bugzilla: Sanitise a Bugzilla database dump - https://phabricator.wikimedia.org/T85141#1056054 (10Dzahn) {F44606} [01:25:26] (03PS2) 10BryanDavis: logstash: Ship logs via syslog udp datagrams [mediawiki-config] - 10https://gerrit.wikimedia.org/r/191259 (https://phabricator.wikimedia.org/T88732) [01:25:48] (03CR) 10BryanDavis: "> There is needless duplication of handlers." [mediawiki-config] - 10https://gerrit.wikimedia.org/r/191259 (https://phabricator.wikimedia.org/T88732) (owner: 10BryanDavis) [01:27:42] ori: ^ I hope that addresses some of you concerns [02:01:11] 6operations, 6Phabricator, 10Wikimedia-Bugzilla: Sanitise a Bugzilla database dump - https://phabricator.wikimedia.org/T85141#1056081 (10JohnLewis) Leaving my ideas here quickly before I go for @dzahn (and public reasons): Get group_id of the security group and then using that id, associate it with bug_id... [02:15:27] !log l10nupdate Synchronized php-1.25wmf17/cache/l10n: (no message) (duration: 00m 02s) [02:15:35] Logged the message, Master [02:16:34] !log LocalisationUpdate completed (1.25wmf17) at 2015-02-21 02:15:31+00:00 [02:16:38] Logged the message, Master [02:17:11] !log l10nupdate Synchronized php-1.25wmf18/cache/l10n: (no message) (duration: 00m 01s) [02:17:15] Logged the message, Master [02:18:18] !log LocalisationUpdate completed (1.25wmf18) at 2015-02-21 02:17:15+00:00 [02:18:22] Logged the message, Master [02:53:06] 6operations, 10Continuous-Integration, 5Patch-For-Review: Jenkins: Re-enable lint checks for Apache config in operations-puppet - https://phabricator.wikimedia.org/T72068#1056111 (10scfc) Could the `operations-apache-config-lint` job be completely removed until it is enabled again? [03:07:24] PROBLEM - Router interfaces on cr1-eqiad is CRITICAL: CRITICAL: host 208.80.154.196, interfaces up: 220, down: 1, dormant: 0, excluded: 0, unused: 0BRxe-4/2/0: down - Core: cr1-codfw:xe-5/2/1 (Telia, IC-307235) (#2648) [10Gbps wave]BR [03:22:25] PROBLEM - puppet last run on ms-be2014 is CRITICAL: CRITICAL: Puppet has 1 failures [03:22:54] PROBLEM - puppet last run on mw1246 is CRITICAL: CRITICAL: Puppet has 1 failures [03:40:05] RECOVERY - puppet last run on mw1246 is OK: OK: Puppet is currently enabled, last run 41 seconds ago with 0 failures [03:40:44] RECOVERY - puppet last run on ms-be2014 is OK: OK: Puppet is currently enabled, last run 39 seconds ago with 0 failures [03:54:13] 6operations, 10Parsoid, 6Services, 5Patch-For-Review, 7service-runner: Create a standard service template / init / logging / package setup - https://phabricator.wikimedia.org/T88585#1056162 (10GWicke) Now updated merged & slightly improved at https://github.com/wikimedia/service-template-node. I think... [04:11:44] (03CR) 10GWicke: "@Alex, either way when a box is moved some information about it needs to be changed. Forgetting to update the rack/row information for any" [puppet] - 10https://gerrit.wikimedia.org/r/167645 (https://phabricator.wikimedia.org/T84518) (owner: 10Alexandros Kosiaris) [04:32:44] Could the slowdown for me be due to HHVM? [04:49:21] Bsadowski1: doesn't show anything unusual [04:49:48] so I think it might just be you. Is the response time the same when you log out and try to load the page as an anon? [04:53:49] ori: Hm.. "nav start to nav end for desktop sites last month" looks interesting [04:54:05] what happened there 2 weeks ago? [04:55:37] dunno [05:08:28] 6operations: wish to introduce our fleece blankets/bathrobes factory - https://phabricator.wikimedia.org/T90325#1056199 (10emailbot) [06:09:43] (03CR) 10Ori.livneh: "A separate request should not be necessary for counting image views -- you could just count the image requests, no?" (031 comment) [puppet] - 10https://gerrit.wikimedia.org/r/190821 (https://phabricator.wikimedia.org/T89088) (owner: 10Gilles) [06:28:34] PROBLEM - puppet last run on db1046 is CRITICAL: CRITICAL: Puppet has 1 failures [06:28:34] PROBLEM - puppet last run on db1021 is CRITICAL: CRITICAL: puppet fail [06:28:44] PROBLEM - puppet last run on tin is CRITICAL: CRITICAL: puppet fail [06:28:44] PROBLEM - puppet last run on logstash1002 is CRITICAL: CRITICAL: puppet fail [06:29:05] PROBLEM - puppet last run on cp1056 is CRITICAL: CRITICAL: Puppet has 1 failures [06:29:14] PROBLEM - puppet last run on db2018 is CRITICAL: CRITICAL: Puppet has 1 failures [06:29:14] PROBLEM - puppet last run on mw1235 is CRITICAL: CRITICAL: Puppet has 1 failures [06:29:24] PROBLEM - puppet last run on mw1170 is CRITICAL: CRITICAL: Puppet has 1 failures [06:29:24] PROBLEM - puppet last run on mw1166 is CRITICAL: CRITICAL: Puppet has 1 failures [06:29:24] PROBLEM - puppet last run on mw1144 is CRITICAL: CRITICAL: Puppet has 1 failures [06:29:24] PROBLEM - puppet last run on mw1119 is CRITICAL: CRITICAL: Puppet has 1 failures [06:29:34] PROBLEM - puppet last run on analytics1030 is CRITICAL: CRITICAL: Puppet has 1 failures [06:29:34] PROBLEM - puppet last run on elastic1030 is CRITICAL: CRITICAL: Puppet has 1 failures [06:29:43] PROBLEM - puppet last run on cp1061 is CRITICAL: CRITICAL: Puppet has 1 failures [06:30:13] PROBLEM - puppet last run on mw1061 is CRITICAL: CRITICAL: Puppet has 1 failures [06:45:54] RECOVERY - puppet last run on db1046 is OK: OK: Puppet is currently enabled, last run 37 seconds ago with 0 failures [06:46:54] RECOVERY - puppet last run on db1021 is OK: OK: Puppet is currently enabled, last run 40 seconds ago with 0 failures [06:47:04] RECOVERY - puppet last run on logstash1002 is OK: OK: Puppet is currently enabled, last run 2 seconds ago with 0 failures [06:47:34] RECOVERY - puppet last run on db2018 is OK: OK: Puppet is currently enabled, last run 9 seconds ago with 0 failures [06:47:44] RECOVERY - puppet last run on mw1170 is OK: OK: Puppet is currently enabled, last run 8 seconds ago with 0 failures [06:47:54] RECOVERY - puppet last run on analytics1030 is OK: OK: Puppet is currently enabled, last run 33 seconds ago with 0 failures [06:48:04] RECOVERY - puppet last run on elastic1030 is OK: OK: Puppet is currently enabled, last run 47 seconds ago with 0 failures [06:48:04] RECOVERY - puppet last run on cp1061 is OK: OK: Puppet is currently enabled, last run 32 seconds ago with 0 failures [06:48:05] RECOVERY - puppet last run on tin is OK: OK: Puppet is currently enabled, last run 17 seconds ago with 0 failures [06:48:24] RECOVERY - puppet last run on cp1056 is OK: OK: Puppet is currently enabled, last run 57 seconds ago with 0 failures [06:48:24] RECOVERY - puppet last run on mw1061 is OK: OK: Puppet is currently enabled, last run 17 seconds ago with 0 failures [06:48:44] RECOVERY - puppet last run on mw1235 is OK: OK: Puppet is currently enabled, last run 12 seconds ago with 0 failures [06:48:44] RECOVERY - puppet last run on mw1166 is OK: OK: Puppet is currently enabled, last run 44 seconds ago with 0 failures [06:48:44] RECOVERY - puppet last run on mw1144 is OK: OK: Puppet is currently enabled, last run 54 seconds ago with 0 failures [06:48:54] RECOVERY - puppet last run on mw1119 is OK: OK: Puppet is currently enabled, last run 53 seconds ago with 0 failures [06:50:24] RECOVERY - Router interfaces on cr1-eqiad is OK: OK: host 208.80.154.196, interfaces up: 222, down: 0, dormant: 0, excluded: 0, unused: 0 [06:51:53] !log LocalisationUpdate ResourceLoader cache refresh completed at Sat Feb 21 06:50:49 UTC 2015 (duration 50m 48s) [06:52:01] Logged the message, Master [06:52:10] 6operations, 10Beta-Cluster, 6Release-Engineering: Beta cluster unable to create thumbnail for WebM video - https://phabricator.wikimedia.org/T90332#1056292 (10Krinkle) 3NEW [07:52:54] 6operations, 10Beta-Cluster, 7Performance: Need a way to simulate replication lag to test replag issues - https://phabricator.wikimedia.org/T40945#1056310 (10Nemo_bis) [08:16:31] 6operations, 6Phabricator, 10Wikimedia-Bugzilla, 5Patch-For-Review: Create a static HTML version of Bugzilla - https://phabricator.wikimedia.org/T85140#1056325 (10Nemo_bis) > To get rid of Bugzilla This is not going to happen in this decade anyway. FYI, static HTML dumps made for archival purposes shoul... [10:28:33] (03CR) 10Alexandros Kosiaris: "Actually, it quite often doesn't, albeit only on a documentation level (aka racktables). Adding one extra step in the procedure of moving " [puppet] - 10https://gerrit.wikimedia.org/r/167645 (https://phabricator.wikimedia.org/T84518) (owner: 10Alexandros Kosiaris) [11:54:54] PROBLEM - HTTP 5xx req/min on tungsten is CRITICAL: CRITICAL: 6.67% of data above the critical threshold [500.0] [11:54:54] PROBLEM - HTTP 5xx req/min on graphite1001 is CRITICAL: CRITICAL: 6.67% of data above the critical threshold [500.0] [12:06:55] RECOVERY - HTTP 5xx req/min on tungsten is OK: OK: Less than 1.00% above the threshold [250.0] [12:06:55] RECOVERY - HTTP 5xx req/min on graphite1001 is OK: OK: Less than 1.00% above the threshold [250.0] [12:31:59] (03PS2) 10Mjbmr: Unifying talk namespaces for fawikisource [mediawiki-config] - 10https://gerrit.wikimedia.org/r/190232 (https://phabricator.wikimedia.org/T90340) [13:18:40] 6operations, 10Citoid: Configure citoid to use outbound proxy - https://phabricator.wikimedia.org/T89875#1047771 (10Mvolz) [16:29:42] Is runJobs.log incomplete as well now [16:29:45] ? [16:32:24] PROBLEM - puppet last run on mw1190 is CRITICAL: CRITICAL: Puppet has 1 failures [16:35:56] (03PS1) 10Hoo man: Revert "Limit runJobs output to warning and higher severity" [mediawiki-config] - 10https://gerrit.wikimedia.org/r/192083 [16:49:44] RECOVERY - puppet last run on mw1190 is OK: OK: Puppet is currently enabled, last run 29 seconds ago with 0 failures [16:54:19] hoo, what do you need these logs for? [16:55:03] Seeing when jobs ran and whether they ran at all [21:48:57] (03PS1) 10Odder: Enable recent changes patrolling on Wikispecies [mediawiki-config] - 10https://gerrit.wikimedia.org/r/192103 (https://phabricator.wikimedia.org/T89147)