Database locked exception

[bgowland]

I know accessing the gbpvr DB directly isn't approved but I've got a slightly confusing error.

I can create a DataAdapter and Dataset with VS dataset designer and execute the query I want without any problems. When I try to do it within a plugin (in PVRX2), I get this in the log file...

Code:

2007-10-20 18:41:54.157    VERBOSE    [1]    System.Data.SQLite.SQLiteException: The database file is locked
Unable to close due to unfinalised statements
   at System.Data.SQLite.SQLiteConnectionHandle.ReleaseHandle()
   at System.Runtime.InteropServices.CriticalHandle.Cleanup()
   at System.Runtime.InteropServices.CriticalHandle.Dispose(Boolean disposing)
   at System.Runtime.InteropServices.CriticalHandle.Dispose()
   at System.Data.SQLite.SQLite3.Close()
   at System.Data.SQLite.SQLiteConnection.Close()
   at System.Data.Common.DbDataAdapter.QuietClose(IDbConnection connection, ConnectionState originalState)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at DVB_T_Radio.CapSourcesTableAdapters.BDA_RECORDING_SOURCETableAdapter.Fill(BDA_RECORDING_SOURCEDataTable dataTable) in C:\Documents and Settings\gbpvr\My Documents\Visual Studio 2005\Projects\DVB-T Radio\CapSources.Designer.cs:line 636
   at DVBTRadio.DVBTRadio.Activate() in C:\Documents and Settings\gbpvr\My Documents\Visual Studio 2005\Projects\DVB-T Radio\DVB-T Radio.cs:line 26

Why does it work in VS but not in PVRX2?

Cheers,
Brian

[sub]

I've never really used the DataAdapter and Dataset classes, so cant provide you any insights into this. It sounds like its doing a select but then not reading the data so the database is left in a locked state.

BTW, there is a bug in PVRX2 that can cause Activate() to be called twice on a plugin, which may have some bearing on this...

[bgowland]

BTW, there is a bug in PVRX2 that can cause Activate() to be called twice on a plugin, which may have some bearing on this...

OK - thanks I'll move the DB code to a separate method to test it out.

Cheers,
Brian

[bgowland]

Well I can confirm that it's not that Activate() is called twice. I moved the datatable/tableadapter code into a method invoked by a test button and got the same exception.

I then tried 'old school' SQLite connection, command and datareader but still had the same problem.

The plugin has an associated external console app. so I tried to add a datatable and adapter to that - VS let me but I couldn't work out how to reference it. :confused:

Finally I tried 'old school' coding in the console app. and it works perfectly.

I'll give up programming one of these days - nuthin's ever simple.

Cheers,
Brian