[16:50:22] <^demon> RoanKattouw: Tim's got the redirect table changes in his next set of changes. [16:50:29] I know [16:50:33] <^demon> I could've *sworn* you had pushed the db changes out over a year ago [16:50:39] Me too [16:50:41] <^demon> Or had said you were going to [16:50:43] <^demon> Or something [16:50:49] I was gonna lobby for it [16:50:56] ... with Brion, probably :) [16:51:07] <^demon> Anyway, yay :) [16:51:08] I wonder what else hasn't been pushed out... [16:51:08] Damn, my CREATE INDEX on the toolserver is *still* running [16:51:09] <^demon> Long overdue [16:51:15] It's been running for hours [16:51:21] is the table big? :P [16:51:25] Yes [16:51:41] This is ridiculous. I guess I'll just drop the table, add the index, and reimport the data [16:51:42] <^demon> Reedy: Compare output of SHOW CREATE TABLE to trunk's tables.sql [16:51:53] I have done before [16:52:13] wouldn't be suprising if there was a missing index or 2 [16:52:28] There are missing fields [16:52:31] <^demon> Probably a few extra indexes that were live-hacked :p [16:52:36] heh [16:53:32] Then there is proably some discrepancies from wiki to wiki.. [16:56:05] <^demon> Tables that aren't used such as searching and updatelog are outdated I'm sure. [16:57:05] mhmm [16:57:09] Which is fair enough [16:57:20] Though, tims latest schema patch does have an insert to update log [16:57:25] Grr [16:57:27] presumably accidental [16:57:34] The table I tried to create an index on is blocking for every query [16:57:36] Even DROP TABLE hangs [16:57:42] I guess it's locked [16:58:38] <^demon> Silly mysql [16:58:40] Hey Reedy you have ts root, right? Do you know of a way to forcibly drop that table for me? [17:01:20] Oh here we go [17:01:28] I guess I can kill the relevant processes on the DB myself [17:05:34] Success [17:11:35] Haha [17:12:36] SHOW PROCESSLIST; , then KILL 12345; [17:34:35] Poor 12345. [17:36:33] haha [17:48:46] isn't it faster to truncate the table before dropping it? [17:52:03] Damn, my CREATE INDEX on the toolserver is *still* running [17:52:08] On which table? [18:27:53] Shirley: nm, killed it. Was a user DB table [18:28:04] The query ended up taking an hour even with the index :O [19:23:29] *jorm invokes kaldari [21:52:58] here's something for people to complain about: http://www.mediawiki.org/wiki/WikiLove [21:55:05] huh, OSCON Data -- new conference at the same time as OSCON, CfP open for another week: http://www.oscon.com/oscon2011/public/cfp/156 [22:01:11] jorm: I think sending a beer may be offending in certain cultures [22:01:18] cup of coffee? [22:01:29] i went and got the templates that we have. [22:01:38] ah ok [22:01:43] i agree with your concerns, though. [22:01:49] there should be a welcome template as well. [22:02:05] but i couldn't find a good image quickly. i threw this together this morning. [22:02:15] I like the interface [22:02:17] based on a javascript prototype that kaldari wrote. [22:02:21] thanks! [22:02:57] you know we will have to let people add to it [22:04:39] yes. [22:04:48] there's some wording about that in the document. [22:04:56] ideally, i think there will need to be an administration console. [22:05:10] "create template category" -> add template, etc. [22:05:34] right [22:05:47] what kind of kittens?? [22:06:35] kaldari says there are lots of kitten templates. [22:07:08] i'd love to be able to merge the details and preview system into one thing, actually. so when you type, the preview is already there and auto-fills. [22:07:19] but for now, and ease of development, we'll do it in a stepped system. [22:07:31] do you guys think it's too whimsical? the design? [22:08:51] mm no [22:09:11] I think it isn't the final design but I don't know what's... missing or whatever [22:09:56] brion & robla -- http://www.mediawiki.org/wiki/Berlin_Hackathon_2011#Straw_Poll [22:12:28] whee [22:13:55] date looks good [22:14:05] I did not remember about the straw poll, got lucky I guess [22:14:36] sticking in my note that 20-22 is a bad weekend for me [22:15:03] thanks sumanah ... I didn't see the poll originally, but I got behind on a lot of stuff last week, so I'm not surprised if I just missed it [22:15:11] wow, two kids' birthdays and an anniversary between me, trevor, and robla :D [22:15:38] brion: your anniversary, right? [22:15:41] jorm: good first cut on wikilove [22:15:46] yep [22:15:58] and poor duesentrieb's kids's birthday is the next weekend [22:16:04] jorm: the kittens may be too much [22:16:05] we can't win eh :D [22:16:07] brion: and there's another kid's birthday in may - Daniel K [22:16:14] speak to kaldari about that. heh. [22:16:15] yep [22:16:19] i'm more worried about the beer. [22:16:26] islam != liking the beer. [22:16:47] jorm: what do they think about kittens drinking beer? [22:16:56] i'm all for it. [22:18:18] we keep the kittens [22:18:22] it's mandatory [22:18:50] apergos: i like kittens so i agree :-) [22:19:00] Probably more co-operative to be squeezed into the rackmount servers too [22:19:11] I'm allergic [22:19:36] bryan: we can do puppies for you then [22:20:11] that could work [22:20:18] I'm thinking beer drinking kittens with cookies and cigarettes [22:20:21] and of course the fallback is always [22:20:26] hamsters [22:20:39] apergos: :-) [22:21:42] would anyone really want to get a hamster on their page? hmmmmmmmm [22:22:03] how about a rocket-powered hamster [22:22:06] "Hi, you've done a fabulous job on this article! Here's a hamster" [22:22:19] just give me the jet pack and keep the hamster [22:22:27] Maybe we have a selection of cute animals [22:22:36] that works for me [22:22:41] my cat used to leave squirrel guts on the doorstep as sort of her way of sending love [22:22:43] no jimbo eyes though. that's just creepy [22:22:57] awww, how cute ... in a twisted sort of way [22:23:04] apergos, we could just link to the swap jimmy with kitten chrome plugin [22:23:19] I only know the puppy swap, not the kitten one [22:26:36] I wonder if I should have rerun the de history from scratch but it would cost another at least 9 days [22:26:48] this way I cut 6 days out of the equation but there are two pieces [22:26:49] Ouch [22:27:09] which can't really be recombined cause one was written pre 117 and the other post (different schema) [22:27:28] I think it's sane [22:28:24] it will be a bit annoying on the next job because I'll have to run that step by hand I think [22:28:29] but after that we will be back to normal [22:30:19] All better for the long run [22:30:50] well in the long run this whole "produce one file" thing is going to go away [22:31:03] that's the next bit of code I have to do [22:31:24] I've just been playing catchup getting the runs restarted, fixing up things interrrupted by the deployment etc [22:32:35] *jorm finally getting around to eating lunch. [22:32:40] soon: climbing. [22:32:48] nice [22:33:21] then this evening stacey goes to roller derby and i'll get some breathing space to do more work. [22:34:00] ah, work.... [22:34:04] what a cncept