Page 1 of 1
web Interface freezing issue
Posted: Wed Jul 14, 2021 4:11 am
by erkanerturk
Hi
i have previously opened a topic:
https://support.nagios.com/forum/viewto ... 16&t=61944
but we could not get a resolution. Now that threrad is locked, so i wanted to open this one witha new info.
when I see web UI freeze, i have noticed the mysql waiting locks..there are approx more than 30 such line in the output
show processlist;
OUTPUT:
command: query
time: 90 (there are values ranging from 33 to 200)
state: waiting for table metadata lock
info: Insert INTO xi_auditlog (log_time,source....) VALUES ...
i think this causes we freeze problem.. can you help us to solve this?
thanks
Re: web Interface freezing issue
Posted: Wed Jul 14, 2021 3:40 pm
by gsmith
Hi
Please follow this document:
https://assets.nagios.com/downloads/nag ... tabase.pdf
After performing the repair check to see if the waiting for locks is reduced.
Thanks
Re: web Interface freezing issue
Posted: Fri Jul 16, 2021 6:11 am
by erkanerturk
Hi
I have done the repair and seen no error mesages on the screen. just fixing indexes messages..
by the way when i look at the tables, i see the following .. is that normal?
Code: Select all
MariaDB [(none)]> select table_name, data_length/(1024*1024) as "table size in MB",index_length from information_schema.TABLES where table_schema IN ('nagios','nagiosql','nagiosxi') order by data_length;
+--------------------------------------------+------------------+--------------+
| table_name | table size in MB | index_length |
+--------------------------------------------+------------------+--------------+
...
| nagios_hoststatus | 0.5958 | 387072 |
| tbl_lnkServiceToServicetemplate | 1.2813 | 0 |
| tbl_variabledefinition | 1.2813 | 0 |
| xi_cmp_nagiosbpi_backups | 1.5156 | 0 |
| tbl_service | 1.5156 | 0 |
| nagios_services | 1.9645 | 461824 |
| nagios_servicechecks | 2.0697 | 431104 |
| xi_usermeta | 2.5156 | 376832 |
| nagios_objects | 3.8170 | 3118080 |
| nagios_servicestatus | 5.1932 | 2281472 |
| nagios_flappinghistory | 9.5493 | 1572864 |
| nagios_commenthistory | 23.5465 | 2270208 |
| nagios_notifications | 150.3767 | 42685440 |
| nagios_contactnotifications | 170.6334 | 255421440 |
| nagios_contactnotificationmethods | 192.5094 | 208958464 |
| xi_events | 415.9063 | 312901632 |
| nagios_statehistory | 417.4070 | 157355008 |
| nagios_logentries | 2544.8456 | 1338273792 |
| xi_auditlog | 2868.5000 | 881983488 |
| xi_meta | 13352.9688 | 0 |
+--------------------------------------------+------------------+--------------+
175 rows in set (0.27 sec)
Re: web Interface freezing issue
Posted: Fri Jul 16, 2021 9:26 am
by gsmith
Hi,
Did the freezing issue get solved or is it still happening?
What from the mysql query are you concerned about, anything specific?
Thanks