Hi, 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> Any idea ? I can make my own copy and rename ..that is probably what Vaccum does...but using vaccum would be very nice if it would work ok... Thanks Carlos -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of RSmith Sent: sexta-feira, 18 de Julho de 2014 15:41 To: General Discussion of SQLite Database Subject: Re: [sqlite] Vacuum command fails On 2014/07/18 16:30, Nelson, Erik - 2 wrote: > veeresh kumar wrote: > > >> Now I am running the the application on D: Drive (it has 841 GB free >> space) and C: drive has space (333 GB free). It looks like VACUUM >> uses C:drive space ??? Also command seems to be working fine... >> > Maybe I'm missing something, but I felt like this was pretty clearly answered before. > > PRAGMA temp_store_directory returns and controls the directory that is used for temp files. You can query it, and it will probably resolve to your C: drive, which is probably where your TEMP or TMP environment variables point. > > If your temp store directory doesn't have enough space, the VACUUM will fail. And to add, you can change this by changing the TEMP or TMP directive in your OS, it is not up to SQLite to decide where your OS intends temp files to be, but it is changable. _______________________________________________ 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
