I am facing this issue randomly with no reason sometimes it works great sometime it just happens and no matter if i create duplicate workflow or copy nodes to new one it doesn’t goes away:
Describe the issue/error/question
The workflow portion i have pasted below, you can see, it has 2 insert nodes which are inserting data properly, but after everything is done somehow it inserts same data again(as duplicate entry).
This is totally random sometimes twice and sometime thrice.
have tried various scenarios connecting and removing various nodes but I can’t understand the logic why it would happen.
I even enabled execute once on both mysql nodes still no use.
duplicates get created in the table.
After lot of hit and trial connection and disconnection it pinpointed the issue at http node, if i remove the http node one step before the previous workflow portion i shared, it works wonderfully, but of course http node is a must have.
Why would a http node trigger unwanted mysql query ?
If i disconnect the Http node and join the workflow directly to other mysql nodes it creates normal entry but no duplicate.
Hi @mayanktiwari, I am sorry to hear you’re having trouble. Tbh I can’t see how the HTTP Request node would cause the behaviour you have reported but perhaps I am missing something here. I tried reproducing your problem using the below docker compose setup:
This is the strangest issue i have faced ever, I have no idea how to reproduce it’s just happening and overall not making any sense to me. I even checked if there may be some hidden function or trigger implemented in the mysql but none is there.
@MutedJam we found out the issue and it was neither in n8n, or any of other elements like mysql, nginx etc.
It was another workflow which was updating the data from another webhook trigger,
as soon as the entry was getting created in hubspot it would trigger the webhook which in turn would trigger another workflow. we had to do a lot of trials to find out the issue exactly.
It was completely on our end.
Thank you for trying out and testing in order to help out.