Support for Nagios products and services
https://support.nagios.com/forum/
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?mbellerue wrote: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.
Code: Select all
echo "select * from xi_usermeta ORDER BY LENGTH(keyvalue) DESC LIMIT 1;" | mysql -h 127.0.0.1 -uroot -pnagiosxi nagiosxiCode: Select all
echo "select * from xi_usermeta ORDER BY LENGTH(keyvalue) DESC LIMIT 1;" | mysql -h 127.0.0.1 -uroot -pnagiosxi nagiosxi >> HUGEROW.txtERROR 1049 (42000): Unknown database 'nagiosxi'ssax wrote:Interesting, it has to do with something in your xi_usermeta table, it's 8GB!
What is the output of this command?
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
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
Code: Select all
echo "select * from xi_usermeta ORDER BY LENGTH(keyvalue) DESC LIMIT 1;" | psql nagiosxi nagiosxiOutput was too long to be saved, but here is the tail of it atttached.ssax wrote: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
Code: Select all
https://support.nagios.com/kb/article/nagios-xi-can-t-log-into-the-web-interface-25.htmlCode: 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 nagiosxiPlease see the outputssax wrote:Please search for vacuum in this doc and vacuum your postgresql tables:
Once that's done, please send the output of this command:Code: Select all
https://support.nagios.com/kb/article/nagios-xi-can-t-log-into-the-web-interface-25.html
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
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)