Search found 1339 matches

by asker
Thu Aug 13, 2015 12:02 pm
Forum: ZoneMinder 1.28.x
Topic: zmfilter polling slow.
Replies: 54
Views: 6285

Re: zmfilter polling slow.

I just noticed you have Asc in the filter match. Can you please change it to descending just for now?

Also, please use this latest zmfilter.pl https://gist.github.com/pliablepixels/5 ... f595cbd9d7
I've added more logs so we can see what is going on
by asker
Thu Aug 13, 2015 11:53 am
Forum: ZoneMinder 1.28.x
Topic: zmfilter polling slow.
Replies: 54
Views: 6285

Re: zmfilter polling slow.

zmfilter.pl is back to being stable. Getting SQL queries every 20 seconds, but same batch processing as far as filters go; anywhere from 2 to 5 minutes until filters will see an event. i'll re-run the scenario and gather logs in a little bit. Okay. Look forward to the uncut logs Please sort them by...
by asker
Thu Aug 13, 2015 12:59 am
Forum: ZoneMinder 1.28.x
Topic: zmfilter polling slow.
Replies: 54
Views: 6285

Re: zmfilter polling slow.

Whoops looks like there was a typo in line 1175
dbh needs to be $dbh

Please make that change - I don't know how that $ got removed

That explains why the new zmfilter crashed the moment it matched first - this is in the "execute" subroutine which gets called on match
by asker
Thu Aug 13, 2015 12:55 am
Forum: ZoneMinder 1.28.x
Topic: zmfilter polling slow.
Replies: 54
Views: 6285

Re: zmfilter polling slow.

Does it crash/display any error if you run it manually after triggering an event? Good question. something new. ╰─$ zmfilter.pl alertFile 130 ↵ Name "Net::SFTP::Foreign::debug" used only once: possible typo at /usr/bin/zmfilter.pl line 821. Can't locate object method "prepare_cached" via package "d...
by asker
Wed Aug 12, 2015 11:49 pm
Forum: ZoneMinder 1.28.x
Topic: zmfilter polling slow.
Replies: 54
Views: 6285

Re: zmfilter polling slow.

Does it crash/display any error if you run it manually after triggering an event?
by asker
Wed Aug 12, 2015 11:42 pm
Forum: ZoneMinder 1.28.x
Topic: zmfilter polling slow.
Replies: 54
Views: 6285

Re: zmfilter polling slow.

I'll break up each file with a new line or the filename or something next time I combine them to make it easier to think about. here's a time sorted one. gist github com segordon c612301a61c8a39ff50a the same big gist, but sorted. *sigh* You're right. It's crashing every time the event matches, but...
by asker
Wed Aug 12, 2015 11:28 pm
Forum: ZoneMinder 1.28.x
Topic: zmfilter polling slow.
Replies: 54
Views: 6285

Re: zmfilter polling slow.

Perhaps I am misinterpreting lines 142-166? Abnormal exit status on zmfilter being reported by zmdc, along with new pids every restart? Referring to that big gist. I think those should be ignored - that's happening when ZM is initializing. I've forced DB connections that may be causing this. If you...
by asker
Wed Aug 12, 2015 11:16 pm
Forum: ZoneMinder 1.28.x
Topic: zmfilter polling slow.
Replies: 54
Views: 6285

Re: zmfilter polling slow.

I don't see zmfilter crashing at all in the large gist you provided at https://gist.github.com/segordon/53558a3a0552f180f1b8 IT only crashed right at the start - lets assume thats because all of ZM did not start. It's hard to debug logs if you only post a small snapshot like the latest one which is ...
by asker
Wed Aug 12, 2015 10:36 pm
Forum: ZoneMinder 1.28.x
Topic: zmfilter polling slow.
Replies: 54
Views: 6285

Re: zmfilter polling slow.

I just re-created your settings at home: a) set a filter to send email b) reload 300 c) interval 20 Force generated events and each time my logs showed the filter executing and I get the email right then (in a matter of seconds) I'm curious why zmfilter is crashing for you. I am using the same zmfil...
by asker
Wed Aug 12, 2015 9:52 pm
Forum: ZoneMinder 1.28.x
Topic: zmfilter polling slow.
Replies: 54
Views: 6285

Re: zmfilter polling slow.

The 'Force closing..' message stops re-appearing every 20 seconds after the first abnormal exit, and then the timer is increased from the every 20s to every 3-5 minutes. The abnormal exit seems to happen every time it hits a valid event, so it'll hit that first event quickly and then revert back to...
by asker
Wed Aug 12, 2015 8:45 pm
Forum: ZoneMinder 1.28.x
Topic: zmfilter polling slow.
Replies: 54
Views: 6285

Re: zmfilter polling slow.

So I'm confused - where are we now? The "PP - Force closing DB just to test" log should occur every 20 seconds. Your latest log seems to show it recurring in minutes. You might have changed the wrong variable. Please make sure: FILTER_RELOAD_DELAY = 300 FILTER_EXECUTE_INTERVAL = 20 and restart ZM If...
by asker
Wed Aug 12, 2015 8:30 pm
Forum: ZoneMinder 1.28.x
Topic: zmfilter polling slow.
Replies: 54
Views: 6285

Re: zmfilter polling slow.

Here is the modified zmfilter.pl --> please keep a backup of the original, replace with this one, restart ZM https://gist.github.com/pliablepixels/5bb2e1408af595cbd9d7 It adds 2 things: a) Adds a log of the query b) Forcibly reconnects to DB every 20 seconds (not a good idea, but lets go with this f...
by asker
Wed Aug 12, 2015 8:17 pm
Forum: ZoneMinder 1.28.x
Topic: zmfilter polling slow.
Replies: 54
Views: 6285

Re: zmfilter polling slow.

segordon wrote:Sure, that's easy.

gist github com segordon 05f12db6dad483fca114
This is a non-crashing copy of zmfilter.pl correct?
Also, please take a look at the other suggestion in parallel (in my post above)
by asker
Wed Aug 12, 2015 8:06 pm
Forum: ZoneMinder 1.28.x
Topic: zmfilter polling slow.
Replies: 54
Views: 6285

Re: zmfilter polling slow.

Okay, that eliminates late DB writes. What remains is a) zmfilter db handle is going stale without generating errors and magically recovering b) the sql command is getting mangled That Info command was to check b. You might want to check where you changed it. That Info should not cause a crash unles...
by asker
Wed Aug 12, 2015 6:01 pm
Forum: ZoneMinder 1.28.x
Topic: zmfilter polling slow.
Replies: 54
Views: 6285

Re: zmfilter polling slow.

Okay, I have a theory on this: The only reason I can think of this is happening is that this line https://github.com/ZoneMinder/ZoneMinder/blob/master/scripts/zmfilter.pl.in#L638 is returning null till a "filter reload" happens (which is around that 5 min timeline) This could be three things: a) DB ...