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

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

Maybe you need to upgrade the database...

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

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

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 » Thu Apr 15, 2010 2:58 am

What about sudo updatedb to uptade find db???

MarcoP
Posts: 46
Joined: Wed Mar 24, 2010 1:46 pm

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

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

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

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

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

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

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

Yes that's a BUG :)

Tolengo.

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

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

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

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 » Wed Jun 23, 2010 7:59 pm

Bump.

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

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!

Post Reply

Who is online

Users browsing this forum: No registered users and 11 guests