Nagios Support Forum

Posted: **Wed Dec 09, 2020 4:03 pm**

I continue to get these messages in my log even though I have already updated them per mentioned specs from this article:

https://support.nagios.com/kb/article.php?id=139

Dec 9 14:53:59 nagiosxiserver ndo2db: Message sent to queue.
Dec 9 14:53:59 nagiosxiserver ndo2db: Warning: queue send error, retrying...

ipcs -q

------ Message Queues --------
key msqid owner perms used-bytes messages
0x7e020002 131072 nagios 600 262037504 255896

grep 'kernel.msgmnb' /etc/sysctl.conf
kernel.msgmnb = 262144000

grep 'kernel.msgmax' /etc/sysctl.conf
kernel.msgmax = 262144000

grep 'kernel.msgmni' /etc/sysctl.conf
kernel.msgmni = 512000

Should I increase these settings to something else?

Posted: **Thu Dec 10, 2020 1:45 pm**

Please PM me a copy of your profile, you can download it from Admin > System Profile by clicking the Download Profile button.

Additionally, please send the output of these commands:
- NOTE: You may need to adjust the -h 127.0.0.1, the -uroot, and -pnagiosxi in the first command if your DB is offloaded to another server and/or you've changed the root mysql password

Code: Select all

echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table

This next command may fail, that's okay, not all systems run postgresql, send the output anyways:

Code: Select all

echo "SELECT relname as Table, pg_size_pretty(pg_total_relation_size(relid)) As Size, pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as ExternalSize FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;" | psql nagiosxi nagiosxi

Send the output of these commands as root:

Code: Select all

ulimit -a
su -s /bin/bash -c 'ulimit -a' nagios
su -s /bin/bash -c 'ulimti -a' mysql
uname -a
cat /etc/*release
cat /etc/my.cnf
sar

Nagios Support Forum

ndo2db messages

ndo2db messages

Re: ndo2db messages