System.Data.SQLite

Login
This project makes use of Eagle, provided by Mistachkin Systems.
Eagle: Secure Software Automation
Ticket Hash: 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!

<hr /><i>anonymous added on 2012-02-24 19:31:32 UTC:</i><br />
I mean x86.


<hr /><i>mistachkin added on 2012-02-25 00:17:34 UTC:</i><br />
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.