Re: [sqlite] Vacuum command fails

On 18 Jul 2014, at 4:45pm, Carlos Ferreira wrote: > 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. Can you please check to see if using VACUUM in the shell tool has the same problem with

Re: [sqlite] Vacuum command fails

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 so

Re: [sqlite] Vacuum command fails

On 18 Jul 2014, at 4:11pm, Carlos Ferreira 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. > or Is

Re: [sqlite] Vacuum command fails

: [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 s

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

Re: [sqlite] Vacuum command fails

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

Re: [sqlite] Vacuum command fails

Hi Simon,, Happy to provide you with answers...Answers Inline... One thing i would like to know is does the VACUUM command uses C: drive space or the drive where my application is running...It seems like it requires C: drive to have enough space. On Thursday, 17 July 2014 2:14 PM, Simon

Re: [sqlite] Vacuum command fails

My earlier email didnt went due to size limit. May be it might come later. Here is my summary What I understood after this exercise i.e executing VACUUM command is - It requires C: drive free space and not the drive where your application is running. Since PRAGMA temp_store_directory is

Re: [sqlite] Vacuum command fails

On 2014/07/17 23:03, veeresh kumar wrote: I did google aswell :-)...I did set PRAGMA temp_store = 1 (PRAGMA temp_store = FILE). But it did not help. I get SQLITE_NOMEM error message. Might I offer one more possible (although probably not very likely) problem - I have just recently posted an

Re: [sqlite] Vacuum command fails

On 17 Jul 2014, at 10:03pm, veeresh kumar wrote: > I did google aswell :-)...I did set PRAGMA temp_store = 1 (PRAGMA temp_store > = FILE). But it did not help. I get SQLITE_NOMEM error message. What version of SQLite are you using ? The simplest way is probably to tell us

Re: [sqlite] Vacuum command fails

I did google aswell :-)...I did set PRAGMA temp_store = 1 (PRAGMA temp_store = FILE). But it did not help. I get SQLITE_NOMEM error message. Its not a space issue as I do have enough space in the hard drive. Whenver Vacuum command is executed, its using the RAM and thats were it goes out of

Re: [sqlite] Vacuum command fails

On 17 Jul 2014, at 6:24pm, veeresh kumar wrote: > I tried to execute Vacuum on the sqlite database of size 14GB and it failed > with an error "out of memory". What kind of error is this ? Are you getting SQLITE_NOMEM returned from a SQLite call or is this being returned

Re: [sqlite] Vacuum command fails

Luuk wrote: >so, 0 means temp is written to disk. >Back to the the question. >How much free disk space is there? >I think you need more than 14Gb of free space if your database is 14Gb in size. >http://lmgtfy.com/?q=sqlite+vacuum+how+much+disk+space+is+needed=1 >"This means that when

Re: [sqlite] Vacuum command fails

On 17-7-2014 21:11, Roger Binns wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 17/07/14 10:42, veeresh kumar wrote: When i execute the command PRAGMA temp_store, it returned me 0. What is the ideal value that needs to be set? A quick google search would have found the answer:

Re: [sqlite] Vacuum command fails

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 17/07/14 10:42, veeresh kumar wrote: > When i execute the command PRAGMA temp_store, it returned me 0. What is > the ideal value that needs to be set? A quick google search would have found the answer:

Re: [sqlite] Vacuum command fails

When i execute the command PRAGMA temp_store, it returned me 0. What is the ideal value that needs to be set? On Thursday, 17 July 2014 10:30 AM, Simon Slavin wrote: On 17 Jul 2014, at 6:24pm, veeresh kumar wrote: > I tried to execute Vacuum on

Re: [sqlite] Vacuum command fails

On 17 Jul 2014, at 6:24pm, veeresh kumar wrote: > I tried to execute Vacuum on the sqlite database of size 14GB and it failed > with an error "out of memory". I was under the impression that it copies the > database file and then performs vacuum on that file. Here it looks

[sqlite] Vacuum command fails

