Page 1 of 1
invalid date and negative event duration times
Posted: Mon Oct 03, 2011 8:18 pm
by ehb
Hi
I see these strange record values scattered when in live views window (two different machines, same problem). Some times they also show in filter window, say, events for the last 24h.
- 10521 Event-10521 1969-12-31 21:00:00 -13769113.96 12/2 16/17 X
10508 Event-10508 1969-12-31 21:00:00 -13769714.28 79/48 13/29 X
These are from one monitor (modect) and happened about one hour ago.
Note the date is 1969 (zero seconds epoc ? since my time zone is UTC-3 ?). About the event duration I have no clue about this negative number (maybe some other zero representation).
Any clues on what to do? Is this harmful?
i've been seen MySQL eating 100% of CPU for about 30 seconds over and over aganin leading ZM to death for a few minutes. Any relation??
These are sorted by CPU utilization:
Code: Select all
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
4374 mysql 20 0 249m 36m 4408 S 96.2 7.5 261:45.40 mysqld
10892 www-data 20 0 189m 17m 11m S 0.7 3.5 0:21.52 nph-zms
9877 www-data 20 0 186m 13m 11m S 0.3 2.8 0:16.80 zmc
9879 www-data 20 0 185m 13m 11m S 0.3 2.8 0:36.27 zma
9883 www-data 20 0 185m 13m 11m S 0.3 2.8 0:37.34 zma
9885 www-data 20 0 186m 14m 11m S 0.3 2.8 0:19.45 zmc
10428 www-data 20 0 140m 11m 3136 S 0.3 2.3 0:00.83 apache2
10474 www-data 20 0 185m 13m 11m S 0.3 2.8 0:30.77 zma
10746 www-data 20 0 190m 13m 11m S 0.3 2.8 0:10.34 zmc
11477 www-data 20 0 186m 13m 11m S 0.3 2.8 0:03.15 zmc
11662 root 20 0 19224 1396 1028 R 0.3 0.3 0:00.71 top
Environment: Ubuntu 10.04 LTS, ZM 1.24.2
Re: invalid date and negative event duration times
Posted: Mon Oct 03, 2011 11:11 pm
by bb99
Re: invalid date and negative event duration times
Posted: Tue Oct 04, 2011 12:52 am
by ehb
Nope!! Already did the phpmyadmin procedure before my first post.
Database was OK.Same behavior persists.
ZM is jamming so bad I can not even open Options to increase DEBUG. I got a blank page and Firefox keeps that doted ring spinning "ad infinitum".
Have to mention that this jam occurs every time I click to watch one of those "invalid time/negative duration" events.
Not only those events. there are some I could not relate that causes ZM to stall. (one may say: DON'T Click those events!!
)
I also installed mytop and I can see an UPDATE and a SELECT running (100% CPU) for a dozen or so seconds, then mysql drops to 0.3% CPU but ZM is still dead. In fact ZM kicks me out and I have to login again after a few minutes later.
mytop (URL not admited here by phpBB, "too spamy" it said!) reports no SLOW QUERIES. Ever.
Nothing (relevant) at the apache's error log either.
Any other hints? Any test I can run?
Meanwhile I am digging a lots of holes hunting the (imaginary?) bug.
Maybe I am lucky!
Re: invalid date and negative event duration times
Posted: Tue Oct 04, 2011 1:43 am
by bb99
For the "update" part of the cpu at 100% untick Options::system CHECK_FOR_UPDATES (had an issue with this myself in 1.23.3). A cheap UPS fixed the corrupted events for me several years ago with no repeats. I had to delete all those events by ticking them, selecting delete and letting ZMAudit do it's thing.
Re: invalid date and negative event duration times
Posted: Tue Oct 04, 2011 12:25 pm
by ehb
Oopps! the UPDATE I am refering to is the MySQL update due to events. But just to not let you without an answer, CHECK_FOR_UPDATES is unchecked since installation.
About the UPS, I don't think it will help. As you can see in my first post the "record corruption" is too stable (the "corruption" is the same in every record) to be caused by a power glitch.
Every record has its Time field set to zero (seconds since 1970-01-01 00:00:00 UTC) and Duration set to some always increasing very big negative numbers. All the other record fields make sense.
I am not a PHP expert but I think that something happened to some sql query that is leading my PHP session jammed (this is the next hole I'm gonna dig). When logged in again after ZM has kicked me out makes everything works ok until the next time.
Re: invalid date and negative event duration times
Posted: Tue Oct 04, 2011 4:17 pm
by ehb
Ok. I can confirm that ZM engine is not dead. My PHP session is dead. I can login and see things working from another machine while mine (session) just give me blank windows.
To close and reopen the FireFox tab does not restore the session. I have to shutdown FF.
As I said before I am not a PHP expert.
So, how can this kind of "error" be debugged?
Re: invalid date and negative event duration times
Posted: Thu Oct 06, 2011 2:42 pm
by ehb
Here we go again. Let me ask you guys a favor.
Please run a filter like this: in main window click "Filter" -> choose "Duration" -> "less than" -> "0" (zero) -> submit. (you may limit to the first N results if you like)
Please tell me if you see a list of record(s) like this:
Code: Select all
Id Name Monitor Cause Time(^) Duration ....
9782 Event-9782 blablabla Motion 12/31 21:00:00 -13852313.62 ....
7837 Event-7837 blablabla Motion 12/31 21:00:00 -14145614.41 ....
...
(please note the Time and Duration unusual values)
If you click on any of these events, does they show all of the frames till the last one or freezes at some frame?
Thanx.