SQLITE Error causing crash

[Jeff]

This may belong in the development thread. I get the following error

7/9/2006 10:04:18 PM.878 ERROR [2] FATAL UNHANDLED EXCEPTION:: System.Data.SQLite.SQLiteException: The database file is locked
Unable to close due to unfinalised statements
at System.Data.SQLite.SQLite3.Close()
at System.Data.SQLite.SQLiteConnection.Close()
at System.Data.SQLite.SQLiteConnection.Dispose(Boolean disposing)
at System.ComponentModel.Component.Finalize()

It happens while I am stress-testing a plug-in I am writing to do EPG searches. The plug-in directly accessing the database to do the querries. I am opening and closing the database often in rapid succession. It seems that GBPVR is doing something on a background thread and this problem comes up, sometimes right away sometimes after a while. I have the Visual Studio Express Edition so I don't have the tool that displays background threads so I don;t know what is causing this. I do know, however, that it is not one of my threads.

Jeff

[sub]

Its hard to guess. GB-PVR does lots of things in the background that could lock the database for short time (ie, any data change)

Have a look in the logs around the same time.

[Jeff]

I have. I assume that [2] is the thread ID? If so, that is the first message logged by that thread. Oddly enough, if I ignore the error (i.e., don't acknowledge the dialog box asking if I want to debug) both GBPVR and my plug-in continue to run fine.

Jeff