SQL database locked (random, restart services normally fixes it)

[SFX Group]

Hi

Current version installed it v3.3.8, have a client running (same version), i sometimes get the below message, the only fix is to restart the NPVR service (which can hang for a few minutes on restart)....

I also have some XBMC looking at this server as well...

Has this got anything to do with the client or XBMC's?

The server is XP 64bit (i have got to upgrade the server, however no money at present).

[mvallevand]

My observation is that some of the sqlite update operations are not fully thread or multi-user safe. You'd need to post all the logs to see what operation might have been involved.

Martin

[SFX Group]

My observation is that some of the sqlite update operations are not fully thread or multi-user safe. You'd need to post all the logs to see what operation might have been involved.

Martin

Next time it happens, i'll post logs to this thread....

[gEd]

I say this to everyone who experiences a database locked message, make sure you disable "updateEPG during live TV" in the config. It may be completely unrelated to your issue but it is a simple thing to check.

[SFX Group]

I had a message on the screen, however i dont use this server (its a DNS and Webserver), so i dont know whne it appeared.

I also dont really use NPVR at the moment (no recording or watching TV), however it is runing and XBMC clients are pulling there EPG from it. Logs enclosed.

Dates will be 24 Dec 2014 - 4 Jan 2015 (10 days).

[mvallevand]

I had a message on the screen, however i dont use this server (its a DNS and Webserver), so i dont know whne it appeared.

I also dont really use NPVR at the moment (no recording or watching TV), however it is runing and XBMC clients are pulling there EPG from it. Logs enclosed.

Dates will be 24 Dec 2014 - 4 Jan 2015 (10 days).

I don't think it was a locked error, but there was a bad return from Schedules Direct

2015-01-04 04:03:38.098 [DEBUG][9] Requesting program details for 75 new shows
2015-01-04 04:03:41.286 [DEBUG][9] Got /programs
2015-01-04 04:03:55.989 [ERROR][9] Unexpected error processing chunk: Newtonsoft.Json.JsonReaderException: Unexpected character encountered while parsing value: <. Path '', line 0, position 0.
at Newtonsoft.Json.JsonTextReader.ParseValue()
at Newtonsoft.Json.JsonTextReader.ReadInternal()
at Newtonsoft.Json.JsonTextReader.Read()
at Newtonsoft.Json.Linq.JObject.Load(JsonReader reader)
at Newtonsoft.Json.Linq.JObject.Parse(String json)
at NShared.SchedulesDirectJSONEPGSource.ProcessChunk(List`1 channelsChunk, IEPGUpdateCallback callback)
at NShared.SchedulesDirectJSONEPGSource.UpdateEPG(IEPGUpdateCallback callback)

Maybe look into the event viewer for other errors.

Martin

[SFX Group]

Hi

Thanks, so does this mean we are not sure why this error is happening?