| 00:01.43 | blast007 | here goes nothing *crosses fingers* |
| 00:02.19 | QuantumWork | I can smell the smoke from here |
| 00:02.28 | blast007 | the poor VPS ;) |
| 00:02.44 | QuantumWork | awww |
| 00:02.51 | blast007 | mysql using 105% CPU, how cute |
| 00:03.40 | QuantumWork | Probably one of those burstable-CPU situations |
| 00:03.45 | blast007 | auth/list might be down during the restore, but the restore shouldn't take too long |
| 00:04.11 | blast007 | I think we're more disk I/O limited on this VPS than anything |
| 00:05.20 | QuantumWork | My VPS is ridiulously IO limited because everyone else is using it for a seedbox |
| 00:05.27 | blast007 | heh |
| 00:05.45 | QuantumWork | but surely the bzbb database can fit inside RAM? |
| 00:05.53 | blast007 | 512MB RAM |
| 00:05.56 | QuantumWork | Bah |
| 00:06.02 | QuantumWork | I pay $25 for 1.5gb |
| 00:06.02 | blast007 | 493, actually |
| 00:06.10 | blast007 | this is $8 :) |
| 00:06.13 | QuantumWork | geez |
| 00:06.22 | QuantumWork | I can feel the dedication from here |
| 00:06.40 | blast007 | hey, this was an UPGRADE from what it was |
| 00:06.45 | QuantumWork | I remember |
| 00:06.51 | blast007 | at least we have free RAM now ... |
| 00:07.23 | blast007 | the wiki runs off my xlhost box.. it was a bit too hungry for the VPS |
| 00:07.38 | QuantumWork | Your xlhost is the Mofo box, right? |
| 00:07.46 | blast007 | no, I have my own |
| 00:07.48 | QuantumWork | ah |
| 00:07.53 | blast007 | quite a bit faster than the mofo box |
| 00:07.58 | blast007 | mofo box is a single core, iirc |
| 00:08.00 | blast007 | mine's a quad |
| 00:08.20 | blast007 | quad 2.5GHz, 2GB RAM |
| 00:08.31 | QuantumWork | sounds like $$ to me |
| 00:08.43 | blast007 | same price as the mofo box, iirc - or close |
| 00:09.27 | blast007 | $69 |
| 00:09.33 | QuantumWork | The Mofo box could easily be moved to a VPS now |
| 00:09.38 | blast007 | yeah |
| 00:09.53 | blast007 | or just run off a home connection |
| 00:10.00 | QuantumWork | It was in the beginningg |
| 00:10.04 | blast007 | yep |
| 00:10.07 | QuantumWork | IDO had it on his cable |
| 00:10.16 | blast007 | my server started on my 56k modem ;) |
| 00:10.29 | blast007 | those were the days |
| 00:10.35 | QuantumWork | I ran some nice bz games on an Amazon free wedge |
| 00:10.37 | QuantumWork | got 10ms ping |
| 00:11.08 | blast007 | my 133MHz system running Slackware linux, getting internet through a Windows XP computer with ICS to a dialup modem |
| 00:11.18 | QuantumWork | BZ ain't CPU hog |
| 00:11.38 | blast007 | can't remember if I had a USB ethernet adapter on the XP system.. |
| 00:11.41 | QuantumWork | you could probably take that box, give it cable internet, and run every server in the community on it at once |
| 00:11.57 | blast007 | the 133MHz? definately not |
| 00:12.02 | QuantumWork | No? |
| 00:12.09 | blast007 | not enough RAM |
| 00:12.20 | QuantumWork | It used like 3% of the Celly 2.5 at utter peak on my Aplus mofo box |
| 00:12.30 | QuantumWork | and that was running Mofo plus like 40 others |
| 00:12.51 | blast007 | I don't think you can pack enough RAM into even the best Pentium I chipset to run all the servers |
| 00:13.06 | blast007 | isn't the most you'd get like 128MB? |
| 00:13.23 | QuantumWork | they had 64mb SIMMS |
| 00:13.33 | QuantumWork | they looked ridiculous |
| 00:13.37 | QuantumWork | but you could get them |
| 00:13.55 | blast007 | one of my servers is using 27MB right now |
| 00:14.04 | blast007 | (108MB 'virt') |
| 00:14.50 | QuantumWork | time have changed |
| 00:14.59 | QuantumWork | that was 2.0.0 we were using at the time |
| 00:15.06 | blast007 | also, I think the overhead of processing all the network traffic would overload a 133MHz |
| 00:15.15 | *** join/#bzflag mdskpr_ (~mdskpr@108.25.131.122) |
| 00:15.22 | *** join/#bzflag spldart (~spldart2@c-98-198-227-61.hsd1.tx.comcast.net) |
| 00:15.22 | *** join/#bzflag spldart (~spldart2@bzflag/contributor/spldart) |
| 00:15.22 | *** mode/#bzflag [+v spldart] by ChanServ |
| 00:15.34 | blast007 | at least if stuff picked up again |
| 00:15.46 | QuantumWork | I fear it won't |
| 00:15.55 | blast007 | probably |
| 00:15.56 | QuantumWork | the heart of the freebie gamer has been stolen by TFs |
| 00:16.00 | QuantumWork | TF2 |
| 00:16.11 | blast007 | god I hate that game |
| 00:16.17 | QuantumWork | blasphemer |
| 00:18.00 | spldart | TF is for infidels! |
| 00:18.02 | blast007 | hrm.. that restore didn't seem to work.. the forum was still in the offline mode from before |
| 00:18.21 | blast007 | or maybe it did |
| 00:18.34 | blast007 | QuantumWork: looks like your sister's account is back |
| 00:18.48 | QuantumWork | Coool |
| 00:19.05 | QuantumWork | testing... |
| 00:19.37 | blast007 | goes back to re-re-ban FangUp |
| 00:19.52 | QuantumWork | Yep, she's doing her happy dance |
| 00:19.54 | QuantumWork | all is well |
| 00:20.01 | blast007 | cool |
| 00:20.18 | mdskpr_ | ack, was gonna steal her callsign |
| 00:20.33 | blast007 | steals mdskpr_'s face |
| 00:20.40 | blast007 | look at me, I'm mdskpr_! |
| 00:20.43 | QuantumWork | Pam still had her account in order |
| 00:20.49 | QuantumWork | she would have rained grief upon your head |
| 00:21.21 | mdskpr_ | ya, im just that sexy |
| 00:21.35 | blast007 | my conditioner protects against liquid grief |
| 00:22.07 | spldart | lmao |
| 00:26.29 | blast007 | QuantumWork: thanks for letting me know that the problem was more widespread than I had initial thought |
| 00:26.44 | QuantumWork | My pleasure |
| 00:26.49 | blast007 | really glad it was discovered so soon after it occured so data loss was minimal |
| 00:26.56 | QuantumWork | I take a sort of ugly pride in being the bearer of bad news |
| 00:27.34 | blast007 | might be worth me looking into the binary logs though |
| 00:27.40 | QuantumWork | I told her that you restored the entire forum to fid her logon |
| 00:27.46 | blast007 | haha |
| 00:27.47 | QuantumWork | No need to clarify that one |
| 00:29.19 | blast007 | it was 24 hours ago exactly that the forum category vanished while I was trying to split a topic that was within it |
| 00:29.44 | blast007 | should have seen my face when the forum poped up "The forum does not exist" |
| 00:30.13 | QuantumWork | I know that feeling |
| 00:30.34 | QuantumWork | Same one you get when you format the wrong drive |
| 00:30.34 | blast007 | the server does daily backup though, and it pushing them off to a remote host |
| 00:31.00 | blast007 | and if I get the mysql binary log turned on, it should be possible to restore to any point in time (within reason) |
| 00:31.21 | blast007 | the binary log also makes it easier to recover from crashes |
| 00:31.29 | QuantumWork | nice |
| 00:31.37 | blast007 | "The binary log contains “events” that describe database changes such as table creation operations or changes to table data." |
| 00:34.22 | blast007 | I just need to read more about it before I turn it on |
| 00:34.48 | QuantumWork | right |
| 00:35.00 | QuantumWork | database features are a bazooka to the face unless proven otherwise |
| 00:43.08 | blast007 | that, and I might switch back to a plain MySQL instead of using MariaDB |
| 01:17.10 | *** join/#bzflag kierra (~Jolie@unaffiliated/kierra) |
| 01:21.36 | kierra | blast007: |
| 01:24.16 | *** join/#bzflag GvzEvxre (~timr@bzflag/projectlead/TimRiker) |
| 01:24.16 | *** mode/#bzflag [+o GvzEvxre] by ChanServ |
| 01:34.05 | *** join/#bzflag rathis (~rathis@5e09e8ba.bb.sky.com) |
| 02:41.35 | *** join/#bzflag rathis (~rathis@5e09e8ba.bb.sky.com) |
| 03:16.23 | allejo | blast007: what happened to the forums? what has been the issue with it lately? |
| 03:31.52 | *** join/#bzflag JeffM (~Jeff@unaffiliated/jeffm2501) |
| 03:31.53 | *** mode/#bzflag [+v JeffM] by ChanServ |
| 03:43.45 | blast007 | allejo: lately? |
| 03:44.20 | blast007 | there's been no issue with it "lately" that I'm aware of |
| 03:44.38 | blast007 | the issue was a database wackyness in the last 30 hours |
| 03:44.43 | allejo | well a few days ago i remember you said that a category disappeared. and now you had to restore to another db |
| 03:44.56 | blast007 | that wasn't a few days ago, that was about 30 hours ago :) |
| 03:45.19 | allejo | ohhhhhh ok. this week has been killing me. i've lost all track of time |
| 03:45.43 | blast007 | that's the only issue that's occured |
| 03:46.45 | allejo | and the user db? |
| 04:50.23 | *** join/#bzflag ts3d (~anonymous@adsl-76-215-146-141.dsl.mtry01.sbcglobal.net) |
| 05:23.10 | Constitution | hmmm... SQL ERROR [ mysqli ] Too many connections [1040] |
| 05:23.44 | ts3d | Same for me |
| 05:25.51 | allejo | :o |
| 05:27.25 | ts3d | I believe the list server is down as a result |
| 05:27.41 | ts3d | Global authentication didn't work for me. I had pass right. |
| 05:28.10 | ts3d | MOTD in game down aswell |
| 05:36.15 | *** join/#bzflag [dmp] (~dennis@unaffiliated/dmp/x-546784) |
| 05:37.41 | *** join/#bzflag Cobra_Fast (~coprah@wtwrp.de) |
| 05:37.42 | *** join/#bzflag Nitroxis (~nitroxis@wtwrp.de) |
| 05:48.08 | *** join/#bzflag ts3d (~anonymous@76.215.146.141) |
| 05:59.55 | ts3d | main site is down now aswell.. |
| 06:00.04 | BulletCatcher | I'm working on it. |
| 06:01.22 | ts3d | Ok |
| 06:03.54 | BulletCatcher | The root file system is full. sigh |
| 06:04.03 | ts3d | ouch |
| 06:10.23 | BulletCatcher | The server list is back and should be back up to full size within about 1/2 hour. |
| 06:10.28 | *** join/#bzflag Gabe_G23 (u557@bzflag/player/GabrielG) |
| 06:11.02 | BulletCatcher | Global auth works, too. |
| 06:11.47 | ts3d | I'll relay message onto server i'm on |
| 06:18.23 | ts3d | So what's the future of bz? |
| 06:26.56 | BulletCatcher | Difficult to predict the future is. </yoda> |
| 06:28.46 | BulletCatcher | The developers aren't doing anything at this time, but we are still committed to keeping the list server, forum, etc. running for everyone to use. |
| 06:30.23 | ts3d | I'd like to help. I'm a newbie at coding. |
| 06:30.53 | ts3d | I don't know how I would be helpful though.. |
| 06:31.53 | BulletCatcher | The BZFlag code base is not easy to learn, unfortunately. |
| 06:32.36 | BulletCatcher | If you want to take a look at it, the best way to start is to download the source and learn to compile it. |
| 06:32.43 | ts3d | I've been going through it |
| 06:33.48 | ts3d | I'm reading the lastest OpenGL super bible. I was thinking about moving everything to shaders. |
| 06:34.23 | ts3d | I don't understand the octtree and related classes. |
| 06:39.12 | BulletCatcher | I can't help much there, having never studied rendering enough to have a useful understanding of shaders, octtrees, etc. |
| 06:46.04 | *** join/#bzflag ts3d (~anonymous@adsl-76-215-146-141.dsl.mtry01.sbcglobal.net) |
| 06:46.15 | ts3d | My patch was closed for the wrong reason. It's the lastest one on the tracker. |
| 06:46.47 | ts3d | Could you look at it. |
| 06:48.36 | BulletCatcher | The one from user ab8? |
| 06:48.56 | ts3d | yes |
| 06:49.14 | ts3d | The problem was not acutally fixed in r22205 |
| 06:50.00 | ts3d | I was going to comment on it but could not figure out how to on a closed one. |
| 06:51.59 | BulletCatcher | .size() returning zero is not the same as .empty() ? |
| 06:52.16 | BulletCatcher | Or is the r22205 simply not complete? |
| 06:54.46 | ts3d | the problem is that an empty string is indexed with [0]. |
| 06:57.25 | ts3d | in the stricter vs2010 it produces an exception |
| 06:58.23 | BulletCatcher | The first change in your submitted patch seems unnecessary because the while tests for src.length() != 0. |
| 06:59.21 | BulletCatcher | Is that exception at runtime or compile time? |
| 07:01.03 | ts3d | runtime if i remember correctly |
| 07:03.56 | BulletCatcher | I reopened SF patch 3431556. |
| 07:03.57 | BulletCatcher | Go ahead and submit a new patch that fixes the problem for you. |
| 07:04.08 | ts3d | if you change src.at(0); it will produce the exception under vs2008 ( again if i remember correctly) |
| 07:04.28 | ts3d | That patch fixes it |
| 07:09.00 | ts3d | I'm double checking |
| 07:10.51 | BulletCatcher | Okay, I can see that the while() loops are still vulnerable to the problem. |
| 07:12.15 | ts3d | src is made empty by the substr above it i believe |
| 07:13.53 | BulletCatcher | Yeah. I'm going to reorder the loop operations. |
| 07:15.53 | *** join/#bzflag AAA_awright (~a3@ip24-251-159-93.ph.ph.cox.net) |
| 07:16.28 | *** join/#bzflag ts3d (~anonymous@adsl-76-215-146-141.dsl.mtry01.sbcglobal.net) |
| 07:16.42 | ts3d | my connections flaky. might miss something |
| 07:19.33 | ts3d | Jeff said it should have been done "the c way". |
| 07:20.54 | BulletCatcher | I am tempted to rewrite the whole function. |
| 07:25.01 | BulletCatcher | But I won't. |
| 07:26.32 | ts3d | hehe |
| 07:27.39 | ts3d | Gah. vs isn't running the post build event |
| 07:31.21 | ts3d | http://i.imgur.com/ZWBgH.png |
| 07:31.25 | ts3d | comfirmation |
| 07:39.02 | CIA-109 | BZFlag: 03bullet_catcher * r22231 10/trunk/bzflag/src/common/StateDatabase.cxx: |
| 07:39.02 | CIA-109 | BZFlag: Do not attempt to dereference the first character in an empty standard string. |
| 07:39.02 | CIA-109 | BZFlag: Thanks to ab8 for SF patch #3431556. |
| 07:39.09 | BulletCatcher | Give that a try. |
| 07:43.19 | ts3d | That should do it. |
| 07:43.34 | ts3d | Although there's an extra check in there. The first one. |
| 07:43.57 | ts3d | nvm. |
| 07:47.11 | BulletCatcher | It is sleep time for me. Thanks for providing that bugfix. |
| 07:47.19 | ts3d | Np, good night. |
| 07:49.05 | *** join/#bzflag Marzipan (~Marzipan@bzflag/player/Marzipan) |
| 11:10.03 | *** join/#bzflag JeffM (~Jeff@unaffiliated/jeffm2501) |
| 11:10.03 | *** mode/#bzflag [+v JeffM] by ChanServ |
| 12:32.48 | *** join/#bzflag dcat (~dcat@c-98-249-63-154.hsd1.va.comcast.net) |
| 12:52.17 | *** join/#bzflag JeffM (~Jeff@unaffiliated/jeffm2501) |
| 12:52.17 | *** mode/#bzflag [+v JeffM] by ChanServ |
| 12:59.43 | *** join/#bzflag sigonasr2 (~sigonasr2@ip68-0-162-35.tc.ph.cox.net) |
| 13:37.27 | *** part/#bzflag sigonasr2 (~sigonasr2@ip68-0-162-35.tc.ph.cox.net) |
| 13:45.32 | blast007 | JeffM: the drive on the VPS filled up last night - could be why the database had decided to eat itself the other day, too :) |
| 13:45.49 | blast007 | pondering upgrading to the next level of VPS |
| 13:46.01 | blast007 | double the space (30GB) and double the RAM (1GB) |
| 14:22.52 | *** join/#bzflag Pimpinella (~frank@gondolin.pimpi.org) |
| 14:54.15 | *** join/#bzflag Qw3rty (45dda4db@gateway/web/freenode/ip.69.221.164.219) |
| 14:54.51 | Qw3rty | hello? |
| 14:59.23 | blast007 | goodbye? |
| 15:02.29 | kierra | lol |
| 15:04.58 | blast007 | these darn kids think it means Instant Reply Chat |
| 15:06.55 | short_circuit | indeed |
| 15:12.35 | blast007 | should have a bot in here that greets people when they say "hello?" with "HELP, I'M TRAPPED IN A TANK FACTORY!" |
| 15:15.18 | BulletCatcher | blast007: Before buying more disk space, change the log file rotation from weekly to daily in /etc/logrotate.d/apache2 . |
| 15:15.34 | BulletCatcher | Compressing the logs sooner will free lots of space. |
| 15:19.58 | blast007 | switching back to MySQL might save some log space too (or at least to the mysql client libs) |
| 15:20.35 | blast007 | currently every request to the web server throws a warning about a mismatched mysql library :) |
| 15:21.29 | blast007 | however, even with the logs trimmed, we're still rather close on space |
| 15:21.37 | blast007 | I'd rather have a bit more of a buffer |
| 15:22.13 | blast007 | the most I think I can free up is a gig or two |
| 15:24.02 | BulletCatcher | Deleting old logs (perhaps after copying them to a place where storage is cheaper) would help, too. |
| 15:24.38 | blast007 | 1.5GB free right now |
| 15:26.00 | blast007 | ah, and maybe I did end up turning on the binary log in MariaDB |
| 15:26.02 | *** join/#bzflag meeba (~lamer@c-98-245-150-35.hsd1.co.comcast.net) |
| 15:26.27 | blast007 | guess I'll have to figure out how to utilize that later for data restoration |
| 15:29.56 | CIA-109 | BZFlag: 03blast007 * r22232 10/trunk/web/mainsite/document.php: Get rid of the persistent MySQL connection code. |
| 15:30.44 | blast007 | this is the one I want to get rid of: |
| 15:30.45 | blast007 | PHP Warning: mysql_connect(): Headers and client library minor version mismatch. Headers:50141 Library:50302 |
| 15:42.48 | CIA-109 | BZFlag: 03blast007 * r22233 10/trunk/web/bzfls/bzfls.php: |
| 15:42.48 | CIA-109 | BZFlag: Get rid of the persistent MySQL connection code. |
| 15:42.48 | CIA-109 | BZFlag: Quell a warning by properly using define. |
| 15:47.00 | CIA-109 | BZFlag: 03blast007 * r22234 10/trunk/web/bzfls/bzfls.php: Quick fix to quell some more warnings about undefined indexes. Should properly fix this later by checking if the input array key actually exists. |
| 16:15.52 | *** join/#bzflag TimRiker (~TimRiker@bzflag/projectlead/TimRiker) |
| 16:15.52 | *** mode/#bzflag [+o TimRiker] by ChanServ |
| 16:52.42 | blast007 | ah, that error might only occur if we use mysql_connect |
| 16:58.28 | *** join/#bzflag JeffM_ (~JeffM@adsl-75-16-90-217.dsl.irvnca.sbcglobal.net) |
| 17:05.32 | *** join/#bzflag spldart_droid (~spldart@bzflag/contributor/spldart) |
| 17:05.32 | *** mode/#bzflag [+v spldart_droid] by ChanServ |
| 17:12.06 | *** join/#bzflag zuii (~zuii@catv3EC94215.pool.t-online.hu) |
| 17:18.17 | blast007 | I'll have to try switching something from the mysql extention to mysqli or PDO and see if that warning goes away |
| 17:25.57 | blast007 | hmm, almost 6 million lines in the m.b.o error log in a week ;) 1.2 million were the MySQL lib/header mismatch warning. |
| 17:51.42 | *** join/#bzflag Thumper_ (~Thumper@CPE000102d0fe75-CM0012256ecbde.cpe.net.cable.rogers.com) |
| 17:51.49 | *** join/#bzflag Thumper_ (~Thumper@about/essy/coffeeAddict/Thumper) |
| 17:51.49 | *** mode/#bzflag [+v Thumper_] by ChanServ |
| 18:21.08 | *** join/#bzflag nielsle (~nielsle@3239059-cl69.boa.fiberby.dk) |
| 18:22.57 | *** join/#bzflag Tuxist64bit (~quassel@dyndsl-091-096-121-126.ewe-ip-backbone.de) |
| 18:28.53 | *** join/#bzflag spldart (~spldart2@c-98-201-137-215.hsd1.tx.comcast.net) |
| 18:28.53 | *** join/#bzflag spldart (~spldart2@bzflag/contributor/spldart) |
| 18:28.53 | *** mode/#bzflag [+v spldart] by ChanServ |
| 19:14.20 | *** join/#bzflag spldart_droid (~spldart@bzflag/contributor/spldart) |
| 19:14.20 | *** mode/#bzflag [+v spldart_droid] by ChanServ |
| 19:57.24 | *** join/#bzflag TimRiker (~TimRiker@bzflag/projectlead/TimRiker) |
| 19:57.24 | *** mode/#bzflag [+o TimRiker] by ChanServ |
| 20:09.25 | *** join/#bzflag TimRiker (~TimRiker@bzflag/projectlead/TimRiker) |
| 20:09.26 | *** mode/#bzflag [+o TimRiker] by ChanServ |
| 20:15.22 | *** join/#bzflag spldart_droid (~spldart@bzflag/contributor/spldart) |
| 20:15.22 | *** mode/#bzflag [+v spldart_droid] by ChanServ |
| 20:48.47 | blast007 | wee, packet loss to the VPS now :) |
| 20:51.10 | blast007 | seems nobody uses the JSON list format. good. :) |
| 20:51.29 | blast007 | makes plans |
| 21:08.24 | *** join/#bzflag TimRiker (~TimRiker@bzflag/projectlead/TimRiker) |
| 21:08.24 | *** mode/#bzflag [+o TimRiker] by ChanServ |
| 21:45.15 | *** join/#bzflag mdskpr_ (~mdskpr@108.25.131.122) |
| 22:05.42 | *** join/#bzflag TimRiker (~TimRiker@bzflag/projectlead/TimRiker) |
| 22:05.43 | *** mode/#bzflag [+o TimRiker] by ChanServ |
| 22:32.44 | *** join/#bzflag KTL (~KTL@213.219.166.97.adsl.dyn.edpnet.net) |
| 23:11.30 | *** join/#bzflag TimRiker (~TimRiker@bzflag/projectlead/TimRiker) |
| 23:11.31 | *** mode/#bzflag [+o TimRiker] by ChanServ |
| 23:37.08 | brad | [passing a message on] could a lovely admin check the textures waiting approval on images.bzflag.org? |
