-----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 >> <ala...@metrocast.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@sqlite.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
