Announcement

Collapse

New forum rules

The forum get new posts rules.

A new user will be moderate for new post. After five valid posts, the user will be to have right to post without moderation.

If you have some issue to post or to connect, contact us.
See more
See less

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