Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
@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:
Regards,
Brett
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
Hi Gustavo, we are having this same issue in a single node June 2020 Patch 1 environment. Did you ever work out a fix?
This bug was fixed in May 2021 Patch 2 and later. You need to upgrade your Qlik Sense.