Page 1 of 2 problem

Posted: Tue Apr 13, 2010 11:57 pm

I just updated a zm box everything looked fine, but my load just went to the sky. After looking at it I have this problem on my logs.

[' -c' exited abnormally, exit status 9]

If I run directly I got this error

[root@camaras]# /usr/lib/zm/bin/
Found open event '136685', closing
Can't locate object method "execute" via package "update Events set Name = ?, EndTime = ?, Length = ?, Frames = ?, AlarmFrames = ?, TotScore = ?, AvgScore = ?, MaxScore = ?, Notes = concat_ws( ' ', Notes, ? ) where Id = ?" (perhaps you forgot to load "update Events set Name = ?, EndTime = ?, Length = ?, Frames = ?, AlarmFrames = ?, TotScore = ?, AvgScore = ?, MaxScore = ?, Notes = concat_ws( ' ', Notes, ? ) where Id = ?"?) at /usr/lib/zm/bin/ line 367.

Looking at my *tops, the processor is fine, its my HDD that its being hammered by "find /var/lib/zm/www/events -amin -65 -name .[0-9]*

Killing the find process relax my box for a while.

Any help please?

Posted: Wed Apr 14, 2010 2:39 am
by whatboy
Maybe you need to upgrade the database...

Posted: Thu Apr 15, 2010 2:54 am
I haven't updated from different versions of ZM, any other thoughs?

Posted: Thu Apr 15, 2010 2:58 am
by whatboy
What about sudo updatedb to uptade find db???

Posted: Thu Apr 15, 2010 5:47 am
by MarcoP
Did you reboot the server after the update?

Posted: Thu Apr 15, 2010 1:41 pm
Already updated it a couple times. Yeah I rebooted it also.

The problem seem to be that zmaudit is crashing or something and is creating multiple instances of "find /var/lib/zm/www/events -amin -65 -name .[0-9]*" overloading the harddrive.

Or at least thats how it looks on my logs and *tops.

Posted: Tue Apr 27, 2010 10:07 am
by MarcoP
Strange my is executing that query at line 352.

Is this zm 1.24.x?

Did you modified the perl file?

Also post back the output of

Code: Select all

rpm -qa | grep dbi

Posted: Fri Apr 30, 2010 5:01 am
Can't find the problem yet.

I'm using the svn version, it shows as 1.24.2 on the main console.

I haven't touch that file.

Is this what you need?

[zm@camaras ~]$ pacman -Qs dbi
local/perl-dbi 1.609-1
Database independent interface for Perl

Thanks for the help.

Posted: Thu May 06, 2010 7:35 pm
by johnnytolengo
yes I have the solution, just go to the DB and delete the event " 136685 " then try again to run zmaudit and if you get another error do it again the same process remove the event from the DB run zmaudit and so on...

it is possible that do you have some opened event without folder or images.

I hope it helps.


Posted: Fri May 07, 2010 4:36 pm
johnnytolengo I love you man!

I deleted a lot of events that had the "EndTime = NULL", after that zmaudit runs awain without crash constantly.

Should I make a bug report on this?

Thanks again.

Posted: Sat May 08, 2010 8:06 am
by johnnytolengo
Yes that's a BUG :)


Posted: Thu May 13, 2010 8:51 am
Ok, I haven't get rid of this problem yet.

Deleting those events help, but zmaudit keep crashing, making new weird events, and slowing down my harddrives.

Please any more help would be apreciated.


Posted: Thu May 13, 2010 3:47 pm
by johnnytolengo
please post some log to help you.



Posted: Wed Jun 23, 2010 7:59 pm

Posted: Fri Aug 13, 2010 6:31 pm
Hey guys, I'm still having this problem. I just made a script to kill the "find" process every hour but thats not a solution.

Yesterday I updated this zm box to zoneminder-svn but I'm still having the same problem.

If anyone have any clue or some advice I'l be thankfull, also any more info needed please post a reply.