ZoneMinder Forums

Hello!

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.

['zmaudit.pl -c' exited abnormally, exit status 9]

If I run zmaudit.pl directly I got this error

[root@camaras]# /usr/lib/zm/bin/zmaudit.pl
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/zmaudit.pl 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?
Thanks.

Maybe you need to upgrade the database...

I haven't updated from different versions of ZM, any other thoughs?

What about sudo updatedb to uptade find db???

Did you reboot the server after the update?

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.

Strange my zmaudit.pl 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

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.

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.


J.

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.

Yes that's a BUG

Tolengo.

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.

thanks.

please post some log to help you.

Regards.

Jt.

Bump.

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.

Thanks!