Testing DB Fix... HIT THE PAGE HARD!

[sohum]

Well, the problem has happened again but at least this time I know what the issue is.

Basically, several entities are trying to read/write from the database file from the same time and hence the file is locked when the simulation tries to run. I can't think of an easy solution off the top of my head so right now the best I can do is this:

1. I'll re-simulate the games in PCCS and post the results in the match threads.
2. I'll try to come up with a fix for tomorrow's preseason game.

Looks like the live feature was too popular and hence too many people were trying to use it. :P

The solution for this will be to have a separate database for the web server so that the matches can proceed with simulation despite high server load.

Sorry for all this guys! But the main purpose of the pre-season tournament was to work out the kinks in the live output. Bear with me as I figure the issues out!

 

[Viral Shah]

No Problem Sohum.

 

[Akash00]

Thanks a lot for letting us know what the problem is, finally.

 

[WestIndian]

Best of luck mate with this, must say was pretty interesting while it lasted

 

[Kshitiz_Indian]

Cant you store the db on the pc server and have pccs use it?

 

[Themer]

Thanks a lot for letting us know what the problem is, finally.

Wow that sounds rather ungrateful. Sohum didn't know what the problem was until it went down just then.

 

[Amar791849]

No problem Bro

 

[Kshitiz_Indian]

Or you could make pccs output to an html file periodically and let us see that?

 

[sohum]

Cant you store the db on the pc server and have pccs use it?

The issue is not the location of the database but the access to it. It's mainly my fault because I didn't put mutexes and such or check for SQLite exceptions in my code. I'm going to run an international simulation that doesn't affect PCCS to see if I can reproduce the error.

 

[Pranav]

The Llamas can have a sigh of relief now! They have yet another chance to prove themselves. They were smashed in the last two though.

The live feature definitely brings in some issues. Hopefully they'll get worked upon soon and we will have a healthy tournament ahead.

 

[sohum]

Or you could make pccs output to an html file periodically and let us see that?

Yeah, that's my short-term solution. It does mean that I won't have some of the nifty ASP stuff (such as the tabs, etc.).

 

[saiyaman]

No problem Sohum! Glad to see that you've managed to corner the problem at last. Would take a weight off your shoulders that way.

 

[sohum]

I'm going to schedule a Twenty20 tri-series between India, England and Australia in an hour or so to test a fix for the db problem.

 

[WestIndian]

I'm going to schedule a Twenty20 tri-series between India, England and Australia in an hour or so to test a fix for the db problem.

Good luck with that and I wish you success, because re-starting matches can be problematic with the outcome

 

[ShamiLoverGlipGlops]

Best of luck sohum, You have done superb hardwork and hope it goes for best