Hello Arizona EDU admin (Chandler?),

I am sorry to hear you are having these problems.

Although it is possible that Bacula incremental has problems, it is unlikely.  There is more likely some other cause. I don't think you mentioned what version of Bacula you are running. Could you post the output from one of your successful backups.

You should be aware that the project no long support SQLite as it is not suitable for backups of the size we are seeing today.  We do leave the code in Bacula so that users can upgrade to MySQL or PostgreSQL at their ease rather than being forced.

That said, perhaps some of the Bacula users can help you. Otherwise, I suggest that reading the SQLite documentation might help you find a solution.   Good luck.

Best regards,
Kern

On 12/20/18 11:55 PM, ad...@genome.arizona.edu wrote:
Thanks all...

I think this problem has also caused a problem with bacula incremental backup, perhaps the accurate information?  If you look at my original post, can see the backup is quite large and a large amount of files... the incremental backup that was running (started on 12-15) was acting like a full backup... i think it was at 29 million files and over 3TB of data when i noticed something was wrong.  I did free up about 1GB on the / disk and that seemed to be enough for sqlite to get by now... i am able to do a restore, and the most recent incremental backup after 12-14 was only 35GB.

Would anyone here happen to know how i could tell the sqlite that bacula is using, to use a different location for temporary data? I did read that document that Martin mentioned and tried to set SQLITE_TMPDIR="/bacula/foo" before starting bconsole but it didn't seem to have any effect since the / disk still filled up with temporary data when the directory tree was being built.  So I guess it is using the PRAGMA temp_store_directory or the sqlite3_temp_directory global variable?  There isn't a /etc/sqlite.conf file or anything.... Anyone know how i could update that location?  Or maybe i need to ask sqlite community?

Thanks



_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users




_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to