On Fri, Oct 05, 2007 at 07:42:33PM +0200, LIMA David wrote:
> Here are the results, i repeat that i only appears using poller2.
Hmm, thats strange in itself, but let's see.

> mysql> SELECT (date_stop - date_start) AS duration FROM alarms WHERE 
> triggered = 1 AND interface=3108;
> +-------------+
> | duration    |
> +-------------+
> | 4864.000000 |
OK, here is our problem. Can you run 
 SELECT *, (date_stop - date_start)  AS duration FROM alarms WHERE triggered = 
1 AND interface=3108;

> | 2147 | 2007-10-04 21:57:56 |   40 |  306 | Reachability Test | unreachable 
> | status   | 80% Packet Loss |       0 |   1 |        1 |
> | 2162 | 2007-10-04 22:06:20 |   40 |  306 | Reachability Test | reachable | 
> status   | 0% Packet Loss |       0 |   1 |        1 |
So they're the right times as before.

 - Craig
-- 
Craig Small      GnuPG:1C1B D893 1418 2AF4 45EE  95CB C76C E5AC 12CA DFA5
http://www.enc.com.au/                             csmall at : enc.com.au
http://www.debian.org/          Debian GNU/Linux, software should be Free 

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
jffnms-users mailing list
jffnms-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jffnms-users

Reply via email to