Hi, This is on a standard windows 7 64 bits laptop.
I am not using a shell command. I am using the win32/win64 precompiled Dlls. I will check the pragma integrity check... One thing I noticed before was that the maximum size for a blob inside a record field is much smaller than what I imagined. If I use blobs with more than 200 Mb, things go wrong when trying to read it back using the direct blob functions. I am going to check carefully if there is any other limit I am hitting because in this case the only difference between the database that fails and the database that works is that the working database has much smaller blobs...and proximately the same number of records. Regards. Carlos -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: sexta-feira, 18 de Julho de 2014 16:34 To: General Discussion of SQLite Database Subject: Re: [sqlite] Vacuum command fails On 18 Jul 2014, at 4:11pm, Carlos Ferreira <car...@csiberkeley.com> wrote: > I also have a problem with VACCUM. ( both 32 and 64 bits ) > > Whenever I deal with small databases, it works fine, but as soon as > the DB is more than 200 Mb, the vaccum command bails out with code 21. > <Library misused..> or <incorrect use of library> Is this on a standard type of computer, or in a small device ? If you use the VACUUM command from the SQLite shell tool (copy the database onto a standard computer if necessary), rather than your own application, do you get the same result ? Does your database show any corruption when you use "PRAGMA integrity_check;" ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users