Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

unique constraint violation in SQL like persistance in ScheduledCommand table #1321

Open
DudnykOleksandr opened this issue Dec 22, 2024 · 0 comments

Comments

@DudnykOleksandr
Copy link

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.

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant