Announcement

Collapse
No announcement yet.

mysql_query() failed for 'INSERT INTO nagios_servicestatus, Please help

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • mysql_query() failed for 'INSERT INTO nagios_servicestatus, Please help

    Hi All,

    I am getting some insert errors for the nagios_servicestatus , I was wondering if any one knows how to fix this. Any help would be greatly appreciated.

    Actually what happens means our MYSQL server automatically restarting with "Normal shutdown" message in error log.Apart from this i didn't find any thing in mysql errorlog.

    but when i checked in /var/log/messages i have seen below errors, can any one help on this.


    Server ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_servicestatus SET instance_id='1', service_object_id='29955', status_update_time=FROM_UNIXTIME(1529080269), output='Ram : 4%, Swap : 0% : : OK', long_output='', perfdata='ram_used=1232836;29590834;31234769;0;328 78704 swap_used=920;4194302;6291454;0;20971512', current_state='0', has_been_checked='1', should_be_scheduled='1', current_check_attempt='1', max_check_attempts='5', last_check=FROM_UNIXTIME(1529080269), next_check=FROM_UNIXTIME(1529080569), check_type='0', last_state_change=FROM_UNIXTIME(1528442219), last_hard_state_change=FROM_UNIXTIME(1526076880), last_hard_state='0', last_time_ok=FROM_UNIXTIME(1529080269), last_time_warning=FROM_UNIXTIME(0), last_time_unknown=FROM_UNIXTIME(1528442219), last_time_critical=FROM_UNIXTIME(0), state_type='1', last_notification=FROM_UNIXTIME(0), next_notification=FROM_UNIXTIME(0), no_more_notifications='0', notifications_enabled='1', problem_has_been_acknowledged='0', acknowledgement_type='0', current_notification_number='0', passive_checks_enabled='1', active_checks_enabled='1', event_handler_enabled='1', flap_detection_enabled='1', is_flapping='0', percent_state_change='0.000000', latency='0.000000', execution_time='0.249830', scheduled_downtime_depth='0', failure_prediction_enabled='0', process_performance_data='1', obsess_over_service='1', modified_service_attributes='0', event_handler='', check_command='check_xi_service_snmp_memory! -C ava90t3ch --v2c -w 90,20 -c 95,30 -f!!!!!!!', normal_check_interval='5.000000', retry_check_interval='5.000000', check_timeperiod_object_id='131' ON DUPLICATE KEY UPDATE instance_id='1', service_object_id='29955', status_update_time=FROM_UNIXTIME(1529080269), output='Ram : 4%, Swap : 0% : : OK', long_output='', perfdata='ram_used=1232836;29590834;31234769;0;328 78704 swap_used=920;4194302;6291454;0;20971512', current_state='0', has_been_checked='1', should_be_scheduled='1', current_check_attempt='1', max_check_attempts='5', last_check=FROM_UNIXTIME(1529080269),
    Jun 15 09:31:09 Server ndo2db: mysql_error: 'MySQL server has gone away'
    Jun 15 09:31:09 Server ndo2db: Error: Connection to MySQL database has been lost!

    If this is not the right section , can you please move it to correct section and please let me know to check on this.
Working...
X