Database is locked - v1.2.13

[tm12]

I've noticed this problem last week and again last night when I tried to update the EPG. The only add-ons on my system is the Community Skin and the Skin Plugin. Could this be locking the DB? Are there any utilities to help determine who is locking the DB?

Code:

2008-08-04 21:41:11.625    VERBOSE    [1]    Found potential match at 2008/08/06 08:30:00 PM  ()
2008-08-04 21:41:11.625    VERBOSE    [1]     - scheduling this episode
2008-08-04 21:41:11.625    VERBOSE    [1]    Looking for capture source to record: Top Gear Xtra
2008-08-04 21:41:11.625    VERBOSE    [1]    Possible capture device: DEVICE:Hauppauge PVR500:2
2008-08-04 21:41:11.625    VERBOSE    [1]    Checking 'PVR 500 with fm' (DEVICE:Hauppauge PVR500 with FM tuner:1)
2008-08-04 21:41:11.625    VERBOSE    [1]    Checking 'PVR 500 #2' (DEVICE:Hauppauge PVR500:2)
2008-08-04 21:41:11.625    VERBOSE    [1]    RecordingFactory.save()
2008-08-04 21:41:41.875    ERROR    [1]    Unabled to save ScheduledRecording: The database file is locked
database is locked
2008-08-04 21:41:41.875    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)
2008-08-04 21:41:41.875    VERBOSE    [1]    Requesting recording service schedule reload

[sub]

Try setting <LogSQL>true</LogSQL> in config.xml, then reboot and next time it happens zip and attach a complete set of logs and I'll take a look.

[tm12]

I've missing around on another PC trying to recreate the problem. I've set my capture devices like on my production PC. Then I started adding recurring recordings from the TV Guide. After adding a few recordings I found the database locked error.

Sub, I will try your suggestion and post the logs soon.

[tm12]

bump

[martint123]

Yes, the bump will be needed as an edit won't send an email notification, or appear as a "new" post to the boss that the thread has been updated. Always best to add a reply rather than an edit.

[tm12]

Thanks for the tip martin..... but I didn't get an email notification of your post either :confused:

[martint123]

Thanks for the tip martin..... but I didn't get an email notification of your post either :confused:

That only happens if you have your profile set up to subscribe to threads and to get an email. AFAIK.

[tm12]

I had an old email addy in my user profile :o

[tm12]

sub, let me know if you already have this on your to-do list and if I should stop bumping this thread.

[sub]

Sorry, I've looked into it but I dont know the cause, and was unable to reproduce it here.