zmaudit.pl problem

Forum for questions and support relating to the 1.24.x releases only.
DREMA
Posts: 162
Joined: Fri Dec 12, 2008 2:39 am
Location: México

zmaudit.pl problem

Post by DREMA »

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
Posts: 304
Joined: Mon Aug 31, 2009 10:31 pm

Post by whatboy »

Maybe you need to upgrade the database...
DREMA
Posts: 162
Joined: Fri Dec 12, 2008 2:39 am
Location: México

Post by DREMA »

I haven't updated from different versions of ZM, any other thoughs?
whatboy
Posts: 304
Joined: Mon Aug 31, 2009 10:31 pm

Post by whatboy »

What about sudo updatedb to uptade find db???
MarcoP
Posts: 46
Joined: Wed Mar 24, 2010 1:46 pm

Post by MarcoP »

Did you reboot the server after the update?
DREMA
Posts: 162
Joined: Fri Dec 12, 2008 2:39 am
Location: México

Post by DREMA »

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
Posts: 46
Joined: Wed Mar 24, 2010 1:46 pm

Post by MarcoP »

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
Posts: 162
Joined: Fri Dec 12, 2008 2:39 am
Location: México

Post by DREMA »

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
Posts: 184
Joined: Tue Oct 14, 2008 5:59 pm

Post 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.


J.
DREMA
Posts: 162
Joined: Fri Dec 12, 2008 2:39 am
Location: México

Post by DREMA »

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
Posts: 184
Joined: Tue Oct 14, 2008 5:59 pm

Post by johnnytolengo »

Yes that's a BUG :)

Tolengo.
DREMA
Posts: 162
Joined: Fri Dec 12, 2008 2:39 am
Location: México

Post by DREMA »

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
Posts: 184
Joined: Tue Oct 14, 2008 5:59 pm

Post by johnnytolengo »

please post some log to help you.

Regards.

Jt.
DREMA
Posts: 162
Joined: Fri Dec 12, 2008 2:39 am
Location: México

Post by DREMA »

Bump.
DREMA
Posts: 162
Joined: Fri Dec 12, 2008 2:39 am
Location: México

Post by DREMA »

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!
Locked