97.9 sqlite error: database file is locked

[congenictv]

I was playing back an old recording and all of a sudden I get a msg that says

Error: The database file is locked
database is locked

I've attached the logs... (couldnt seem to attach files)

6/6/2006 3:01:37 PM.892 VERBOSE [1] getValue() loading new key/value into cache: /settings/VideoPlugin8
6/6/2006 3:01:37 PM.892 VERBOSE [1] getValue: /settings/VideoPlugin8 :
6/6/2006 3:01:37 PM.892 VERBOSE [1] getValue() loading new key/value into cache: /settings/VideoPlugin9
6/6/2006 3:01:37 PM.892 VERBOSE [1] getValue: /settings/VideoPlugin9 :
6/6/2006 3:01:37 PM.902 VERBOSE [1] HideMouse ref=-1
6/6/2006 3:01:51 PM.482 VERBOSE [1] PlaybackPositionManager.storeLastPlaybackPosition(E:\Download\eTalk\eTalk_20060606_10001030-2.mpg, 318)
6/6/2006 3:02:21 PM.595 ERROR [1] Encounter unexpected exception in timerRefresh_Tick:The database file is locked
database is locked
6/6/2006 3:02:21 PM.635 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.x38d54e470ed17baf.x8d76ac89b9dab854(String x8b1d9e3189e6e73d, Int32 x113e47efaf01feb0)
at GBPVR.x977e0aa739bd29d7.RefreshOSD()
at GBPVR.xbb1566157f5f8b1f.xb1cbc922a07ef39b(Object xdf2e3583f942db7b, EventArgs xc4f45905cb1fc7ba)
6/6/2006 3:02:21 PM.635 VERBOSE [1] ShowMouse ref=0
6/6/2006 3:02:21 PM.655 VERBOSE [1] PlaybackPositionManager.storeLastPlaybackPosition(E:\Download\eTalk\eTalk_20060606_10001030-2.mpg, 348)
6/6/2006 3:02:51 PM.979 ERROR [1] Error: msg=0x200 (WM_MOUSEMOVE) hwnd=0x501b2 wparam=0x0 lparam=0x70022 result=0x0 : 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.x38d54e470ed17baf.x8d76ac89b9dab854(String x8b1d9e3189e6e73d, Int32 x113e47efaf01feb0)
at GBPVR.x977e0aa739bd29d7.RefreshOSD()
at GBPVR.x977e0aa739bd29d7.OnMouseMove()
at GBPVR.xbb1566157f5f8b1f.x135a03bc0f573b6c(Object xdf2e3583f942db7b, MouseEventArgs xc4f45905cb1fc7ba)
at System.Windows.Forms.Control.OnMouseMove(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseMove(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at GBPVR.xbb1566157f5f8b1f.WndProc(Message& m)
6/6/2006 3:02:58 PM.578 VERBOSE [1] HideMouse ref=-1
6/6/2006 3:03:12 PM.518 VERBOSE [1] ShowMouse ref=0
6/6/2006 3:03:19 PM.609 VERBOSE [1] HideMouse ref=-1
6/6/2006 3:06:13 PM.859 VERBOSE [1] Loading recording list for next recording panel
6/6/2006 3:06:13 PM.859 VERBOSE [1] RecordingFactory.loadSchedule()
6/6/2006 3:06:13 PM.859 VERBOSE [1] getValue cached value: /settings/AutoRemoveMissingRecordings : true

[sub]

Can you zip and attach the complete log?

[congenictv]

Yup! Of course!

I tried attaching .log and .txt but this time i will try .zip

[sub]

Can you post the other logs aswell? I'd like to see what the other processes were doing at the time.

[congenictv]

Not sure which logs will be useful, so I've zipped up all the logs that were modified just slightly before this occured.

Thanks!

[congenictv]

Hi Sub,

I regularly get database lock error messages and it always occurs during playback of a previously recorded video.

I also get Error playback file error messages too.

I've attached my logs for you to see.

Thanks.

[sub]

Sorry, I dont really know. I cant see any obvious cause. I'll try some tests today with the resume prompting enabled to see if I have any success reproducing it. This is what seemed to be happening when the problem occurred.

[congenictv]

Thanks, I hope you figure it out. I hope it's not one of those stupid things that's specific to me (like i installed some weird plugin.) I hope it's not my pvr2 usb2 either. Or VNC server?

Thanks again hope you find a cause/solution.

[congenictv]

I'm still occassionally getting the sqlite database lock error message during playback of a recording (either from resume or not).

What usually happens is when I'm watching a video and I press skip >| on the remote or the keyboard you don't get a response. If you press skip again, no response, but after several seconds, it will actually skip the number of times you have pressed skip but then it immediately quits the playback and display the msg claiming the database file is locked.

If you press skip only once and you get no response, sometimes if you wait several seconds, it will actually skip and continue normal playback. If you try to skip again it may skip properly or it may exit and display the database file is locked message.

I've attached the logs of my most recent database lock event.

Thanks!

[sub]

Can you post a complete set of logs?

Do you set GB-PVR to auto convert recordings to some other format? (xvid/divx etc)