2006-05-15, 11:27 PM
I am calling ScheduleHelper.CancelScheduledRecording() and finding that sometimes it works and sometime I get database locked errors. Here is a sample from my application's log file.
In this particular run I cancelled 30 pending recordings, 4 of which generated this error and 26 of which worked just fine.
Jeff
Code:
05/15/06 04:19:15:092 PM[18] Looking at Go, Diego, Go! (Pepito's Penguin School) with unique id of EP7654580009
05/15/06 04:19:15:092 PM[18] Cancelling pending recording for previously recorded show Go, Diego, Go!
05/15/06 04:19:16:284 PM[18] Looking at Go, Diego, Go! (Chinta the Baby Chinchilla) with unique id of EP7654580003
05/15/06 04:19:16:284 PM[18] Cancelling pending recording for previously recorded show Go, Diego, Go!
05/15/06 04:19:47:569 PM[18] Error cancelling pending recording for previously recorded show Go, Diego, Go!. System.Data.SQLite.SQLiteException: The database file is locked
database is locked
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.x5e29b479fd4eab70(ScheduledRecording xe41d2b9d98dc1269, Boolean x29a0b54a36a7fcdf)
at GBPVR.Backend.Common.x396614b3dae3b1da.x5e29b479fd4eab70(ScheduledRecording xe41d2b9d98dc1269)
at GBPVR.Backend.Common.ScheduleHelper.CancelScheduledRecording(ScheduledRecording scheduledRecording)
at ArchiveVideosPlugin.UpcomingRecordings.FillList(Int32 unusedparameter) in C:\Documents and Settings\My Documents\Visual Studio 2005\Projects\Video Archiver Source\PendingList.cs:line 454
05/15/06 04:19:47:569 PM[18] Looking at Go, Diego, Go! (Chito and Rita the Spectacled Bears) with unique id of EP7654580012
05/15/06 04:19:47:579 PM[18] Cancelling pending recording for previously recorded show Go, Diego, Go!
05/15/06 04:20:06:075 PM[18] Looking at Go, Diego, Go! (Rescue of Red-Eyed Tree Frogs!) with unique id of EP7654580002
05/15/06 04:20:06:075 PM[18] Cancelling pending recording for previously recorded show Go, Diego, Go!
05/15/06 04:20:07:177 PM[18] Looking at Go, Diego, Go! (A Booboo on the Pygmy Marmoset) with unique id of EP7654580015
05/15/06 04:20:07:177 PM[18] Cancelling pending recording for previously recorded show Go, Diego, Go!
05/15/06 04:20:37:420 PM[18] Error cancelling pending recording for previously recorded show Go, Diego, Go!. System.Data.SQLite.SQLiteException: The database file is locked
database is locked
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.x5e29b479fd4eab70(ScheduledRecording xe41d2b9d98dc1269, Boolean x29a0b54a36a7fcdf)
at GBPVR.Backend.Common.x396614b3dae3b1da.x5e29b479fd4eab70(ScheduledRecording xe41d2b9d98dc1269)
at GBPVR.Backend.Common.ScheduleHelper.CancelScheduledRecording(ScheduledRecording scheduledRecording)
at ArchiveVideosPlugin.UpcomingRecordings.FillList(Int32 unusedparameter) in C:\Documents and Settings\My Documents\Visual Studio 2005\Projects\Video Archiver Source\PendingList.cs:line 454
05/15/06 04:20:37:420 PM[18] Looking at Go, Diego, Go! (Diego Saves the Mommy and Baby Sloth) with unique id of EP7654580001
05/15/06 04:20:37:420 PM[18] Cancelling pending recording for previously recorded show Go, Diego, Go!In this particular run I cancelled 30 pending recordings, 4 of which generated this error and 26 of which worked just fine.
Jeff