Testing DB Fix... HIT THE PAGE HARD!

Hi guys, I've started three concurrent matches with what I think is a fix to the issues demonstrated earlier today. I deduced that the issue in fact wasn't because of a high demand of viewership but because my database writes weren't protected.

The mutexes are in place now, so let's hope these simulations go through unscathed. You are encouraged to hit the server hard, though!

(I couldn't be bothered to create international teams so I just used Yudi's IPL db).
 
Hey mate the db is made by Yudi.
 
Whoops, corrected.

sohum added 6 Minutes and 7 Seconds later...

Hey guys, I've got three games going:

Chennai Super Kings 52/0 (6.2 ov, P Amarnath 16*, R Ashwin 36*, F Edwards 0/26, S Styris 0/26) | Live Scorecard | PCCL
Delhi Daredevils 76/1 (7.1 ov, D Vettori 28*, AB de Villiers 6*, S Katich 0/5) | Live Scorecard | PCCL
Mumbai Indians 41/1 (6.1 ov, K Mills 13*, M Ashraful 23*, Ishant Sharma 1/20, M Cameron 0/20) | Live Scorecard | PCCL

Try to hit the page hard (or at least have it open in your background) to see if I can recreate the database issue.

Cheers!
 
Opened :)
 
Cool, try refreshing it (F5 or CTRL+F5) every few minutes or whenever you remember.

I'm pretty certain I've nailed the bug (I remember something similar happening during one of my tests but I put it off as a Dropbox issue).
 
Done :)

Vettori is on fire

rahulkhush added 1 Minutes and 36 Seconds later...

Error!!!

All 3 files stopped working

Code: 
Server Error in '/' Application.
The database file is locked
database is locked
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SQLite.SQLiteException: The database file is locked
database is locked

Source Error:

Line 253:                Table,
Line 254:                String.Format("`Id` = '{0}'", id.ToString()));
Line 255:            Connection.Open();
Line 256:            command.Connection = Connection;
Line 257:            DataTable data = new DataTable();


Source File: D:\dev\NET\PCCS\trunk\Objects\ABackendObject.cs    Line: 255

Stack Trace:

[SQLiteException (0x80004005): The database file is locked
database is locked]
   System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain) +1028
   System.Data.SQLite.SQLiteCommand.BuildNextCommand() +333
   System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index) +18
   System.Data.SQLite.SQLiteDataReader.NextResult() +179
   System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) +87
   System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior) +38
   System.Data.SQLite.SQLiteCommand.ExecuteNonQuery() +39
   System.Data.SQLite.SQLiteConnection.Open() +3162
   PCCS.Objects.ABackendObject`1.Read(Int32 id) in D:\dev\NET\PCCS\trunk\Objects\ABackendObject.cs:255
   PCCS.Objects.ABackendObject`1..ctor(Int32 id) in D:\dev\NET\PCCS\trunk\Objects\ABackendObject.cs:51
   PCCS.Objects.Match..ctor(Int32 id) in D:\dev\NET\PCCS\trunk\Objects\Match.cs:67

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle._InvokeConstructor(IRuntimeMethodInfo method, Object[] args, SignatureStruct& signature, RuntimeType declaringType) +0
   System.RuntimeMethodHandle.InvokeConstructor(IRuntimeMethodInfo method, Object[] args, SignatureStruct signature, RuntimeType declaringType) +15
   System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +281
   System.Reflection.ConstructorInfo.Invoke(Object[] parameters) +17
   PCCS.Objects.ABackendObject`1.Load(Int32 id) in D:\dev\NET\PCCS\trunk\Objects\ABackendObject.cs:67
   Matches.Page_Load(Object sender, EventArgs e) +120
   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


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
 
I'm really bombing it on mine, all three open, each auto reloading every 5 seconds :p
 
It's gone again.

Server Error in '/' Application.

The database file is locked
database is locked

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SQLite.SQLiteException: The database file is locked
database is locked

Source Error:


Line 253: Table,
Line 254: String.Format("`Id` = '{0}'", id.ToString()));
Line 255: Connection.Open();
Line 256: command.Connection = Connection;
Line 257: DataTable data = new DataTable();

Source File: D:\dev\NET\PCCS\trunk\Objects\ABackendObject.cs Line: 255

Stack Trace:


[SQLiteException (0x80004005): The database file is locked
database is locked]
System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain) +1028
System.Data.SQLite.SQLiteCommand.BuildNextCommand() +333
System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index) +18
System.Data.SQLite.SQLiteDataReader.NextResult() +179
System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) +87
System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior) +38
System.Data.SQLite.SQLiteCommand.ExecuteNonQuery() +39
System.Data.SQLite.SQLiteConnection.Open() +3162
PCCS.Objects.ABackendObject`1.Read(Int32 id) in D:\dev\NET\PCCS\trunk\Objects\ABackendObject.cs:255
PCCS.Objects.ABackendObject`1..ctor(Int32 id) in D:\dev\NET\PCCS\trunk\Objects\ABackendObject.cs:51
PCCS.Objects.Match..ctor(Int32 id) in D:\dev\NET\PCCS\trunk\Objects\Match.cs:67

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeMethodHandle._InvokeConstructor(IRuntimeMethodInfo method, Object[] args, SignatureStruct& signature, RuntimeType declaringType) +0
System.RuntimeMethodHandle.InvokeConstructor(IRuntimeMethodInfo method, Object[] args, SignatureStruct signature, RuntimeType declaringType) +15
System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +281
System.Reflection.ConstructorInfo.Invoke(Object[] parameters) +17
PCCS.Objects.ABackendObject`1.Load(Int32 id) in D:\dev\NET\PCCS\trunk\Objects\ABackendObject.cs:67
Matches.Page_Load(Object sender, EventArgs e) +120
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

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
Click to expand...
 
I was first!!:banana2 :p :laugh

Sohumm Solve it
 
Argh, looks like I spoke to soon.

This is interesting, everything I read suggested that read-locks were different. I can add mutexes to the read as well, it just means everything will be slower.
 
Is there no way of slowing it down, and then forming a code to speed it up?
 
You must log in or register to reply here.

Similar threads

kurtkz
DigiSims/Cricket Heroes
11 12 13
Replies
186
Views
37K
Pinch hitter
Pinch hitter
tglover
Criggit - New cricket simulator coming to Windows
2 3 4
Replies
50
Views
10K
Prashanth S Kharche
P
Manish.
  • Sticky
Manish's Simulators - T10, The Hundred, Twenty Twenty, List A
2
Replies
23
Views
6K
viratfanboy05
viratfanboy05
S
How to fix the state of Cricket
2
Replies
23
Views
3K
Hilmens
H
ahmedleo414
Thank you and Goodbye to cricket captain
Replies
7
Views
6K
Bevab
Bevab

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top