Re: [sqlite] VACUUM causes Out of memory error

2016-11-03 Thread Richard Hipp
On 11/3/16, Christian Czech wrote: > > This bug in a release version did a lot of damage to us. > > Especially frustrating was that nobody really cared when I reported it: We cared, and we looked into the problem, but we couldn't reproduce it at that time. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] VACUUM causes Out of memory error

2016-11-03 Thread Christian Czech
sqlite is a great tool! And I also use (and bought) the SEE version. This bug in a release version did a lot of damage to us. Especially frustrating was that nobody really cared when I reported it: - We have a problem with the latest stable release of SQLite. When compiled for 32 bit und

Re: [sqlite] VACUUM causes Out of memory error

2016-11-02 Thread Bernardo Sulzbach
On 11/02/2016 05:18 PM, Christian Czech wrote: It is a fundamental bug. I hope one day it gets fixed. Otherwise 3.15.0 is useless. It has been fixed: http://www.sqlite.org/src/info/3028845329c9b7ac -- Bernardo Sulzbach http://www.mafagafogigante.org/ mafagafogiga...@gmail.com

Re: [sqlite] VACUUM causes Out of memory error

2016-11-02 Thread Christian Czech
I already reported this in this forum a while ago but nobody cared. It is only in the 32bit version when RAM usage gets over 2GB on windows. On 64 bit of course this does not come up if u have enough ram. It is only with 3.15.0. It is easy to reproduce. Problem is that intermediate temp file

Re: [sqlite] VACUUM causes Out of memory error

2016-11-02 Thread Richard Hipp
On 11/2/16, Dan Kennedy wrote: > > We can reproduce it here now too. There will likely be a fix soon... > Dan's fix has been checked in and is available in the "Pre-release Snapshot" on the download page. https://www.sqlite.org/download.html -- D. Richard Hipp d...@sqlite.org _

Re: [sqlite] VACUUM causes Out of memory error

2016-11-02 Thread Dan Kennedy
On 11/02/2016 09:36 PM, Ralf Junker wrote: I am the author of the DISQLite3 Delphi wrapper. Assurance to all DISQLite3 users: The leak is not DISQLite3 specific. DISQLite3 5.15.0 behaves exactly like the official SQLite 3.15.0 release. The problem can reliably be reproduced using the official

Re: [sqlite] VACUUM causes Out of memory error

2016-11-02 Thread Ralf Junker
I am the author of the DISQLite3 Delphi wrapper. Assurance to all DISQLite3 users: The leak is not DISQLite3 specific. DISQLite3 5.15.0 behaves exactly like the official SQLite 3.15.0 release. The problem can reliably be reproduced using the official sqlite3.exe 3.15.0 binary on Win32. Bisec

Re: [sqlite] VACUUM causes Out of memory error

2016-11-02 Thread Donald Griggs
Stephan, I don't have the skills to fix your difficulty, but FWIW, I did reproduce your symptom using the database you provided in case that helps others diagnose it properly. I used: -- SQLite version 3.15.0 -- official command line utility -- Windows 7 -- 16GB installed ram, plenty of hard driv

[sqlite] VACUUM causes Out of memory error

2016-11-02 Thread Hennekens, Stephan
Hello, Since last version of sqlite (3.15.0) VACUUM causes an 'Out of memory' error, at least on my bigger databases (> 1 Gb). I came across this error when I installed the latest DISQLite3 version (http://www.yunqa.de/delphi/products/sqlite3/index). I was also able to reproduce the error whe