Nagios Support Forum

Hello I have a proble with a monitoring service in nagios.log

Nagios XI is intalled in RHEL 8

NDO-3: Note: preceding query is longer than allowed according to maximum SQL buffer size.

the query excecuted its a insert in nagios_servicestatus and total query lenght its 26956 characters

INSERT INTO nagios_servicestatus (instance_id, service_object_id, status_update_time, output, long_output, perfdata, current_state, has_been_checked, should_be_scheduled, current_check_attempt, max_check_attempts, last_check, next_check, check_type, check_options, last_state_change, last_hard_state_change, last_hard_state, last_time_ok, last_time_warning, last_time_unknown, last_time_critical, state_type, last_notification, next_notification, no_more_notifications, notifications_enabled, problem_has_been_acknowledged, acknowledgement_type, current_notification_number, passive_checks_enabled, active_checks_enabled, event_handler_enabled, flap_detection_enabled, is_flapping, percent_state_change, latency, execution_time, scheduled_downtime_depth, failure_prediction_enabled, process_performance_data, obsess_over_service, modified_service_attributes, event_handler, check_command, normal_check_interval, retry_check_interval, check_timeperiod_object_id)

Hi,

Since this a database related error, I would recommend running the database check and repair script to verify that there are no issues there. Log in as root and run the following command:
Secondly, besides the error message in the nagios.log, what other behavior are you noticing? Are check results getting processed in the GUI and notifications working?

Lastly, please PM the system profile along with the /etc/my.cnf (database configuration) file.

Thanks,
Benjamin

benjaminsmith wrote:Hi,

Since this a database related error, I would recommend running the database check and repair script to verify that there are no issues there. Log in as root and run the following command:

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh

Secondly, besides the error message in the nagios.log, what other behavior are you noticing? Are check results getting processed in the GUI and notifications working?

Lastly, please PM the system profile along with the /etc/my.cnf (database configuration) file.

Thanks,
Benjamin

Hello @benjaminsmith, the repair database is executed and mysqlcheck -f -r -u root -pnagiosxi --all-databases in both cases the error persist,

for some strange reason I can't see the services without filter, but putting filter on the services I can see them

I have executed this query to view output

https://support.nagios.com/kb/article/n ... s-478.html

The Backup not function correctly, only function in database if I add --no-tablespaces in backup script

Since you're running EL8, make sure you set your mysql sql_mode="". Try adding max_allowed_packet=512M as well.

Edit this file:
Add these under the [mysqld] section:
Then restart mysql:
Now test again.

If that doesn't work, send the output of this command:

ssax wrote:Since you're running EL8, make sure you set your mysql sql_mode="". Try adding max_allowed_packet=512M as well.

Edit this file:

Code: Select all

/etc/my.cnf.d/mysql-server.cnf

Add these under the [mysqld] section:

Code: Select all

sql_mode=""
max_allowed_packet=512M

Then restart mysql:

Code: Select all

systemctl restart mysqld

Now test again.

If that doesn't work, send the output of this command:

Code: Select all

mysql -h 127.0.0.1 -uroot -pnagiosxi nagios -e "desc nagios_servicestatus;desc nagios_hoststatus;"

Hello @ssax

the error seems to be no longer present, but it did not work to be able to see all the elements in service
To see all the elements in service I had to add in my.cnf
Thanks for your help

Thank you for posting the update and your resolution, I have let our QA/Dev team know about your changes. Let us know when we're okay to lock this up and mark it as resolved.