topic Re: Error in postgres as deploying multiple nodes. in Management & Governance

Error in postgres as deploying multiple nodes.

GusthavoLima — Sat, 16 Nov 2024 01:12:19 GMT

Hello guys, I recently implemented a qlik sense cluster, using a Master Node and two Slaves. However I am getting the following error in postgres.

ERROR: duplicate key value violates unique constraint "ix_sensemq_target_topic_messageid"
DETAIL: Key (target, topic, messageid)=(AppDistributionService, app.update, 9ab82626-a136-48e0-85ff-8687d56d9c0a) already exists.
STATEMENT:
INSERT INTO sensemq (id, messageid, messagetype, createddate, expirydate, source, target, topic, data)
VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9)

For the implementation of the Master Node, the backup was performed followed by the restore of the old server.

Re: Error in postgres as deploying multiple nodes.

mbrdenmark — Mon, 09 Nov 2020 07:19:16 GMT

Like to hear more on this. I see this error 100's of times throughout the day in the event log as well.

I don't noticed any problems in the operation of Sense itself, but I see elevated CPU consumption for the repository service after this issue escalated after upgrading to Qlik Sense June 2020.

Re: Error in postgres as deploying multiple nodes.

Brett_Bleess — Thu, 12 Nov 2020 17:13:41 GMT

@GusthavoLima About the best I have is the following Help link that should provide the official steps on creating the multi-node cluster, so you can verify you followed the steps correctly:

https://help.qlik.com/en-US/sense-admin/November2020/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Installing-Qlik-Sense-multi-node.htm

Regards,
Brett

Re: Error in postgres as deploying multiple nodes.

martinhazer — Tue, 12 Jan 2021 10:32:23 GMT

Hi all,
I have the same issue in multinode deployment.
We also migrated the central node to the new machine.
It is quite possible that migration is related to this.
Any idea what exactly it could cause? @Brett_Bleess

Thank you very much.
MH

Re: Error in postgres as deploying multiple nodes.

mhenning — Mon, 03 May 2021 19:52:36 GMT

Hi Gustavo, we are having this same issue in a single node June 2020 Patch 1 environment. Did you ever work out a fix?

Re: Error in postgres as deploying multiple nodes.

Jaroslav_Stsetinin — Tue, 14 Sep 2021 13:51:59 GMT

This bug was fixed in May 2021 Patch 2 and later. You need to upgrade your Qlik Sense.