# Jabberd dbs size growing

**URL:** <https://forums.suse.com/t/jabberd-dbs-size-growing/29527>\
**Category:** SUSE Multi Linux Manager\
**Created:** [March 22, 2017, 12:40pm UTC](https://forums.suse.com/t/jabberd-dbs-size-growing/29527 "2017-03-22T12:40:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Attila](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@Attila](https://forums.suse.com/u/Attila)\
**Post date:** [March 22, 2017, 12:40pm UTC](https://forums.suse.com/t/jabberd-dbs-size-growing/29527/1 "2017-03-22T12:40:08Z")

</div>

Hello Everyone,

We have a SUMA 3.0.4 with all the latest patches and we manage 371 servers with it.  
In the last 1 month no more server was registered, but the dbs size growed appr. +2G. (+2G/month)  
The problem is that the jabberd’s dbs are still growing.  
At the moment the size is:  
suma3:/var/lib/jabberd/db # du -h  
23G  
and  
suma3:/var/lib/jabberd/db # ls |wc -l  
2348

I would like to ask what is the experience with it?  
How can we stop the growth, or is it normal?  
What is the maximum size for it?

Thank you  
Attila

---

<div class="post-metadata">

**Author:** ![HvdHeuvel](https://avatars.discourse-cdn.com/v4/letter/h/3da27b/32.png) [@HvdHeuvel](https://forums.suse.com/u/HvdHeuvel)\
**Post date:** [March 22, 2017, 9:01pm UTC](https://forums.suse.com/t/jabberd-dbs-size-growing/29527/2 "2017-03-22T21:01:46Z")

</div>

On Wed, 22 Mar 2017 10:44:02 +0000, amaxiprivate wrote:  
[color=blue]

> Hello Everyone,
> 
> We have a SUMA 3.0.4 with all the latest patches and we manage 371  
> servers with it.  
> In the last 1 month no more server was registered, but the dbs size  
> growed appr. +2G. (+2G/month)  
> The problem is that the jabberd’s dbs are still growing.  
> At the moment the size is:  
> suma3:/var/lib/jabberd/db # du -h 23G and suma3:/var/lib/jabberd/db # ls  
> |wc -l 2348
> 
> I would like to ask what is the experience with it?  
> How can we stop the growth, or is it normal?  
> What is the maximum size for it?
> 
> Thank you Attila[/color]

Hi Attila

Not sure if there is a maximum for it.  
But once it gets too large, or becomes corrupt, you can always delete it.

Please do see section 17.3.2 here:

[https://www.suse.com/documentation/suse-manager-3/singlehtml/](https://www.suse.com/documentation/suse-manager-3/singlehtml/)  
book\_suma\_best\_practices/book\_suma\_best\_practices.html#idm140666419831632

Thanks  
Hans

---

<div class="post-metadata">

**Author:** ![Attila](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@Attila](https://forums.suse.com/u/Attila)\
**Post date:** [March 23, 2017, 11:50am UTC](https://forums.suse.com/t/jabberd-dbs-size-growing/29527/3 "2017-03-23T11:50:21Z")

</div>

[QUOTE=HvdHeuvel;37145]On Wed, 22 Mar 2017 10:44:02 +0000, amaxiprivate wrote:  
[color=blue]

> Hello Everyone,
> 
> We have a SUMA 3.0.4 with all the latest patches and we manage 371  
> servers with it.  
> In the last 1 month no more server was registered, but the dbs size  
> growed appr. +2G. (+2G/month)  
> The problem is that the jabberd’s dbs are still growing.  
> At the moment the size is:  
> suma3:/var/lib/jabberd/db # du -h 23G and suma3:/var/lib/jabberd/db # ls  
> |wc -l 2348
> 
> I would like to ask what is the experience with it?  
> How can we stop the growth, or is it normal?  
> What is the maximum size for it?
> 
> Thank you Attila[/color]

Hi Attila

Not sure if there is a maximum for it.  
But once it gets too large, or becomes corrupt, you can always delete it.

Please do see section 17.3.2 here:

[https://www.suse.com/documentation/suse-manager-3/singlehtml/](https://www.suse.com/documentation/suse-manager-3/singlehtml/)  
book\_suma\_best\_practices/book\_suma\_best\_practices.html#idm140666419831632

Thanks  
Hans[/QUOTE]

Hello Hans,

Thank you for your answer.

I found a nice solution how to rotate the databases (reduce the dbs size and numbers too):  
Commands:  
sudo -u jabber /usr/bin/db\_checkpoint -1 -h /var/lib/jabberd/db  
/usr/bin/db\_archive -d -h /var/lib/jabberd/db  
systemctl restart spacewalk.target jabberd.service osa-dispatcher.service

You can easily create cronjob that can run once a month.

- I would like to say “thank you” to barthai for his solution.

You can find more information about the commands here:  
[https://github.com/spacewalkproject/spacewalk/wiki/JabberDatabase](https://github.com/spacewalkproject/spacewalk/wiki/JabberDatabase)

Regards,  
Attila