search

microsoft / durabletask-mssql

Microsoft SQL storage provider for Durable Functions and the Durable Task Framework
MIT License
87 stars 32 forks source link

Support Orchestration restart #73

Closed ghost closed 2 years ago

ghost commented 2 years ago

Trying to manage an Eternal Orchestration is difficult due to:

I believe there is a TODO item in the CreateInstance stored procedure which would address this, but it appears the database schema itself blocks this since it would cause a duplicate key. Perhaps I'm misunderstanding, shouldn't ExecutionId be used as part of the unique identifier? In other words, a combination of TaskHub, InstanceId, and ExecutionId signify a unique orchestration, with ContinueAsNew starting a new Orchestration with the same InstanceId and different ExecutionId.

This ticket requests a solution for restarting orchestrations using the same InstanceId.

cgillum commented 2 years ago

Support for this is now released: https://github.com/microsoft/durabletask-mssql/releases/tag/v1.0.0-rc

ghost commented 2 years ago

Wicked fast, thank you!