Re: Enormous Daily files in /usr/local/nagios/var/archives (
Posted: Tue Jul 13, 2021 12:21 pm
Yes, I see many hosts that are no longer visible in the UI.
For instance:
Interestingly, that is not in the other table.
The centos3 object shown in my previous reply is in this table, though.
For instance:
Code: Select all
MariaDB [nagios]> select * from nagios_objects where name1 like '%DELETED%' ;
+-----------+-------------+---------------+---------------+---------------------------------------------+-----------+
| object_id | instance_id | objecttype_id | name1 | name2 | is_active |
+-----------+-------------+---------------+---------------+---------------------------------------------+-----------+
| 14242 | 1 | 1 | TO-BE-DELETED | | 0 |
| 14243 | 1 | 2 | TO-BE-DELETED | Ping | 0
Code: Select all
MariaDB [nagios]> select * from nagios_hosts where display_name like '%TO-BE-DELETED%' ;
Empty set (0.00 sec)
Code: Select all
MariaDB [nagios]> select * from nagios_objects where name1 like '%centos%' ;
+-----------+-------------+---------------+---------+-------------------------------------------+-----------+
| object_id | instance_id | objecttype_id | name1 | name2 | is_active |
+-----------+-------------+---------------+---------+-------------------------------------------+-----------+
| 12004 | 1 | 1 | centos3 | | 0 |
| 12005 | 1 | 2 | centos3 | Load | 0 |