search

wanlitao / HangfireExtension

Hangfire Extension plugins
Apache License 2.0
22 stars 32 forks source link

Database is locked error #17

Closed arielmoraes closed 6 years ago

arielmoraes commented 6 years ago

When using SQLite with a recurring job the error SQLite error (5): database is locked is shown in the output window many times, after that rows are inserted into the State table and they stay with the Processing state.

I'm using Hangfire in a Windows Service following the docs.

wanlitao commented 6 years ago

please refer to my comment on #3

0xced commented 5 years ago

I have configured the background job server options with WorkerCount = 1 but I'm still getting those errors:

SQLite error (5): database is locked in "select Value from [HangFire.Set] where [Key] = @key and Score between @from and @to order by Score limit 1"