Re: [sqlite] Database is full warnings

[Ray Irvine]

Simon:

Thank you - let me run all this to ground.

Ray


On Sep 10, 2011, at 12:40 PM, Simon Slavin wrote:

> 
> On 10 Sep 2011, at 8:28pm, Ray wrote:
> 
>> I am using the Sqlite3 API.
>> 
>> Why is so much free disc required?
> 
> The error you reported means "I have run out of free space on a disk.".
> 
> SQLite makes temporary files while you use it.  If you use some APIs these 
> temporary files go in the same folder as the database.  If you use other APIs 
> these temporary files go on the boot disk.
> 
> On some operating systems the OS demands to have a lot of space free space on 
> the boot disk so it has space to do its own things.  So if you are using a 
> database on a different disk it would complain only if free space was zero, 
> but if you are using a database on a boot disk it might refuse to give you 
> any more disk space if it has less than, perhaps, 10 Gigabytes free.  This is 
> not a function of SQLite, it's the way the operating system works.
> 
> 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

Re: [sqlite] Database is full warnings

[Ray Irvine]

My mistake - sorry!

On Sep 10, 2011, at 12:30 PM, Richard Hipp wrote:

> On Sat, Sep 10, 2011 at 3:28 PM, Ray  wrote:
> 
>> I am using the Sqlite3 API.
>> 
> 
> If you are using the sqlite3 API, then why is the warning message about the
> sqlite2 API?  Is that a bug in PHP?
> 
> 
>> 
>> Why is so much free disc required?
>> 
>> I will the real answers from my hosting service
>> 
>> 
>> 
>> 
>> 
>> Sent from my iPad
>> 
>> On Sep 10, 2011, at 12:09 PM, Simon Slavin  wrote:
>> 
>>> 
>>> On 10 Sep 2011, at 7:47pm, Ray Irvine wrote:
>>> 
 [09-Sep-2011 09:10:20] PHP Warning:  sqlite_exec() [> href='function.sqlite-exec'>function.sqlite-exec]: database is full in
>> /home/xx/00build/include/t02enterreg.inc on line 738
>>> 
>>> Are you using the sqlite3 API for PHP or are you using the PDO API ?
>>> 
>>> Do you have plenty of free space on the disk the database is stored on ?
>>> Do you have plenty of free space on the disk that that server is booted
>> from ?
>>> 
>>> By 'plenty' I mean 'at least 10 Gigabytes'.
>>> 
>>> 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
>> 
> 
> 
> 
> -- 
> D. Richard Hipp
> d...@sqlite.org
> ___
> 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] Database is full warnings

[Luuk]

On 10-09-2011 21:48, Simon Slavin wrote:
> 
> On 10 Sep 2011, at 8:47pm, Luuk wrote:
> 
>> Should that 10Gb not be, if free space drops below 10% of diskspace?
> 
> You are sort of correct.  It is different things -- sometimes a percentage, 
> sometimes a fixed number -- in different OS and different versions.  I quoted 
> 10Gig to show the OP that I meant a /big/ amount of free space, not an amount 
> of space perhaps only as big as the database file.
> 

ok, thanks

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

Re: [sqlite] Database is full warnings

[Simon Slavin]

On 10 Sep 2011, at 8:47pm, Luuk wrote:

> Should that 10Gb not be, if free space drops below 10% of diskspace?

You are sort of correct.  It is different things -- sometimes a percentage, 
sometimes a fixed number -- in different OS and different versions.  I quoted 
10Gig to show the OP that I meant a /big/ amount of free space, not an amount 
of space perhaps only as big as the database file.

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

Re: [sqlite] Database is full warnings

[Luuk]

On 10-09-2011 21:40, Simon Slavin wrote:
> 
> On 10 Sep 2011, at 8:28pm, Ray wrote:
> 
>> I am using the Sqlite3 API.
>>
>> Why is so much free disc required?
> 
> The error you reported means "I have run out of free space on a disk.".
> 
> SQLite makes temporary files while you use it.  If you use some APIs these 
> temporary files go in the same folder as the database.  If you use other APIs 
> these temporary files go on the boot disk.
> 
> On some operating systems the OS demands to have a lot of space free space on 
> the boot disk so it has space to do its own things.  So if you are using a 
> database on a different disk it would complain only if free space was zero, 
> but if you are using a database on a boot disk it might refuse to give you 
> any more disk space if it has less than, perhaps, 10 Gigabytes free.  This is 
> not a function of SQLite, it's the way the operating system works.
> 
> Simon.

Should that 10Gb not be, if free space drops below 10% of diskspace?

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

Re: [sqlite] Database is full warnings

[Simon Slavin]

On 10 Sep 2011, at 8:28pm, Ray wrote:

> I am using the Sqlite3 API.
> 
> Why is so much free disc required?

The error you reported means "I have run out of free space on a disk.".

