Times are UTC Toggle Colours
01:36:14 *** Supercheese has joined #openttdcoop.devzone 01:50:03 *** Supercheese has quit IRC 02:08:45 *** Supercheese has joined #openttdcoop.devzone 05:51:14 *** Supercheese has quit IRC 06:07:48 *** Zuu has joined #openttdcoop.devzone 08:12:16 *** Zuu has quit IRC 11:44:01 <Brot6> DACh - Narrow Gauge - Feature #5396: NG sprites XVoyager1X @ http://dev.openttdcoop.org/issues/5396#change-16865 14:57:01 *** ODM has joined #openttdcoop.devzone 16:04:48 <Brot6> Grapes - Revision 183:aef9d68b722f: Change: move callback execution into a central place and make it... XdihX @ http://dev.openttdcoop.org/projects/grapes/repository/revisions/aef9d68b722f 16:04:48 <Brot6> Berries - Revision 68:87c9ac07233d: Change: comply with changes made to PluginManager XdihX @ http://dev.openttdcoop.org/projects/berries/repository/revisions/87c9ac07233d 16:13:12 *** Alberth has joined #openttdcoop.devzone 16:37:12 *** Jam35 has joined #openttdcoop.devzone 17:06:05 <planetmaker> @op 17:06:17 <planetmaker> @services op 17:06:37 <Alberth> op doesn't like you :) 17:07:29 *** ChanServ sets mode: +o planetmaker 17:07:49 <^Spike^> ? :) 17:08:18 <planetmaker> :-P 17:08:25 <^Spike^> it's not like i'm about to break stuff..... 17:08:28 <^Spike^> oh wait... ;) 17:08:29 *** planetmaker changes topic to "DevZone might be currently unresponsive due to DB maintenance | Talk about things hosted and developed on http://dev.openttdcoop.org | Downloads log: http://bundles.openttdcoop.org/log.csv | Sandbox passwords are the same as the usernames" 17:08:37 <planetmaker> just wanted... to warn people :D 17:09:38 <Rubidium> doing the same as owen? 17:09:58 <^Spike^> ? 17:10:00 <^Spike^> what 17:10:18 <planetmaker> dunno exactly what owen does. But I don't think so 17:11:02 <^Spike^> me neither... :) 17:11:55 <^Spike^> hmmmm..... 17:13:33 *** Jam35_ has joined #openttdcoop.devzone 17:14:32 <Rubidium> I'd say: see the forum, but it's unbearibly slow 17:14:45 <Rubidium> but... some tidbits of the last few days (including today) 17:14:53 <Rubidium> "I've moved the database back to MyISAM and the old MySQL search index." 17:15:04 *** Jam35 has quit IRC 17:15:08 <Rubidium> "All posts up to post id 121200 have now been indexed" 17:15:21 <Rubidium> "The search indexing is still going, which may slow things down for a bit." 17:15:38 <^Spike^> :) 17:15:46 *** Jam35 has joined #openttdcoop.devzone 17:15:53 <^Spike^> i only try to setup a copy of the DB so we know it works yes/no... 17:15:55 <Rubidium> "I've made some more changes to the database server. If this still doesn't help, I'll see what else can be done." 17:15:56 <^Spike^> not break devzone :) 17:16:05 <^Spike^> wget mysqltuner.pl 17:16:06 <^Spike^> ;) 17:16:18 <^Spike^> helps alot... 17:16:19 <^Spike^> or well 17:16:29 <^Spike^> 2 DB servers... master/master.... 1 read only 17:16:35 <^Spike^> and loadbalance that stuff... :) 17:16:44 <^Spike^> also makes load alot easier on the server... 17:16:54 <^Spike^> if that still breaks... you seriously need a server that can handle IO.... 17:17:00 <^Spike^> i recommend FusionIO in that case.... 17:17:10 <^Spike^> only costs a few K per card... but SSD on steroids ;) 17:17:34 <^Spike^> as you might notice... i've done alot of these kind of setups in the past 1,5 year :) 17:19:11 <dihedral> ^Spike^, ever had a master/master with mysql 17:19:32 <^Spike^> use it at work for several customers... only 1 node in forced read only for users 17:19:33 <dihedral> that works for small db's but never start carzy queries or else it will miserably fail 17:19:38 <^Spike^> ehm.... 17:19:46 <dihedral> that is master/slave 17:19:50 <^Spike^> as said... we use it to create a fail-over scenario 17:19:53 <^Spike^> yes/no 17:19:55 <dihedral> yes 17:19:57 <^Spike^> it's master/master... 17:20:06 <^Spike^> with a global define read_only yes on one side 17:20:10 <^Spike^> the moment we need to fail-over 17:20:11 <dihedral> master master means you can write to any db and it will be synced to the other 17:20:12 <^Spike^> fix LB 17:20:15 <^Spike^> fix node.... 17:20:17 <^Spike^> and done... 17:20:27 <^Spike^> the moment your other node comes back it's the slave of the new master and syncs 17:20:38 <^Spike^> i know... 17:20:43 <dihedral> there you have it - master / slave with failover :-) 17:20:45 <^Spike^> :) 17:20:53 <^Spike^> but big dbs? 17:21:02 <dihedral> complex statements 17:21:03 <^Spike^> ehm./.. think got a customer with 50GB db... 17:21:10 <^Spike^> and they make fucked up statements 17:21:14 <dihedral> nah - i mean the real master master 17:21:18 <^Spike^> ah... 17:21:21 <dihedral> active active might be more specific 17:21:31 <^Spike^> well these f***** had a 75GB DB just for caching.... 17:21:36 <^Spike^> until we put them on fusionio 17:21:58 <^Spike^> they dropped that "cache" database :D 17:21:59 <dihedral> hehe - ssd helps :-P 17:22:03 <^Spike^> it's not even SSD 17:22:13 <^Spike^> it's even worse..... it's much faster then that :D 17:22:18 <dihedral> if you have enough disks in the stripe it works as well 17:22:22 <dihedral> with SAS 17:22:33 <^Spike^> for this site that wasn't even enough 17:22:37 <^Spike^> they had 4 DB servers 17:22:42 <^Spike^> 1 master 3 slaves 17:22:59 <^Spike^> with christmas.... ehm.... it was hell of a work to keep it running 17:23:04 <^Spike^> i wonder how it will be this year :D 17:23:05 <dihedral> once had a client with a 60GB DB, gave his VM 128 GB and made a tmpfs of 64GB for the db :-D 17:23:12 <dihedral> ran mysql out of a ramdisk :-D 17:23:16 <^Spike^> ...... 17:23:23 <dihedral> it worked like a charm 17:23:27 <^Spike^> true it works.... 17:23:29 <^Spike^> just don't reboot... 17:23:36 <dihedral> have a background process sync to harddisk 17:23:49 <^Spike^> live sync? ;) 17:23:55 <dihedral> hihi 17:23:59 <^Spike^> so..... 17:24:03 <^Spike^> don't reboot... 17:24:09 <^Spike^> and hoe for no power fails :D 17:24:16 <^Spike^> but back to ruby/gems being a bitch.... 17:24:21 <^Spike^> you must install gem... 17:24:24 <^Spike^> ok install.... 17:24:27 <^Spike^> run command again 17:24:30 <^Spike^> you must install gem.... 17:24:35 <^Spike^> i just installed that thing FFS!!!! 17:24:47 <planetmaker> I'd not call it 'gem' ;-) I call it... something else :-P 17:25:00 <^Spike^> i call it *(#$*(@#&$)(@#$*)_(@#&$*(@#&$*(@#&)$() ruby 17:25:08 <planetmaker> yeah, similar 17:25:19 <^Spike^> i know i have 255 characters... but well it would be repetitive :D 17:25:20 <Alberth> doesn't look like a proper RE :p 17:25:38 <^Spike^> RAILS_ENV=new_postgres rake db:migrate 17:25:41 <^Spike^> all ik want to do.... 17:26:02 <^Spike^> i* 17:27:29 <^Spike^> atleast devzone still works 17:27:51 <^Spike^> even worst.... gem list shows it installed..... 17:28:35 <Alberth> lol 17:28:50 <^Spike^> really feels like a talk at work.... 17:28:57 <^Spike^> for IT ppl everything has to be logical..... 17:29:03 <^Spike^> the moment it isn't.... they either... 17:29:06 <^Spike^> 1. PANIC!!!!!! 17:29:13 <^Spike^> 2. Ah screw it let's start over 17:29:21 <^Spike^> :) 17:32:45 *** frosch123 has joined #openttdcoop.devzone 17:33:45 <Alberth> hi hi 17:33:56 <^Spike^> say that i'm wrong in that... :) 17:34:38 <Alberth> my reaction is then 3. stop typing, and start thinking about why it happens :) 17:34:54 <^Spike^> well... that's what we tried friday with a loadbalancer..... 17:34:56 <Alberth> but then again, maybe I am not part of "IT PPL" :) 17:35:15 <^Spike^> it kept showing the wrong server..... every setting was correct up to the IP and everything 17:35:18 <^Spike^> still wrong server.... 17:35:23 <Rubidium> oh please... can I have one of those at my work? 17:35:38 <planetmaker> no, I want that one person ;-) 17:35:40 <^Spike^> we remove the external IP completly... start over... exact same settings and it works... 17:35:42 <Alberth> ^Spike^: might have one :) 17:36:04 <^Spike^> dev:~ # gem install adapter-postgres 17:36:04 <^Spike^> ERROR: Error installing adapter-postgres: 17:36:04 <^Spike^> adapter-postgres requires adapter-postgres (>= 0) 17:36:06 <^Spike^> also a fun one 17:36:18 <^Spike^> i start to like ruby more with the minute :D 17:36:22 <Alberth> how useful :) 17:36:40 <^Spike^> do we really need redmine? ;) 17:37:24 <Alberth> do you really want to install another one from scratch? ;) 17:37:45 <^Spike^> ehm.... well if we can switch to something else... ;) 17:39:02 <planetmaker> uhm... if it helps 17:39:25 <planetmaker> that means indeed completely new everything. Still we need to transition projects + issues 17:39:31 <^Spike^> :) 17:39:57 <^Spike^> it's too much to do on 1 night though :D 17:40:09 <^Spike^> as said... tomorrow i have to upgrade/downgrade my friend the loadbalancer(s) 17:40:29 <^Spike^> what could only go wrong next to over 10k sites going down... :) 17:41:05 <planetmaker> that's less important! ;-) 17:41:08 <^Spike^> ;) 17:56:15 <^Spike^> even worse.... i foudn the actual ruby file of that gem.... 17:56:17 <^Spike^> it's there ffs 18:16:46 *** ChanServ sets mode: +o ^Spike^ 18:16:59 *** ^Spike^ changes topic to "Talk about things hosted and developed on http://dev.openttdcoop.org | Downloads log: http://bundles.openttdcoop.org/log.csv | Sandbox passwords are the same as the usernames" 18:23:34 <Brot6> Grapes - Revision 184:def1d6fefd0c: Change: method name changed - use it! XdihX @ http://dev.openttdcoop.org/projects/grapes/repository/revisions/def1d6fefd0c 18:24:47 <^Spike^> dihedral felt safe committing the moment i changed topic... :D 18:29:15 *** Jam35 has quit IRC 18:32:31 *** andythenorth has joined #openttdcoop.devzone 18:35:14 <Alberth> o/ 18:35:41 <andythenorth> o/ 18:35:48 <^Spike^> \o/ 18:39:48 <planetmaker> o 18:39:50 <planetmaker> ;-) 18:40:26 <V453000> o//-f>/ 18:57:32 <dihedral> hihi 18:57:38 <dihedral> ^Spike^, i like moving in shadows 18:58:10 <^Spike^> ;) 18:58:19 <^Spike^> /etc/init.d/vz stop 18:58:23 <^Spike^> oh.. wrong screen... ;) 18:58:34 <^Spike^> more of a case of try it now!!! ;) 19:00:03 <dihedral> ... lol? 19:01:29 <^Spike^> basicly if i did that... i killed all containers :D 19:01:31 <^Spike^> try commits then ;) 19:01:35 <^Spike^> to devzone ;) 19:44:07 *** ODM has quit IRC 19:44:30 *** Alberth has left #openttdcoop.devzone 20:46:43 <^Spike^> should devzone respond slower.. SORRY i'm cloning it :) 20:50:32 *** ^Spike^ changes topic to "DevZone MIGHT respond slow/not, Known issue | Talk about things hosted and developed on http://dev.openttdcoop.org | Downloads log: http://bundles.openttdcoop.org/log.csv | Sandbox passwords are the same as the usernames" 20:51:48 *** ^Spike^ changes topic to "DevZone MIGHT respond slow/not, Known issue. ETA: Blame the server | Talk about things hosted and developed on http://dev.openttdcoop.org | Downloads log: http://bundles.openttdcoop.org/log.csv | Sandbox passwords are the same as the usernames" 20:53:33 <TWerkhoven> i like your eta 20:53:42 <^Spike^> :D 20:53:51 <^Spike^> i can't help it if copying takes long :) 20:53:55 <^Spike^> out of my power :D 20:54:16 <^Spike^> and well... i really need that clone so... 20:54:19 <TWerkhoven> its done when its done 20:54:26 <^Spike^> :) 20:54:37 <^Spike^> best way to work with it :) 20:54:48 <^Spike^> do it at work all the times with outtages 20:54:56 <^Spike^> alot of customers calling: 20:55:00 <^Spike^> we're working on it 20:55:04 <^Spike^> when will it be fixed!? 20:55:12 <^Spike^> we don't know... but you'll know when we know! 20:55:12 <^Spike^> :D 20:55:17 <TWerkhoven> hehe 20:56:51 <^Spike^> better said all we tell the ppl on the phone: Yes there is an outtage that is all you can tell 20:56:54 <frosch123> get a better coffee machine 20:57:00 <^Spike^> the moment they ask: But what is it 20:57:02 <frosch123> one which gives you an eta when the coffee is ready 20:57:08 <^Spike^> You'll get to know when you NEED to know 20:57:11 <^Spike^> at this time you don't! 20:57:19 <TWerkhoven> 'we dont know either, we're just phonemonkeys' 20:57:24 <TWerkhoven> at least that was my excuse 20:57:26 <^Spike^> that's the idea yeah 20:57:35 <^Spike^> the less they know the less they can tell :) 21:00:36 <^Spike^> not rocket science that is happening is see..... 21:00:47 <^Spike^> cp container containerclone 21:00:55 <^Spike^> even i could've thought of that.... 21:34:38 <^Spike^> seems it didn't like the clone action... 21:34:44 <^Spike^> next time i'll do it manually... :D 21:45:34 <^Spike^> i get a feeling i have one choice.... 21:45:49 <^Spike^> might aswell update when i do so 21:48:57 <^Spike^> Our servers will need a reboot... might be down for a few minutes