-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 06/08/2011 04:20, terryc wrote:
> woops, list this time.
> 
> Konstantin Khomoutov wrote:
>> On Fri, 05 Aug 2011 13:11:09 -0400 Phil Stracchino 
>> <alaric AT metrocast DOT net> wrote:
>> 
>> [...]
>>> You know, he did just say he's using sqlite.
>> According to [1], the limits on the database size are mostly 
>> imposed by the OS. So maybe certain things worth checking: 1) If 
>> /proc/$sd_pid/limits indicates some limit on the file size for the 
>> SD process? 2) Is it possible that a file system-imposed limit is 
>> hit (see [2] for instance)? 3) No space left on device? (Does not 
>> sound like this but who knows how bacula interprets such an error 
>> returned from the sqlite backend?)
> 
> Unfortunately not 2 or 3.

Hello,

Found this while Googling:

http://www.mail-archive.com/sqlite-users AT sqlite DOT org/msg10902.html
- -----------------
I believe that SQLite will return with an SQLITE_FULL error if your run
out of disk space, OR if the value of the inserted row's rowid or INTEGER
PRIMARY KEY AUTOINCREMENT column exceeds a maximum value (2147483647 on a
32 bit, 9223372036854775807 on a 64 bit).

[...]

To check the second condition you could "SELECT max(rowid) from category;"
and see if you are at or near the maximum value for your platform.
- -----------------

If that's not the case either, your best bet is to take this up with the
SQLite developers, or to migrate to a 'proper' database backend like
MySQL or postgres. (The Bacula manual does state 'we do not recommend it
[SQLite] for production use'.
http://www.bacula.org/5.0.x-manuals/en/main/main/Installing_Configuring_SQLi.html)


Greetings,
      Michel
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (MingW32)

iEYEARECAAYFAk4/tdwACgkQ2Vs+MkscAyWccACdGQvjYeuJE4CfHMeJXb6ukLD5
S2sAoPC6K5l66yJldwlHx9D1zCnZGlxG
=wN89
-----END PGP SIGNATURE-----

------------------------------------------------------------------------------
BlackBerry&reg; DevCon Americas, Oct. 18-20, San Francisco, CA
The must-attend event for mobile developers. Connect with experts. 
Get tools for creating Super Apps. See the latest technologies.
Sessions, hands-on labs, demos & much more. Register early & save!
http://p.sf.net/sfu/rim-blackberry-1
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users