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

[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#modify.

HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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 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), 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 anything here?
>> >
>> > Regards,
>> > manohar.S
>> >
>> The error refers to the file system hosting the temporary files
>> location. Try setting the TEMP environment variable to a location with
>> more free space, reboot your system, and it willwork. It's actually a
>> really bad idea to have little space ont he file system hosting the
>> temporary file location...
>>
>> HTH,
>> Mihai
>> ___
>> 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

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

[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), 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 anything here?
> >
> > Regards,
> > manohar.S
> >
> The error refers to the file system hosting the temporary files
> location. Try setting the TEMP environment variable to a location with
> more free space, reboot your system, and it willwork. It's actually a
> really bad idea to have little space ont he file system hosting the
> temporary file location...
>
> HTH,
> Mihai
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
hope is the only thing which keeps us all happy
http://sqlyog.wordpress.com/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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.11.
>
> 1) Am I missing anything here?
>
> Regards,
> manohar.S
>   
The error refers to the file system hosting the temporary files 
location. Try setting the TEMP environment variable to a location with 
more free space, reboot your system, and it willwork. It's actually a 
really bad idea to have little space ont he file system hosting the 
temporary file location...

HTH,
Mihai
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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 anything here?

Regards,
manohar.S
-- 
hope is the only thing which keeps us all happy
http://sqlyog.wordpress.com/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users