Testing DB Fix... HIT THE PAGE HARD!

[sohum]

I'm investigating another potential fix. Just resetting the DBs (probably should've backed it up earlier ).

sohum added 3 Minutes and 49 Seconds later...

Testing the fix now....

Deccan Chargers 2/0 (0.4 ov, D Teja 1*, VVS Laxman 1*, S Tyagi 0/2) | Live Scorecard | PCCL
Delhi Daredevils 5/0 (0.3 ov, D Vettori 3*, T Dilshan 1*, S Sreesanth 0/5) | Live Scorecard | PCCL
Mumbai Indians 1/1 (0.3 ov, R Raje 0*, D Fernando 1*, S Bond 1/1) | Live Scorecard | PCCL

 

[Zaxotes]

hey... any orange caps? purple caps? leader boards?

 

[sohum]

There aren't going to be any silly names like that, no. But there'll be leaderboards once I'm done testing this change out.

 

[Ollie_H]

I think it's stopped, but not getting anywhere refreshing errors.

 

[Imager36]

Yeah, all the matches have stopped like they did first and second times round.

 

[Themer]

I'm getting this error on clicking Tournament.

 

[Insomniac]

I'm getting errors on mine.

[NullReferenceException: Object reference not set to an instance of an object.]
   Matches.UpdateLivePageTitle() +30
   Matches.Page_Load(Object sender, EventArgs e) +1236
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +91
   System.Web.UI.Control.LoadRecursive() +74
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

 

[Ollie_H]

It's all re-started now.

 

[sohum]

This is getting pretty annoying. I've now gone ahead and made everyone using the DB protected by a mutex... meaning that the DB cannot theoretically be locked. Let's see if that helps.

 

[Themer]

Sohums probably trying another fix.

Edit - Emu'd

 

[sohum]

I've sped up the simulation a bit. Will speed it up even more if this doesn't work. I've one more fix I can think of and if that doesn't work then I'll just have to table the live thing for a bit until I write the non-trivial amount of code that is necessary to generate static pages so that the web-server isn't accessing the DB.

sohum added 5 Minutes and 15 Seconds later...

This is around the time things screw up (around the 12th over).

sohum added 15 Minutes and 26 Seconds later...

This seems to have fixed the issue at the cost of low page performance. I'm sure you notice page refreshes take a long time to display, now.

 

[Ollie_H]

CSK vs MI is turning into a really good game!

Ollie_H added 1 Minutes and 29 Seconds later...

Also, one thing I have spotted, is that there is no commentary on wicket balls.

 

[sohum]

Yeah, I haven't added that in yet. Will do it soon.

Looks like this simulation went through. I'm going to do the next round of this fake IPL at normal speed and make sure it goes through.

There's going to be a performance hit for sure, but I guess this is the best we can hope for until I set up the static HTML pages.