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