Error message in Windows Event logs : only superuser can VACUUM it

Error message in Windows Event Logs:
 

The description for Event ID '0' in Source 'PostgreSQL' cannot be found.  The local computer may not have the necessary registry information or message DLL files to display the message, or you may not have permission to access them.  The following information is part of the event:'ATTENTION:  ignore « pg_pltemplate » --- only superuser can vacuum it

 

Environments :

• Sense November 2017 all patches
• Sense February 2018 all patches

 

How to reproduce:

Set up Qlik Logging Service, ensure QLogs_writer is not a super user and check for errors in windows event logs.


 

Bug QLIK-85306 : Postgres issues warnings on vacuum 

The event log in Windows shows that Postgres is issuing warnings due to user trying to do vacuum on system tables.

Description :

"WARNING: skipping "pg_shseclabel" — only superuser can vacuum it" in the logs

Does it have impact on performance?

The database clean up code that invokes the vacuum command runs only once an hour and unlikely to have any significant impact on performance.
It is possible for the centralized logging service to be bogged down as it waits for the clean up routine to complete; but that should have no impact on the rest of the system.

Workaround :

If you don't use Qlik Log Service; stop it and set it to "Manual Start"

Fixed ?

This bug is fixed in April 2018 release.

Information provided on this defect is given as is at the time of documenting.  For up to date information, please review the most recent Release Notes, or contact support with the ID QLIK-85306 for reference. ​