[closed] A Long Week

[closed] A Long Week

Postby TheIceMage » Sun Aug 07, 2011 11:55 pm

Nothing is ever as easy as you think it is going to be. Nothing.

I finished the database restore at around 11:30 Sunday night. Then I moved all league schedules out by three days. Between now and then, please - please - please look around and see if you see anything acting funky or get any "BUG FOUND" messages anywhere, particularly after various server processes run (which is pretty much all day). Also, know that some things just aren't working yet. For example, the Assistant has gotten even lazier with the slack time. He refuses to bail orcs out, put orcs in regeneration and won't assign looters.

If you do find something, please send me an email at either game@orcsports.com or eclg underscore brett on hotmail. Or both. Or if you happen to know another email address for me, give that a try.
39-21-23-72 on 4/9/2009
34-11-14-38 on 12/5/2007
30-8-9-33 on 5/2/2007
::goldmedal:: ::silvermedal:: ::bronzemedal:: ::dog::
User avatar
TheIceMage
Site Admin
 
Posts: 1949
Joined: Sun Jan 05, 2003 9:58 pm
Location: Denver, CO

Re: A Long Week

Postby TheIceMage » Mon Aug 08, 2011 12:41 am

At work we do a thing called a "retrospective" where you make fun of what other team members did wrong all week. At least I think that's how it works. But working alone, I don't have the luxury of someone else's mistakes to laugh at. Everything's on me. With that in mind, I'll try to be a little constructive as I look back at the last 10 days.

What Went Well
I have long wanted to translate the server processes from VB6 into C#, and in the last week, I took on and finished a large chunk of that. The last time I attempted this, I didn't get very far.
Also, shortly before I started having really irritating database connection issues, the web site was actually running pretty quickly. Hopefully that will continue. At least as long as my ISP can keep the web server running (8 unscheduled down times in July that I knew about, one of which lasted several hours, makes me wonder if this is possible).
I wrote a heck of a lot of code. Thousands of lines. I even tested some of it.
In some cases, the code I wrote was far more efficient than the old VB6 code was, and not just because it isn't VB6 any more.
I was able to get a backup of the database. This might seem like an obvious thing, but like I said above - nothing is ever easy. I'll take the easy win.
I learned a few new things about C# and about MySQL that came in handy.
It's been a while since I tried to see how well I functioned on 4 hours of sleep. A year, I think. I did the 48-hour film project last year.

What Went Poorly
Well, obviously the fact that I had to suspend the game for 10 days is the first thing in this section. I hated doing it, but couldn't see a way around it.
I didn't get everything done the first weekend that I wanted to get done, and the "weekend downtime" lengthened into 10 days.
There's no guarantee that I'm done. Something else could break. For example, I found some deprecated PHP commands I'm using that my ISP might suddenly decide aren't allowed any more. I'll have to address that.
On top of the fact that I wasn't done at the end of the weekend is the fact that I got really sick late Monday. That lasted all the way through Friday (and I'm still recovering). I started seriously working on the system again Friday evening.
I can't compile VB6 on my new Win7 computer. I had to break out an old laptop to rebuild the simulation after my changes.
I can't do a simple database restore with my web host because the backup file (which I downloaded from them) was too large for my ISP. I had to break it into 11 chunks by hand and run each piece individually as an import (which meant I had to get rid of the existing tables).
There's still more work to do. Other server processes need to be finished and tested.
I still can't write a MySQL stored procedure that works. I was going to use this to solve one of the problems I was having, but ended up using a different MySQL feature instead.
The first attempt I wrote to try to have a resilient database connection failed utterly.
I think I accidentally sent a bunch of test emails to players. I have no way of knowing for sure unless they tell me so, as I don't keep a "Sent Items" folder for the game.
Bottom line: it's a complicated beast, and there's no way to predict what's going to go wrong next.
I missed the 48-hour Film Project this year. And the premiere. Meh. There's always next year.

Improvements For Next Time
I think the only improvement would be if there isn't a "next time."
39-21-23-72 on 4/9/2009
34-11-14-38 on 12/5/2007
30-8-9-33 on 5/2/2007
::goldmedal:: ::silvermedal:: ::bronzemedal:: ::dog::
User avatar
TheIceMage
Site Admin
 
Posts: 1949
Joined: Sun Jan 05, 2003 9:58 pm
Location: Denver, CO

Re: A Long Week

Postby Seth » Mon Aug 08, 2011 6:50 am

We appreciate your hard work on this, and the orcs do too!

I'll check on my teams now...
User avatar
Seth
Senior Overlord
 
Posts: 135
Joined: Mon Nov 27, 2006 4:48 pm
Location: Chicago, IL

Re: A Long Week

Postby TheIceMage » Mon Aug 08, 2011 12:42 pm

Today has not been encouraging. There hasn't been a scheduled process that hasn't ended up in an error state, and the most recent of them marked the "orcs" table as crashed. It's repaired now, but it randomly deleted an orc that was owned by a player. (It's been restored.) This is definitely troubling. I am going to have to improve the way I'm handling data and connections, as well as add an automatic repair response when a table is marked as crashed.
39-21-23-72 on 4/9/2009
34-11-14-38 on 12/5/2007
30-8-9-33 on 5/2/2007
::goldmedal:: ::silvermedal:: ::bronzemedal:: ::dog::
User avatar
TheIceMage
Site Admin
 
Posts: 1949
Joined: Sun Jan 05, 2003 9:58 pm
Location: Denver, CO

Re: A Long Week

Postby TheIceMage » Mon Aug 08, 2011 11:59 pm

