Receiving disabled notifications

[dlukinski]

Hi

I am receiving disabled notifications (disabled WARNINGS, FLAPPING, DOWNTIMED, but getting all the emails)

What could be done to fix this Nagios XI problem in version 5.6.6 ?

Thank you

[mbellerue]

Could you PM me a system profile? Also if you could tell us about when you received an email notification when you knew a service was disabled, that would be helpful too.

[dlukinski]

Could you PM me a system profile? Also if you could tell us about when you received an email notification when you knew a service was disabled, that would be helpful too.

If both the group template and my personal notification prefrences are configured as attached, why would I receive FLAPPING/WARNING/ UNKNOWNs ? Notifications and the service are enabled, but prefrences should prevent them from being sent?

Support edit: profile.zip downloaded and shared with team.

[ssax]

Interesting, it has to do with something in your xi_usermeta table, it's 8GB!

What is the output of this command?

Code: Select all

echo "select * from xi_usermeta ORDER BY LENGTH(keyvalue) DESC LIMIT 1;" | mysql -h 127.0.0.1 -uroot -pnagiosxi nagiosxi

May need to do this:

Code: Select all

echo "select * from xi_usermeta ORDER BY LENGTH(keyvalue) DESC LIMIT 1;" | mysql -h 127.0.0.1 -uroot -pnagiosxi nagiosxi >> HUGEROW.txt

[dlukinski]

Interesting, it has to do with something in your xi_usermeta table, it's 8GB!

What is the output of this command?

Code: Select all

echo "select * from xi_usermeta ORDER BY LENGTH(keyvalue) DESC LIMIT 1;" | mysql -h 127.0.0.1 -uroot -pnagiosxi nagiosxi

May need to do this:

Code: Select all

echo "select * from xi_usermeta ORDER BY LENGTH(keyvalue) DESC LIMIT 1;" | mysql -h 127.0.0.1 -uroot -pnagiosxi nagiosxi >> HUGEROW.txt

ERROR 1049 (42000): Unknown database 'nagiosxi'

[ssax]

Are you running postgresql?

Try this one:

Code: Select all

echo "select * from xi_usermeta ORDER BY LENGTH(keyvalue) DESC LIMIT 1;" | psql nagiosxi nagiosxi

[dlukinski]

Are you running postgresql?

Try this one:

Code: Select all

echo "select * from xi_usermeta ORDER BY LENGTH(keyvalue) DESC LIMIT 1;" | psql nagiosxi nagiosxi

Output was too long to be saved, but here is the tail of it atttached.

[ssax]

Please search for vacuum in this doc and vacuum your postgresql tables:

Code: Select all

https://support.nagios.com/kb/article/nagios-xi-can-t-log-into-the-web-interface-25.html

Once that's done, please send the output of this command:

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

[dlukinski]

Please search for vacuum in this doc and vacuum your postgresql tables:

Code: Select all

https://support.nagios.com/kb/article/nagios-xi-can-t-log-into-the-web-interface-25.html

Once that's done, please send the output of this command:

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

Please see the output

Code: Select all

[root@nagxiprod02 nagiosxi]# echo "vacuum;vacuum analyze;"|psql nagiosxi postgres
VACUUM
VACUUM
[root@nagxiprod02 nagiosxi]# service postgresql restart
Stopping postgresql service:                               [  OK  ]
Starting postgresql service:                               [  OK  ]
[root@nagxiprod02 nagiosxi]# 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
        table        |    size    | externalsize
---------------------+------------+--------------
 xi_meta             | 1440 kB    | 1112 kB
 xi_auditlog         | 1080 kB    | 1024 kB
 xi_auth_tokens      | 672 kB     | 128 kB
 xi_events           | 552 kB     | 528 kB
 xi_usermeta         | 240 kB     | 168 kB
 xi_commands         | 104 kB     | 96 kB
 xi_sessions         | 96 kB      | 96 kB
 xi_sysstat          | 88 kB      | 72 kB
 xi_options          | 88 kB      | 72 kB
 xi_users            | 80 kB      | 72 kB
 xi_mibs             | 72 kB      | 64 kB
 xi_eventqueue       | 48 kB      | 48 kB
 xi_cmp_trapdata     | 24 kB      | 24 kB
 xi_cmp_trapdata_log | 16 kB      | 16 kB
 xi_incidents        | 8192 bytes | 8192 bytes
(15 rows)

[benjaminsmith]

Hello @dlukinski,

The table sizes look much better. Are you still having the same issue with notifications? You can test this by submitting passive checks for a service to force a notification event.

passive-checks.png