Nagios Support Forum

mysql> 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(1620844440),0,FROM_UNIXTIME(0),0,2028,1,1,1,0,1,60,1,0.000000,0.000000,0,'Process UP=6','','',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);
ERROR 1264 (22003): Out of range value for column 'servicecheck_id' at row 1

I am getting above error. Is there any other way without downgrading the NDO-3 broker?

Hi,

I talked with some of the other Support Techs and they say downgrading NDO is the way to solve
the problem.

Can you clone this environment and see if you can reproduce the error? Then downgrade NDO
on the cloned environment to see if it solves the problem.

Thanks

I just realized that this is version xi 5.8.3, we have other host instance with xi 5.8.2 which is working fine.

Is it problem with version xi 5.8.3 . Can I rollback to xi 5.8.2 to fix this issue?

Hi,

Rolling back to 5.8.2 is highly unlikely to solve the problem unless there is something pretty
unique about your setup. Here is what was fixed in 5.8.3:

5.8.3 - 03/31/2021
==================
- Updated jQuery to version 3.6.0 to fix minor issues -JO
- Updated email validation to require RFC 822 valid email addresses to fix possible security vulnerabilities -JO
- Fixed install process on Oracle Linux 8 due to mod_php being used instead of php-fpm like CentOS/RHEL -JO
- Fixed config/<object> endpoints to properly display array of contacts (and other objects) when using append (+) in config [TPS#15509] -JO
- Fixed argument quoting in mysqlrepair and restore_xi scripts -DC,JO
- Fixed issue with Scheduled Backups sending local backup success email with SSH or FTP emails [TPS#15501] -JO
- Fixed API help/example PUT config calls not working properly due to space not being url encoded [TPS#15505] -JO
- Fixed XSS vulnerability in user Email Address field when on Send Test Notification page -JO
- Fixed possible RCE vulnerability via Email Address not being properly validated (CVE-2020-24899) -JO
- Fixed scheduled reports jobs not changing with username change [TPS#15502] -JO
- Fixed issue where masquerade button in the Manage Users page wasn't working on some OS/PHP versions -JO
- Fixed issues with MIB integration after upgrading to SNMPTT 1.4.2 [TPS#15376] -SAW
- Fixed issues with Undo Trap Processing button [TPS#15500] -SAW
- Fixed issue with downgraded ndo2db systems where limited users would not properly load data due to is_ndo_loaded failing -JO

Thanks