danielgerlag / danielgerlag/workflow-core

unique constraint violation in SQL like persistance in ScheduledCommand table

Open
#1,321 0 comments 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.