Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 );
Hello,
So those two events are harmless to your system.
There is no proper way to get rid of those events as far as I know.
Hope this helps!
Hello,
So those two events are harmless to your system.
There is no proper way to get rid of those events as far as I know.
Hope this helps!
Thank you for the quick response.
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