I tried to execute Vacuum on the sqlite database of size 14GB and it failed with an error "out of memory". I was under the impression that it copies the database file and then performs vacuum on that file. Here it looks like its using RAM. Appreciate your inputs from the experts.

Re: [sqlite] Vacuum command in a transaction?

On 2013/12/11 01:41, veeresh kumar wrote: Thanks Igor and Simon for your inputs. I was under the impression that VACUUM would also help performance since it does defragmentation. Hi Veeresh, Vacuum does de-fragment the database, it also amalgamates any transaction files and so on - so you

Re: [sqlite] Vacuum command in a transaction?

Thanks Igor and Simon for your inputs. I was under the impression that VACUUM would also help performance since it does defragmentation. On Tuesday, 10 December 2013 3:02 PM, Simon Slavin wrote: On 10 Dec 2013, at 8:04pm, veeresh kumar wrote: >

Re: [sqlite] Vacuum command in a transaction?

On 10 Dec 2013, at 8:04pm, veeresh kumar wrote: > -If we put inside a transaction, definitely we would get a SQLITE_BUSY > error.Any way to avoid this error? It is normal for SQL engines to prevent VACUUM inside a transaction, and to lock the database from other

Re: [sqlite] Vacuum command in a transaction?

On 12/10/2013 3:04 PM, veeresh kumar wrote: I wanted to know what is the good way to execute Vacuum command. - Inside a transaction or without transaction? Doesn't really matter (unless you want to combine it with other statements in a single transaction). VACUUM command is no different

[sqlite] Vacuum command in a transaction?

The database size that we use in the application can grow upto 50 GB. We have an option of shrinking the database using the Vacuum command. I understand that Vacuum command consumes lots of time to execute,but i dont see any other way. I wanted to know what is the good way to execute Vacuum

Re: [sqlite] VACUUM command issue

Thank you for your reply. Pragma wal_checkpoint gave reduced file size. But I still dont know why DB file size increased when I deleted all records .. Can you please clarify this issue? Thanks in advance. On 04-Jan-2012 5:42 PM, "Richard Hipp" wrote: On Wed, Jan 4, 2012 at

Re: [sqlite] VACUUM command issue

On Wed, Jan 4, 2012 at 6:52 AM, Tarun wrote: > Hi All, > > I am running program in which I have created SQLite DB file using: > sqlite3_open_v2() > > configured it: > > PRAGMA journal_mode = WAL > PRAGMA synchronous=OFF > > Then created one table into SQLiteDB by using

[sqlite] VACUUM command issue

Hi All, I am running program in which I have created SQLite DB file using: sqlite3_open_v2() configured it: PRAGMA journal_mode = WAL PRAGMA synchronous=OFF Then created one table into SQLiteDB by using sqlite3_exec() in which I passed SQL command of creating table. After configuration,

Re: [sqlite] VACUUM command not working

Thank you so much Richard. I have tried WAL and then applied VACUUM, it is working fine. Thanks again, Tarun Thakur On 8/19/11, Richard Hipp wrote: > On Thu, Aug 18, 2011 at 11:19 PM, Tarun wrote: > >> Hi All, >> >> I am running program in which I

Re: [sqlite] VACUUM command not working

On Thu, Aug 18, 2011 at 11:19 PM, Tarun wrote: > Hi All, > > I am running program in which I have created SQLite DB file using: > > sqlite3async_initialize() > The easiest solution to your problem might be simply to not use the test_async.c module. That module was

[sqlite] VACUUM command not working

Hi All, I am running program in which I have created SQLite DB file using: sqlite3async_initialize() sqlite3_open_v2() Then created one table into SQLiteDB by using sqlite3_exec() in which I passed SQL command of creating table. Then I inserted records into table using INSERT sql command in

Re: [sqlite] "Vacuum" command is failing with "SQL Error:Database or disk is full"

manohar s wrote: > Yes, the solution you suggested is working fine. But can't we change this > through SQLite? > > You can set the location SQLite will use for temporary files using pragma commands. See pragma_temp_store and pragma_temp_store_directory at