SQLite makes temporary files while you use it.  If you use some APIs these 
temporary files go in the same folder as the database.  If you use other APIs 
these temporary files go on the boot disk.

On some operating systems the OS demands to have a lot of space free space on 
the boot disk so it has space to do its own things.  So if you are using a 
database on a different disk it would complain only if free space was zero, but 
if you are using a database on a boot disk it might refuse to give you any more 
disk space if it has less than, perhaps, 10 Gigabytes free.  This is not a 
function of SQLite, it's the way the operating system works.

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

Re: [sqlite] Database is full warnings

[Richard Hipp]

On Sat, Sep 10, 2011 at 3:28 PM, Ray  wrote:

> I am using the Sqlite3 API.
>

If you are using the sqlite3 API, then why is the warning message about the
sqlite2 API?  Is that a bug in PHP?


>
> Why is so much free disc required?
>
> I will the real answers from my hosting service
>
>
>
>
>
> Sent from my iPad
>
> On Sep 10, 2011, at 12:09 PM, Simon Slavin  wrote:
>
> >
> > On 10 Sep 2011, at 7:47pm, Ray Irvine wrote:
> >
> >> [09-Sep-2011 09:10:20] PHP Warning:  sqlite_exec() [ href='function.sqlite-exec'>function.sqlite-exec]: database is full in
> /home/xx/00build/include/t02enterreg.inc on line 738
> >
> > Are you using the sqlite3 API for PHP or are you using the PDO API ?
> >
> > Do you have plenty of free space on the disk the database is stored on ?
> > Do you have plenty of free space on the disk that that server is booted
> from ?
> >
> > By 'plenty' I mean 'at least 10 Gigabytes'.
> >
> > 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
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Database is full warnings

[Ray]

I am using the Sqlite3 API.

Why is so much free disc required?

I will the real answers from my hosting service





Sent from my iPad

On Sep 10, 2011, at 12:09 PM, Simon Slavin  wrote:

> 
> On 10 Sep 2011, at 7:47pm, Ray Irvine wrote:
> 
>> [09-Sep-2011 09:10:20] PHP Warning:  sqlite_exec() [> href='function.sqlite-exec'>function.sqlite-exec]: database is full in 
>> /home/xx/00build/include/t02enterreg.inc on line 738
> 
> Are you using the sqlite3 API for PHP or are you using the PDO API ?
> 
> Do you have plenty of free space on the disk the database is stored on ?
> Do you have plenty of free space on the disk that that server is booted from ?
> 
> By 'plenty' I mean 'at least 10 Gigabytes'.
> 
> 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

Re: [sqlite] Database is full warnings

[Ray Irvine]

Sample message:

[09-Sep-2011 09:10:20] PHP Warning:  sqlite_exec() [function.sqlite-exec]: database is full in 
/home/xx/00build/include/t02enterreg.inc on line 738


On Sep 10, 2011, at 11:43 AM, Luuk wrote:

> On 10-09-2011 19:45, Ray wrote:
>> 
>> I am using sqlite on an application that run on a hosting service.  After 
>> some 18 months, I have started to see a few database is full warnings from 
>> my PHP application.   I will receive a warning but all appears well with the 
>> database.   The application uses four databases and the warning has occurred 
>> on more than one but not always the same one.  It appears on and INSERT of 
>> UPDATE functions.  The frequency is 1 warning every two weeks or so. The 
>> Database are around 5MB each 
>> 
>> Any ideas on why and what I can do to prevent this?
>> 
>> Thanks
> 
> Copy the FULL text of the error/warning here...
> (people reading this dont have a crystal ball ;)
> 
> 
> 
> ___
> 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] Database is full warnings

[Luuk]

On 10-09-2011 19:45, Ray wrote:
> 
> I am using sqlite on an application that run on a hosting service.  After 
> some 18 months, I have started to see a few database is full warnings from my 
> PHP application.   I will receive a warning but all appears well with the 
> database.   The application uses four databases and the warning has occurred 
> on more than one but not always the same one.  It appears on and INSERT of 
> UPDATE functions.  The frequency is 1 warning every two weeks or so. The 
> Database are around 5MB each 
> 
> Any ideas on why and what I can do to prevent this?
> 
> Thanks

Copy the FULL text of the error/warning here...
(people reading this dont have a crystal ball ;)



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

[sqlite] Database is full warnings

[Ray]

I am using sqlite on an application that run on a hosting service.  After some 
18 months, I have started to see a few database is full warnings from my PHP 
application.   I will receive a warning but all appears well with the database. 
  The application uses four databases and the warning has occurred on more than 
one but not always the same one.  It appears on and INSERT of UPDATE functions. 
 The frequency is 1 warning every two weeks or so. The Database are around 5MB 
each 

Any ideas on why and what I can do to prevent this?

Thanks
Sent from my iPad
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users