[00:57:11] <theopolisme>	 Quick question: is it possible to search the `text` table via a labs database replica? (In other words, look for pages that meet certain requirements and also contain a given string)
[01:01:44] <Ryan_Lane>	 theopolisme: I don't believe so
[01:01:59] <Ryan_Lane>	 we have the revision table around, but text is in external store and isn't (and won't be) available
[01:02:10] <Ryan_Lane>	 you can search the dumps
[01:02:52] <Ryan_Lane>	 external store is massive and isn't really in a format that's queryable anyway
[06:34:32] <krd>	 https://de.wikipedia.org/w/api.php?action=login&maxlag=300
[06:34:33] <krd>	 Waiting for 10.64.16.15: 26495 seconds lagged
[06:34:34] <krd>	 ??
[06:35:51] <blarumyrran>	 There's a ton of wiki(p/m)edia channels around, which one is for questions about wikipedia commons?
[06:36:29] <blarumyrran>	 wikimedia commons*
[06:36:48] <closedmouth>	 #wikimedia-commons
[06:36:58] <closedmouth>	 krd: ooh, that's bad http://ganglia.wikimedia.org/latest/graph.php?r=week&z=xlarge&title=cpu_system&mreg[]=^cpu_system%24&hreg[]=db1026&aggregate=1&hl=db1026.eqiad.wmnet|MySQL+eqiad
[06:37:02] <blarumyrran>	 thanks
[06:38:00] <krd>	 anything to do about it? single machine affected? take it out of service?
[06:39:12] <closedmouth>	 if you can get someone's attention, it'll be rotated out or whatever you call it
[06:39:22] <closedmouth>	 though good luck on the weekend
[06:39:55] <krd>	 I even don't know whom to ask.
[06:40:08] <closedmouth>	 yeah i can never remember
[06:40:53] <apergos>	  #wikimedia-commons  is the channel for you
[06:42:04] <closedmouth>	 apergos: db1026 is lagging badly, are you able to deal with it?
[06:43:44] <krd>	 All my bot skripts are stopped currently. I have no idea what I shall do, and only two hours left before I have to leave for today.
[06:47:16] <closedmouth>	 can you set it to ignore maxlag?
[06:48:07] <krd>	 yes, but I'm doing a lot of realtime text replacement, and that could be a bad idea to ignore it.
[07:25:26] <MaxSem>	 @lag all
[07:25:44] <MaxSem>	 where's that pesky bot?
[07:25:59] <legoktm>	 krd: MaxSem has fixed the issue (see -operations) and the lag is slowly going down
[07:26:12] <krd>	 Thank you!
[07:26:58] <Elsie>	 closedmouth: ottomata is on RT duty, BTW.
[07:27:01] <Elsie>	 Though he's also not online.
[07:27:35] <Elsie>	 closedmouth: Also, it's adorable that you're using ganglia.
[07:27:57] <closedmouth>	 i just followed the link from dbtree
[07:28:18] <Elsie>	 You're a dbtree.
[07:28:28] <closedmouth>	 you love it
[07:28:34] <Elsie>	 It's true.
[07:28:44] <Elsie>	 krd: https://bugzilla.wikimedia.org/show_bug.cgi?id=52979
[07:28:55] <Elsie>	 If you're interested in following the issue more generally.
[07:30:22] <apergos>	 ah so it wasn't me after all, how interesting is that
[07:30:42] <krd>	 Elsie: Indded I am, because this is causing my lots of trouble.
[07:30:57] <apergos>	 lemme  make sure they did not in fact kill my dumps...
[07:33:52] <apergos>	 nope, they are chugging right along
[07:34:03] <legoktm>	       <db host="db1026" lag="0" /> !
[07:35:02] <krd>	 at least nice that my stuff starts to work by itself and I don't have to kick it...
[07:35:09] <apergos>	 yay for that
[07:43:40] <Nemo_bis>	 uh, https://bugzilla.wikimedia.org/show_bug.cgi?id=51741 mentioned as particularly evil by RoanKattouw_away was fixed
[07:44:01] <Nemo_bis>	 or was it https://bugzilla.wikimedia.org/show_bug.cgi?id=50749
[08:28:06] <Steinsplitter>	 Error while moving the page.
[08:28:07] <Steinsplitter>	 A detailed description of the error is shown below:
[08:28:07] <Steinsplitter>	 API request failed (filetypemismatch): The new file extension doesn't match its type <i>at Sun, 18 Aug 2013 08:27:28 GMT</i> <u>served by mw1117</u>
[08:28:10] <Steinsplitter>	 o_O
[08:35:09] <apergos>	 what page title originally (including namespace) and moved to what?
[09:09:00] <Steinsplitter>	 apergos: http://commons.wikimedia.org/wiki/File:Test_vc_%282%29.ogv 
[09:09:07] <Steinsplitter>	 (see the request)
[09:09:50] <apergos>	 weird
[09:11:16] <apergos>	 [ariel@localhost ~]$ file Test_vc_\(2\).ogv 
[09:11:16] <apergos>	 Test_vc_(2).ogv: ISO Media, MPEG v4 system, version 2
[09:11:21] <apergos>	 well that's special
[09:12:50] <apergos>	 try moving it to blahblah.mp4 ? 
[09:12:59] <apergos>	 this file http://commons.wikimedia.org/wiki/File:Boomer_fires_at_Apogee_Stadium.ogv  has the right type, just for comparison...
[09:13:46] <Steinsplitter>	 no to mp4
[09:13:54] <apergos>	 hahaha
[09:13:58] <Steinsplitter>	 ?
[09:13:59] <apergos>	 http://commons.wikimedia.org/wiki/Commons:File_types
[09:14:02] <apergos>	 mp4 not allowed
[09:14:08] <Steinsplitter>	 but why is uploaded
[09:14:09] <Steinsplitter>	 ....?
[09:14:20] <apergos>	 good question.  there's a bug someplace!
[09:14:40] <peachey|laptop__>	 do we even properly check the file type at upload? or does the transcoding magic do it later?
[09:14:56] <apergos>	 I assume there is a check but that's truly an assumption
[09:15:13] <Steinsplitter>	 (https://triton.aquila.uberspace.de/wiki/comapi.jpg... to late, now we know the problem :D)  
[09:16:36] <apergos>	 maybe conversion failed or something, who knows
[09:17:29] <Steinsplitter>	 now what?
[09:17:49] <p858snake>	 file a bug and run
[09:17:53] <apergos>	 ask the maintainer of the file upload bot about it first
[09:18:20] <apergos>	 (Magnus) ... if he doesn't see anything there, a bug report would be next
[09:18:56] <Steinsplitter>	 apergos: is ihmo a tech priblem, ulpading mp4 is not bit operators problem imho
[09:19:06] <Steinsplitter>	 *bot
[09:19:20] <Steinsplitter>	 ther is a bug in the medawiki
[09:19:29] <apergos>	 not the operator, sorry, the maintainer
[09:20:14] <Steinsplitter>	 the mainteiner...  but is a bug.
[09:20:26] <apergos>	 flickrtocommons is the software piece, so start there
[09:20:29] <Steinsplitter>	 it is abusive if evry user can upload mp4
[09:20:32] <apergos>	 magnus will know, it's his
[09:20:58] <Steinsplitter>	 the softear user upload by url?
[09:21:19] <apergos>	 I don't know anything more about it
[09:21:29] <apergos>	 this is why asking the author is good
[09:22:25] <Steinsplitter>	 okay, i open a bug and add magnus in the CC. maby he can comment this
[09:22:30] <apergos>	 sure
[09:26:48] <Steinsplitter>	 can i post your console/ssh command in the ticket?
[09:29:19] <apergos>	 you can but it's also obvious form the commons file decription page
[09:29:43] <apergos>	 Full resolution ‎(MP4 audio/video file, AAC/h.264, length 42 s, 1,280 × 720 pixels, 2.12 Mbps overall) 
[09:29:48] <apergos>	 it shows right there
[09:30:11] <Steinsplitter>	 okay thx
[16:38:38] <Pitlane02>	 hey, some admins of commons on board?
[16:39:37] <Glaisher>	 Pitlane02: Sure that you are in the correct venue?
[16:40:13] <Pitlane02>	 no, i'm not sure
[16:40:34] <Glaisher>	 Pitlane02: #wikimedia-commons
[16:40:44] <Pitlane02>	 oh, thx
[16:43:11] <Elsie>	 Hi Glaisher.
[16:43:19] <Glaisher>	 :O
[16:47:12] <Glaisher>	 Elsie: You called me?
[16:48:16] <Amgine>	 <assumes it was something mean>
[22:17:37] <DaBPunkt>	 gn8 folks
[22:31:34] <Sk1d>	 apergos: there still seems to be some irregularities with the lag of db1021: https://ganglia.wikimedia.org/latest/graph_all_periods.php?title=mysql_slave_lag&mreg[]=^mysql_slave_lag%24&hreg[]=db1021&aggregate=1&hl=db1021.eqiad.wmnet|MySQL%20eqiad