SQLLite DB is locked

[JonRoyle]

I upgraded yesterday and I am now having a lot of problems with locked SQL DB which is causing numerous. I have read the post on Locked DB when converting files but I don't use file conversion. My main use has been via EWA.

More details is in my post on issues with EWA and IIS. http://forums.nextpvr.com/showthread.php?t=22742

Latest error (web page) when trying to cancel a recording is as follows


[INDENT]Line 67: public override void CancelScheduledRecording(ScheduledRecording scheduledRecording)
Line 68: {
Line 69: scheduleHelper.CancelScheduledRecording(scheduledRecording);
Line 70: }
Line 71:


Source File: c:\Program Files\devnz\gbpvr\web\App_Code\classes\GBPVRSchedule.cs Line: 69

Stack Trace:


[SQLiteException (0x80004005): The database file is locked
database is locked]
System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt) +334
System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt) +190
System.Data.SQLite.SQLiteCommand.ExecuteNonQuery() +54
GBPVR.Backend.Common.x396614b3dae3b1da.x5e29b479fd4eab70(ScheduledRecording xe41d2b9d98dc1269, Boolean x29a0b54a36a7fcdf) +1092
GBPVR.Backend.Common.ScheduleHelper.CancelScheduledRecording(ScheduledRecording scheduledRecording) +229
gbweb.GBPVRSchedule.CancelScheduledRecording(ScheduledRecording scheduledRecording) in c:\Program Files\devnz\gbpvr\web\App_Code\classes\GBPVRSchedule.cs:69
gbweb.Migrated_Details.lnkRecordCancel_Click(Object sender, EventArgs e) in c:\Program Files\devnz\gbpvr\web\Details.aspx.cs:456
System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) +75
System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +98
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +172
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4921[/INDENT]

Edit - NB If I leave GBPVR for a while it seems to sort itself out. Jon

Any ideas?

Thanks

Jon

[JonRoyle]

Unfortunately this is still regularly happening. Is this impacting anyone else.
Extract from logs?

28/12/2006 08:56:24.376 ERROR [1] Unabled to save ScheduledRecording: The database file is locked
database is locked
28/12/2006 08:56:24.423 ERROR [1] at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at GBPVR.Backend.Common.x396614b3dae3b1da.xc979432fcc5a510a(ScheduledRecording xe41d2b9d98dc1269)

Many thnaks,

Jon

[SniperDude]

no problems like this at all for me ... you might want to post this in the correct forum tho... and have "Uncle" take a look at it..

[sub]

This most likely means that some database update is occuring somewhere in the code, but the connection or transaction is not be closed, leading to problems with subsequent update attempts. Since its occuring with EWA usage, it most likely means its a bug somewhere in EWA that is causing it.

If you're not running v0.99.5, then I'd suggest upgrading.