Hello
This time I think I have a REAL problem :-/
My check: Opsview Data Warehouse Status has gone critical:
ODW_STATUS CRITICAL - No update since: 2009-08-05T 17:00:00
When I try the procedure suggested in docs I get:
nag...@t-monitoring-01:/usr/local/nagios/bin$ cleanup_import
Running cleanup for all data after Wed Aug 5 15:59:59 2009 on this opsview
instance
Finished cleanup
nag...@t-monitoring-01:/usr/local/nagios/bin$ import_runtime
Running for 2009-08-05 16:00:00
Use of uninitialized value in string eq at
/usr/local/nagios/bin/import_runtime line 270.
Use of uninitialized value in concatenation (.) or string at
/usr/local/nagios/bin/import_runtime line 278.
DBD::mysql::db do failed: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to
use near ')' at line 1 [for Statement "INSERT INTO performance_data
(datetime, performance_label, value) VALUES ('2009-08-05 14:00:15', 3013,
)"] at /usr/local/nagios/bin/import_runtime line 278.
nag...@t-monitoring-01:/usr/local/nagios/bin$ cleanup_import
Running cleanup for all data after Wed Aug 5 15:59:59 2009 on this opsview
instance
Finished cleanup
Last dataimport was successful:
mysql> select from_unixtime(period_start_timev),status from odw.dataloads
order by id desc limit 1;
+-----------------------------------+---------+
| from_unixtime(period_start_timev) | status |
+-----------------------------------+---------+
| 2009-08-05 15:00:00 | success |
+-----------------------------------+---------+
1 row in set (0.03 sec)
Lines 270 and 278 are part of "# Read in servicechecks and grab performance
data" block.
It looks like the line 278 of import_runtime script:
INSERT INTO performance_data (datetime, performance_label, value) VALUES
('$service_start_time', ".$odw_perflabel->id.", ".$p->value.")
tries to put into the database this SQL command:
INSERT INTO performance_data (datetime, performance_label, value) VALUES
('2009-08-05 14:00:15', 3013, )
so ".$p->value." has no value.
mysql> select * from performance_data where performance_label=3013;
Empty set (0.00 sec)
It probably has something to do with me tinkering with map.local file.
I think the file is ok now
How can I "skip" those few hours?
Or fix this in any other way?
Regards
Michał Zyzak
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users
