Support for Nagios products and services
https://support.nagios.com/forum/
Code: Select all
echo "SELECT * FROM nagios_logentries;" | mysql -u root -pnagiosxi nagiosCode: Select all
echo 'repair table nagios_logentries use_frm;' | mysql -t -u root -pnagiosxi nagiosCode: Select all
echo 'repair table nagios_logentries use_frm;' | m ysql -t -u root -pnagiosxi nagios
+--------------------------+--------+----------+-------------------------------- -------+
| Table | Op | Msg_type | Msg_text |
+--------------------------+--------+----------+-------------------------------- -------+
| nagios.nagios_logentries | repair | warning | Number of rows changed from 0 t o 9146 |
| nagios.nagios_logentries | repair | status | OK |
+--------------------------+--------+----------+-------------------------------- -------+After that please run the following commands in order:echo 'repair table nagios_logentries use_frm;' | mysql -t -u root -pnagiosxi nagios
Code: Select all
service crond stop
service npcd stop
service nagios stop
service ndo2db stop
pkill -9 -u nagios
for i in $(ipcs -q | grep nagios |awk '{print $2}'); do ipcrm -q $i; done
rm -rf /usr/local/nagiosxi/var/dbmaint.lock
rm -rf /usr/local/nagiosxi/var/event_handler.lock
rm -rf /usr/local/nagiosxi/scripts/reconfigure_nagios.lock
service mysqld restart
service ndo2db start
service nagios start
service npcd start
service crond startCode: Select all
ls -lR /store/backups/Code: Select all
root@lkenfusionp01 ~]# echo 'repair table nagios_logentries use_frm;' | mysql -t -u root -pnagiosxi nagios
+--------------------------+--------+----------+-------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+--------------------------+--------+----------+-------------------------------------------------------------+
| nagios.nagios_logentries | repair | error | Can't create new tempfile: './nagios/nagios_logentries.TMD' |
| nagios.nagios_logentries | repair | status | Operation failed Code: Select all
df -hCode: Select all
mv /nagios/nagios_logentries.TMD /tmp/Code: Select all
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_lkenfusiondev-lv_root
96G 14G 78G 16% /
tmpfs 7.8G 80K 7.8G 1% /dev/shm
/dev/sda1 477M 130M 322M 29% /boot
/dev/mapper/vg_lkenfusiondev-lv_home
446G 4.0G 420G 1% /home
/dev/mapper/vg_fusiondev900-lv_nagdb
413G 71M 392G 1% /nagdb
/dev/mapper/vg_fusiondev900-lv_perf
413G 71M 392G 1% /perf
[root@lkenfusionp01 nagios]#
Code: Select all
mv /nagios/nagios_logentries.TMD /tmp/
mv: cannot stat `/nagios/nagios_logentries.TMD': No such file or directory
[root@lkenfusionp01 ~]# cd /usr/local/nagios/
[root@lkenfusionp01 nagios]# mv /nagios/nagios_logentries.TMD /tmp/
mv: cannot stat `/nagios/nagios_logentries.TMD': No such file or directory
You have duplicate nagios processes running and these commands should get rid of it.service crond stop
service npcd stop
service nagios stop
service ndo2db stop
pkill -9 -u nagios
for i in $(ipcs -q | grep nagios |awk '{print $2}'); do ipcrm -q $i; done
rm -rf /usr/local/nagiosxi/var/dbmaint.lock
rm -rf /usr/local/nagiosxi/var/event_handler.lock
rm -rf /usr/local/nagiosxi/scripts/reconfigure_nagios.lock
service mysqld restart
service ndo2db start
service nagios start
service npcd start
service crond start
When done, please run the repair table command one more time. And upload the /var/log/mariadb/mariadb.log or /var/log/mysqld.log from the offloaded mysql server.mv /var/lib/mysql/nagios/nagios_logentries.TMD /tmp/