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

2009-03-18 Thread Dennis Cote
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 http://www.sqlite.org/pragma.html#modi

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

2009-03-17 Thread manohar s
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 SQLite? > > Thanks and Re

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

2009-03-17 Thread manohar s
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 SQLite > DB(Size > > 1.5 GB

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

2009-03-11 Thread Mihai Limbasan
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: 3.6.1

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

2009-03-10 Thread manohar s
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 anythin