Jabberd dbs size growing

SUSE Manager
1

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

2

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

Thanks
Hans

3

[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/
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

Regards,
Attila