System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: 3140bd9437d01ec083b0cd51a80ca98eedc61055
Title: Many new sqlite debug error messages
Status: Closed Type: Incident
Severity: Minor Priority: Medium
Subsystem: Integration_Via_PInvoke Resolution: Unable_To_Reproduce
Last Modified: 2012-02-29 14:56:27
Version Found In: 1.0.79
Description:
(vs2010, winforms, .net 4, 1.0.79 x32 statically linked)

These are some errors I am seeing in code that has run without them for over a year with older version of system.data.sqlite. The error 17 is strange, does this mostly occur with the '*' wildcard?

SQLite error (21): API called with finalized prepared statement SQLite error (21): misuse at line 62706 of [ebd01a8def] SQLite error (21): API called with finalized prepared statement SQLite error (21): misuse at line 62706 of [ebd01a8def] SQLite error (21): API called with finalized prepared statement SQLite error (21): misuse at line 62706 of [ebd01a8def] SQLite error (21): API called with finalized prepared statement SQLite error (21): misuse at line 62706 of [ebd01a8def] SQLite error (21): API called with finalized prepared statement SQLite error (21): misuse at line 62706 of [ebd01a8def] ... SQLite error (17): statement aborts at 24: [SELECT * FROM `main`.`Attribute` WHERE (IsDeleted IS NULL OR IsDeleted = 0)] database schema has changed

-- welcome to the forums!


anonymous added on 2012-02-24 19:31:32 UTC:
I mean x86.


mistachkin added on 2012-02-25 00:17:34 UTC:
Do you have a C# code sample which demonstrates the problem? These message by themselves are relatively benign and typically result from not explicitly disposing of the SQLiteConnection and SQLiteDataReader objects.