I made a few more changes today. I'm trying to figure out a sustainable pace for making changes. As it's midnight, I don't think I've quite found it yet. Anyway, we'll see how tomorrow goes. I might end up pushing games out further, but I hope not.

Please keep reporting any weirdness you see to me. Well, weirdness in the game. I can't help any other weirdness you might come across. :lol:
39-21-23-72 on 4/9/2009
34-11-14-38 on 12/5/2007
30-8-9-33 on 5/2/2007
::goldmedal:: ::silvermedal:: ::bronzemedal:: ::dog::
User avatar
TheIceMage
Site Admin
 
Posts: 1949
Joined: Sun Jan 05, 2003 9:58 pm
Location: Denver, CO

Re: A Long Week

Postby TheIceMage » Wed Aug 10, 2011 9:57 am

More changes yesterday, but these seem to be holding. I've had such an issue getting a connection to the database, but now it seems to reliably get a connection and keep it when it runs stuff. The trouble is, that's only for the stuff I rewrote in the past couple weeks. I haven't rewritten the auction or the simulation yet, and both of those seem fragile still. We'll see how tonight's games go.
39-21-23-72 on 4/9/2009
34-11-14-38 on 12/5/2007
30-8-9-33 on 5/2/2007
::goldmedal:: ::silvermedal:: ::bronzemedal:: ::dog::
User avatar
TheIceMage
Site Admin
 
Posts: 1949
Joined: Sun Jan 05, 2003 9:58 pm
Location: Denver, CO

Re: A Long Week

Postby GlorkagGutripper » Wed Aug 10, 2011 7:10 pm

Ummmm 710PM MST and my orcs are running around in circles waiting for the competition............ :cry:
GlorkagGutripper
Overlord
 
Posts: 50
Joined: Sat Sep 04, 2010 8:31 pm
Location: West Valley City, UT

Re: A Long Week

Postby TheIceMage » Wed Aug 10, 2011 9:14 pm

The games are still running, right here next to me, interactively under my watchful eye. I learned two things: 1) the changes I made to the simulation weren't enough to keep the connection the whole time and 2) I really need to rewrite this in C# to make it robust enough.

Oh, look - they just finished. Let me know what you see that's weird. I'm sure there's something....
39-21-23-72 on 4/9/2009
34-11-14-38 on 12/5/2007
30-8-9-33 on 5/2/2007
::goldmedal:: ::silvermedal:: ::bronzemedal:: ::dog::
User avatar
TheIceMage
Site Admin
 
Posts: 1949
Joined: Sun Jan 05, 2003 9:58 pm
Location: Denver, CO

Re: A Long Week

Postby GlorkagGutripper » Thu Aug 11, 2011 6:09 pm

I have one game I scored a hundred points in :)
GlorkagGutripper
Overlord
 
Posts: 50
Joined: Sat Sep 04, 2010 8:31 pm
Location: West Valley City, UT

Re: A Long Week

Postby TheIceMage » Thu Aug 11, 2011 7:38 pm

Are you saying that's unusual? :D

I'm pretty sure that's related to the bug I posted separately. I haven't had a chance to fix that yet.
39-21-23-72 on 4/9/2009
34-11-14-38 on 12/5/2007
30-8-9-33 on 5/2/2007
::goldmedal:: ::silvermedal:: ::bronzemedal:: ::dog::
User avatar
TheIceMage
Site Admin
 
Posts: 1949
Joined: Sun Jan 05, 2003 9:58 pm
Location: Denver, CO

Re: A Long Week

Postby Seth » Fri Aug 12, 2011 9:28 pm

Did games run tonight? Looks like not, in my leagues anyway.
User avatar
Seth
Senior Overlord
 
Posts: 135
Joined: Mon Nov 27, 2006 4:48 pm
Location: Chicago, IL

Re: A Long Week

Postby GlorkagGutripper » Sat Aug 13, 2011 6:12 am

Seth the games are running but not at 6:00 PM MST......also bossman, the cost to fix after the games is rather low. Assuming the Orcs are now afraid of contact :shock: and rather enjoy just running around in circles. Too much free time on their hands I guess.
GlorkagGutripper
Overlord
 
Posts: 50
Joined: Sat Sep 04, 2010 8:31 pm
Location: West Valley City, UT

Re: A Long Week

Postby TheIceMage » Sat Aug 13, 2011 6:52 am

Yesterday's games were rescheduled to today. I estimated 5 days to rewrite the simulation and today could be day 2 of 5.
39-21-23-72 on 4/9/2009
34-11-14-38 on 12/5/2007
30-8-9-33 on 5/2/2007
::goldmedal:: ::silvermedal:: ::bronzemedal:: ::dog::
User avatar
TheIceMage
Site Admin
 
Posts: 1949
Joined: Sun Jan 05, 2003 9:58 pm
Location: Denver, CO

Re: A Long Week

Postby GlorkagGutripper » Sat Aug 13, 2011 9:51 am

Was wondering why the damage was so low :) Guess i need to get some more sleep instead of having orc-filled fantasies all day at work.
GlorkagGutripper
Overlord
 
Posts: 50
Joined: Sat Sep 04, 2010 8:31 pm
Location: West Valley City, UT

Re: A Long Week

Postby Seth » Sat Aug 13, 2011 9:26 pm

Seems to have failed to run again today.
User avatar
Seth
Senior Overlord
 
Posts: 135
Joined: Mon Nov 27, 2006 4:48 pm
Location: Chicago, IL

Next

Return to Closed

Who is online

Users browsing this forum: No registered users and 0 guests

cron