Bacula-users

[Bacula-users] Bacula filling /var/tmp with sqlite journal

2008-09-11 23:35:36
Subject: [Bacula-users] Bacula filling /var/tmp with sqlite journal
From: Jason Dixon <jdixon AT omniti DOT com>
To: bacula-users AT lists.sourceforge DOT net
Date: Thu, 11 Sep 2008 23:35:14 -0400
Our bacula server filled up /var this evening.  This was highly unusual,
as bacula doesn't use anything in /var.  We have a couple of partitions
(/data1, /data2) that are used for bacula's home and file storage,
respectively.

The weird thing was that df showed /var full, but du said there was
plenty available.  A quick lsof led me to the culprit:

884763 /var/tmp/etilqs_5nJ3kcue9bdlJYt (deleted)
bacula-di  5462    bacula   84u      REG                9,2           0
884764 /var/tmp/etilqs_qj5l8xY6x5BcTC3-journal (deleted)

After more searching I realized this was due to the temp_store_directory
pragma for SQLite.  We started a new backup job today for our Zimbra
server, and it appears that the SQLite update created a hot journal that
was large enough to fill /var.  I've repaired the situation and have
symlinked /var/tmp to /data1/tmp as a temporary measure.

Long term, I'd like to find out what our best option is.  Is there any
way for bacula to set the temp_store_directory pragma based on a setting
of my choosing (or perhaps TMPDIR)?  I don't know how or when bacula-dir
performs the locks for updates, so I'm not sure that simply logging in
and setting the pragma manually on the database file will be sufficient.


P.S.  That single journal got to at least 3.5G in size.  Who knows how 
large it could have gotten if it hadn't run out of space.  :(

Thanks,

-- 
Jason Dixon
OmniTI Computer Consulting, Inc.
jdixon AT omniti DOT com
443.325.1357 x.241 

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

<Prev in Thread] Current Thread [Next in Thread>
  • [Bacula-users] Bacula filling /var/tmp with sqlite journal, Jason Dixon <=