Re: [sqlite] Database is full warnings
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
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
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
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
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
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
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
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
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
Re: [sqlite] Database is full warnings
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
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