purge when full

Forum for questions and support relating to the 1.25.x releases only.
Locked
tibetfreedom
Posts: 163
Joined: Fri Oct 22, 2010 11:21 am

purge when full

Post by tibetfreedom »

sorry this is really stupid but can someone post a default purge when full config ? i want to purge after 65%


i am getting this...

Code: Select all

SQL-ERR 'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and E.Archived = 0 )' at line 1', statement was 'select count(E.Id) as EventCount from Monitors as M inner join Events as E on (M.Id = E.MonitorId) where 1 and ( 86 >= 65% and E.Archived = 0 )'
Attachments
purge.tiff
purge.tiff (73.31 KiB) Viewed 1478 times
mikb
Posts: 603
Joined: Mon Mar 25, 2013 12:34 pm

Re: purge when full

Post by mikb »

That error message looks horrid, you certainly shouldn't see that, no matter what you tried as config!

At a guess, looking at the SQL error, have you literally put "65%" in the box in your config? Try just "65" (no %), you might be confusing MySQL. Look at the comparison bit of the SQL statement at the end.

As a guide, mine says :-

Archived Status, equal to, Unarchived Only
and, Disk Percent, greater than or equal to, 95

Sort by, ID, Asc, Limit to first, 50, results only
Delete all matches [Tick]
Locked