Testing DB Fix... HIT THE PAGE HARD!

sohum

Executive member
Joined
Aug 3, 2004
Location
San Francisco, CA
Profile Flag
India
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).
 

ShamiLoverGlipGlops

The Man With The Glip Glops
India
NZ....
AFG...
KKR
Avengers
Joined
Aug 14, 2008
Online Cricket Games Owned
  1. Don Bradman Cricket 14 - PS3
  2. Don Bradman Cricket 14 - Steam PC
  3. Don Bradman Cricket 14 - Xbox One
Hey mate the db is made by Yudi.
 

sohum

Executive member
Joined
Aug 3, 2004
Location
San Francisco, CA
Profile Flag
India

ShamiLoverGlipGlops

The Man With The Glip Glops
India
NZ....
AFG...
KKR
Avengers
Joined
Aug 14, 2008
Online Cricket Games Owned
  1. Don Bradman Cricket 14 - PS3
  2. Don Bradman Cricket 14 - Steam PC
  3. Don Bradman Cricket 14 - Xbox One

sohum

Executive member
Joined
Aug 3, 2004
Location
San Francisco, CA
Profile Flag
India
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).
 

ShamiLoverGlipGlops

The Man With The Glip Glops
India
NZ....
AFG...
KKR
Avengers
Joined
Aug 14, 2008
Online Cricket Games Owned
  1. Don Bradman Cricket 14 - PS3
  2. Don Bradman Cricket 14 - Steam PC
  3. Don Bradman Cricket 14 - Xbox One
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
 

Imager36

Club Captain
Joined
Aug 7, 2007
Location
Sussex, England
Online Cricket Games Owned
  1. Don Bradman Cricket 14 - Steam PC
I'm really bombing it on mine, all three open, each auto reloading every 5 seconds :p
 

Ollie_H

Chairman of Selectors
Joined
Jul 3, 2007
Online Cricket Games Owned
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
 

ShamiLoverGlipGlops

The Man With The Glip Glops
India
NZ....
AFG...
KKR
Avengers
Joined
Aug 14, 2008
Online Cricket Games Owned
  1. Don Bradman Cricket 14 - PS3
  2. Don Bradman Cricket 14 - Steam PC
  3. Don Bradman Cricket 14 - Xbox One
I was first!!:banana2 :p :laugh

Sohumm Solve it
 

sohum

Executive member
Joined
Aug 3, 2004
Location
San Francisco, CA
Profile Flag
India
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.
 

Ollie_H

Chairman of Selectors
Joined
Jul 3, 2007
Online Cricket Games Owned
Is there no way of slowing it down, and then forming a code to speed it up?
 

Users who are viewing this thread

Top