Re: [sqlite] 50MB Size Limit?
On Mon, 2005-04-11 at 11:28 -0400, Jonathan Zdziarski wrote: Greetings! I couldn't find any information on this via google or sqlite.org, so I'm hoping someone can answer this for me. We support SQLite v2.x and v3.x as storage backends in DSPAM. I've had a lot of users complain that they get 'Database Full' errors once their file hits 50MB in size, and so I'm wondering if there's a size limitation I should know about, and if there's any possible workaround. The most recent report of this is running 2.8.16. Will upgrading to 3.0 solve their problem? The size limits on SQLite v2 and v3 are like 4TiB - 2**42 bytes. There are no 50MB limits. Indeed, I create databases larger than 50MB on a regular basis. Are you sure your users are not, in fact, filling up their disk drives? -- D. Richard Hipp [EMAIL PROTECTED]
Re: [sqlite] 50MB Size Limit?
On Mon, 2005-04-11 at 12:05 -0400, Jonathan Zdziarski wrote: D. Richard Hipp wrote: Are you sure your users are not, in fact, filling up their disk drives? nope, plenty of free space on the drives. The 50MB limit seems to be very exact as well...exactly 51,200,000 bytes. I'm stumped too. quotas? -- G. Roderick Singleton [EMAIL PROTECTED] PATH tech
Re: [sqlite] 50MB Size Limit?
G. Roderick Singleton wrote: quotas? That crossed my mind, but all of these databases are being stored in system space (/usr/local/var/dspam) and owned by the mail system.
RE: [sqlite] 50MB Size Limit?
Mail system likely has a quota. Check this link: http://www.webservertalk.com/archive280-2004-6-280358.html -Original Message- From: Jonathan Zdziarski [mailto:[EMAIL PROTECTED] Sent: Monday, April 11, 2005 12:27 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] 50MB Size Limit? G. Roderick Singleton wrote: quotas? That crossed my mind, but all of these databases are being stored in system space (/usr/local/var/dspam) and owned by the mail system.
Re: [sqlite] 50MB Size Limit?
What about the os shells limit? Look at commands limit/ulimit/unlimit G. Roderick Singleton wrote: On Mon, 2005-04-11 at 12:05 -0400, Jonathan Zdziarski wrote: D. Richard Hipp wrote: Are you sure your users are not, in fact, filling up their disk drives? nope, plenty of free space on the drives. The 50MB limit seems to be very exact as well...exactly 51,200,000 bytes. I'm stumped too. quotas?
Re: [sqlite] 50MB Size Limit?
Jonathan Zdziarski wrote: D. Richard Hipp wrote: Are you sure your users are not, in fact, filling up their disk drives? nope, plenty of free space on the drives. The 50MB limit seems to be very exact as well...exactly 51,200,000 bytes. I'm stumped too. Assuming your application is called by the mail system: your mail delivery system may limit the size of files to 50MB using the 'setrlimit' system call. If you have source code you can check that easily. The 'bash' shell shows all resource limits with the command 'ulimit -a', maybe you can insert it in a script somewhere and find out what it's actually set to. BTW: sendmail (8.13.1) explicitly tries to set the file resource limit to 'infinity', which may fail if the hard limit was lowered. Gé