Re: [Bacula-users] failed:,database is full
2011-08-08 06:33:33
-----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® 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
|
|
|