topic Re: Disk full in Management & Governance

Disk full

phultman — Sat, 16 Nov 2024 06:58:22 GMT

Hi all,

I have a problem with my Qlik Sense Enterprise installation. The hard disk is rapidly filling up (se below).

I have not paid attention to the disk space used until I got a warning about full disk last week. Today I created some space (~20Gb) but it has already been filled up. Server has been running without any problem since may this year.

Hope someone can tell me if this is normal behaviour for Qlik? If not, what is wrong and how do I fix it?

Thanks,

Peter

Re: Disk full

Gysbert_Wassenaar — Thu, 27 Dec 2018 15:38:49 GMT

That's most likely the logging that's stored in the QLogs database. You can change the logging configuration to for example set a maximum size of that database or the age of the log entries or disabling logging to the database altogether. See the online help page for more information: https://help.qlik.com/en-US/sense/November2018/Subsystems/PlanningQlikSenseDeployments/Content/Sense_Deployment/Qlik-Logging-Service.htm

Re: Disk full

phultman — Fri, 28 Dec 2018 12:28:06 GMT

Thank you, you are completely right. It is the QLogs database.

I changed the configuration and set the maximum size to 40GB but it doesn't seem to have any effect.

log_entries is 77GB

archive_entries is 35GB

Do I need to do something else to free up space from DB?

Re: Disk full

phultman — Fri, 28 Dec 2018 12:31:07 GMT

---

C:\Program Files\Qlik\Sense\Logging>Qlik.Logging.Service.exe validate
archive_age_in_hours: 720
last_forced_db_trim: 2018-05-03 13:49:49.32026+02
purge_age_in_hours: 1440
version: 0.3

CentralizedLoggingEnabled: True
LoggingToFileEnabled: True
MaximumDatabaseSizeInGB: Max db size(40GB) enforced

---

What does 'last_forced_db_trim' mean? Can I force a trim of the DB?

Re: Disk full

Gysbert_Wassenaar — Fri, 28 Dec 2018 12:43:21 GMT

Yes, see the online help page I posted about. There are archive and purge commands you can use. You will probably also want to vacuum the postgresql database. See the postgresql documentation for the vacuum command.