topic Re: _deletedentitylog spaming in Management & Governance

_deletedentitylog spaming

Anders_Eriksson — Wed, 21 Dec 2022 14:45:38 GMT

Have a testserver for Qlik Sense.
On that the Repository DB table _deletedentitylog is going crazy and spaming GBs of data filling up the C-drive.
This happens in short amount of time and causes problems to the server even though it is a test server (with test licens) and very few occasional users.
I've followed this article in order to limit was is logged and have Qlik clean the table more frequently but does not help.
https://community.qlik.com/t5/Official-Support-Articles/deletedentitylogs-take-up-disk-space-on-C/ta-p/1713929

Did see a comment of someone deleting this table and running without it, is that safe?
I have truncated the table on several occasions last month to free up many GBs of space.
Today that recovered 30 GBs even though the configuration says to clean the table after three days!

What can cause this amount of data being logged to this table in short time?
Entity Type = StaticContentReference looks to be very frequently logged.

Re: _deletedentitylog spaming

Alan_Slaughter — Wed, 21 Dec 2022 15:14:58 GMT

Hi Anderseriksson, I would suggest the following articles:

1. https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Steps-to-reduce-Excessive-HDD-space-occupied-by/ta-p/1714166

2. https://community.qlik.com/t5/Official-Support-Articles/Deprecation-of-Centralized-Logging-in-Qlik-Sense-Enterprise-on/ta-p/1810794

3. https://community.qlik.com/t5/Official-Support-Articles/Failed-to-log-deleted-entities-Error-duplicate-key-value/ta-p/1716879

Re: _deletedentitylog spaming

Anders_Eriksson — Thu, 22 Dec 2022 08:29:15 GMT

Thanks for the reply Alan, but;
1) article is about logging database, our problem is specifically with QSR table _deletedentitylog
2) again article is about logging database
3) article is about not being able to add new rows to _deletedentitylog, the opposite of our problems

In less than 24 hours of running the test server with minimal usage the QSR _deletedentitylog table has accumulated more than 3 million rows!

Re: _deletedentitylog spaming

Anders_Eriksson — Thu, 22 Dec 2022 08:33:12 GMT

Production server where the QSR._deletedentitylog has not been cleaned for a long time only has 90 000 rows!

Re: _deletedentitylog spaming

Anders_Eriksson — Thu, 22 Dec 2022 09:55:50 GMT

Now implementing the sql-delete scheduled in Windows from this post;
https://community.qlik.com/t5/Official-Support-Articles/Failed-to-log-deleted-entities-Error-duplicate-key-value/ta-p/1716879

Re: _deletedentitylog spaming

Chip_Matejowsky — Thu, 22 Dec 2022 15:17:31 GMT

Hi @Anders_Eriksson,

Have a look at Qlik knowledgebase article _deletedentitylogs take up disk space on C:\ to see if that is what you need.

Best Regards

Re: _deletedentitylog spaming

Anders_Eriksson — Fri, 30 Dec 2022 10:13:58 GMT

I already mentioned that article in my initial posting!
That is not what I need and it did not help.

Re: _deletedentitylog spaming

Filippo_Nicolussi_P — Wed, 30 Aug 2023 13:24:33 GMT

@Anders_Eriksson based on that article you could add to :

Based on your request I suppose you used on the DB a query like "select count("entityid"),"entitytype" from "_deletedentitylog" group by "entitytype" order by count("entityid") desc;"

to get the most mutable/deleted entity types, that you could more or less add to the option DeletedEntityLog.ExcludedEntities.

Unfortunately <add key="DeletedEntityLog.ExcludedEntities" value="*" /> is not allowed.