Page 1 of 1
zmfilter ERR Can't execute filter 'SELECT E.Id,#012
Posted: Sun Feb 05, 2017 1:34 pm
by XabiX
Hello,
i do get this error message when my filter is executed:
Code: Select all
Feb 5 14:29:06 SERVER zmfilter[6229]: ERR [Can't execute filter 'SELECT E.Id,#012 E.MonitorId,#012 M.Name as MonitorName,#012 M.DefaultRate,#012 M.DefaultScale,#012 E.Name,#012 E.Cause,#012 E.Notes,#012 E.StartTime,#012 unix_timestamp(E.StartTime) as Time,#012 E.Length,#012 E.Frames,#012 E.AlarmFrames,#012 E.TotScore,#012 E.AvgScore,#012 E.MaxScore,#012 E.Archived,#012 E.Videoed,#012 E.Uploaded,#012 E.Emailed,#012 E.Messaged,#012 E.Executed#012 FROM Events as E#012 INNER JOIN Monitors as M on M.Id = E.MonitorId#012 where not isnull(E.EndTime) and ( E.Length = 00:00:00 ) order by E.Id asc', ignoring: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':00:00 ) order by E.Id asc' at line 25]
I tried changing the length from '00:00:00' to 00:00:00 and with \: but always the same. Basically I just want to delete events with a null duration. Not sure why they get recorded though but at least I wanted to clean those.
Any idea of the right config to get this working? and potentially of what is causing null duration events?
Merci
Xavier
Re: zmfilter ERR Can't execute filter 'SELECT E.Id,#012
Posted: Sun Feb 05, 2017 2:34 pm
by XabiX
Here is an example of what I am seeing.I assume I can tweak ZM to have one event per hour? What are these events based on? If the duration is 00 does it mean like that during x number of minutes not detection was done (Cameras with VBR) so nothing has been recorded since the previous file? That seems strange to me.
- zm.png (297.48 KiB) Viewed 12084 times
Re: zmfilter ERR Can't execute filter 'SELECT E.Id,#012
Posted: Sun Feb 05, 2017 2:52 pm
by knight-of-ni
Duration should be simply "0" w/o quotes.
Re: zmfilter ERR Can't execute filter 'SELECT E.Id,#012
Posted: Sun Feb 05, 2017 2:55 pm
by knight-of-ni
Oh, and a common reason for null events are an inability to write to the disk. Is the disk full? Are the right permissions set? Is the disk slow/failing? You need to look in your log for clues.
Re: zmfilter ERR Can't execute filter 'SELECT E.Id,#012
Posted: Sun Feb 05, 2017 8:17 pm
by XabiX
Hi Knnniggett
1/ Thanks this was the issue, now I see:
Feb 5 21:08:16 SERVER zmfilter[12641]: INF [Scanning for events using filter '_TempFilter1486325295']
2/ As the previous, screenshot the disks correctly accessible (it was a 69% and now is at 96%). I do have the other filter "PurgeWhenFull" kicking at 95% with the oldest 100 events to be deleted so normally the disk is never full.
3/ As per the log, I did put as documented in the wiki (
http://zoneminder.readthedocs.io/en/sta ... ogging.png) but the file in /var/log/zm is empty and I don't have logs in the web page (even it is orange). I do believe I may have an issue there but I was thinking this was stored in the db rather than the file. At least I do get the logs in syslog correctly and don't see anything strange. Should I be looking at another place?
Code: Select all
Feb 5 21:11:51 SERVER zmaudit[12940]: INF [Filesystem event '5/86' does not exist in database]
Feb 5 21:11:51 SERVER zmaudit[12940]: INF [deleting]
Feb 5 21:11:51 SERVER zmaudit[12940]: INF [Filesystem event '5/90' does not exist in database]
Feb 5 21:11:51 SERVER zmaudit[12940]: INF [deleting]
Feb 5 21:11:51 SERVER zmaudit[12940]: INF [Filesystem event '5/4323' does not exist in database]
Feb 5 21:11:51 SERVER zmaudit[12940]: INF [deleting]
Feb 5 21:11:52 SERVER zmaudit[12940]: INF [Filesystem event '7/89' does not exist in database]
Feb 5 21:11:52 SERVER zmaudit[12940]: INF [deleting]
Feb 5 21:11:52 SERVER zmaudit[12940]: INF [Filesystem event '7/4322' does not exist in database]
Feb 5 21:11:52 SERVER zmaudit[12940]: INF [deleting]
Feb 5 21:11:53 SERVER zmaudit[12940]: INF [Filesystem event '7/85' does not exist in database]
Feb 5 21:11:53 SERVER zmaudit[12940]: INF [deleting]
Feb 5 21:11:53 SERVER zmaudit[12940]: INF [Filesystem event '7/4319' does not exist in database]
Feb 5 21:11:53 SERVER zmaudit[12940]: INF [deleting]
Feb 5 21:12:01 SERVER zma_m5[10922]: INF [Devant HD: 45000 - Analysing at 24.39 fps]
Feb 5 21:12:01 SERVER zma_m6[10926]: INF [Cote HD: 45000 - Analysing at 24.39 fps]
Feb 5 21:12:02 SERVER zma_m7[10931]: INF [Derriere HD: 45000 - Analysing at 25.00 fps]
Feb 5 21:12:22 SERVER zmc_m7[12926]: INF [Derriere HD: 503000 - Capturing at 25.00 fps]
Feb 5 21:12:23 SERVER zmc_m5[12898]: INF [Devant HD: 503000 - Capturing at 25.00 fps]
Feb 5 21:12:24 SERVER zmc_m6[12911]: INF [Cote HD: 503000 - Capturing at 25.00 fps]
Feb 5 21:12:35 SERVER zmc_m3[12891]: INF [Derriere: 302000 - Capturing at 15.15 fps]
Feb 5 21:12:37 SERVER zmc_m1[12879]: INF [Devant: 302000 - Capturing at 14.93 fps]
Feb 5 21:12:37 SERVER zmc_m2[12885]: INF [Cote: 302000 - Capturing at 15.15 fps]
Feb 5 21:12:41 SERVER zma_m5[10922]: INF [Devant HD: 46000 - Analysing at 25.00 fps]
Feb 5 21:12:41 SERVER zma_m6[10926]: INF [Cote HD: 46000 - Analysing at 25.00 fps]
Feb 5 21:12:43 SERVER zma_m7[10931]: INF [Derriere HD: 46000 - Analysing at 24.39 fps]
Feb 5 21:13:03 SERVER zmc_m7[12926]: INF [Derriere HD: 504000 - Capturing at 25.00 fps]
Feb 5 21:13:03 SERVER zmc_m5[12898]: INF [Devant HD: 504000 - Capturing at 25.00 fps]
Feb 5 21:13:04 SERVER zmc_m6[12911]: INF [Cote HD: 504000 - Capturing at 25.00 fps]
Feb 5 21:13:21 SERVER zma_m5[10922]: INF [Devant HD: 47000 - Analysing at 25.00 fps]
Feb 5 21:13:21 SERVER zma_m6[10926]: INF [Cote HD: 47000 - Analysing at 25.00 fps]
Feb 5 21:13:23 SERVER zma_m7[10931]: INF [Derriere HD: 47000 - Analysing at 25.00 fps]
Feb 5 21:13:42 SERVER zmc_m3[12891]: INF [Derriere: 303000 - Capturing at 14.93 fps]
Feb 5 21:13:42 SERVER zmc_m7[12926]: INF [Derriere HD: 505000 - Capturing at 25.00 fps]
Feb 5 21:13:43 SERVER zmc_m5[12898]: INF [Devant HD: 505000 - Capturing at 25.00 fps]
Feb 5 21:13:44 SERVER zmc_m1[12879]: INF [Devant: 303000 - Capturing at 14.93 fps]
Feb 5 21:13:44 SERVER zmc_m2[12885]: INF [Cote: 303000 - Capturing at 14.93 fps]
Feb 5 21:13:44 SERVER zmc_m6[12911]: INF [Cote HD: 505000 - Capturing at 25.00 fps]
Feb 5 21:14:01 SERVER zma_m5[10922]: INF [Devant HD: 48000 - Analysing at 25.00 fps]
Feb 5 21:14:01 SERVER zma_m6[10926]: INF [Cote HD: 48000 - Analysing at 25.00 fps]
Feb 5 21:14:03 SERVER zma_m7[10931]: INF [Derriere HD: 48000 - Analysing at 25.00 fps]
Feb 5 21:14:22 SERVER zmc_m7[12926]: INF [Derriere HD: 506000 - Capturing at 25.00 fps]
Feb 5 21:14:23 SERVER zmc_m5[12898]: INF [Devant HD: 506000 - Capturing at 25.00 fps]
Feb 5 21:14:24 SERVER zmc_m6[12911]: INF [Cote HD: 506000 - Capturing at 25.00 fps]
Feb 5 21:14:41 SERVER zma_m6[10926]: INF [Cote HD: 49000 - Analysing at 25.00 fps]
Feb 5 21:14:41 SERVER zma_m5[10922]: INF [Devant HD: 49000 - Analysing at 25.00 fps]
Feb 5 21:14:43 SERVER zma_m7[10931]: INF [Derriere HD: 49000 - Analysing at 25.00 fps]
Feb 5 21:14:49 SERVER zmc_m3[12891]: INF [Derriere: 304000 - Capturing at 14.93 fps]
Feb 5 21:14:50 SERVER zmc_m1[12879]: INF [Devant: 304000 - Capturing at 15.15 fps]
Feb 5 21:14:51 SERVER zmc_m2[12885]: INF [Cote: 304000 - Capturing at 14.93 fps]
Feb 5 21:15:02 SERVER zmc_m7[12926]: INF [Derriere HD: 507000 - Capturing at 25.00 fps]
Feb 5 21:15:03 SERVER zmc_m5[12898]: INF [Devant HD: 507000 - Capturing at 25.00 fps]
Feb 5 21:15:04 SERVER zmc_m6[12911]: INF [Cote HD: 507000 - Capturing at 25.00 fps]
Feb 5 21:15:21 SERVER zma_m6[10926]: INF [Cote HD: 50000 - Analysing at 25.00 fps]
Feb 5 21:15:21 SERVER zma_m5[10922]: INF [Devant HD: 50000 - Analysing at 25.00 fps]
Feb 5 21:15:24 SERVER zma_m7[10931]: INF [Derriere HD: 50000 - Analysing at 25.00 fps]
MERCI
XabiX
PS: I have opened this other thread (maybe on the wrong section) and I don't have much luck with insights. Anyway idea at least on Question 1?
viewtopic.php?f=14&t=25790
