Database locked when deleting or setting to record

[mkenyon2]

This is getting frustrating. I know you're busy sub, but this happens off and on a lot lately.

Deletes (from the default recordings screen) delete the folder, but the database entry is still there, showing up.

Recordings, from both the local PC through TV Guide and through EWA hit this issue.

[sub]

Can you tell me what plugins you have installed?

[mkenyon2]

Thanks for looking into this:
Skip Tool
International Cinema listing
Web Cams
Game Zone 2 (happened before I put this on)
MovieWiz
Video Archive (Only for DVD to Mpeg)
Netflix Watch Now alpha
Music Library 2
Caller ID

[mkenyon2]

Another thought... this started happening in this version, but also seemed to be linked to when I'm running SkipTool (hate to lay the blame) to edit commercials and transcode.

[sub]

Usually with these "database locked" errors in the past, its been fairly easy for me to look at the SQL statements in the logs and identify the cause, but I cant see it in your logs, which makes me think its a plugin (since they dont log their SQL statements).


Unfortunately I dont have any good suggestion for tracking it down though, other than selectively disabling plugins to try to narrow down the cause. You've got a big list too, so that could be a painful experience and could take a while.

[mkenyon2]

A few of the items don't use the database, like Game Zone and Caller ID.

MS SQL has a trace tool. Is there anything like this for your db?

[sub]

MS SQL has a trace tool. Is there anything like this for your db?

When I was looking into your problem this morning I looked for something like this, but I dont think a similar exists for SQLite.

I had also looked in the past but never found an equivalent, which is why I've added SQL logging functionality to GBPVR, but that only works for stuff I've written, so unfortunately I have no visiblility of any SQL that plugins perform.

[mkenyon2]

If folks use GBPVR.Public in their plugins, can you track it?
http://forums.nextpvr.com/showthread.php...post272009

[sub]

If he is using APIs I've provided for doing stuff like getting a list of recordings etc, then that stuff would be logged. If he is just using GBPVR.Public to get a database connection, then I wont see any SQL executed against that connection.