Hi i have again problem with import_runtime, this time i can not help myself - please help me
I have opsview 3.9.0 My database solution died due to no space left on device. After recovery mysql functionality opsview successfully made 3 next hours import. since this time import dying on select statement which returns "empty set" if i set time between "the problem" and now(); it still returns nothing, so i expect problem remains SELECT downtime_type, object_id, entry_time, author_name, comment_data, is_fixed, duration, scheduled_start_time, scheduled_end_time, was_started, actual_start_time, actual_end_time, was_cancelled, internal_downtime_id FROM nagios_downtimehistory WHERE actual_start_time BETWEEN '2011-04-07 17:00:00' AND '2011-04-07 17:59:59' ORDER BY object_id [nagios@opsview-master01 ~]$ /usr/local/nagios/bin/import_runtime -v Running for 2011-04-07 20:00:00 - started at Fri Apr 8 13:27:18 2011 DBD::mysql::st execute failed: MySQL server has gone away [for Statement " SELECT downtime_type, object_id, entry_time, author_name, comment_data, is_fixed, duration, scheduled_start_time, scheduled_end_time, was_started, actual_start_time, actual_end_time, was_cancelled, internal_downtime_id FROM nagios_downtimehistory WHERE actual_start_time BETWEEN '2011-04-07 18:00:00' AND '2011-04-07 18:59:59' ORDER BY object_id "] at /usr/local/nagios/perl/lib/DBIx/ContextualFetch.pm line 52. _______________________________________________ Opsview-users mailing list Opsview-users@lists.opsview.org http://lists.opsview.org/lists/listinfo/opsview-users
