Still same problem
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-19 02:00:00' AND '2011-04-19 02:59:59' ORDER BY object_id "] at /usr/local/nagios/perl/lib/DBIx/ContextualFetch.pm line 52. Tomas Kucera píše v Pá 08. 04. 2011 v 13:55 +0200: > 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 > [email protected] > http://lists.opsview.org/lists/listinfo/opsview-users _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
