New Member

Question

System event Requested to trim database tables

Forum|Forum|10 years ago
March 27, 2016
12 replies
14369 views

I keep getting the following warning message about every 1 hours. "Requested to trim database tables older than 442days to enforce the auto-delete policy for Adom FortiAnalyzer."

Other information:

1) The system has only been running for about 40 days

2) this is analyzer v5.4.0-build1019 160217 (GA)

3) this is a VM running in AWS

scao_FTNT

Staff

can you help do a check for below config?

config system auto-delete config log-auto-deletion set status enable set value xx set when xx end end

and before upgrade to 5.4, is there old logs from old build?

Thanks

Simon

dgp_fortinetAuthor

New Member

I ran the following command

config system auto-delete config log-auto-deletion set status enable set value 400 set when month 12 end end

Yes there were old logs from 5.2 but not longer than 40 days. I just upgraded last week.

scao_FTNT

Staff

can you provide "diag log device"?

by the way, "set when month 12" this seems not correct config, maybe "set when month"?

Thanks

Simon

dgp_fortinetAuthor

New Member

FAZVM64-AWS # diag log device

Device Name Device ID Used Space(logs / quarantine / content / IPS) Allocated Space Used%

43.1MB( 43.1MB/ 0.0KB/ 0.0KB/ 0.0KB) 1000.0MB 4.3%

J 45.3MB( 45.3MB/ 0.0KB/ 0.0KB/ 0.0KB) 1000.0MB 4.5%

51.9MB( 51.9MB/ 0.0KB/ 0.0KB/ 0.0KB) 1000.0MB 5.2%

Total: 3 log devices, used=140.3MB quota=2.9GB

AdomName AdomOID Type Logs Database

 [Retention Quota UsedSpace(logs / quarantine / content / IPS) Used%] [Retention Quota Used Used%]

root 3 FGT 442days 14.0GB 140.3MB( 140.3MB/ 0.0KB/ 0.0KB/ 0.0KB) 1.0% 442days 21.0GB 1.9GB 9.2%

Total usage: 1 ADOMs, logs=140.3MB database=2.0GB(ADOMs usage:1.9GB + Internal Usage:111.4MB)

Total Quota Summary:

 Total Quota Allocated Available Allocate%

 63.7GB 35.0GB 28.7GB 54.9%

System Storage Summary:

 Total Used Available Use%

 78.7GB 7.2GB 71.5GB 9.2 %

Reserved space: 15.0GB (19.0% of total space).

Sign up

Login with SSO

Login to the community

Login with SSO