[00:31:28] <icinga-wm>	 PROBLEM - search indices - check lucene status page on search1003 is CRITICAL: CRITICAL - Socket timeout after 10 seconds
[00:35:17] <icinga-wm>	 RECOVERY - search indices - check lucene status page on search1003 is OK: HTTP OK: HTTP/1.1 200 OK - 269 bytes in 0.004 second response time
[00:57:34] <icinga-wm>	 RECOVERY - udp2log log age for lucene on oxygen is OK: OK: all log files active
[01:00:38] <icinga-wm>	 PROBLEM - udp2log log age for lucene on oxygen is CRITICAL: CRITICAL: log files /a/log/lucene/lucene.log,  have not been written in a critical amount of time.  For most logs, this is 4 hours.  For slow logs, this is 4 days.
[01:22:29] <icinga-wm>	 PROBLEM - Puppetmaster HTTPS on stafford is CRITICAL: CRITICAL - Socket timeout after 10 seconds
[01:23:19] <icinga-wm>	 RECOVERY - Puppetmaster HTTPS on stafford is OK: HTTP OK: Status line output matched 400 - 336 bytes in 0.124 second response time
[01:32:20] <icinga-wm>	 RECOVERY - NTP on ssl3003 is OK: NTP OK: Offset 0.002796411514 secs
[01:32:59] <icinga-wm>	 RECOVERY - NTP on ssl3002 is OK: NTP OK: Offset 0.003968477249 secs
[01:56:29] <icinga-wm>	 PROBLEM - Puppetmaster HTTPS on stafford is CRITICAL: CRITICAL - Socket timeout after 10 seconds
[01:57:18] <icinga-wm>	 RECOVERY - Puppetmaster HTTPS on stafford is OK: HTTP OK: Status line output matched 400 - 336 bytes in 0.126 second response time
[02:03:52] <logmsgbot>	 !log LocalisationUpdate completed (1.22wmf4) at Mon May 27 02:03:50 UTC 2013
[02:06:26] <icinga-wm>	 PROBLEM - Puppetmaster HTTPS on stafford is CRITICAL: CRITICAL - Socket timeout after 10 seconds
[02:07:15] <icinga-wm>	 RECOVERY - Puppetmaster HTTPS on stafford is OK: HTTP OK: Status line output matched 400 - 336 bytes in 0.128 second response time
[02:15:05] <logmsgbot>	 !log LocalisationUpdate ResourceLoader cache refresh completed at Mon May 27 02:15:05 UTC 2013
[02:15:15] <icinga-wm>	 PROBLEM - Puppet freshness on db1032 is CRITICAL: No successful Puppet run in the last 10 hours
[02:21:17] <icinga-wm>	 PROBLEM - Puppet freshness on virt1 is CRITICAL: No successful Puppet run in the last 10 hours
[02:21:17] <icinga-wm>	 PROBLEM - Puppet freshness on virt3 is CRITICAL: No successful Puppet run in the last 10 hours
[02:21:17] <icinga-wm>	 PROBLEM - Puppet freshness on virt4 is CRITICAL: No successful Puppet run in the last 10 hours
[02:22:25] <icinga-wm>	 PROBLEM - Puppetmaster HTTPS on stafford is CRITICAL: CRITICAL - Socket timeout after 10 seconds
[02:23:16] <icinga-wm>	 RECOVERY - Puppetmaster HTTPS on stafford is OK: HTTP OK: Status line output matched 400 - 336 bytes in 0.123 second response time
[02:23:16] <Susan>	 morebots is missing.
[02:24:15] <icinga-wm>	 PROBLEM - Puppet freshness on pdf1 is CRITICAL: No successful Puppet run in the last 10 hours
[02:24:17] <icinga-wm>	 PROBLEM - Puppet freshness on pdf2 is CRITICAL: No successful Puppet run in the last 10 hours
[02:27:25] <icinga-wm>	 PROBLEM - Puppetmaster HTTPS on stafford is CRITICAL: CRITICAL - Socket timeout after 10 seconds
[02:28:18] <icinga-wm>	 RECOVERY - Puppetmaster HTTPS on stafford is OK: HTTP OK: Status line output matched 400 - 336 bytes in 0.125 second response time
[02:52:27] <icinga-wm>	 PROBLEM - Puppetmaster HTTPS on stafford is CRITICAL: CRITICAL - Socket timeout after 10 seconds
[02:53:17] <icinga-wm>	 RECOVERY - Puppetmaster HTTPS on stafford is OK: HTTP OK: Status line output matched 400 - 336 bytes in 0.127 second response time
[03:09:15] <icinga-wm>	 PROBLEM - Puppet freshness on db45 is CRITICAL: No successful Puppet run in the last 10 hours
[03:17:05] <icinga-wm>	 PROBLEM - Host mw27 is DOWN: PING CRITICAL - Packet loss = 100%
[03:18:05] <icinga-wm>	 RECOVERY - Host mw27 is UP: PING OK - Packet loss = 0%, RTA = 26.52 ms
[03:22:26] <icinga-wm>	 PROBLEM - Puppetmaster HTTPS on stafford is CRITICAL: CRITICAL - Socket timeout after 10 seconds
[03:23:08] <p858snake|l>	 Susan: morebots ran out on you again
[03:23:15] <icinga-wm>	 RECOVERY - Puppetmaster HTTPS on stafford is OK: HTTP OK: Status line output matched 400 - 336 bytes in 0.167 second response time
[03:23:38] <Susan>	 I re-opened the bug.
[03:23:40] <Susan>	 Poor morebots.
[03:30:27] <icinga-wm>	 PROBLEM - Puppetmaster HTTPS on stafford is CRITICAL: CRITICAL - Socket timeout after 10 seconds
[03:32:15] <icinga-wm>	 RECOVERY - Puppetmaster HTTPS on stafford is OK: HTTP OK: Status line output matched 400 - 336 bytes in 0.203 second response time
[03:41:19] <Crindy>	 more poorbots
[03:52:29] <icinga-wm>	 PROBLEM - Puppetmaster HTTPS on stafford is CRITICAL: CRITICAL - Socket timeout after 10 seconds
[03:53:19] <icinga-wm>	 RECOVERY - Puppetmaster HTTPS on stafford is OK: HTTP OK: Status line output matched 400 - 336 bytes in 0.126 second response time
[04:16:16] <icinga-wm>	 PROBLEM - Puppet freshness on ms-fe3001 is CRITICAL: No successful Puppet run in the last 10 hours
[04:17:16] <icinga-wm>	 PROBLEM - Puppet freshness on erzurumi is CRITICAL: No successful Puppet run in the last 10 hours
[04:20:16] <icinga-wm>	 PROBLEM - Puppet freshness on cp1029 is CRITICAL: No successful Puppet run in the last 10 hours
[04:49:14] <icinga-wm>	 PROBLEM - Puppet freshness on stat1002 is CRITICAL: No successful Puppet run in the last 10 hours
[04:54:24] <icinga-wm>	 PROBLEM - NTP on ssl3002 is CRITICAL: NTP CRITICAL: No response from NTP server
[05:00:44] <icinga-wm>	 PROBLEM - NTP on ssl3003 is CRITICAL: NTP CRITICAL: No response from NTP server
[05:12:32] <icinga-wm>	 PROBLEM - SSH on lvs6 is CRITICAL: Server answer:
[05:13:31] <icinga-wm>	 RECOVERY - SSH on lvs6 is OK: SSH OK - OpenSSH_5.9p1 Debian-5ubuntu1.1 (protocol 2.0)
[05:26:31] <icinga-wm>	 PROBLEM - Puppetmaster HTTPS on stafford is CRITICAL: CRITICAL - Socket timeout after 10 seconds
[05:27:21] <icinga-wm>	 RECOVERY - Puppetmaster HTTPS on stafford is OK: HTTP OK: Status line output matched 400 - 336 bytes in 0.137 second response time
[06:35:31] <icinga-wm>	 PROBLEM - Puppetmaster HTTPS on stafford is CRITICAL: CRITICAL - Socket timeout after 10 seconds
[06:36:31] <icinga-wm>	 RECOVERY - Puppetmaster HTTPS on stafford is OK: HTTP OK: Status line output matched 400 - 336 bytes in 2.477 second response time
[08:01:35] <icinga-wm>	 PROBLEM - Puppetmaster HTTPS on stafford is CRITICAL: CRITICAL - Socket timeout after 10 seconds
[08:02:25] <icinga-wm>	 RECOVERY - NTP on ssl3002 is OK: NTP OK: Offset 0.0001685619354 secs
[08:02:26] <icinga-wm>	 RECOVERY - Puppetmaster HTTPS on stafford is OK: HTTP OK: Status line output matched 400 - 336 bytes in 0.129 second response time
[08:11:04] <icinga-wm>	 PROBLEM - Puppet freshness on stat1 is CRITICAL: No successful Puppet run in the last 10 hours
[08:16:03] <icinga-wm>	 PROBLEM - Puppet freshness on lvs1004 is CRITICAL: No successful Puppet run in the last 10 hours
[08:16:03] <icinga-wm>	 PROBLEM - Puppet freshness on lvs1005 is CRITICAL: No successful Puppet run in the last 10 hours
[08:16:03] <icinga-wm>	 PROBLEM - Puppet freshness on lvs1006 is CRITICAL: No successful Puppet run in the last 10 hours
[08:18:03] <icinga-wm>	 PROBLEM - Puppet freshness on mc15 is CRITICAL: No successful Puppet run in the last 10 hours
[08:31:33] <icinga-wm>	 RECOVERY - NTP on ssl3003 is OK: NTP OK: Offset 0.002451181412 secs
[12:05:42] <icinga-wm>	 PROBLEM - Puppetmaster HTTPS on stafford is CRITICAL: CRITICAL - Socket timeout after 10 seconds
[12:06:31] <icinga-wm>	 RECOVERY - Puppetmaster HTTPS on stafford is OK: HTTP OK: Status line output matched 400 - 336 bytes in 0.124 second response time
[12:15:19] <icinga-wm>	 PROBLEM - Puppet freshness on db1032 is CRITICAL: No successful Puppet run in the last 10 hours
[12:21:17] <Dereckson>	 Hello ori-l. I prepared an improvement to throttle.php needed for the NIH editing session tomorrow. https://gerrit.wikimedia.org/r/#/c/65644/ Could you look at this?
[12:21:19] <icinga-wm>	 PROBLEM - Puppet freshness on virt1 is CRITICAL: No successful Puppet run in the last 10 hours
[12:21:19] <icinga-wm>	 PROBLEM - Puppet freshness on virt3 is CRITICAL: No successful Puppet run in the last 10 hours
[12:21:19] <icinga-wm>	 PROBLEM - Puppet freshness on virt4 is CRITICAL: No successful Puppet run in the last 10 hours
[12:24:19] <icinga-wm>	 PROBLEM - Puppet freshness on pdf1 is CRITICAL: No successful Puppet run in the last 10 hours
[12:24:19] <icinga-wm>	 PROBLEM - Puppet freshness on pdf2 is CRITICAL: No successful Puppet run in the last 10 hours
[12:32:33] <gerrit-wm>	 New patchset: GWicke; "New Parsoid Varnish puppetization" [operations/puppet] (production) - https://gerrit.wikimedia.org/r/63890
[12:34:44] <aude>	 97
[12:50:33] <gerrit-wm>	 New patchset: ArielGlenn; "Fix for compatibility with help2man and Debian Policy" [operations/dumps] (ariel) - https://gerrit.wikimedia.org/r/64343
[12:55:10] <gerrit-wm>	 New review: ArielGlenn; "I moved the version string into the Makefile and moved the man pages to separate targets while I was..." [operations/dumps] (ariel) - https://gerrit.wikimedia.org/r/64343
[13:09:29] <icinga-wm>	 PROBLEM - Puppet freshness on db45 is CRITICAL: No successful Puppet run in the last 10 hours
[13:35:25] <yurik>	 paravoid_, around?
[13:37:30] <yurik>	 i'm monitoring zero log, and it seems that there are a few entries that get X-ORIG-CLIENT-IP, but still many entries that don't and they still have 3 values in XFF. Could this be because they are cached, or because not all varnish server were updated?
[14:02:29] <icinga-wm>	 RECOVERY - udp2log log age for lucene on oxygen is OK: OK: all log files active
[14:16:19] <icinga-wm>	 PROBLEM - Puppet freshness on ms-fe3001 is CRITICAL: No successful Puppet run in the last 10 hours
[14:17:19] <icinga-wm>	 PROBLEM - Puppet freshness on erzurumi is CRITICAL: No successful Puppet run in the last 10 hours
[14:20:19] <icinga-wm>	 PROBLEM - Puppet freshness on cp1029 is CRITICAL: No successful Puppet run in the last 10 hours
[14:25:10] <gerrit-wm>	 New review: ArielGlenn; "Kent signed off on my tweaks so in it goes." [operations/dumps] (ariel); V: 2 C: 2;  - https://gerrit.wikimedia.org/r/64343
[14:25:10] <gerrit-wm>	 Change merged: ArielGlenn; [operations/dumps] (ariel) - https://gerrit.wikimedia.org/r/64343
[14:49:53] <icinga-wm>	 PROBLEM - Puppet freshness on stat1002 is CRITICAL: No successful Puppet run in the last 10 hours
[15:35:28] <gerrit-wm>	 New review: Tim Landscheidt; "petan apparently installed something local with the same name, but in /usr/bin and only on tools-log..." [operations/puppet] (production) - https://gerrit.wikimedia.org/r/64847
[16:40:35] <icinga-wm>	 PROBLEM - Puppetmaster HTTPS on stafford is CRITICAL: CRITICAL - Socket timeout after 10 seconds
[16:41:25] <icinga-wm>	 RECOVERY - Puppetmaster HTTPS on stafford is OK: HTTP OK: Status line output matched 400 - 336 bytes in 0.127 second response time
[16:51:56] <gerrit-wm>	 New review: ArielGlenn; "Let's hold off on this. We already have projects in beta using wgInstantCommons (set in CommonSettin..." [operations/mediawiki-config] (master) - https://gerrit.wikimedia.org/r/62606
[17:03:01] <logmsgbot>	 !log reedy synchronized php-1.22wmf5  'Initial file sync out'
[17:04:27] <logmsgbot>	 !log reedy synchronized w
[17:04:57] <logmsgbot>	 !log reedy synchronized docroot
[17:11:54] <logmsgbot>	 !log reedy synchronized php-1.22wmf5/extensions/Diff/
[17:12:30] <logmsgbot>	 !log reedy synchronized php-1.22wmf5/extensions/DataValues/
[17:13:38] <logmsgbot>	 !log reedy synchronized php-1.22wmf5/extensions/Wikibase/
[17:14:04] <gerrit-wm>	 New patchset: Reedy; "1.22wmf5 stuffs" [operations/mediawiki-config] (master) - https://gerrit.wikimedia.org/r/65683
[17:14:18] <gerrit-wm>	 Change merged: Reedy; [operations/mediawiki-config] (master) - https://gerrit.wikimedia.org/r/65683
[17:15:17] <logmsgbot>	 !log reedy Started syncing Wikimedia installation... : test2wiki to 1.22wmf5 and build localisation cache
[17:17:27] <Reedy>	 apergos: What's needed to get the wikidata related tables dumped as part of the usual dumps process?
[17:17:51] <apergos>	 any private data in 'em?
[17:17:59] <aude>	 none at all
[17:18:05] <aude>	 they are just tracking tables
[17:18:13] <apergos>	 guess I need to see how big they are compared to everything else
[17:18:29] <apergos>	 this is on wikidatawiki or on the rest?
[17:18:35] <aude>	 just wikidata
[17:18:46] <aude>	 items per site is probably most interesting to folks
[17:18:48] <apergos>	 well that wiki dump process is a mess right now
[17:18:57] <aude>	 the terms one might be a bit larger
[17:19:01] <apergos>	 which table is items per site?
[17:19:10] <aude>	 wb_items_per_site
[17:19:11] <apergos>	 which reminds me Reedy :-P
[17:19:40] <apergos>	 https://gerrit.wikimedia.org/r/#/c/65236/
[17:21:56] <apergos>	 uh oh
[17:22:13] <apergos>	 really. "only" 30 million rows
[17:22:34] <aude>	 apergos: yes
[17:22:35] <apergos>	 well it's small enough to mysqldump so I could do that,
[17:22:52] <aude>	 it's like all the langlink tables from wikipedia combined into one
[17:22:56] <apergos>	 gotta think about how to add that table only to the wikidata dump without having a bunch of ugly special cases in there
[17:23:10] <apergos>	 I can hardly wait for all the infobox data to make it over
[17:23:16] <apergos>	 that'll kill us for sure
[17:23:24] <aude>	 :o
[17:24:09] <apergos>	 good think this project hasn't been around 10 years already...
[17:24:12] <apergos>	 *thing
[17:24:26] * aude  nods

