<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Hi all<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Just in case anyone else did once struggle with a lot of jabberd log files within “/var/lib/jabberd/db” (has been discussed on
<a href="http://www.redhat.com/archives/spacewalk-list/2011-March/msg00033.html">
http://www.redhat.com/archives/spacewalk-list/2011-March/msg00033.html</a>) but was not able to cleanup any old logs according berkley db log file removal (<a href="https://web.stanford.edu/class/cs276a/projects/docs/berkeleydb/ref/transapp/logfile.html">https://web.stanford.edu/class/cs276a/projects/docs/berkeleydb/ref/transapp/logfile.html</a>),
here’s the way we go:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"># berkley db maintenance (transaction log cleanup)<o:p></o:p></p>
<p class="MsoNormal">55 20 * * 0 /usr/bin/db_checkpoint -1 -h /var/lib/jabberd/db && /usr/bin/db_archive -d -h /var/lib/jabberd/db<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">That is not the official way of doing this, but we discovered that on our server there were no checkpoints written and thus we were not able to remove logfiles without a complete db removal (<a href="https://access.redhat.com/solutions/1199153">https://access.redhat.com/solutions/1199153</a>
-> you have to cleanup your jabber-clients too). The small crontab entry above will write a checkpoint and afterwards remove the logfiles (without the active log) and your disk usage is under control.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Kind regards,<o:p></o:p></p>
<p class="MsoNormal">Rolf Linder<o:p></o:p></p>
</div>
</body>
</html>