System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: 0cc0139c3933addd3d3b3a32f6d6ff4e44cfb8cf
Title: AccessViolationException on long running ExecuteNonQuery
Status: Closed Type: Incident
Severity: Important Priority: Medium
Subsystem: Integration_Via_PInvoke Resolution: Unable_To_Reproduce
Last Modified: 2013-03-15 01:07:02
Version Found In: 1.0.82.0
User Comments:
anonymous added on 2013-03-04 06:40:14: (text/x-fossil-plain)
In my .net windows application on executing ExecuteNonQuery on an opened SqliteConnection object, for deleting large amount records from database with a WHERE condition which takes a while to compare(there is a database function that decodes a string column's value and then applies a LIKE query), in between the query is getting executed, if we call Close() and then Dispose() methods of connection, our application crashes with System.AccessViolationException error. The brief stack trace is as below:

Description: The process was terminated due to an unhandled exception.
Exception Info: System.AccessViolationException
Stack:
   at System.Data.SQLite.UnsafeNativeMethods.sqlite3_changes(IntPtr)
   at System.Data.SQLite.SQLite3.get_Changes()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(System.Data.SQLite.SQLiteCommand, System.Data.CommandBehavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(System.Data.CommandBehavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()

mistachkin added on 2013-03-04 22:01:28: (text/x-fossil-plain)
Could you try upgrading to the latest released version of System.Data.SQLite and 
see if the issue is still present?