[17:24:46] <aude>	 well, the data itself is like regular wiki text data
[17:25:05] <apergos>	 deleting 45k cronspam messages... wonder if evolution will keel over and die horribly in the middle
[17:25:15] <aude>	 and we will have more indexing in places, maybe like solr soonish
[17:28:38] <apergos>	 it would be nice for folks to be able to find the q-thing they want easily
[17:28:50] <apergos>	 by typing in the translation in their language
[17:29:09] <apergos>	 without having to have a redirect or something, I mean, and without having to look through a bunch of other results, if "go" just went there
[17:30:24] <logmsgbot>	 !log reedy synchronized wmf-config/squid.php  'Repush'
[17:31:32] <aude>	 apergos: actually that's coming quite soon
[17:32:02] <aude>	 fancy redirects based on page title (e.g. en.wikidata.org/wiki/New_York_City -> www.wikidata.org/wiki/Q60)
[17:32:08] <apergos>	 yep
[17:32:20] <apergos>	 where you don't have to have an actual page in there with the redirect
[17:32:22] <aude>	 the site link table would help tool and bot folks with that
[17:32:25] <apergos>	 that wil be a life saver
[17:32:26] <aude>	 if they want to do that
[17:35:47] <apergos>	 wow this is really lame
[17:35:59] <apergos>	 how do we dump flagged revs only for the wikis that have it:
[17:36:06] <apergos>	 		return self.dbName in self.config.flaggedRevsList
[17:36:08] <apergos>	 bummer...
[17:36:14] <aude>	 hmmmm
[17:36:23] <apergos>	 we can do better than that
[17:38:34] <apergos>	 hahaha
[17:38:39] <apergos>	 but why do better when we can be lazy
[17:38:46] <apergos>	 ariel@fenari:/home/w/common$ ls *dblist
[17:38:51] <aude>	 :)
[17:38:54] <apergos>	 ...wikidata.dblist
[17:39:15] <apergos>	 that's hilarious. I was about to write a little routine to check for tables and stuff, all nice
[17:39:17] <apergos>	 meh :-D
[17:41:05] <aude>	 apergos: must be new since yesterday :)
[17:41:23] <aude>	 3a4b9fa8 (Reedy 2013-05-26 12:28:40 +0000 1) wikidatawiki
[17:41:48] <Reedy>	 I did it so we can list all wikidata repos as one config group ;)
[17:42:01] * aude  nods

