zmaudit.pl problem

DREMA · Post by **DREMA** » Tue Apr 13, 2010 11:57 pm

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.

whatboy · Post by **whatboy** » Wed Apr 14, 2010 2:39 am

Maybe you need to upgrade the database...

DREMA · Post by **DREMA** » Thu Apr 15, 2010 2:54 am

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

whatboy · Post by **whatboy** » Thu Apr 15, 2010 2:58 am

What about sudo updatedb to uptade find db???

MarcoP · Post by **MarcoP** » Thu Apr 15, 2010 5:47 am

Did you reboot the server after the update?

DREMA · Post by **DREMA** » 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.

MarcoP · Post by **MarcoP** » Tue Apr 27, 2010 10:07 am

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

Code: Select all

rpm -qa | grep dbi

DREMA · Post by **DREMA** » 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.

johnnytolengo · Post by **johnnytolengo** » Thu May 06, 2010 7:35 pm

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.

DREMA · Post by **DREMA** » 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.

johnnytolengo · Post by **johnnytolengo** » Sat May 08, 2010 8:06 am

Yes that's a BUG

Tolengo.

DREMA · Post by **DREMA** » 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.

thanks.

johnnytolengo · Post by **johnnytolengo** » Thu May 13, 2010 3:47 pm

please post some log to help you.

Regards.

Jt.

DREMA · Post by **DREMA** » Wed Jun 23, 2010 7:59 pm

Bump.

DREMA · Post by **DREMA** » 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.

Thanks!