[04:25:05] " Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.64.32.29)" :-( [04:30:19] There's a bug already filed https://bugzilla.wikimedia.org/show_bug.cgi?id=43331 [05:19:45] looks like a metadata update is being triggered [05:19:59] * Aaron|home doesn't recall our ogg metadata format changing lately [05:22:07] huh, running it via a script, it still wants to do it again...sigh [05:26:05] well, yes, it was never completed iirc [05:27:56] no I mean I called maybeUpgrade so it should be fast the next times [05:28:23] seems like purge is somehow causing it to think it needs to be updated [05:28:38] and really, such an update for a large file should be a de-duplicated job anway [05:28:46] it's too slow to do from an apache [05:38:29] hmm, now maybeUpgradeRow short-circuits, strange [05:40:41] ahh, WikiFilePage calls $this->mFile->upgradeRow(); in doPurge [05:40:49] yeah... [07:51:34] valhallasw: http://commons.wikimedia.org/w/api.php?action=query&list=allcategories&acprop=hidden&acfrom=Cultural heritage monuments in Darién Province [09:13:15] Hi all, if somebody is at Amsterdam Hacktaton and wants to share a cab to the airport this afternoon (leaving between 16.30 and 17.30) please contact me ^_^ [09:13:58] CristianCantoro: what time do you have to be at the airport for? [09:14:17] addshore: my plane leaves at 19.40 [09:14:29] addshore: I would like to be at Schipol before 18.00 [09:14:43] Mine leaves at 18:50, need to be at Schipol before 17:30 [09:15:11] I was just about to try and work out a tram or bus to get me there :P [09:18:08] Trains from here are pretty easy [09:18:10] well, with public transport you have to go to Muiderpoort by foot, then take a train to Schipol (~ 4 €). there is a bus from the hostel, you have to book it at keast 2 hours before you leave (~ 16 €), a cab is ~ 50 € so if we share it in 4 it is reasonable I believe... [09:44:44] sooooo, what to do? :) [09:47:53] any tech around? [09:48:07] we are getting errors on wikidata we are doing to many edits [09:48:27] during the pywikipedia workshop on the hackaton [09:48:29] :o [09:48:44] heh [09:48:49] 77.170.89.227 :-) [09:49:04] isn't that in Amsterdam this year? [09:49:05] akoopal: wikimedia2 has a different IP [09:49:07] i think there was a limit exemption put in place [09:49:18] MatmaRex: I put one in place for account creation [09:49:25] ah. [09:49:25] RoanKattouw: do you know it? [09:49:27] But apparently Wikidata is also doing IP-based rate limiting separately [09:50:21] akoopal: 213.127.161.46 [09:50:25] is the IP for wikimedia2 [09:50:28] wikimedia1 is the one you said [09:50:55] MatmaRex: (BTW, where are you at? I've been meaning to say hi) [09:53:22] Susan: More efficient how? [09:55:53] RoanKattouw: near the back of the room [09:55:58] next to the lunch area [09:56:40] but can somebody raise that limit? [09:56:53] akoopal: where are you? [09:57:06] addshore: pywikipedia workshop [09:57:14] in the big breakoutroom [09:59:04] should you not all be logged in to accounts...? [10:00:37] addshore: yes, they just created accounts [10:00:50] still there seemed to be a limit I heared from others [10:01:17] (i am running it from home, so didn't see it) [10:01:57] Many people seemed to have been editing without being logged in (looking at the contribs of the two ips) [10:02:05] lol [10:02:07] which may have been why they were hitting a limit [10:02:11] There's always a account creation limit per IP [10:02:22] oh do we need to fix the limit addshore ? [10:03:30] I'v just walked in, Ill see if they are having problems :) [10:04:11] addshore: ok, maybe wave to maarten [10:05:19] I think they are just wrapping up now anyway :) [10:05:25] yep [10:10:34] RoanKattouw: afaik wikidata does all the limiting seperately, since the code doesn't hit the normal limiting features [10:11:32] as they found out when Lego was running that bot iirc [10:16:49] p858snake: wasn't that bug closed? [10:17:45] https://bugzilla.wikimedia.org/show_bug.cgi?id=47158 [10:17:50] DanielK_WMDE__: ?? [10:20:50] I don't understand if throttle.php also raises the throttle for non-autoconfirmed user edits [10:25:15] Nemo_bis: it's closed, and seems to be working as designed [10:25:22] which was exactly the problem at the workshop :) [10:25:44] that is, it enforced a rate limit on the IP address, because the bots were not autoconfirmed [10:25:57] yep [10:26:13] I assumed throttle.php changed wgRateLimits for that too [10:34:59] ahhh [10:35:18] had I known this would have been a problem earlier I would have poped in and confirmed the accounts as they were created :) [10:45:49] Reedy: where should bugs like https://bugzilla.wikimedia.org/show_bug.cgi?id=43815 be? [10:46:11] it was moved from the component where I originally put it [10:47:34] Where else would it go? [10:47:39] ChristianCantoro, did you decide what you are doing? :-) [10:50:02] Reedy: see the history? :P [10:50:12] General -> Installer [10:50:53] there are other similar bugs in Tools > [Other] [10:51:08] even filed by you and Chad; should they be moved? [10:54:24] Guess it doesn't make much difference [10:54:46] should probably have an installer bug, and a bug to do the script change [10:55:30] :/ [11:21:32] hello there [11:21:50] hello here [11:21:53] we do have a serious issue with abusefilter on tr-wiki [11:22:04] ? [11:22:13] the new filters do not work at all [11:22:32] which new filters? [11:22:35] newly added filters? [11:23:07] http://tr.wikipedia.org/wiki/%C3%96zel:%C4%B0stismarS%C3%BCzgeci [11:23:11] yes, newly added ones, [11:23:17] no's 40-45 [11:23:55] they do work when we in test mode, though [11:24:10] but they do not tag edits [11:24:24] Do you have any examples that it should've caught/there should be hits for [11:24:48] yes [11:27:27] to test 45, you may create a talk page with a single character [11:27:36] and you'll see it will not be caught [11:29:15] we suspect the recent updates are the reason [11:29:47] no matter who created the filter (technician, sysop, etc.) the newly added ones do not work [11:30:12] are you there? [11:31:49] hello? [11:36:27] Reedy? [11:47:32] hello [14:38:21] DanielK_WMDE__: ping [14:53:20] I'm having an issue installing mw 1.21 [14:53:41] after I upload everything I run update.php and it gives me an error [14:53:48] okay [14:54:37] here's the error: [14:54:38] [ps126442]$ php update.php A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: SELECT page_id,page_len,page_is_redirect,page_latest,page_content_model FROM `page` WHERE page_namespace = '0' AND page_title = 'UNTITLED' LIMIT 1 Function: LinkCache::addLinkObj Error: 1054 Unknown column 'page_content_mo [14:54:56] too long, end is missing. [14:55:56] it's enough to tell what the error is andre__ [14:55:58] here's the end again [14:55:59] Query: SELECT page_id,page_len,page_is_redirect,page_latest,page_content_model FROM `page` WHERE page_namespace = '0' AND page_title = 'UNTITLED' LIMIT 1 Function: LinkCache::addLinkObj Error: 1054 Unknown column 'page_content_model' in 'field list' (data.aiowiki.com) [14:57:10] I was running 1.20.5 before [14:59:21] reddo: you should be discussing this problem in #mediawiki [15:00:42] okay Jeremyb i will, thanks [15:41:16] Heyo. This is Sahar from fundraising. Can someone please tell me the parameters of this room? What's on-topic? What's off-? [15:43:51] This channel is about technical issues on wikimedia wikis. [15:46:57] Out of curiousity, what about backend problems that aren't wikis? Load balancing, databases, etc? [15:48:29] sahar: that, too. [15:49:42] sahar: Anything that affects the operation, performance or functionality of a Wikimedia wiki, basically. [15:51:40] Thanks. My specific issue is that I'm a contractor for fr, and have a pesky bash question that google isn't too helpful with. Is this a good place to ask for quick advice? Or should I just try somewhere else like stackoverflow? [16:00:33] sahar, you can try asking here [16:03:19] Krenar: thanks [16:04:44] I want to do something like " grep abcd *.tsv > *abcd.tsv" [16:05:54] or simplified: when I use the * selector, how do I access the value that the * turned into later on in the piping chain? [16:07:10] I think it should look like: ls *.tsv | echo $_ , except with some other magic combination other than $_. I can't for the life of me remember or figure out what the correct thing is [16:11:36] sahar: hmm [16:11:48] i think for something like that you'd wand to use a for loop [16:12:01] for x in *.tsv; do echo $x; done [16:12:09] or rather [16:12:11] echo "$x" [16:12:17] gotta quote just in case :D [16:12:27] Right [16:12:28] I tried this [16:12:30] for f in *.tsv; do echo $f; done; [16:12:43] but that gives me whole string, not just what's contained in the * [16:12:52] ahh [16:13:05] lemme pull up the handy bash reference i use for string manipulation [16:13:10] thanks brion [16:13:12] there's a fairly easy way to trim the '.tsv' off the end [16:13:23] yeah, but that's for the toy example I gave you [16:13:38] http://www.unixguide.net/unix/bash/G6.shtml <- has a hint [16:13:59] if you're doing tricky stuff you can probably use a regular expression and sed or perl… oh shell scripting gets so fun :P [16:14:20] ah there's the full page i wa looking for http://tldp.org/LDP/abs/html/string-manipulation.html [16:14:27] there's various different operators available standard [16:18:38] brion: thanks. this is a great lead. I appreciate your help [16:18:51] good luck! [16:28:16] what's this? https://noc.wikimedia.org/conf/highlight.php [16:28:28] it's called trolling [16:32:13] str4nd: what? isn't it leaking something maybe unwanted? [16:32:37] heh :) [16:44:18] wtf [16:44:47] Some one want to stop the flood? ^ [16:45:07] !ops [16:45:21] Hello Krenair [16:45:26] hi QueenOfFrance [16:48:09] Krenair: if he's flooding other channels w/ that, you may want to forward this to freenode staff [16:48:13] they do klines for excesses of this [16:48:51] I haven't seen it in any other channels I don't think [16:49:29] and the user in question gets my memo [16:49:42] (which I sent to him to notify him about why he's banned from the channel) [16:49:51] In my experience this sort of issue isn't the user's fault [16:49:55] yeah [16:50:09] so once he tells me that he fixed his client, I'm going to unban [16:51:22] I've been looking into doing https://bugzilla.wikimedia.org/show_bug.cgi?id=40785 (removing sajax from core) [16:51:32] only thing using it is the upload form's file existence check [16:51:53] Have successfully moved it into a new API module but I feel like maybe I should merge this into an existing one [16:53:00] Jasper_Deng, ah that guy was also in -labs [17:00:31] he told me his bouncer is now fixed [21:04:36] can anyone have a look at http://en.wikipedia.org/wiki/Wikipedia:Village_pump_(technical)#Problem_deleting_redirect._Developer_action_needed.3F ? [21:05:43] Interesting. [21:05:48] bizarre edge case triggered, not really sure how to deal with it [21:06:11] I think I can delete it via the API [21:09:16] if you can, do so [21:10:26] done [21:10:45] 21:10, 26 May 2013 Legoktm (talk | contribs | block) deleted page ƀ (Wikipedia:Redirects_for_discussion/Log/2013_May_18#.C6.80) (view/restore) [21:11:14] did oldid fail like curid? [21:11:23] this is similar to the problem with the weird m user [21:11:25] A bug should probably be filed... [21:11:42] idk. I just found the page id with action=info and deleted it with ApiSandbox [21:11:46] Krenair: do you remember the bug about that user? [21:11:55] No... When was that? [21:12:02] few weeks or months ago [21:12:32] Did it end up in bugzilla? If not I probably didn't see it... :p [21:12:53] Special:Contributions and renameuser didn't work because he had a special lower case m-like letter [21:13:19] Krenair: http://en.wikipedia.org/wiki/Wikipedia:Village_pump_(technical)/Archive_105#Link_in_history_says_user_does_not_exist [21:13:37] * Krenair wishes xchat could parse links correctly [21:14:28] thanks Titoxd_ :) [21:14:32] no prob