[17:42:44] <apergos>	 please give me a one line summary of what's in the table. it will appear on the dump page as the description of the tble contents. e.g. for flagged revs we have
[17:43:08] <apergos>	 flaggedpages
[17:43:17] <apergos>	 This contains a row for each flagged article, containing th\
[17:43:17] <apergos>	 e stable revision ID, if the lastest edit was flagged, and how long edits have been pending.
[17:43:18] <aude>	 apergos:  for the items per site one?
[17:43:20] <apergos>	 yes
[17:43:23] <aude>	 ok
[17:43:59] <apergos>	 see what we need, human-readable description for people who just want to know what data they are getting
[17:44:15] <aude>	 tracking table of wikipedia sites links (by page title, site id) and wikidata item ids
[17:44:33] <aude>	 although technically we could have wikivoyage and other clients at some point
[17:44:40] <aude>	 the site id = global site id like enwiki
[17:44:49] <aude>	 so can easily accommodate non wikipedias
[17:45:17] <apergos>	 so instead of putting wikipedia  I can put 'wikimedia project' ?
[17:45:26] <aude>	 sure
[17:47:27] <apergos>	 is the site id the db name or some other thing?
[17:47:43] <apergos>	 for the particular wiki I mean
[17:47:44] <aude>	 it's almost always or always the same for wikimedia
[17:47:53] <apergos>	 ok
[17:47:54] <aude>	 it's stored in the site table of mediawiki
[17:48:05] <aude>	 could be different
[17:48:16] <aude>	 it comes from sitematrix
[17:48:50] <apergos>	 the 'site global key' from the site table eh?
[17:48:56] <aude>	 yes
[17:48:59] <apergos>	 ok great
[17:49:47] <aude>	 the wikidata ids are numeric ids
[17:50:07] * apergos  goes to find a sample row (it wasn't in the scrollback)

[17:50:10] <aude>	 the pages (don't ask me why) are in non db key format (e.g. with spaces instead of underscores)
[17:51:05] <aude>	 i think there is a primary key (id) column, useful for maintenance operations like schema changes
[17:51:28] <apergos>	 heh as soon as people get the data they will start complaining
[17:51:31] <apergos>	 ah well
[17:52:02] <aude>	 heh
[17:52:49] <apergos>	 so this link
[17:52:55] <apergos>	 scuse me for being such a b00b
[17:52:58] <apergos>	 *noob!
[17:52:59] <apergos>	 grr
[17:53:01] <apergos>	 anyways,
[17:53:03] <aude>	 lol
[17:53:16] <apergos>	 it's not a link on the site's page including the item
[17:53:20] <apergos>	 ?
[17:53:43] * aude  confused

[17:53:55] <apergos>	 |         55 |     3596065 | abwiki      | Џьгьарда            |
[17:53:57] <apergos>	 ok there's a row
[17:54:00] <aude>	 right
[17:54:03] <apergos>	 http://ab.wikipedia.org/w/index.php?title=%D0%8F%D1%8C%D0%B3%D1%8C%D0%B0%D1%80%D0%B4%D0%B0&action=edit
[17:54:06] <apergos>	 here's the page on that site
[17:54:14] <aude>	 so it's Q3596065
[17:54:45] <apergos>	 it's a bit hard to see if there is some ref to it in that page
[17:54:50] <apergos>	 cause templates etc
[17:54:51] <aude>	 http://ab.wikipedia.org/w/index.php?title=%D0%8F%D1%8C%D0%B3%D1%8C%D0%B0%D1%80%D0%B4%D0%B0
[17:54:55] <aude>	 it's in the sidebar
[17:55:13] <aude>	 "edit links" and how we know which interwiki links to put there
[17:55:43] <aude>	 and then which properties (available in the connected item) can be used on that page
[17:55:46] <apergos>	 ok so what I'm asking is
[17:55:49] <apergos>	 the link in the table
[17:55:58] <apergos>	 is due to
[17:56:18] <aude>	 http://www.wikidata.org/wiki/Q3596065#sitelinks
[17:56:21] <aude>	 because it's listed there
[17:56:25] <apergos>	 yep
[17:56:31] <apergos>	 just took me a minute to get to the page
[17:56:35] <aude>	 ok
[17:57:07] <aude>	 it's obviously much better to have the tracking table to look this up in these cases
[17:57:57] <apergos>	 oh no it's got the bleeping
[17:58:17] <aude>	 the other tables that would be interesting are wb_entity_per_page (should be smaller, 13 million or however items we have)
[17:58:24] <aude>	 wb_terms might be more challenging
[17:58:48] <apergos>	 grrrr
[17:59:21] <aude>	 i don't see much use for wb_changes and wb_changes_dispatch (those are better for the labs / toolserver), although those would be smallish....especially dispatch table
[17:59:21] <apergos>	 I want to ne able to see the raw wikitext for the item
[17:59:34] <apergos>	 I mean, there is a page Qblah
[17:59:41] <aude>	 ok
[17:59:42] <apergos>	 and it has wikitext, I've seen it in the dumps >_<
[17:59:47] <aude>	 it does
[17:59:56] <aude>	 it's the same place all the other wikitext is
[17:59:59] <apergos>	 but I can't just click 'edit' or even 'view source'
[18:00:03] <aude>	 no
[18:00:23] <aude>	 http://www.wikidata.org/wiki/Special:EntityData/Q3596065 is closest to raw
[18:00:41] <aude>	 although it's not exactly the same as the internal blob
[18:00:50] <apergos>	 no it sure isn't
[18:00:54] <apergos>	 I'll rant about that later
[18:00:56] * aude  can't see the internal blob without downloading the dump

[18:01:20] <apergos>	 and neither can anyone else unless they have access to the cluster
[18:01:33] <aude>	 the json would be "encoded" and then stuffed into xml
[18:01:41] <apergos>	 so when people add an item
[18:01:53] <apergos>	 they add 'links' which basically amount to
[18:02:04] <apergos>	 in this languag hre is the name of that thing
[18:02:21] <aude>	 apergos: yes
[18:02:38] <apergos>	 okey dokey I can turn this into a one line summary, sorry to eat so much of your time
[18:02:46] <aude>	 not a problem
[18:02:47] <apergos>	 link means a zilion different things so...
[18:02:54] <aude>	 denny and lots of people will be super happy
[18:02:59] * aude  too

[18:07:16] <apergos>	 For each WikiData item, this contains rows with the corresnponding page name on a given wiki project.
[18:07:25] <aude>	 yes
[18:07:29] <apergos>	 sold.
[18:07:37] <apergos>	 plain english is hard.
[18:07:47] * aude  nods

[18:07:55] <aude>	 although it's "Wikidata"
[18:08:10] <apergos>	 woops
[18:08:24] <apergos>	 fixed
[18:08:30] <aude>	 denny might be slightly annoyed with "WikiData"
[18:08:36] <apergos>	 I have to test this and then deployment will take a little while too
[18:08:38] <aude>	 it's like Wikisource and not WikiSource
[18:08:49] <aude>	 ok
[18:08:51] <apergos>	 except it isn't
[18:09:13] <apergos>	 because everything is all on www.wikidata.org
[18:09:19] <apergos>	 it's more like *cough*
[18:09:22] <apergos>	 wikispecies :-P
[18:09:28] <aude>	 heh
[18:09:30] * apergos  ducks...

[18:09:55] <apergos>	 I wonder if my local test copy of wikidata has anything in that table
[18:09:56] * apergos  looks

[18:11:09] <apergos>	 heh
[18:11:15] <apergos>	 mysql> select count(*) from wb_items_per_site;
[18:11:22] <apergos>	 |        0 |
[18:11:32] <apergos>	 what maintenance script to I run to populate that sucker?
[18:11:48] <icinga-wm>	 PROBLEM - Puppet freshness on stat1 is CRITICAL: No successful Puppet run in the last 10 hours
[18:11:55] <aude>	 there is one for entity per page speciifcally
[18:12:09] <apergos>	 but not items per site?
[18:12:18] <aude>	 not sure we have one specific for site links but we have one for "rebuild all data" :)
[18:12:30] <Reedy>	 Don't we have some other scripts that we were going to run?
[18:12:31] <aude>	 it'd be like 2 lines of code
[18:12:40] <aude>	 Reedy: that's entity per page
[18:12:44] <apergos>	 rebuld all data works for me
[18:12:51] <aude>	 ok
[18:13:13] <aude>	 we use it on our test machine so it works
[18:13:40] <Reedy>	 oh ffs
[18:14:14] <apergos>	 found it
[18:14:25] <apergos>	 ah in the extension dir, right
[18:14:29] * aude  assumes it does site links too

[18:14:37] <aude>	 yes in Wikibase/lib/maintenance
[18:15:07] <apergos>	 doo dee doo
[18:15:10] <apergos>	 yep, running it now
[18:15:17] <logmsgbot>	 !log reedy synchronized php-1.22wmf5/cache/
[18:15:25] <apergos>	 hahahaha
[18:15:27] <aude>	 foreach ( $pages as $pageRow ) {
[18:15:28] <aude>	 $page->doEditUpdates( $revision, $GLOBALS['wgUser'] );
[18:15:31] <aude>	 in a nutshell
[18:16:01] <apergos>	 I'm not sure what the ascii art is though :-(
[18:16:08] <aude>	 hah
[18:16:45] <logmsgbot>	 !log reedy Started syncing Wikimedia installation... : Take 2
[18:16:48] <icinga-wm>	 PROBLEM - Puppet freshness on lvs1006 is CRITICAL: No successful Puppet run in the last 10 hours
[18:16:48] <icinga-wm>	 PROBLEM - Puppet freshness on lvs1004 is CRITICAL: No successful Puppet run in the last 10 hours
[18:16:48] <icinga-wm>	 PROBLEM - Puppet freshness on lvs1005 is CRITICAL: No successful Puppet run in the last 10 hours
[18:16:52] * aude  thinks it's a kitten 

[18:17:09] <aude>	 or some animal
[18:17:11] <apergos>	 it's definitely not a kitten
[18:17:40] <apergos>	 mysql> select count(*) from wb_items_per_site;
[18:17:46] <apergos>	 |     1484 |
[18:17:53] <aude>	 nice
[18:18:06] <apergos>	 will do a little test tomorrow, now that it's set up
[18:18:12] <aude>	 k
[18:18:16] <apergos>	 (after 9 pm, pretty done for the day)
[18:18:21] <apergos>	 thanks for the assist!
[18:18:26] <aude>	 thank you!
[18:18:48] <icinga-wm>	 PROBLEM - Puppet freshness on mc15 is CRITICAL: No successful Puppet run in the last 10 hours
[18:18:52] <Reedy>	 apergos: Can you run chown l10nupdate:l10nupdate /a/common/php-1.22wmf5/cache/l10n on tin for me please?
[18:18:59] <apergos>	 sec
[18:19:44] <apergos>	 just the dir right?
[18:19:51] <Reedy>	 yeah
[18:19:51] <apergos>	 (done)
[18:20:01] <Reedy>	 scap just carried on when it couldn't write the cdb files
[18:20:02] <Reedy>	 thanks
[18:20:04] <apergos>	 ok, anything else you need? cause I"m about to disappear
[18:20:54] <Reedy>	 I don't think so
[18:21:27] <apergos>	 k
[18:21:30] <apergos>	 good luck!
[18:21:39] <apergos>	 I might swing by again later just to peek in
[18:21:50] * aude  grants reedy root access

[18:21:53] <aude>	 if i could
[18:24:49] <logmsgbot>	 !log reedy Started syncing Wikimedia installation... : Take 3
[18:31:28] <icinga-wm>	 PROBLEM - Apache HTTP on mw1070 is CRITICAL: CRITICAL - Socket timeout after 10 seconds
[18:32:18] <icinga-wm>	 RECOVERY - Apache HTTP on mw1070 is OK: HTTP OK: HTTP/1.1 301 Moved Permanently - 747 bytes in 0.599 second response time
[18:39:00] <logmsgbot>	 !log reedy Finished syncing Wikimedia installation... : Take 3
[18:40:22] <Reedy>	 Yay
[18:41:50] <logmsgbot>	 !log reedy rebuilt wikiversions.cdb and synchronized wikiversions files: testwiki and mediawikiwiki to 1.22wmf5
[18:42:21] <gerrit-wm>	 New patchset: Reedy; "testwiki, test2wiki and mediawikiwiki to 1.22wmf5" [operations/mediawiki-config] (master) - https://gerrit.wikimedia.org/r/65685
[18:42:31] <gerrit-wm>	 Change merged: Reedy; [operations/mediawiki-config] (master) - https://gerrit.wikimedia.org/r/65685
[18:43:13] <aude>	 test2 works fine with wikidata stuff
[19:55:52] <Krenair>	 SAL not updating today?
[19:56:13] <Krenair>	 stuff hasn't been logged... where's morebots?
[19:57:04] <Nemo_bis>	 eek 21.50 -!- morebots [~morebots@wikitech-static.wikimedia.org] has quit [Ping timeout: 256 seconds]
[19:57:08] <Nemo_bis>	 04.23 < Susan> morebots is missing.
[19:57:10] <Nemo_bis>	 05.23 < p858snake|l> Susan: morebots ran out on you again
[19:57:13] <Nemo_bis>	 05.23 < Susan> Poor morebots.
[20:18:43] <apergos>	 !log restarted morebots
[20:18:52] <morebots>	 Logged the message, Master
[20:29:47] <logmsgbot>	 !log reedy synchronized php-1.22wmf5/extensions/UniversalLanguageSelector  'Revert back to 1.22wmf4 version of ULS'
[20:29:56] <morebots>	 Logged the message, Master
[20:41:22] <gerrit-wm>	 New patchset: ArielGlenn; "include dump of (one of the) wikidata tables" [operations/dumps] (ariel) - https://gerrit.wikimedia.org/r/65689
[22:16:12] <icinga-wm>	 PROBLEM - Puppet freshness on db1032 is CRITICAL: No successful Puppet run in the last 10 hours
[22:22:12] <icinga-wm>	 PROBLEM - Puppet freshness on virt1 is CRITICAL: No successful Puppet run in the last 10 hours
[22:22:12] <icinga-wm>	 PROBLEM - Puppet freshness on virt4 is CRITICAL: No successful Puppet run in the last 10 hours
[22:22:12] <icinga-wm>	 PROBLEM - Puppet freshness on virt3 is CRITICAL: No successful Puppet run in the last 10 hours
[22:25:12] <icinga-wm>	 PROBLEM - Puppet freshness on pdf1 is CRITICAL: No successful Puppet run in the last 10 hours
[22:25:12] <icinga-wm>	 PROBLEM - Puppet freshness on pdf2 is CRITICAL: No successful Puppet run in the last 10 hours
[22:43:28] <icinga-wm>	 PROBLEM - NTP on ssl3003 is CRITICAL: NTP CRITICAL: No response from NTP server
[22:55:16] <icinga-wm>	 PROBLEM - NTP on ssl3002 is CRITICAL: NTP CRITICAL: No response from NTP server
[23:09:49] <icinga-wm>	 PROBLEM - Puppet freshness on db45 is CRITICAL: No successful Puppet run in the last 10 hours
[23:13:50] <gerrit-wm>	 New patchset: Tim Landscheidt; "Tool Labs: Add more user requested packages to exec_environ." [operations/puppet] (production) - https://gerrit.wikimedia.org/r/65705