filter not delete events
Posted: Wed Sep 16, 2009 9:32 am
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!
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!