Sorry for my english
ZM 1.24.2
Debian lenny
fs - reiserfs
I create filter
date/time less than -14 days
delete all mathes
save it, choose run in background.
But filter didn't work. When i try submit - it choose events older than 2 weeks. When i try execute - it delete only first events
zm_filter.log
09/16/09 11:54:40.747770 zmfilter[7654].INF [Scanning for events using filter '_TempFilter1253087680']
09/16/09 11:54:40.929404 zmfilter[7654].INF [Deleting event 38437]
in zmdc.log
'zmfilter.pl ' exited abnormally, exit status 9
if enter in shell zmfilter.pl
debug level 9
in zmfilter.log
16.09.2009 15:26:29.253696 zmfilter[9255].INF [Scanning for events]
16.09.2009 15:26:34.254036 zmfilter[9255].DBG [Reloading filters]
16.09.2009 15:26:34.254366 zmfilter[9255].DBG [Found filter 'OldestEventsDelete']
16.09.2009 15:26:34.264117 zmfilter[9255].DBG [SQL:select E.Id,E.MonitorId,M.Name as MonitorName,M.DefaultRate,M.DefaultScale,E.Name,E.Cause,E.Notes,E.StartTime,unix_timestamp(E.StartTime) as Time,E.Length,E.Frames,E.AlarmFrames,E.TotScore,E.AvgScore,E.MaxScore,E.Archived,E.Videoed,E.Uploaded,E.Emailed,E.Messaged,E.Executed from Events as E inner join Monitors as M on M.Id = E.MonitorId where not isnull(E.EndTime) and ( E.StartTime < '2009-08-23 15:26:34' ) order by E.StartTime asc]
16.09.2009 15:26:34.264223 zmfilter[9255].DBG [Found filter 'PurgeWhenFully']
16.09.2009 15:26:34.265584 zmfilter[9255].DBG [SQL:select E.Id,E.MonitorId,M.Name as MonitorName,M.DefaultRate,M.DefaultScale,E.Name,E.Cause,E.Notes,E.StartTime,unix_timestamp(E.StartTime) as Time,E.Length,E.Frames,E.AlarmFrames,E.TotScore,E.AvgScore,E.MaxScore,E.Archived,E.Videoed,E.Uploaded,E.Emailed,E.Messaged,E.Executed from Events as E inner join Monitors as M on M.Id = E.MonitorId where not isnull(E.EndTime) and ( E.Archived = 0 and zmDiskPercent >= 90 ) order by E.Id asc limit 0,5]
16.09.2009 15:26:34.265658 zmfilter[9255].DBG [Checking filter 'OldestEventsDelete', delete]
16.09.2009 15:26:34.396786 zmfilter[9255].DBG [Checking filter 'PurgeWhenFully', delete]
16.09.2009 15:26:34.398994 zmfilter[9255].DBG [Sleeping for 60 seconds]
what i do wrong?
Thanks!
filter not delete events
filter not delete events
Last edited by kert on Wed Sep 16, 2009 5:53 pm, edited 1 time in total.
in ZMDC.LOG i saw this
16.09.2009 18:52:35.089165 zmdc[3466].INF ['zmfilter.pl' starting at 09/09/16 18:52:35, pid = 3553]
16.09.2009 18:52:35.106440 zmdc[3466].ERR ['zmfilter.pl ' exited abnormally, exit status 9]
16.09.2009 18:52:35.106638 zmdc[3466].INF [Starting pending process, zmfilter.pl]
16.09.2009 18:52:35.109182 zmdc[3466].INF ['zmfilter.pl' starting at 09/09/16 18:52:35, pid = 3556]
16.09.2009 18:52:35.113964 zmdc[3466].ERR ['zmfilter.pl ' exited abnormally, exit status 9]
16.09.2009 18:52:35.209246 zmdc[3466].INF ['zmaudit.pl -c' starting at 09/09/16 18:52:35, pid = 3557]
16.09.2009 18:52:35.216082 zmdc[3466].ERR ['zmaudit.pl -c' exited abnormally, exit status 9]
16.09.2009 18:52:35.216290 zmdc[3466].INF [Starting pending process, zmaudit.pl -c]
16.09.2009 18:52:35.223680 zmdc[3466].INF [Can't find child with pid of '3560']
16.09.2009 18:52:35.223925 zmdc[3466].INF ['zmaudit.pl -c' starting at 09/09/16 18:52:35, pid = 3560]
16.09.2009 18:52:35.323969 zmdc[3466].INF ['zmwatch.pl' starting at 09/09/16 18:52:35, pid = 3561]
16.09.2009 18:52:35.331050 zmdc[3466].ERR ['zmwatch.pl ' exited abnormally, exit status 9]
16.09.2009 18:52:35.331318 zmdc[3466].INF [Starting pending process, zmwatch.pl]
16.09.2009 18:52:35.338821 zmdc[3466].INF [Can't find child with pid of '3564']
16.09.2009 18:52:35.339064 zmdc[3466].INF ['zmwatch.pl' starting at 09/09/16 18:52:35, pid = 3564]
16.09.2009 18:52:35.439834 zmdc[3466].INF ['zmupdate.pl -c' starting at 09/09/16 18:52:35, pid = 3565]
16.09.2009 18:52:35.447132 zmdc[3466].ERR ['zmupdate.pl -c' exited abnormally, exit status 9]
16.09.2009 18:52:35.447352 zmdc[3466].INF [Starting pending process, zmupdate.pl -c]
16.09.2009 18:52:35.455316 zmdc[3466].INF [Can't find child with pid of '3570']
16.09.2009 18:52:35.455560 zmdc[3466].INF ['zmupdate.pl -c' starting at 09/09/16 18:52:35, pid = 3570]
16.09.2009 18:52:40.052471 zmdc[3466].INF [Starting pending process, zmfilter.pl]
16.09.2009 18:52:40.053643 zmdc[3466].INF ['zmfilter.pl' starting at 09/09/16 18:52:40, pid = 3678]
16.09.2009 18:52:40.060306 zmdc[3466].ERR ['zmfilter.pl ' exited abnormally, exit status 9]
16.09.2009 18:52:50.064463 zmdc[3466].INF [Starting pending process, zmfilter.pl]
16.09.2009 18:52:50.065091 zmdc[3466].INF ['zmfilter.pl' starting at 09/09/16 18:52:50, pid = 3679]
16.09.2009 18:52:50.071810 zmdc[3466].ERR ['zmfilter.pl ' exited abnormally, exit status 9]
16.09.2009 18:53:10.077466 zmdc[3466].INF [Starting pending process, zmfilter.pl]
16.09.2009 18:53:10.078093 zmdc[3466].INF ['zmfilter.pl' starting at 09/09/16 18:53:10, pid = 3680]
16.09.2009 18:53:10.084901 zmdc[3466].ERR ['zmfilter.pl ' exited abnormally, exit status 9]
16.09.2009 18:53:50.036462 zmdc[3466].INF [Starting pending process, zmfilter.pl]
16.09.2009 18:53:50.037095 zmdc[3466].INF ['zmfilter.pl' starting at 09/09/16 18:53:50, pid = 3701]
16.09.2009 18:53:50.043761 zmdc[3466].ERR ['zmfilter.pl ' exited abnormally, exit status 9]
16.09.2009 18:55:10.052470 zmdc[3466].INF [Starting pending process, zmfilter.pl]
16.09.2009 18:55:10.060053 zmdc[3466].INF [Can't find child with pid of '3745']
16.09.2009 18:55:10.060306 zmdc[3466].INF ['zmfilter.pl' starting at 09/09/16 18:55:10, pid = 3745]
if i run each *.pl in shell it's all work!
16.09.2009 18:52:35.089165 zmdc[3466].INF ['zmfilter.pl' starting at 09/09/16 18:52:35, pid = 3553]
16.09.2009 18:52:35.106440 zmdc[3466].ERR ['zmfilter.pl ' exited abnormally, exit status 9]
16.09.2009 18:52:35.106638 zmdc[3466].INF [Starting pending process, zmfilter.pl]
16.09.2009 18:52:35.109182 zmdc[3466].INF ['zmfilter.pl' starting at 09/09/16 18:52:35, pid = 3556]
16.09.2009 18:52:35.113964 zmdc[3466].ERR ['zmfilter.pl ' exited abnormally, exit status 9]
16.09.2009 18:52:35.209246 zmdc[3466].INF ['zmaudit.pl -c' starting at 09/09/16 18:52:35, pid = 3557]
16.09.2009 18:52:35.216082 zmdc[3466].ERR ['zmaudit.pl -c' exited abnormally, exit status 9]
16.09.2009 18:52:35.216290 zmdc[3466].INF [Starting pending process, zmaudit.pl -c]
16.09.2009 18:52:35.223680 zmdc[3466].INF [Can't find child with pid of '3560']
16.09.2009 18:52:35.223925 zmdc[3466].INF ['zmaudit.pl -c' starting at 09/09/16 18:52:35, pid = 3560]
16.09.2009 18:52:35.323969 zmdc[3466].INF ['zmwatch.pl' starting at 09/09/16 18:52:35, pid = 3561]
16.09.2009 18:52:35.331050 zmdc[3466].ERR ['zmwatch.pl ' exited abnormally, exit status 9]
16.09.2009 18:52:35.331318 zmdc[3466].INF [Starting pending process, zmwatch.pl]
16.09.2009 18:52:35.338821 zmdc[3466].INF [Can't find child with pid of '3564']
16.09.2009 18:52:35.339064 zmdc[3466].INF ['zmwatch.pl' starting at 09/09/16 18:52:35, pid = 3564]
16.09.2009 18:52:35.439834 zmdc[3466].INF ['zmupdate.pl -c' starting at 09/09/16 18:52:35, pid = 3565]
16.09.2009 18:52:35.447132 zmdc[3466].ERR ['zmupdate.pl -c' exited abnormally, exit status 9]
16.09.2009 18:52:35.447352 zmdc[3466].INF [Starting pending process, zmupdate.pl -c]
16.09.2009 18:52:35.455316 zmdc[3466].INF [Can't find child with pid of '3570']
16.09.2009 18:52:35.455560 zmdc[3466].INF ['zmupdate.pl -c' starting at 09/09/16 18:52:35, pid = 3570]
16.09.2009 18:52:40.052471 zmdc[3466].INF [Starting pending process, zmfilter.pl]
16.09.2009 18:52:40.053643 zmdc[3466].INF ['zmfilter.pl' starting at 09/09/16 18:52:40, pid = 3678]
16.09.2009 18:52:40.060306 zmdc[3466].ERR ['zmfilter.pl ' exited abnormally, exit status 9]
16.09.2009 18:52:50.064463 zmdc[3466].INF [Starting pending process, zmfilter.pl]
16.09.2009 18:52:50.065091 zmdc[3466].INF ['zmfilter.pl' starting at 09/09/16 18:52:50, pid = 3679]
16.09.2009 18:52:50.071810 zmdc[3466].ERR ['zmfilter.pl ' exited abnormally, exit status 9]
16.09.2009 18:53:10.077466 zmdc[3466].INF [Starting pending process, zmfilter.pl]
16.09.2009 18:53:10.078093 zmdc[3466].INF ['zmfilter.pl' starting at 09/09/16 18:53:10, pid = 3680]
16.09.2009 18:53:10.084901 zmdc[3466].ERR ['zmfilter.pl ' exited abnormally, exit status 9]
16.09.2009 18:53:50.036462 zmdc[3466].INF [Starting pending process, zmfilter.pl]
16.09.2009 18:53:50.037095 zmdc[3466].INF ['zmfilter.pl' starting at 09/09/16 18:53:50, pid = 3701]
16.09.2009 18:53:50.043761 zmdc[3466].ERR ['zmfilter.pl ' exited abnormally, exit status 9]
16.09.2009 18:55:10.052470 zmdc[3466].INF [Starting pending process, zmfilter.pl]
16.09.2009 18:55:10.060053 zmdc[3466].INF [Can't find child with pid of '3745']
16.09.2009 18:55:10.060306 zmdc[3466].INF ['zmfilter.pl' starting at 09/09/16 18:55:10, pid = 3745]
if i run each *.pl in shell it's all work!