Recording service error

[Dava]

Hi,

I am repeatedly getting the folling in the recording service log:

at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at GBPVR.RecordingService.x92f6085038c83bb7.x4fa2bfc067e20d05(Int32 x0f7b9658643bceb7)
06/11/2006 19:26:33.171 VERBOSE [12] RecordingFactory.loadScheduleRecordingByOID()
06/11/2006 19:26:33.171 VERBOSE [12] Removing non existant file from conversion queue. OID = 5
06/11/2006 19:27:06.171 ERROR [12] Unexpected error removing recording from conversion queue: 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.RecordingService.x92f6085038c83bb7.x4fa2bfc067e20d05(Int32 x0f7b9658643bceb7)
06/11/2006 19:28:06.171 VERBOSE [12] RecordingFactory.loadScheduleRecordingByOID()
06/11/2006 19:28:06.171 VERBOSE [12] Removing non existant file from conversion queue. OID = 5
06/11/2006 19:28:39.156 ERROR [12] Unexpected error removing recording from conversion queue: 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.RecordingService.x92f6085038c83bb7.x4fa2bfc067e20d05(Int32 x0f7b9658643bceb7)
06/11/2006 19:29:39.156 VERBOSE [12] RecordingFactory.loadScheduleRecordingByOID()
06/11/2006 19:29:39.156 VERBOSE [12] Removing non existant file from conversion queue. OID = 5

What should I do?

[sub]

Set <LogSQL>true</LogSQL> in config.xml, then restart all the software (or reboot), then next time the problem occurs, zip and attach a complete set of logs.

[Dava]

Set <LogSQL>true</LogSQL> in config.xml, then restart all the software (or reboot), then next time the problem occurs, zip and attach a complete set of logs.

Please see attached.

Do you think that this could have anything to do with the unit not going to standby when idle? It seems to repeat at 2 minute intervals.

[sub]

I think its somehow related to the auto conversion of video files.

I'm not really sure, but can see if this patch helps: http://forums.gbpvr.com/showpost.php?p=151661

[Dava]

Thanks for the immediate response.. again.

I am recording at the moment so will give it a whirl in half an hour.

[Dava]

No joy, I get the same error. Should I replace gbpvr.db3 with empty.db3?

[sub]

Did you restart all GB-PVR processes?

[Dava]

I stopped the recording service, replaced the file and then restarted the service. GBPVR was not running. Was that OK?

Normally, I would have rebooted but I am hooked! I keep recording things. This software is great!

[sub]

It might be worth a reboot first, then zip and attach the logs again when the error happens again.

[Dava]

These are after a reboot. I checked the versions of the patch that you provided against the original and the patch is there.