OrchardCMS / OrchardCore

Orchard Core is an open-source modular and multi-tenant application framework built with ASP.NET Core, and a content management system (CMS) built on top of that framework.
https://orchardcore.net
BSD 3-Clause "New" or "Revised" License
7.21k stars 2.34k forks source link

SQLite database locking when executing workflow #3917

Open jptissot opened 4 years ago

jptissot commented 4 years ago

When an exception occurs as part of a CreateContentTask or a createContenItem() call during a workflow, the sqlite database locks up.

We created a custom YesSql.Indexes.IndexProvider that was throwing a NRE if some value was null. When this happens during the execution of a workflow, the sqlite database locks up and the workflow instance never gets created.

I was able to find the issue by looking at the logs in App_Data/logs.

Workflows should gracefully handle the error instead of locking the database.

sebastienros commented 4 years ago

Thanks for the repro