[zabbix 4.0.8][zabbix proxy][sqlite] sqlite file growing alarmingly

[eljibe]

Hi all,

We have set up a proof of concept for zabbix 4.0.8, with an Innodb Cluster DB, and 3 sqlite proxies.
So far we got everything up and running but sqlite zabbix.db file is groiwng at an alarming rate: we hit 20GB in 24 hours.
So, my question is, how to prevent that. I tried starting the housekeeper but it did not reduce the size of the file.
Do you have any idea as to what is wrong ? how do I housekeep it ?

here is our proxy configuration file:

###############################
# ZABBIX Proxy Configuration  #
###############################
#
Hostname=hlzart1exe0a_proxy
ConfigFrequency=300
# Si ZABBIX Proxy port
# 10051 par defaut si ZABBIX Proxy sur machine dediee
# 20051 si meme machine que ZABBIX Server
ListenPort=10051
#
Server=hlzart1exe0d.yres.ytech
ServerPort=10051
ProxyMode=0
ProxyOfflineBuffer=1
#
PidFile=/opt/ZAR10/Logiciel/ZABXPROXY/run/zabbix_proxy.pid
SocketDir=/opt/ZAR10/Logiciel/ZABXPROXY/run
#
ExternalScripts=/opt/ZAR10/Logiciel/ZABXPROXY/externalscripts
SSHKeyLocation=/home/zabbix/.ssh
#
Timeout=15
TrapperTimeout=300
UnavailableDelay=300
UnreachableDelay=300
UnreachablePeriod=45
#
DebugLevel=3
LogFile=/var/log/ZPX0/zabbix_proxy.log
#SNMPTrapperFile=/var/log/ZPX0/snmptrap.log
LogFileSize=30
LogSlowQueries=10000
#
DBName=/data/ZAR10/ZPX0/sqlite/zabbix.db
#
StartPollers=100
StartTrappers=40
StartDBSyncers=16
StartPollersUnreachable=20
StartPingers=10
StartIPMIPollers=0
StartDiscoverers=0
StartHTTPPollers=100
#
HousekeepingFrequency=24
#
CacheSize=256M
HistoryCacheSize=256M
#
#Ajout SUP JMX
JavaGateway=hlzart1exe0a.yres.ytech
JavaGatewayPort=10052
StartJavaPollers=5

Here's a screenshot of the growth rate...

Thanks for your help.

[eljibe]

I have just noticed and modified HousekeepingFrequency to 1, so that it happens more frequently.
I will delete the zabbix.db file and restart the proxy.
And I will check if anything changes.