Nagios Support Forum

Code: Select all

[1647354247] NDO-3: INSERT INTO nagios_servicechecks (instance_id, start_time, start_time_usec, end_time, end_time_usec, service_object_id, check_type, current_check_attempt, max_check_attempts, state, state_type, timeout, early_timeout, execution_time, latency, return_code, output, long_output, perfdata, command_object_id, command_args, command_line) VALUES (1,FROM_UNIXTIME(1647354247),621734,FROM_UNIXTIME(1647354247),734849,9379,0,1,1,0,1,60,0,0.113115,0.000277,0,'DNS OK: 0.010 seconds response time. hostname.domain.tld returns 192.168.100.101','','time=0.010104s;2.000000;4.000000;0.000000',0,'','') ON DUPLICATE KEY UPDATE instance_id = VALUES(instance_id), start_time = VALUES(start_time), start_time_usec = VALUES(start_time_usec), end_time = VALUES(end_time), end_time_usec = VALUES(end_time_usec), service_object_id = VALUES(service_object_id), check_type = VALUES(check_type), current_check_attempt = VALUES(current_check_attempt), max_check_attempts = VALUES(max_check_attempts), state = VALUES(state), state_type = VALUES(state_type), timeout = VALUES(timeout), early_timeout = VALUES(early_timeout), execution_time = VALUES(execution_time), latency = VALUES(latency), return_code = VALUES(return_code), output = VALUES(output), long_output = VALUES(long_output), perfdata = VALUES(perfdata), command_object_id = VALUES(command_object_id), command_args = VALUES(command_args), command_line = VALUES(command_line)

Code: Select all

[root@u3 ~]# mysqldump -u root -p nagios  nagios_servicechecks  > /tmp/nagios_servicechecks.sql
Enter password:
[root@u3 ~]# ls -la /tmp/nagios_servicechecks.sql
-rw-r--r-- 1 root root 3157 Mar 15 16:06 /tmp/nagios_servicechecks.sql
[root@u3 ~]# less /tmp/nagios_servicechecks.sql
[root@u3 ~]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 20723
Server version: 5.5.68-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use nagios;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [nagios]> check table nagios_servicechecks;
+-----------------------------+-------+----------+----------+
| Table                       | Op    | Msg_type | Msg_text |
+-----------------------------+-------+----------+----------+
| nagios.nagios_servicechecks | check | status   | OK       |
+-----------------------------+-------+----------+----------+
1 row in set (0.00 sec)

MariaDB [nagios]> repair table nagios_servicechecks use_frm;
+-----------------------------+--------+----------+----------+
| Table                       | Op     | Msg_type | Msg_text |
+-----------------------------+--------+----------+----------+
| nagios.nagios_servicechecks | repair | status   | OK       |
+-----------------------------+--------+----------+----------+
1 row in set (0.00 sec)

MariaDB [nagios]> quit