danielgerlag / danielgerlag/workflow-core
unique constraint violation in SQL like persistance in ScheduledCommand table
- Dominant language
- C#
- Stars
- 5.9k
- Forks
- 1.3k
- Avg merge
- 1d 1h
- Merged PRs (30d)
- 5
Description
**Describe the bug**
After some time DB keeps complaining about duplicate key value violations in ScheduledCommand table.
2024-12-22 17:34:51.017 UTC [20373] ERROR: duplicate key value violates unique constraint "IX_ScheduledCommand_CommandName_Data"
2024-12-22 17:34:51.017 UTC [20373] DETAIL: Key ("CommandName", "Data")=(ProcessWorkflow, b0d7c172-faf6-4cce-894c-eec895c9859f) already exists.
2024-12-22 17:34:51.017 UTC [20373] STATEMENT: INSERT INTO wfc."ScheduledCommand" ("CommandName", "Data", "ExecuteTime")
**To Reproduce**
Steps to reproduce the behavior:
1. Use a SQLite or postgreSQL as persistence
2. Create a complex workflow with external activity.
3. Use it for some time.
**Expected behavior**
No issues.
**Additional context**
Add any other context about the problem here.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.