Re: [sqlite] "Vacuum" command is failing with "SQL Error:Database or disk is full"

Also, In linux whether these temporary files are created while vacuuming? If yes, can you tell me where will this be created? manohar On Tue, Mar 17, 2009 at 6:20 PM, manohar s wrote: > Yes, the solution you suggested is working fine. But can't we change this > through

Re: [sqlite] "Vacuum" command is failing with "SQL Error:Database or disk is full"

Yes, the solution you suggested is working fine. But can't we change this through SQLite? Thanks and Regards, Manohar.S On Wed, Mar 11, 2009 at 12:44 PM, Mihai Limbasan wrote: > manohar s wrote: > > Hi, > > I am trying to execute "PRAGMA page_size=4096; Vacuum;" on a

Re: [sqlite] "Vacuum" command is failing with "SQL Error:Database or disk is full"

manohar s wrote: > Hi, > I am trying to execute "PRAGMA page_size=4096; Vacuum;" on a SQLite DB(Size > 1.5 GB), On a drive which has 9 GB free space (But my C: has 150 MB free is > this an issue?). But it is failing with "SQL Error:Database or disk is full" > error everytime. SQLite version:

[sqlite] "Vacuum" command is failing with "SQL Error:Database or disk is full"

Hi, I am trying to execute "PRAGMA page_size=4096; Vacuum;" on a SQLite DB(Size 1.5 GB), On a drive which has 9 GB free space (But my C: has 150 MB free is this an issue?). But it is failing with "SQL Error:Database or disk is full" error everytime. SQLite version: 3.6.11. 1) Am I missing

[sqlite] Vacuum command

Hi all, I want to do a vacuum on my table. Can any one tell me whether the below statement is the valid syntax for the vacuum command. How can we make sure that the command is really executing or not. Will there be any time difference if we do the vacuum for a table? I tried inserting

Re: [sqlite] Vacuum Command

Persson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 02, 2006 10:33 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Vacuum Command I am new to SQLITE but in some other database vacuum want to have full controll test with Transaction as BEGIN EXCLUSIVE TRANSACTION test VACUUM [tableName] END

Re: [sqlite] Vacuum Command

(causing a SCHEMA_CHANGE) and then add this table back into the db? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 02, 2006 10:08 AM To: George Mavroudes Subject: Re: [sqlite] Vacuum Command GM> hi, GM> - I am pretty new to SQLITE

RE: [sqlite] Vacuum Command

: [sqlite] Vacuum Command I am new to SQLITE but in some other database vacuum want to have full controll test with Transaction as BEGIN EXCLUSIVE TRANSACTION test VACUUM [tableName] END TRANSACTION test // Anders George Mavroudes skrev: > Sorry for the omission and thanks for the qu

Re: [sqlite] Vacuum Command

George Mavroudes wrote: If I delete all records from a [tableName] and then execute the VACUUM command, will this temporarily delete the table (causing a SCHEMA_CHANGE) and then add this table back into the db? George, Yes, SQLite has an optimization which replaces a delete without a

RE: [sqlite] Vacuum Command

: [sqlite] Vacuum Command GM> hi, GM> - I am pretty new to SQLITE and I am having a problem with the GM> following sequence of commands: GM> - DELETE FROM [tableName] GM> - VACUUM [tableName] GM> The project I am working on has multiple threads

Re: [sqlite] Vacuum Command

GM> hi, GM> - I am pretty new to SQLITE and I am having a problem with the GM> following sequence of commands: GM> - DELETE FROM [tableName] GM> - VACUUM [tableName] GM> The project I am working on has multiple threads Reading / Writing to this GM> table and other

[sqlite] Vacuum Command

hi, - I am pretty new to SQLITE and I am having a problem with the following sequence of commands: - DELETE FROM [tableName] - VACUUM [tableName] The project I am working on has multiple threads Reading / Writing to this table and other tables, and after