PDA

View Full Version : Jabberd dbs size growing



amaxiprivate
22-Mar-2017, 11:40
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

HvdHeuvel
22-Mar-2017, 20:01
On Wed, 22 Mar 2017 10:44:02 +0000, amaxiprivate wrote:

> 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

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/
book_suma_best_practices/book_suma_best_practices.html#idm140666419831632


Thanks
Hans

amaxiprivate
23-Mar-2017, 10:50
On Wed, 22 Mar 2017 10:44:02 +0000, amaxiprivate wrote:

> 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

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/
book_suma_best_practices/book_suma_best_practices.html#idm140666419831632


Thanks
Hans

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

Regards,
Attila