Timestamps are in GMT/BST.
| 00:58:12 | | raptor Quit () |
| 01:35:34 | | koda has joined |
| 02:04:08 | | LordDVG has joined |
| 02:07:01 | | Flynnn Quit (Quit: This computer has gone to sleep) |
| 02:29:38 | | Nothing_Much Quit (*.net *.split) |
| 02:31:12 | | Nothing_Much has joined |
| 02:31:12 | | Nothing_Much Quit (Changing host) |
| 02:31:12 | | Nothing_Much has joined |
| 03:05:55 | | Nothing_Much Quit (*.net *.split) |
| 03:05:55 | | koda Quit (*.net *.split) |
| 03:06:48 | | Nothing_Much has joined |
| 03:06:48 | | koda has joined |
| 03:23:56 | | Nothing_Much Quit (*.net *.split) |
| 03:23:56 | | koda Quit (*.net *.split) |
| 03:25:26 | | LordDVG Quit (Read error: Connection reset by peer) |
| 03:28:38 | | koda has joined |
| 03:30:51 | | Nothing_Much has joined |
| 03:30:54 | | Nothing_Much Quit (Changing host) |
| 03:30:54 | | Nothing_Much has joined |
| 03:48:32 | | koda Quit (Remote host closed the connection) |
| 03:49:29 | | koda has joined |
| 03:56:47 | | LordDVG has joined |
| 04:00:52 | | LordDVG Quit (Remote host closed the connection) |
| 04:49:15 | | koda Quit (Quit: koda) |
| 05:27:39 | | Watusimoto has joined |
| 07:12:09 | | koda has joined |
| 07:31:19 | | Skybax has joined |
| 07:31:19 | | Skybax Quit (Client Quit) |
| 07:37:52 | | Watusimoto Quit (Ping timeout: 252 seconds) |
| 09:01:24 | | raptor has joined |
| 09:01:24 | | ChanServ sets mode +o |
| 10:04:34 | | thread_ has joined |
| 10:04:55 | thread_ | Sorry I missed that party. How'd it go? |
| 10:05:04 | raptor | Hi |
| 10:05:15 | raptor | It was OK, only about 5 or 6 of us most of the time |
| 10:05:28 | thread_ | I see |
| 10:06:28 | thread_ | hey question: in the Lua documentation there are some ScoringEvents. How are those supposed to be used? |
| 10:07:00 | raptor | hmm... i'm not exactly sure. let me look |
| 10:07:11 | thread_ | Also, It's missing an event for a soccer goal |
| 10:09:34 | raptor | i'm not even sure it's used... |
| 10:09:42 | raptor | looks quite unfinished.. |
| 10:09:57 | thread_ | hmmmmkay |
| 10:10:42 | thread_ | In that case, it is possible to get the teams' scores somehow? |
| 10:10:53 | raptor | yes, let me get you a snippet... |
| 10:12:22 | raptor | here's copypasta from a levelgen: http://pastie.org/pastes/8158909/text |
| 10:12:26 | raptor | have to go, back soon... |
| 10:12:33 | thread_ | thanks cya |
| 10:13:54 | | bobdaduck has joined |
| 10:14:21 | bobdaduck | Sup, fresh dudes? |
| 10:14:31 | bobdaduck | Hows my homeslices doin' up in here. |
| 10:14:59 | thread_ | IT'S THE UGLY DUCK!!!!! Wait no, it's just bob |
| 10:21:58 | thread_ | Hi bob |
| 10:47:28 | bobdaduck | sup |
| 11:00:52 | | Nothing_Much Quit (Quit: l8r) |
| 11:01:05 | | Nothing_Much has joined |
| 11:01:06 | | Nothing_Much Quit (Changing host) |
| 11:01:06 | | Nothing_Much has joined |
| 11:04:42 | raptor | hello again |
| 11:10:09 | thread_ | hey raptor, was that code snippet you sent me for bots or levelgen? |
| 11:10:15 | raptor | levelgen |
| 11:10:26 | raptor | but TeamInfo() should work for both |
| 11:10:40 | thread_ | ok, I just didn't see a subscribe to tick and was wondering |
| 11:10:42 | raptor | yeah, actually, that should with both |
| 11:10:47 | raptor | oh really? |
| 11:10:48 | raptor | oops |
| 11:10:50 | raptor | i left that out |
| 11:10:55 | thread_ | lol ok |
| 11:11:00 | raptor | yeah, the subscribe is needed for levelgen... |
| 11:16:19 | raptor | FYI thread_: https://code.google.com/p/bitfighter/source/detail?r=638ae7405a6e |
| 11:16:31 | raptor | 019 will have an onScoreChanged event |
| 11:17:43 | raptor | would this address your issue of usage? |
| 11:19:21 | raptor | back later! |
| 11:19:23 | | raptor Quit () |
| 11:22:24 | | Nothing_Much Quit (Ping timeout: 248 seconds) |
| 11:24:17 | | Nothing_Much has joined |
| 11:24:18 | | Nothing_Much Quit (Changing host) |
| 11:24:18 | | Nothing_Much has joined |
| 11:26:19 | | thread_ Quit (Ping timeout: 250 seconds) |
| 11:51:03 | | Watusimoto has joined |
| 12:02:08 | | BFLogBot Commit: 6b9085734454 | Author: watusimoto | Message: Additional messages for soccer scoring |
| 12:02:09 | | BFLogBot Commit: 7f3aa8948967 | Author: watusimoto | Message: Fix tests |
| 12:02:11 | | BFLogBot Commit: 0a88ccd1c6e6 | Author: watusimoto | Message: Whitespace |
| 12:02:12 | | BFLogBot Commit: 1207483fdb7a | Author: watusimoto | Message: Fix compile problem... tsk tsk |
| 12:02:14 | | BFLogBot Commit: efa1a4616591 | Author: watusimoto | Message: Pass games played count from master down to clients... compiles but untested |
| 12:04:33 | | raptor has joined |
| 12:04:34 | | ChanServ sets mode +o |
| 12:05:16 | | Flynnn has joined |
| 12:45:19 | Watusimoto | hi raptor |
| 12:45:28 | raptor | bwahahaha |
| 12:45:30 | Watusimoto | I tried upgrading the master server... did not go well |
| 12:45:38 | Watusimoto | original has been restored |
| 12:45:39 | raptor | (reading level reviews) |
| 12:45:51 | Watusimoto | oh, good idea! |
| 12:46:49 | raptor | a few people should get the criitized-by-Quartz badge again... |
| 12:49:55 | Watusimoto | :-) |
| 12:50:10 | Watusimoto | btw, saw bobdaduck's thread on the raptor functions |
| 12:50:24 | Watusimoto | did you know we have a geometry library that does translation, rotation, and scaling? |
| 12:51:10 | raptor | i actually didn't until about 2 weeks ago... |
| 12:51:27 | raptor | that would have been nice... |
| 12:52:33 | Watusimoto | how was the party? |
| 12:57:09 | raptor | we had 4 -6 people! |
| 12:57:17 | raptor | what did your kids think? |
| 13:00:50 | Watusimoto | they thought it was fun, but were surprised how few people were there |
| 13:01:22 | Watusimoto | quartz has interesting reviews... he doesn't hold back! |
| 13:04:39 | Watusimoto | though I kind of have to agree with his 0/10 rating |
| 13:09:31 | | Flynnn Quit (Quit: This computer has gone to sleep) |
| 13:09:56 | | Flynnn has joined |
| 13:12:01 | raptor | heh |
| 13:17:32 | Watusimoto | so we have disucssion, then do voting sometime soon? |
| 13:17:51 | raptor | traditionally voting was started on the monday after the hangover |
| 13:17:57 | Watusimoto | ok, great |
| 13:18:04 | raptor | but i don't mind changing tradition |
| 13:18:17 | Watusimoto | also... is there supposed to me a motd other than "welcome to bitfighter"? I am nervous I broke something |
| 13:18:26 | raptor | in fact, about the contest party, I think we need to change something about it to get people to play more.. |
| 13:18:36 | Watusimoto | what do you mean? |
| 13:18:38 | raptor | augh! |
| 13:18:43 | raptor | i forgot the MOTD for the party |
| 13:18:52 | raptor | what i mean |
| 13:18:52 | Watusimoto | as did I; and I forgot to send out email |
| 13:19:00 | Watusimoto | so we both messed up |
| 13:19:28 | Watusimoto | we need a checklist |
| 13:19:30 | raptor | traditionally we open the contest server up on friday morning or so, let people poke around, then play semi-unorganized at the party |
| 13:19:43 | raptor | maybe the party should be the unveiling? |
| 13:19:50 | raptor | to get more people to play, etc.. |
| 13:20:02 | Watusimoto | do you think anyone didn't come to the party because of the early unveiling? |
| 13:20:08 | | LordDVG has joined |
| 13:20:10 | raptor | i think so yes |
| 13:20:14 | Watusimoto | playing in the group is the real treat, no? |
| 13:20:23 | raptor | I would think so |
| 13:20:30 | raptor | but I'm not sure... |
| 13:20:43 | raptor | I'm not a good judge of this |
| 13:20:46 | Watusimoto | well sure, it kind of makes sense to do the unveiling at the party |
| 13:20:55 | Watusimoto | so let's do that next time |
| 13:21:02 | Watusimoto | it will heigten the anticipation during the event |
| 13:21:05 | raptor | I want to do what's *best*, whatever that may be... |
| 13:21:25 | Watusimoto | so yes, I'm on board with that change |
| 13:21:30 | raptor | ok |
| 13:21:38 | raptor | let me start a contest checklist... |
| 13:21:43 | Watusimoto | put the server up in the morning with a password for testing amongst a select few |
| 13:21:54 | Watusimoto | the disable the pw at party time |
| 13:21:59 | raptor | yes, good idea |
| 13:22:09 | raptor | !contest |
| 13:22:33 | Watusimoto | as for what's best in these situations... well... we're both engineers, so we shouldn't be deciding :-) |
| 13:23:05 | Watusimoto | btw, I really like the review template idea |
| 13:23:22 | Watusimoto | makes things look all neat and clean |
| 13:23:36 | | Flynnn Quit (Quit: Leaving) |
| 13:25:56 | Watusimoto | it doesn't matter from which folder I start the master, does it? |
| 13:26:06 | Watusimoto | (i.e. if I'm in the master folder itself, or somewhere else) |
| 13:28:49 | raptor | not if you use my start script |
| 13:28:59 | raptor | but if you call the binary directly, it does |
| 13:29:02 | raptor | !contest |
| 13:29:05 | BFLogBot | See the contest checklist here: http://bitfighter.org/wiki/index.php/Contest_checklist |
| 13:30:49 | raptor | ok that contest checklist is up |
| 13:30:51 | | bobdaduck Quit (Remote host closed the connection) |
| 13:30:54 | raptor | very rudimentary |
| 13:30:58 | raptor | feel free to add to it.. |
| 13:31:28 | Watusimoto | ok, I'll use the script |
| 13:31:37 | raptor | :) |
| 13:31:43 | Watusimoto | but there is a problem with the script |
| 13:32:03 | raptor | you need to be the 'master' user |
| 13:32:06 | Watusimoto | it won't affect me at the moment... |
| 13:32:08 | Watusimoto | yes |
| 13:32:35 | Watusimoto | good grief |
| 13:32:40 | raptor | hehe |
| 13:32:44 | Watusimoto | now i'm totally lost |
| 13:32:57 | Watusimoto | in update_recompile_restart_master.sh |
| 13:33:03 | raptor | aach |
| 13:33:09 | raptor | ok |
| 13:33:09 | Watusimoto | we have these lines |
| 13:33:10 | Watusimoto | if [ $? -ne 0 ]; then |
| 13:33:10 | Watusimoto | echo "==> Compile error. FIX YOUR CODE. Old master binary is still left," |
| 13:33:10 | Watusimoto | echo " you should restart it in the mean time" |
| 13:33:10 | Watusimoto | fi |
| 13:33:22 | Watusimoto | so you compile, and hit a compile error |
| 13:33:32 | Watusimoto | then it just continues on |
| 13:33:43 | Watusimoto | should it not stop at this point? |
| 13:33:50 | raptor | I can make it do that... |
| 13:34:04 | Watusimoto | how do you stop a script? exit? |
| 13:34:12 | raptor | ok |
| 13:34:15 | raptor | udpated |
| 13:34:25 | Watusimoto | ok, another problem |
| 13:34:36 | Watusimoto | popd # Restore the galactic balance |
| 13:34:46 | Watusimoto | doesn't work |
| 13:34:53 | Watusimoto | there are more pushds that popds |
| 13:35:06 | Watusimoto | things have taken a slight turn for the worse since i ran that script |
| 13:35:35 | Watusimoto | 3 pushds and one popd |
| 13:35:37 | raptor | have you been editing it? |
| 13:35:39 | Watusimoto | no |
| 13:35:43 | Watusimoto | I've changed nothing |
| 13:36:00 | Watusimoto | but I could remove the two inner pushds and change them to cds |
| 13:36:02 | raptor | uhh... it looks like people have removed my popds?? |
| 13:36:06 | raptor | no no |
| 13:36:09 | Watusimoto | well, I have not |
| 13:37:07 | Watusimoto | but... my proposed fix would work! |
| 13:37:32 | Watusimoto | ah, exit 1 |
| 13:37:34 | Watusimoto | good call |
| 13:37:50 | raptor | ok, you may fix the script as I've been pulled away temporarily... |
| 13:37:54 | raptor | (sorry0 |
| 13:38:39 | Watusimoto | no worries |
| 13:42:38 | Watusimoto | I'm seeing this pop up in the logfile |
| 13:42:39 | Watusimoto | !Failure writing stats to database: Unknown column 'turret_kills' in 'field list' |
| 13:42:46 | Watusimoto | xxx !Failure writing stats to database: Unknown column 'turret_kills' in 'field list' |
| 13:43:10 | raptor | that might be from kaen's php script? |
| 13:43:15 | raptor | for the stats |
| 13:43:16 | Watusimoto | seems to come from here insertStatsPlayer( |
| 13:43:34 | Watusimoto | which inserts into stats_player |
| 13:43:38 | raptor | might it be from an old client running on old schema? |
| 13:43:45 | Watusimoto | but that column exists in stats_player |
| 13:43:56 | Watusimoto | the error is on the master |
| 13:46:07 | Watusimoto | odd... it first appeared in the log in June |
| 13:46:21 | raptor | huh |
| 13:46:22 | Watusimoto | but stats are still being written to that table |
| 13:46:35 | Watusimoto | ah |
| 13:46:46 | Watusimoto | always seems to happen after a server disconnect line is logged |
| 13:47:25 | Watusimoto | so what happens when the server disconnects? who is writing stats to the logfile at that point? |
| 13:47:40 | Watusimoto | could it be trying to log to a sqlite table or something that is not up to date? |
| 13:48:47 | raptor | oh - yeah, sqlite could be the problem |
| 13:49:11 | Watusimoto | but are we sending stats to sqlite on the master in addition to mysql? |
| 13:49:27 | raptor | what log are you looking at? |
| 13:49:34 | raptor | _master.log? |
| 13:49:57 | raptor | on the master, no |
| 13:50:03 | raptor | only mysql |
| 13:50:18 | raptor | but sqlite might be built in... |
| 13:50:29 | raptor | back in a bit... |
| 13:50:55 | Watusimoto | I know you're not here, will keep typing notes as I find stuff |
| 13:54:23 | Watusimoto | I'm trying to figure out where the sqlite database might reside, if it in fact exists |
| 13:54:53 | Watusimoto | aha |
| 13:54:56 | Watusimoto | /home/master/bitfighter/exe/stats.db |
| 13:54:59 | Watusimoto | looks promising |
| 13:56:38 | raptor | whack it |
| 13:56:41 | Watusimoto | ok |
| 13:56:45 | Watusimoto | whack it? |
| 13:56:50 | Watusimoto | just delete the file? |
| 13:56:53 | raptor | yes |
| 13:56:58 | Watusimoto | is it just there as backup? |
| 13:57:02 | raptor | no |
| 13:57:08 | raptor | completely unneeded |
| 13:57:12 | Watusimoto | ok |
| 13:57:22 | Watusimoto | hopefully that is where those error msgs are cmoing from |
| 13:57:25 | Watusimoto | they make me nervous |
| 13:57:30 | raptor | but if it's being written to, then that is odd... |
| 13:57:41 | raptor | then both database types are being written to.. |
| 13:57:59 | Watusimoto | well... one is not :-) |
| 13:58:20 | Watusimoto | I moved the file to /tmp for the moment, in case you change your mind in the next few minutes :-) |
| 13:58:25 | raptor | heh |
| 13:58:29 | raptor | ok, let me play a game... |
| 13:58:31 | Watusimoto | I should probably restart the master, no? |
| 13:58:40 | raptor | nahhh |
| 13:58:43 | Watusimoto | oook! |
| 13:58:46 | Watusimoto | ok! |
| 13:58:48 | raptor | let me play a game.. 10 seconds to database write |
| 13:58:50 | Watusimoto | but you should host |
| 13:59:03 | raptor | done |
| 13:59:06 | raptor | anything? |
| 13:59:10 | Watusimoto | CLIENT_INFO 2013-07-20 Sat 13:58:00 6 6800 IP:69.169.172.147:34963 <None> |
| 13:59:10 | Watusimoto | Authenticated user raptor |
| 13:59:10 | Watusimoto | Failure writing stats to database: Unknown column 'turret_kills' in 'field list' |
| 13:59:17 | raptor | booo |
| 13:59:38 | Watusimoto | [master@bitfighter ~]$ ls /home/master/bitfighter/exe/stats.db |
| 13:59:38 | Watusimoto | ls: cannot access /home/master/bitfighter/exe/stats.db: No such file or directory |
| 13:59:38 | Watusimoto | [master@bitfighter ~]$ Failure writing stats to database: Unknown column 'turret_kills' in 'field list' |
| 13:59:46 | Watusimoto | so the stats.db is not back |
| 13:59:53 | Watusimoto | but the error is still coming up |
| 14:00:10 | raptor | so we know it comes from 018a.. |
| 14:00:21 | Watusimoto | let me restart the master and see if it fixes it |
| 14:00:28 | raptor | ok |
| 14:00:29 | Watusimoto | because it could be caching sqlite stuff in memory |
| 14:00:31 | Watusimoto | maybe |
| 14:00:48 | Watusimoto | restarted |
| 14:00:55 | raptor | ok |
| 14:00:57 | Watusimoto | try again? |
| 14:01:01 | raptor | ok |
| 14:01:08 | raptor | 6 seconds |
| 14:01:33 | raptor | hmmm.... not connected to master |
| 14:01:34 | Watusimoto | SERVER_CONNECT 2013-07-20 Sat 14:01:16 The Little_Apple Tree With hand picked levels! |
| 14:01:34 | Watusimoto | SERVER_INFO 2013-07-20 Sat 14:01:16 6 6800 IP:76.116.249.209:28000 <None> |
| 14:01:34 | Watusimoto | SERVER_CONNECT 2013-07-20 Sat 14:01:21 ZenerNet Private gaming network. DO NOT JOIN!! |
| 14:01:34 | Watusimoto | SERVER_INFO 2013-07-20 Sat 14:01:21 6 6800 IP:69.36.210.56:28000 <None> |
| 14:01:35 | Watusimoto | CLIENT_CONNECT 2013-07-20 Sat 14:01:22 BlackCat |
| 14:01:38 | Watusimoto | CLIENT_INFO 2013-07-20 Sat 14:01:22 6 6800 IP:69.36.210.56:60498 <None> |
| 14:01:44 | Watusimoto | no error messages |
| 14:01:53 | raptor | 3 secs |
| 14:02:00 | raptor | now? |
| 14:02:05 | Watusimoto | Authenticated user raptor |
| 14:02:05 | Watusimoto | Failure writing stats to database: Unknown column 'turret_kills' in 'field list' |
| 14:02:06 | Watusimoto | dang |
| 14:02:39 | Watusimoto | stats.db was not recreated |
| 14:02:45 | raptor | interesing... when master restarts, the hosted dedicated servers are detected as adress 127.0.0.1... |
| 14:02:51 | raptor | ok, so not sqlite.. |
| 14:03:23 | Watusimoto | agreed |
| 14:03:23 | raptor | so 018a is sending turretKills |
| 14:03:29 | Watusimoto | find |grep *.db |
| 14:03:29 | Watusimoto | returns nothing |
| 14:03:46 | Watusimoto | the master should be writing turret kills |
| 14:03:57 | Watusimoto | let me check the daabase and see if that column is ever populated |
| 14:04:05 | Watusimoto | it is |
| 14:04:16 | Watusimoto | so turret kills are being logged properly |
| 14:04:24 | Watusimoto | and yet... the message still appears |
| 14:05:47 | raptor | did BFLogBot miss some commits?? |
| 14:05:48 | BFLogBot | The only skills I have patience to learn are those that have no real application in life. -- Calvin |
| 14:06:15 | raptor | oh no, i see them in the logs (i wasn't connected) |
| 14:06:40 | Watusimoto | you can't run with my latest code without the master being updated |
| 14:07:07 | Watusimoto | that message has to be coming from insertStatsPlayer() |
| 14:07:08 | raptor | bah |
| 14:07:09 | raptor | ok |
| 14:07:28 | Watusimoto | and insertStatsPlayer() has to be working (or else we'd see no stats in the mysql) |
| 14:07:43 | raptor | maybe the error is something other than we think |
| 14:07:43 | Watusimoto | so the only way it can be both broken and working is if it is called twice |
| 14:07:51 | Watusimoto | impossible! |
| 14:07:58 | raptor | :) |
| 14:09:35 | Watusimoto | and... it doesn't look like it's being called twice |
| 14:09:45 | raptor | http://stackoverflow.com/questions/1346209/unknown-column-in-field-list-error-on-mysql-update-query |
| 14:11:37 | Watusimoto | unless there are two DatabaseWriter instances |
| 14:11:44 | Watusimoto | looking at so... |
| 14:12:27 | Watusimoto | I don't think that's our issue |
| 14:12:49 | Watusimoto | everything is using the same quoting |
| 14:12:57 | Watusimoto | and... remember... we know it works |
| 14:13:05 | raptor | yeah... |
| 14:13:06 | raptor | so... |
| 14:13:09 | raptor | system update! |
| 14:13:30 | raptor | man, the system is so much more responsive now that BFLogBot is in python... |
| 14:13:30 | BFLogBot | If we wanted more leisure, we'd invent machines that do things less efficiently. -- Calvin's dad |
| 14:13:31 | Watusimoto | oh |
| 14:13:33 | Watusimoto | I know |
| 14:13:36 | Watusimoto | maybe |
| 14:13:47 | Watusimoto | hmmmm |
| 14:13:50 | Watusimoto | maybe not |
| 14:13:54 | Watusimoto | no |
| 14:14:07 | Watusimoto | my thought was the message could be coming from the server, not the master |
| 14:14:30 | Watusimoto | because the server could also be logging stats locally |
| 14:14:38 | Watusimoto | using mysql |
| 14:14:53 | Watusimoto | but two strikes agasint that... 1) mesgs appear in the master log |
| 14:15:06 | Watusimoto | and 2) msgs appear when you are hosting your server |
| 14:16:43 | raptor | time for printfs! |
| 14:17:35 | | LordDVG Quit (Remote host closed the connection) |
| 14:17:37 | Watusimoto | further, it appears that sqlite is only used if gWriteStatsToMySql is false... and the name at least suggest that's a global, so it seems unlikely that we have two instances of the database, one of which is sqlite |
| 14:17:44 | Watusimoto | there's a problem with printfs |
| 14:18:12 | Watusimoto | we (I) don't knwo which version of the master is running, so I don't know how to update the code to match it |
| 14:18:25 | Watusimoto | the source on the master is now what I just checked in |
| 14:18:34 | Watusimoto | which doesn't work with the 018a clients |
| 14:18:45 | Watusimoto | (which is why I reverted to the previous binary) |
| 14:19:06 | Watusimoto | so we have the correct binary, but no source for it |
| 14:19:34 | Watusimoto | perhaps we can see when the last changes to the master were and guess what code was used to compile the current binary... |
| 14:20:13 | Watusimoto | gWriteStatsToMySql is indeed a global |
| 14:20:18 | Watusimoto | so it can only have one value |
| 14:21:11 | Watusimoto | so getDatabaseWriter() will always behave the same even if it is called twice and creates two different databaseWriter objects... they will both attempt to write to the same db |
| 14:21:23 | Watusimoto | which leads me to conclude that this is not a sqlite problem |
| 14:21:37 | Watusimoto | (which is what you probably concluded 20 mins ago) |
| 14:23:36 | Watusimoto | we seem to create and discard DatabaseWriters all over the place... but as I noted before, they should all be sqlite or none should be |
| 14:27:02 | Watusimoto | the Failure writing stats to database message is only printed in one place... let me look at that |
| 14:27:26 | Watusimoto | only gets printed if insertStatsGame throws |
| 14:28:25 | Watusimoto | could it be writing and yet still somehow throwing an error saying it couldn't write??? |
| 14:32:16 | | Nothing_Much Quit (Ping timeout: 248 seconds) |
| 14:32:55 | Watusimoto | any idea what the player_mv table is? |
| 14:36:40 | Watusimoto | ok, this might be a problem |
| 14:37:18 | Watusimoto | we have a record in stats_player, with a stats_player_id of 208824 (the largest value in the table) |
| 14:37:41 | Watusimoto | this player killed 12 and died 10 times, which suggests he shot |
| 14:37:58 | Watusimoto | in stats_player_shots |
| 14:38:29 | Watusimoto | the max stats_player_id is 108783 |
| 14:38:32 | Watusimoto | sorry |
| 14:38:41 | Watusimoto | 208783 |
| 14:39:47 | | Nothing_Much has joined |
| 14:39:47 | | Nothing_Much Quit (Changing host) |
| 14:39:47 | | Nothing_Much has joined |
| 14:39:56 | Watusimoto | I think those two numbers shuold match |
| 14:41:25 | Watusimoto | the reason this is interesting is because in insertStatsPlayer(), which, when it throws, displays the error we are seeing, it first runs the query that involves turretKills, then does the shots insertion |
| 14:41:32 | Watusimoto | if the first is throwing, the second will never happen |
| 14:41:59 | Watusimoto | though the only way I can rectify this with the error message we're seeing is if the first both throws and works, and the second is never run |
| 14:42:08 | Watusimoto | and... that doesn't make a lot of sense |
| 14:45:34 | Watusimoto | ok, last changs to master code seem to be by you on June 15. |
| 14:46:20 | Watusimoto | dang |
| 14:46:31 | Watusimoto | when I tried updating the master, I lost the time stamp on the binary |
| 14:46:39 | Watusimoto | but I recall it was late June |
| 14:47:00 | Watusimoto | which stands to reason that the master must have been built with source from version 7596 or so |
| 14:47:16 | Watusimoto | so let me try updating the source to that version, then I can start with the printfs |
| 14:47:28 | Watusimoto | so... how to do this |
| 14:48:51 | Watusimoto | hg revert -r 7596? |
| 14:50:14 | Watusimoto | no |
| 14:50:20 | Watusimoto | hg update 7596? |
| 14:50:25 | Watusimoto | probably |
| 14:51:03 | Watusimoto | and... cmake fails! |
| 14:53:22 | Watusimoto | maybe hg update? |
| 14:53:35 | kaen | try deleting the CMakeCache.txt file |
| 14:53:41 | kaen | in the build directory |
| 14:53:46 | Watusimoto | that helped |
| 14:53:49 | Watusimoto | oh hi |
| 14:53:53 | kaen | hello |
| 14:53:55 | Watusimoto | hg update seemed to fix things |
| 14:54:05 | Watusimoto | I reverted, but did not update |
| 14:54:12 | Watusimoto | which seems like a sad state of affairs |
| 14:54:21 | Watusimoto | have you read any of my monologue? |
| 14:54:27 | Watusimoto | weird stuff in the database |
| 14:54:28 | kaen | hmm. nope |
| 14:54:30 | kaen | looking... |
| 14:54:40 | Watusimoto | getting an error message that I can't fathom |
| 14:54:56 | Watusimoto | basically, I get a msg saying it can't write to the player-stats table |
| 14:55:02 | Watusimoto | yet... it is writing |
| 14:55:10 | Watusimoto | (the master being the "it" here) |
| 14:55:44 | Watusimoto | this is the error message we're getting: |
| 14:55:45 | Watusimoto | Failure writing stats to database: Unknown column 'turret_kills' in 'field list' |
| 14:55:57 | Watusimoto | the column is there, and is being populated |
| 14:56:14 | Watusimoto | so I am now at the hacking the master and inserting random printfs |
| 14:56:33 | kaen | gross |
| 14:58:31 | Watusimoto | indeed |
| 15:02:50 | kaen | hmm |
| 15:03:06 | kaen | so the error is thrown, but everything appears to work Watusimoto ? |
| 15:04:26 | kaen | if can try it now, I think I might have fixed it... |
| 15:05:16 | kaen | no turret_kills in my player_mv table, which is written to on insertion to stats_player via a trigger |
| 15:05:28 | kaen | checking now if the trigger tries to use that table... |
| 15:06:30 | Watusimoto | what is player_mv? |
| 15:07:28 | kaen | it's for the stats page |
| 15:07:55 | kaen | it's an aggregate table of the player stats so that we don't have to aggregate for every request |
| 15:08:02 | Watusimoto | ok... I found error messages in the log from mid June |
| 15:08:14 | Watusimoto | so it's probably had problems since then |
| 15:08:29 | Watusimoto | and so that explains everything, actually |
| 15:08:33 | kaen | after reviewing my triggers, I actually don't think that's the cause anymore :x |
| 15:08:45 | kaen | does the error message still occur? |
| 15:08:49 | Watusimoto | why the stats are being added, but the later stuff might not be running |
| 15:08:58 | Watusimoto | testing |
| 15:09:01 | kaen | ok |
| 15:09:26 | kaen | if it does not occur, or changes to a different column then it is indeed my fault |
| 15:09:53 | Watusimoto | Failure writing stats to database: Unknown column 'ff_kills' in 'field list' |
| 15:09:57 | Watusimoto | different error |
| 15:09:59 | kaen | yay! |
| 15:10:02 | kaen | it's my fault! |
| 15:10:06 | Watusimoto | or not |
| 15:10:27 | Watusimoto | I added some new columns to the player stats, and did not know about player_mv |
| 15:10:32 | kaen | bah |
| 15:10:32 | Watusimoto | so I did not add them there |
| 15:10:40 | kaen | I added some columns to player_mv :x |
| 15:10:50 | kaen | turret_kills, to be specific |
| 15:10:52 | Watusimoto | mv == materialized view? |
| 15:10:56 | kaen | yeah |
| 15:11:00 | kaen | but in quotes :P |
| 15:11:01 | Watusimoto | there were several new columns |
| 15:11:04 | Watusimoto | right |
| 15:11:12 | Watusimoto | do you need all the enw columns? |
| 15:11:19 | kaen | I believe so |
| 15:11:24 | Watusimoto | ff_kills, obviously |
| 15:11:33 | kaen | but I just haven't updated the stats page for the new columns at all yet... |
| 15:11:40 | Watusimoto | astKills) + ", " + itos(playerStats->turretsEngr) + ", " + |
| 15:11:40 | Watusimoto | itos(playerStats->ffEngr) + ", " + itos(playerStats->telEngr) + ", " + |
| 15:11:40 | Watusimoto | itos(playerStats->distTraveled) |
| 15:11:49 | Watusimoto | wait |
| 15:11:51 | Watusimoto | hold |
| 15:12:05 | Watusimoto | "turret_kills, ff_kills, " |
| 15:12:05 | Watusimoto | "asteroid_kills, turrets_engineered, " |
| 15:12:05 | Watusimoto | "ffs_engineered, teleports_engineered, " |
| 15:12:05 | Watusimoto | "distance_traveled |
| 15:12:06 | Watusimoto | these |
| 15:12:26 | Watusimoto | wait |
| 15:12:29 | Watusimoto | will give you types |
| 15:12:44 | Watusimoto | " turret_kills integer NOT NULL," |
| 15:12:45 | Watusimoto | " ff_kills integer NOT NULL," |
| 15:12:45 | Watusimoto | " asteroid_kills integer NOT NULL," |
| 15:12:45 | Watusimoto | " turrets_engineered integer NOT NULL," |
| 15:12:45 | Watusimoto | " ffs_engineered integer NOT NULL," |
| 15:12:45 | Watusimoto | " teleports_engineered integer NOT NULL," |
| 15:12:48 | Watusimoto | " distance_traveled integer NOT NULL," |
| 15:13:09 | Watusimoto | maybe switched_team_count INTEGER NULL, |
| 15:13:16 | Watusimoto | but you may already have that one |
| 15:13:30 | | bobdaduck has joined |
| 15:14:02 | kaen | okay let's give it a shot |
| 15:14:11 | Watusimoto | I've very glad you happened along... I never would haev found that |
| 15:14:12 | Watusimoto | testing |
| 15:14:38 | kaen | I'm very to have inadvertently caused such a subtle and troublesome bug... |
| 15:14:42 | kaen | very sorry* |
| 15:15:24 | Watusimoto | looks like it may be fixed |
| 15:15:45 | kaen | there's no way the stats were aggregating correctly... |
| 15:15:55 | kaen | hah |
| 15:15:56 | kaen | indeed |
| 15:16:13 | kaen | good thing they got inserted into stats_player just fine :P |
| 15:16:18 | Watusimoto | yes |
| 15:16:27 | kaen | I wrote an all-at-once aggregator along with the triggers |
| 15:16:27 | Watusimoto | well, loadout and shot stats might not have worked |
| 15:16:32 | kaen | oh :x |
| 15:16:41 | Watusimoto | but they're less critical |
| 15:16:44 | kaen | yeah |
| 15:16:49 | kaen | okay I'll take a look |
| 15:17:00 | kaen | that should at least stop the bleeding... |
| 15:18:08 | Watusimoto | so do we need to update player_dv to make up for all the stuff that wasn't inserted? |
| 15:19:01 | kaen | yeah, that's what I was just talking about |
| 15:19:02 | Watusimoto | yes, we do! |
| 15:19:21 | Watusimoto | I haev the only game for July! |
| 15:19:36 | Watusimoto | ok, so what can we do to protect ourselves form this in the future? |
| 15:19:37 | kaen | but I have to update my aggregation script and triggers first |
| 15:19:42 | Watusimoto | ok |
| 15:20:06 | kaen | well, we coult try each DB op atomically |
| 15:20:13 | Watusimoto | ideas: 1) somehow make it clearer that player_mv needs to be udated when player_stats does (comments in the code, perhaps?) |
| 15:20:28 | Watusimoto | 2) make a failure to insert not cascade |
| 15:20:36 | Watusimoto | (maybe not a good idea, not sure) |
| 15:20:59 | Watusimoto | 3) make a failure to update player_mv somehow not throw an error (possible??) |
| 15:21:29 | kaen | I don't think SQL has try/catch :P |
| 15:25:44 | kaen | okay, running the aggregator |
| 15:25:45 | kaen | ... |
| 15:26:10 | Watusimoto | the try catch is in c++ |
| 15:26:28 | kaen | I was just being silly |
| 15:26:28 | Watusimoto | what if... what if we didn't use a trigger, but coded the update directly in the master code? |
| 15:26:33 | kaen | yeah |
| 15:26:35 | Watusimoto | then the mechanism would be apparent at least |
| 15:26:38 | kaen | that was my next suggestion |
| 15:26:43 | Watusimoto | i think we shoudl do that |
| 15:26:59 | Watusimoto | I'm actually int he process of tyring to update the master, so this would be a good time |
| 15:27:12 | kaen | https://code.google.com/p/bfstats/source/browse/#hg%2Futil |
| 15:27:35 | kaen | player_stats_triggers.sql and aggregate_player_stats.sql |
| 15:28:00 | Watusimoto | that will take a little bit of work to digest |
| 15:28:22 | Watusimoto | btw, my latest push will not work without an updated master, and the master changes don't work properly with 018a |
| 15:28:48 | bobdaduck | hallo |
| 15:29:00 | Watusimoto | hi |
| 15:29:37 | bobdaduck | Does watusimoto want to see some crazy levelgens? |
| 15:29:55 | Watusimoto | at the moment iI'm in a panic about the master |
| 15:29:58 | bobdaduck | lol |
| 15:30:04 | bobdaduck | Can I panic too? |
| 15:30:11 | Watusimoto | but I do want to see them |
| 15:30:13 | kaen | okay, only the trigger is strictly necessary |
| 15:30:22 | Watusimoto | there was some good scripting stuff in the contest |
| 15:30:24 | kaen | we can use the aggregator from the sql file itself |
| 15:31:06 | Watusimoto | this one: update_player_shots_stats ? |
| 15:31:28 | kaen | we need both triggers in the trigger file |
| 15:31:33 | kaen | update_player_shots_stats and update_player_stats |
| 15:31:44 | Watusimoto | oh, I see |
| 15:31:54 | Watusimoto | so those do what, flatten the table for easier access? |
| 15:32:12 | kaen | yes |
| 15:32:38 | kaen | on each insertion it updates the appropriate player's player_mv entry |
| 15:33:48 | kaen | basically, if you can put the record being inserted into a variable called NEW, then you should be able to run everything between BEGIN and END |
| 15:34:01 | kaen | as a separate query |
| 15:34:10 | kaen | alternatively |
| 15:35:26 | kaen | actually I have no alternative. |
| 15:36:48 | koda | hi guys |
| 15:36:50 | koda | what's up |
| 15:36:55 | kaen | crisis mode |
| 15:36:56 | bobdaduck | sup koda |
| 15:36:58 | kaen | wbu? |
| 15:37:00 | bobdaduck | crisis mode! |
| 15:37:13 | kaen | actually the crisis has been mostly averted |
| 15:37:37 | Watusimoto | ok |
| 15:37:38 | Watusimoto | well |
| 15:37:55 | Watusimoto | looks like we only have shooting stats for bots since whenever this db error started |
| 15:38:09 | Watusimoto | player data was not recorded |
| 15:42:04 | Watusimoto | and loadout stats look like they're still not being recorded |
| 15:43:21 | Watusimoto | only stats for repair bot seem to be recorded |
| 15:43:23 | Watusimoto | odd |
| 15:44:00 | bobdaduck | GRAVITY STACKS IS REBORN |
| 15:45:17 | kaen | Watusimoto, I do have an alternative after all |
| 15:45:58 | kaen | what if we keep the player_mv queries out of master and instead run the aggregator as a cron job each night |
| 15:46:27 | kaen | that way there's no triggers to cause insertion failures, and we still keep player_mv logic out of master which really has no concern for it one way or the other. |
| 15:47:01 | Watusimoto | ok |
| 15:47:06 | kaen | the downside is that the stats page won't be updated instantly, but rather periodically |
| 15:47:17 | kaen | the aggregator takes about two minutes to run right now |
| 15:47:25 | Watusimoto | what does the aggregator do? |
| 15:47:30 | kaen | could take even less if we didn't aggregator for all of time |
| 15:47:39 | kaen | the same thing as the triggers, but in a single operation |
| 15:47:51 | kaen | rather than record-by-record |
| 15:48:11 | Watusimoto | could the aggregator only operate on new records? |
| 15:48:30 | kaen | that could feasibly be done with a shell script |
| 15:48:37 | Watusimoto | i.e. where id > max(already aggrregated id) |
| 15:48:40 | kaen | yep |
| 15:48:58 | kaen | or maybe it could keep its own table |
| 15:49:06 | kaen | with exactly one row and one column :P |
| 15:49:10 | bobdaduck | can we show energy on the commanders chart? |
| 15:49:12 | Watusimoto | that would speed it up a fair bit, right? |
| 15:49:20 | Watusimoto | bobdaduck: yes, I think so |
| 15:49:26 | kaen | oh yes |
| 15:49:30 | kaen | oh wait |
| 15:49:31 | kaen | derp |
| 15:49:52 | kaen | I just realized that it has to process all records for a time period at once... |
| 15:50:07 | kaen | so I'd have to tweak it considerably |
| 15:50:15 | kaen | but let me investigate and get back to you |
| 15:51:14 | kaen | hmm. actually the aggregator has now been running for seven minutes... |
| 15:51:32 | raptor | hi again.. |
| 15:51:34 | kaen | hello |
| 15:51:37 | raptor | sorry, i fell asleep on the floor |
| 15:52:10 | bobdaduck | hi raptor |
| 15:52:19 | bobdaduck | I've reached a perfect orbit on gravity stacks |
| 15:53:03 | Watusimoto | bobdaduck: did you just change your loadout in-game? |
| 15:53:10 | bobdaduck | huh? |
| 15:53:19 | Watusimoto | you were playing, no? |
| 15:53:24 | bobdaduck | I'm playing right now, yeah |
| 15:53:31 | Watusimoto | did you change your loadout? |
| 15:53:35 | bobdaduck | I changed my loadout like |
| 15:53:39 | Watusimoto | during the last level |
| 15:53:39 | bobdaduck | five minutes ago? |
| 15:58:16 | Watusimoto | odd, I can't get any stats to show up in the table now |
| 16:01:23 | Watusimoto | well, dang it |
| 16:01:26 | kaen | on the stats page? |
| 16:01:32 | Watusimoto | no new players are showing in the stat |
| 16:01:33 | Watusimoto | s |
| 16:01:35 | Watusimoto | no |
| 16:01:40 | Watusimoto | in the player_stats table |
| 16:01:46 | kaen | crud |
| 16:01:48 | Watusimoto | nothing changed here |
| 16:01:54 | kaen | that's likely because the aggregator is running |
| 16:02:02 | Watusimoto | did you change something about 5 mins ago that could have caused... oh |
| 16:02:16 | kaen | it drops the table when it starts |
| 16:02:20 | kaen | and then... cascading failures |
| 16:02:26 | Watusimoto | the table is there |
| 16:02:39 | Watusimoto | stats_player is there |
| 16:02:43 | kaen | player_mv |
| 16:02:45 | kaen | is gone |
| 16:02:49 | kaen | so the trigger is erroring |
| 16:03:00 | Watusimoto | but I'm not seeing the exceptions I saw beore |
| 16:03:01 | Watusimoto | before |
| 16:03:05 | kaen | hmm |
| 16:03:30 | kaen | maybe the transactions are holding until it completes? |
| 16:03:31 | Watusimoto | and it usually inserted into player-stats fine, even when the trigger was broken |
| 16:03:35 | Watusimoto | maybe |
| 16:03:42 | kaen | because actually the player_mv table is fine |
| 16:03:55 | Watusimoto | how much longer until the process is finished, do you think? |
| 16:04:32 | kaen | well it usually takes 14 minutes on my 2800ghz laptop for all the records until like last august |
| 16:04:37 | kaen | er |
| 16:04:42 | kaen | 2.8ghz |
| 16:04:51 | Watusimoto | ok |
| 16:04:56 | Watusimoto | so we wait |
| 16:05:23 | Watusimoto | we probably need to find a better way; that's a lot of crunching |
| 16:05:31 | kaen | I can definitely rewrite those triggers into an incremental aggregator |
| 16:05:50 | kaen | and then just run that periodically |
| 16:05:53 | Watusimoto | so why does the aggregator need to do everything at once? |
| 16:06:04 | kaen | because I wrote it as a dumb fall back |
| 16:06:14 | Watusimoto | in case the trigger fails? |
| 16:06:18 | kaen | it's faster than doing it all at once record-by-record though |
| 16:06:18 | kaen | yes |
| 16:06:26 | Watusimoto | ok, then leave it as is |
| 16:06:35 | kaen | if you re-inserted from a backup with the trigger in place it would take at least an hour |
| 16:06:35 | Watusimoto | since it's not meant to be used |
| 16:06:37 | kaen | I've tried that |
| 16:06:50 | kaen | but I'll work on converting the triggers |
| 16:06:51 | Watusimoto | yuck |
| 16:07:07 | Watusimoto | well, with some thought, it does seem that a trigger is the right mechansim |
| 16:07:25 | kaen | yes, but it'd be better if it's run periodically |
| 16:07:29 | Watusimoto | we just need to be better about catching it when it falls down |
| 16:07:38 | kaen | rather than after each insert |
| 16:07:50 | Watusimoto | why would that be better? |
| 16:07:53 | kaen | if we ran it like every 15 minutes it would take only seconds |
| 16:08:06 | Watusimoto | true |
| 16:08:07 | kaen | and there would be no detected failure in the master |
| 16:08:15 | Watusimoto | true |
| 16:08:23 | kaen | using my not-yet-existent incremental aggregator |
| 16:08:59 | Watusimoto | is there a way of running a trigger "out of order" or something, meaning it would run not as part of the transaction, but separately? |
| 16:09:10 | kaen | I have not looked into that |
| 16:09:11 | Watusimoto | that was not the right description |
| 16:09:23 | kaen | I think I understand |
| 16:09:26 | Watusimoto | what would be ideal would be some sort of queued trigger |
| 16:09:33 | kaen | like, it would trigger it and not care about the outcome? |
| 16:09:34 | kaen | oh |
| 16:09:37 | Watusimoto | like the trigger fires, and runs in the background |
| 16:09:43 | Watusimoto | and never explicitly returns |
| 16:09:48 | Watusimoto | yes |
| 16:09:51 | kaen | ok yes |
| 16:09:55 | kaen | I have not looked into that |
| 16:10:09 | Watusimoto | then if it fails, it won't make the master fail |
| 16:10:17 | kaen | I have to go :x |
| 16:10:21 | Watusimoto | of course, if it failed, we'd need to know somehow |
| 16:10:22 | Watusimoto | ok |
| 16:10:24 | kaen | I'll be back in an hour or so |
| 16:10:31 | Watusimoto | I'll be alseep |
| 16:10:33 | Watusimoto | hopefully |
| 16:10:35 | Watusimoto | :-) |
| 16:10:41 | Watusimoto | thanks for your help! |
| 16:10:53 | Watusimoto | bobdaduck: still around? |
| 16:11:20 | bobdaduck | yeah |
| 16:11:24 | bobdaduck | nowait |
| 16:11:25 | bobdaduck | afk |
| 16:11:26 | bobdaduck | 20 min |
| 16:11:39 | Watusimoto | yes, then, or no? |
| 16:14:20 | bobdaduck | okay back |
| 16:14:37 | bobdaduck | can you repeat the question? |
| 16:14:56 | Watusimoto | want to show me your levelgens? |
| 16:15:01 | bobdaduck | yeah! Hosting |
| 16:16:30 | bobdaduck | watusimoto coming? |
| 16:16:36 | Watusimoto | just a sec, yes |
| 16:20:05 | | Nothing_Much Quit (Quit: l8r) |
| 16:23:24 | | Tttt7858 has joined |
| 16:23:31 | Tttt7858 | Hi. |
| 16:24:16 | Watusimoto | hi |
| 16:24:28 | Tttt7858 | ^ Symbols, dots, stars? |
| 16:25:25 | Tttt7858 | I'd like to figure out how many tiers, 10 tiers? or 3 tiers each with 3 levels adding up to nine levels |
| 16:26:16 | Tttt7858 | first three levels could be colored ^ symbols second three could be dots, last three could be stars |
| 16:26:55 | Tttt7858 | I think that could work |
| 16:27:05 | Watusimoto | did you see the thing I pasted on pastie? |
| 16:27:33 | Tttt7858 | yes |
| 16:28:38 | Watusimoto | Tttt7858: maybe -- it needs to be compact |
| 16:28:53 | Watusimoto | chevrons can stack like seargant's stripes |
| 16:29:32 | Tttt7858 | Eh |
| 16:29:43 | Tttt7858 | It's sounding a bit like ranks now. |
| 16:29:45 | Tttt7858 | hmm |
| 16:30:09 | Tttt7858 | 10 Chevrons is um, a bit unrealistic, even though bitfighter isn't either |
| 16:30:25 | Watusimoto | no, only 1,2, or 3 |
| 16:30:30 | Watusimoto | then they change color and reset |
| 16:30:31 | Tttt7858 | Hmm |
| 16:30:56 | Tttt7858 | Maybe first 3 levels chevrons, second three are dots, and last 3 are stars |
| 16:31:06 | | thread_ has joined |
| 16:31:20 | thread_ | I solemnly swear I am up to no good |
| 16:31:24 | Tttt7858 | <<< . . . *** |
| 16:31:33 | thread_ | lol |
| 16:31:56 | Watusimoto | maybe |
| 16:32:08 | Tttt7858 | Hmm |
| 16:32:11 | Watusimoto | I need to try some things and see what works |
| 16:33:07 | Tttt7858 | <) <)) <))) <<) <<)) <<))) <<<) <<<)) <<<))) |
| 16:34:25 | Watusimoto | :-) |
| 16:34:30 | thread_ | Questions: can I use levelgens to change if engineer is enabled? If not, has there been a ticket entered for this? |
| 16:35:23 | Watusimoto | I don't think so, on both counts |
| 16:35:26 | Watusimoto | feel free to do so |
| 16:36:08 | thread_ | remind me, what is the google code url for this project? |
| 16:36:38 | Tttt7858 | hmm |
| 16:37:00 | Tttt7858 | I kind of want to figure out what system. |
| 16:37:05 | Tttt7858 | would be best |
| 16:37:51 | Tttt7858 | I personally think <<< ... *** could work sort of well |
| 16:39:15 | Tttt7858 | ^ |
| 16:39:32 | Tttt7858 | Chevrons for all ranks idk? |
| 16:39:55 | Tttt7858 | sorry if i type too many things lol |
| 16:40:02 | Watusimoto | https://code.google.com/p/bitfighter/issues/ |
| 16:40:09 | Watusimoto | or do !bug |
| 16:40:10 | Watusimoto | !bug |
| 16:40:10 | BFLogBot | To enter a bug, please make sure it is reproducible and then go to http://code.google.com/p/bitfighter/issues/list | Also, see current running bug list: http://bitfighter.org/wiki/index.php/Running_Bug_List |
| 16:42:27 | | Nothing_Much has joined |
| 16:42:27 | | Nothing_Much Quit (Changing host) |
| 16:42:27 | | Nothing_Much has joined |
| 16:43:42 | Tttt7858 | Hm |
| 16:43:45 | Tttt7858 | eh |
| 16:56:00 | Watusimoto | raptor: I'm going to bed. I'll try to get the master upgraded tomorrow |
| 16:56:12 | raptor | okey doke.. is the old one running now? |
| 16:56:14 | Watusimoto | yes |
| 16:56:16 | raptor | great |
| 16:56:28 | raptor | good night |
| 16:56:30 | Watusimoto | I did not modify any of the scripts |
| 16:56:34 | raptor | ok |
| 16:56:41 | Watusimoto | and the current master has a copy called master.current |
| 16:56:50 | Watusimoto | in case we (I) screw something up |
| 16:56:57 | raptor | ok |
| 16:56:58 | raptor | :) |
| 16:57:02 | Watusimoto | in any event... |
| 16:57:03 | Watusimoto | night! |
| 16:57:08 | raptor | night! |
| 16:57:23 | Watusimoto | oh one last thing |
| 16:57:36 | Watusimoto | thread_ was asking how to submit lua api feature requests |
| 16:57:39 | Watusimoto | :-) |
| 16:57:49 | raptor | issues list! |
| 16:57:49 | kaen | I think he submitted it |
| 16:58:06 | Watusimoto | yes, I suspect so... just warning you there is another lua scripter on the loose |
| 16:58:16 | Watusimoto | well, in any event |
| 16:58:24 | Watusimoto | kaen: thanks for your help |
| 16:58:29 | Watusimoto | oh, I need to check the master |
| 16:58:33 | kaen | thanks for your patience :) |
| 17:00:01 | Watusimoto | kaen: is the long query done? |
| 17:00:06 | Watusimoto | the aggregator? |
| 17:00:37 | Watusimoto | because the stats we thought were delayed were never written |
| 17:00:40 | Watusimoto | nor anything since |
| 17:00:56 | Watusimoto | SELECT * |
| 17:00:56 | Watusimoto | FROM `stats_player` |
| 17:00:56 | Watusimoto | ORDER BY `stats_player_id` DESC |
| 17:00:56 | Watusimoto | LIMIT 0 , 30 |
| 17:01:25 | Watusimoto | shows bobdaduck/208829 as the top record, and more should have been written since that was written |
| 17:01:43 | Watusimoto | a fair bit mroe |
| 17:02:08 | | thread_ Quit (Ping timeout: 250 seconds) |
| 17:02:58 | Watusimoto | getting a lot of these in the log: |
| 17:02:59 | Watusimoto | Database thread overloaded - database access too slow? |
| 17:05:20 | | Tttt7858 Quit (Quit: Page closed) |
| 17:06:23 | kaen | it's still running ... |
| 17:06:28 | Watusimoto | ok |
| 17:06:37 | Watusimoto | then that explains it |
| 17:07:38 | Watusimoto | I'll check tomorrow; though I'll probably be away most of the day |
| 17:07:42 | Watusimoto | night |
| 17:07:46 | kaen | night |
| 17:07:47 | | Watusimoto Quit (Remote host closed the connection) |
| 17:11:34 | | Nothing_Much Quit (Quit: l8r) |
| 17:35:18 | | bobdaduck Quit (Remote host closed the connection) |
| 17:52:52 | raptor | another scripter on the loose! |
| 18:16:29 | | Nothing_Much has joined |
| 18:16:30 | | Nothing_Much Quit (Changing host) |
| 18:16:30 | | Nothing_Much has joined |
| 23:57:52 | | Nothing_Much Quit (Quit: l8r) |