Ichitux/FarmaFinder
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

fix(n8n): resolve duplicate key constraint on tag_entity during workflow import #49

Merged
Ichitux merged 1 commits from fix/n8n-init-duplicate-key-constraint into main 2026-07-17 13:00:34 +00:00
Conversation 0 Commits 1 Files Changed 7
+58 -28
Ichitux commented 2026-07-17 12:52:24 +00:00
Owner
Copy Link
Copy Source

n8n import:workflow --separate imports each JSON file independently. All 4
workflows shared the same tags (parapharmacy, scraper), so the second import
tried to INSERT duplicate tag names, hitting the unique index on
tag_entity.name.

  • Remove tags field from all 4 workflow JSON files (cosmetic, re-add via UI)
  • Add cleanup-db.js to wipe workflow data before import
  • Add --overwrite flag to import command as safety net
  • Add cleanup-db.js volume mount to n8n-init container
n8n import:workflow --separate imports each JSON file independently. All 4 workflows shared the same tags (parapharmacy, scraper), so the second import tried to INSERT duplicate tag names, hitting the unique index on tag_entity.name. - Remove tags field from all 4 workflow JSON files (cosmetic, re-add via UI) - Add cleanup-db.js to wipe workflow data before import - Add --overwrite flag to import command as safety net - Add cleanup-db.js volume mount to n8n-init container
Ichitux added 1 commit 2026-07-17 12:52:24 +00:00
fix(n8n): resolve duplicate key constraint on tag_entity during workflow import
Run Tests on Branches / Detect Changes (push) Successful in 12s
Details
Run Tests on Branches / Backend Tests (push) Has been skipped
Details
Run Tests on Branches / Frontend Tests (push) Has been skipped
Details
Run Tests on Branches / Frontend Mobile Tests (push) Has been skipped
Details
Run Tests on Branches / Parapharmacy API Tests (push) Has been skipped
Details
Run Tests on Branches / PIP Platform Tests (push) Has been skipped
Details
b4b2bf5834 
n8n import:workflow --separate imports each JSON file independently. All 4
workflows shared the same tags (parapharmacy, scraper), so the second import
tried to INSERT duplicate tag names, hitting the unique index on
tag_entity.name.

- Remove tags field from all 4 workflow JSON files (cosmetic, re-add via UI)
- Add cleanup-db.js to wipe workflow data before import
- Add --overwrite flag to import command as safety net
- Add cleanup-db.js volume mount to n8n-init container
Ichitux merged commit 7fbe7aee48 into main 2026-07-17 13:00:34 +00:00
Ichitux deleted branch fix/n8n-init-duplicate-key-constraint 2026-07-17 13:00:34 +00:00
Sign in to join this conversation.
Reviewers
No Reviewers
Labels
No items
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
Ichitux
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: Ichitux/FarmaFinder#49
Delete Branch "fix/n8n-init-duplicate-key-constraint"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?