topic Re: PostgreSQL event viewer errors in Management & Governance

PostgreSQL event viewer errors

MynhardtBurger — Sat, 16 Nov 2024 06:01:49 GMT

Our November 2018 Patch 2 Qlik Sense install has been experiencing some crashes and bouts of non-responsiveness.

When reviewing the windows event viewer the errors all seems to relate to PostgreSQL.

Did something in our postgresql database get corrupted?
Is there a way to repair the database?

The two most common errors are listed below:

The description for Event ID 0 from source PostgreSQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event: 

ERROR:  column c.CreatedOn does not exist at character 10
STATEMENT:  SELECT 
	c."CreatedOn"
	FROM "__MigrationHistory" AS c
	LIMIT 1

The description for Event ID 0 from source PostgreSQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event: 

ERROR:  relation "nodes" already exists
STATEMENT:  CREATE TABLE nodes (
		hash BYTEA PRIMARY KEY,
		refs INT NOT NULL,
		value BYTEA,
		value_string TEXT,
		datatype TEXT,
		language TEXT,
		iri BOOLEAN,
		bnode BOOLEAN,
		value_int BIGINT,
		value_bool BOOLEAN,
		value_float double precision,
		value_time timestamp with time zone
	);

Re: PostgreSQL event viewer errors

Bastien_Laugiero — Tue, 23 Apr 2019 08:11:24 GMT

Hello,

So those two events are harmless to your system.

The first one will occur every time you start the Qlik Sense Repository Service https://support.qlik.com/articles/000005410
The second one shows up whenever precedents service starts up (Qlik Sense Dispatcher Service), we re-run the appropriate database initialization request. This is to ensure the required tables exist before we start using them. An unfortunate side effect is that an event gets logged when the tables already exist https://support.qlik.com/articles/000071291

There is no proper way to get rid of those events as far as I know.

Hope this helps!

Re: PostgreSQL event viewer errors

MynhardtBurger — Tue, 23 Apr 2019 08:15:59 GMT

Thank you for the quick response.

Re: PostgreSQL event viewer errors

Raju_6952 — Thu, 21 Sep 2023 00:30:19 GMT

Hi @Bastien_Laugiero ,

Is there any way to fix this error?

Regards,

Raju

Re: PostgreSQL event viewer errors

Bamendaboyplus — Fri, 06 Oct 2023 20:35:54 GMT

I have had to replace 3 hardware\servers in less than 3 months, every time to replace the last one. I was/am not sure why the servers go offline on their own, first I though it was a hardware issue but now its obvious its software. Only thing running is Qlik, I see a lot of the postgre errors in logs, any ideas will help , running release feb 2023