imunify360.db-wal file too large

[petar.kozic]

Hi,

I have installed imunify360 on several WHM servers. On one server file on location /var/imunify360/imunify360.db-wal using 24G.
All servers have same settings and almost same number of accounts etc.. on other server this file using about 2.5G

Someone have idea what can cause this size of file or how to solve this?

[petar.kozic]

I solved problem with:

stop imunify:

systemctl stop imunify360

check db:

imunfy360-agent checkdb

Checking not solve the problem, I run:

imunify360-agent migratedb

Then, start the service again:

systemctl start imunify360

[mchernyavsky]

Hello Petar,

Indeed stopping the imunify360 service will drop the temp files for the SQLLite, while checkdb will only check DB's structure. One of the assumptions is that the problem is caused by concurrent access to SQLite DB by multiple processes:

lsof /var/imunify360/imunify360.db

Although it is possible that there will be no 3d parties involved. In this regard, the latest improvements on this issue were made in ProactiveDefence 7.2.0 released on 12 of December:

• DEF-21772: imunify360.db-wal can grow up to several gigabytes

Please let me know your Imunify360 version.

In addition, if the issue is causing problems and you need a workaround, you may proceed with the following command:

/opt/alt/sqlite/usr/bin/sqlite3 /var/imunify360/imunify360.db "PRAGMA wal_checkpoint(TRUNCATE);"