System.Data.SQLite

Login
This project makes use of Eagle, provided by Mistachkin Systems.
Eagle: Secure Software Automation
Ticket Hash: 2abbf2c2446537e8be164a53f73615c7723bb82d
Title: incremental_vacuum does not work
Status: Closed Type: Incident
Severity: Important Priority: Medium
Subsystem: Integration_Via_PInvoke Resolution: Unable_To_Reproduce
Last Modified: 2016-06-21 20:18:36
Version Found In: 1.0.101.0
User Comments:
anonymous added on 2016-06-15 18:23:36: (text/x-fossil-plain)
I have a db with "pragma auto_vacuum = incremental", when I try to run "pragma incremental_vacuum" by C# SQLite, then nothing happens. When I do the same from SQLiteStudio (sqlite_version 3.8.10), then the db file shrinks.
I use Dapper to execute commands, I have tried


conn.Execute("pragma incremental_vacuum");
conn.Query("pragma incremental_vacuum");

both with no result. I am sure no other connection is opened at the time the commands are issued.

mistachkin added on 2016-06-15 20:26:17: (text/x-fossil-plain)
This issue does not reproduce.  Test case added on trunk via check-in [8f68a04dccdcd107].