Bulk Schedule downtime and Mass acknowlegment for hostgroup

[Mike]

Hello Team,

While performing schedule downtime to a particular hostgroup and while doing a mass acknowledgment by selecting host and services of that particular hostgroup, We get blank screen and it does not go ahead.
Some times schedule downtime works for a hostgroup. but mass acknowledgment does not work.

System status
NagiosXi Load is 0.56, 0.32, 0.35
Ram 14GB used out of 16GB
User % = 5.51%
I/O wait = 0.03%


Below is the log messages..

# tail -f /var/log/messages

Feb 7 11:25:5 9 hostname ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_scheduleddowntime SET instance_id='1', downtime_type='1', object_id='2450', entry_time=FROM_UNIXTIME(1483678355), author_name='(User Name)', comment_data='snooze until otherwise stated per Taj', internal_downtime_id='18666', triggered_by_id='0', is_fixed='1', duration='2587860000', scheduled_start_time=FROM_UNIXTIME(1483505535), scheduled_end_time=FROM_UNIXTIME(4071365535) ON DUPLICATE KEY UPDATE instance_id='1', downtime_type='1', object_id='2450', entry_time=FROM_UNIXTIME(1483678355), author_name='(User Name)', comment_data='snooze until otherwise stated per Taj', internal_downtime_id='18666', triggered_by_id='0', is_fixed='1', duration='2587860000', scheduled_start_time=FROM_UNIXTIME(1483505535), scheduled_end_time=FROM_UNIXTIME(4071365535)'

[rkennedy]

Can you run tail -f /var/log/httpd/*_log at the same time you try to schedule for that hostgroup? It may be a PHP variable hitting the max which is causing it to not work, but the logs will know best.

[tmcdonald]

Just checking in since we have not heard from you in a while. Did @rkennedy's post clear things up or has the issue otherwise been resolved?