Hello

I tried to downgrade from 3.0.4119 to 3.0.3945 and it works fine.
I will try the upgrade again

xp-1000 on 22 Jan 2019

OK I upgraded 1 by 1 version and now it works with 3.0.4119.
sorry to inconvenience

xp-1000 on 22 Jan 2019

Hello, after 2 days the problem appears again without any action (upgrade or other), the service was never restarted (the process pid is the same from 2 days)

xp-1000 on 24 Jan 2019

come back to 3.0.3988 and it works, I suspect the impacted version was 3.0.4036 (may be related to failed requests queue new feature).

xp-1000 on 24 Jan 2019

Hello,
ok I confirm I tested 3.0.4036 during one day and the locking problem appears again and as for last time the pid of ombi is the same so the process was never restarted.
It in my case it impacts 2 last versions 4119 and 4036 but it works with 3988.

xp-1000 on 25 Jan 2019

👍4

I am seeing the same issue. On 3.0.4119. Downgrading to 3.0.3945 has everything working again.

danielcbaldwin on 4 Feb 2019

👍2

Anyone have any more logs?

tidusjar on 11 Feb 2019

This issue with this is the SQLite will lock the whole .db file when a database transaction occurs, it is useless for applications with concurrent transactions. I have been able to work around this by splitting out the databases so we see less locks.

I did create a POC to allow the user to also run MySQL instead of SQLite which would solve this, but that means the user would need to host a MySQL database.

Another option is to split out the databases even more, one logical place would be to remove the Users table and user information e.g. roles from the Ombi.db as that's where the locks seem to be occurring. But due to this being a relational database structure there are a lot of foreign key constrains against the User e.g. a Request object needs to have a valid user. So doing that would require a considerable amount of work as the code also expects the constraint to be enforced.

So I guess we have two options, the second will probably need to be done, split out the databases even more. Then the first option would be a benefit for more technical users to manage the database externally.

tidusjar on 11 Feb 2019

Hello,

Sorry I have no more log I sent to you.

I understand your last point but I don't understand in your explanation why this lock bug impacts only versions after 3.0.3988.

How can I switch to mysql ? there is no problem in my case and will allow me to upgrade ombi to last version rather than stay stucked on 3.0.3988

xp-1000 on 11 Feb 2019

This issue happens daily - cant even login unless reset service. I would love to try out the MySQL option if it solves this.

Version | 3.0.4119
-- | --
Branch | master

More logs :

2019-02-14 09:54:46.129 -07:00 [Error] Something bad happened, ErrorMiddleware caught this
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText)
at Microsoft.Data.Sqlite.SqliteTransaction.Commit()
at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.Commit()
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(DbContext _, ValueTuple2 parameters, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList1 entriesToSave, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.AspNetCore.Identity.EntityFrameworkCore.UserStore9.UpdateAsync(TUser user, CancellationToken cancellationToken) at Microsoft.AspNetCore.Identity.UserManager1.UpdateUserAsync(TUser user)
at Ombi.Controllers.TokenController.CreateToken(Boolean rememberMe, OmbiUser user) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 127
at Ombi.Controllers.TokenController.GetToken(UserAuthModel model) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 72
at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext)
at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware.InvokeCore(HttpContext context)
at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 50
at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24

Mfellner77 on 14 Feb 2019

Here's my log:
Let me know if you need anything else.

--host (Default: http://:5000) Set to a semicolon-separated (;) list
of URL prefixes to which the server should respond. For example,
http://localhost:123. Use "" to indicate that the server should
listen for requests on any IP address or hostname using the
specified port and protocol (for example, http://*:5000). The
protocol (http:// or https://) must be included with each URL.
Supported formats vary between servers.

--storage Storage path, where we save the logs and database

--baseurl The base URL for reverse proxy scenarios

--help Display this help screen.

--version Display version information.

We are running on
/opt/ombi
[41m[30mfail[39m[22m[49m: Ombi.Api.Api[1000]
StatusCode: BadRequest, Reason: Bad Request, RequestUri: http://192.168.0.24:8989/sonarr/api/series/
[41m[30mfail[39m[22m[49m: Ombi.Api.Api[1000]
StatusCode: BadRequest, Reason: Bad Request, RequestUri: http://192.168.0.24:8989/sonarr/api/series/
[41m[30mfail[39m[22m[49m: Ombi.Api.Api[1000]
StatusCode: BadRequest, Reason: Bad Request, RequestUri: http://192.168.0.24:8989/sonarr/api/series/0
Application startup exception: Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues)
at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlCommand(DatabaseFacade databaseFacade, RawSqlString sql, IEnumerable`1 parameters)
at Ombi.Store.Context.OmbiContext.Seed() in C:\projects\requestplex\src\Ombi.Store\Context\OmbiContext.cs:line 91
at Ombi.Startup.Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory, IMemoryCache cache, IServiceProvider serviceProvider) in C:\projects\requestplex\src\Ombi\Startup.cs:line 221
--- End of stack trace from previous location where exception was thrown ---
at Microsoft.AspNetCore.Hosting.ConventionBasedStartup.Configure(IApplicationBuilder app)
at Microsoft.AspNetCore.Hosting.Internal.WebHost.BuildApplication()

Unhandled Exception: Microsoft.Data.Sqlite.SqliteException: SQLite Error 5: 'database is locked'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues)
at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlCommand(DatabaseFacade databaseFacade, RawSqlString sql, IEnumerable`1 parameters)
at Ombi.Store.Context.OmbiContext.Seed() in C:\projects\requestplex\src\Ombi.Store\Context\OmbiContext.cs:line 91
at Ombi.Startup.Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory, IMemoryCache cache, IServiceProvider serviceProvider) in C:\projects\requestplex\src\Ombi\Startup.cs:line 221
--- End of stack trace from previous location where exception was thrown ---
at Microsoft.AspNetCore.Hosting.ConventionBasedStartup.Configure(IApplicationBuilder app)
at Microsoft.AspNetCore.Hosting.Internal.WebHost.BuildApplication()
at Microsoft.AspNetCore.Hosting.Internal.WebHost.StartAsync(CancellationToken cancellationToken)
at Microsoft.AspNetCore.Hosting.WebHostExtensions.RunAsync(IWebHost host, CancellationToken token, String shutdownMessage)
at Microsoft.AspNetCore.Hosting.WebHostExtensions.RunAsync(IWebHost host, CancellationToken token)
at Microsoft.AspNetCore.Hosting.WebHostExtensions.Run(IWebHost host)
at Ombi.Program.Main(String[] args) in C:\projects\requestplex\src\Ombi\Program.cs:line 99
Hello, welcome to Ombi
Valid options are:
Ombi 3.0.4119-master
Copyright (C) 2019 Ombi

--host (Default: http://:5000) Set to a semicolon-separated (;) list
of URL prefixes to which the server should respond. For example,
http://localhost:123. Use "" to indicate that the server should
listen for requests on any IP address or hostname using the
specified port and protocol (for example, http://*:5000). The
protocol (http:// or https://) must be included with each URL.
Supported formats vary between servers.

--storage Storage path, where we save the logs and database

--baseurl The base URL for reverse proxy scenarios

--help Display this help screen.

--version Display version information.

We are running on
/opt/ombi
[41m[30mfail[39m[22m[49m: Ombi.Api.Api[1000]
StatusCode: BadRequest, Reason: Bad Request, RequestUri: http://192.168.0.24:8989/sonarr/api/series/
[41m[30mfail[39m[22m[49m: Ombi.Api.Api[1000]
StatusCode: BadRequest, Reason: Bad Request, RequestUri: http://192.168.0.24:8989/sonarr/api/series/
[41m[30mfail[39m[22m[49m: Ombi.Api.Api[1000]
StatusCode: BadRequest, Reason: Bad Request, RequestUri: http://192.168.0.24:8989/sonarr/api/series/0
Application startup exception: Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues)
at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlCommand(DatabaseFacade databaseFacade, RawSqlString sql, IEnumerable`1 parameters)
at Ombi.Store.Context.OmbiContext.Seed() in C:\projects\requestplex\src\Ombi.Store\Context\OmbiContext.cs:line 91
at Ombi.Startup.Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory, IMemoryCache cache, IServiceProvider serviceProvider) in C:\projects\requestplex\src\Ombi\Startup.cs:line 221
--- End of stack trace from previous location where exception was thrown ---
at Microsoft.AspNetCore.Hosting.ConventionBasedStartup.Configure(IApplicationBuilder app)
at Microsoft.AspNetCore.Hosting.Internal.WebHost.BuildApplication()

Unhandled Exception: Microsoft.Data.Sqlite.SqliteException: SQLite Error 5: 'database is locked'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues)
at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlCommand(DatabaseFacade databaseFacade, RawSqlString sql, IEnumerable`1 parameters)
at Ombi.Store.Context.OmbiContext.Seed() in C:\projects\requestplex\src\Ombi.Store\Context\OmbiContext.cs:line 91
at Ombi.Startup.Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory, IMemoryCache cache, IServiceProvider serviceProvider) in C:\projects\requestplex\src\Ombi\Startup.cs:line 221
--- End of stack trace from previous location where exception was thrown ---
at Microsoft.AspNetCore.Hosting.ConventionBasedStartup.Configure(IApplicationBuilder app)
at Microsoft.AspNetCore.Hosting.Internal.WebHost.BuildApplication()
at Microsoft.AspNetCore.Hosting.Internal.WebHost.StartAsync(CancellationToken cancellationToken)
at Microsoft.AspNetCore.Hosting.WebHostExtensions.RunAsync(IWebHost host, CancellationToken token, String shutdownMessage)
at Microsoft.AspNetCore.Hosting.WebHostExtensions.RunAsync(IWebHost host, CancellationToken token)
at Microsoft.AspNetCore.Hosting.WebHostExtensions.Run(IWebHost host)
at Ombi.Program.Main(String[] args) in C:\projects\requestplex\src\Ombi\Program.cs:line 99
Hello, welcome to Ombi
Valid options are:
Ombi 3.0.4119-master
Copyright (C) 2019 Ombi

--host (Default: http://:5000) Set to a semicolon-separated (;) list
of URL prefixes to which the server should respond. For example,
http://localhost:123. Use "" to indicate that the server should
listen for requests on any IP address or hostname using the
specified port and protocol (for example, http://*:5000). The
protocol (http:// or https://) must be included with each URL.
Supported formats vary between servers.

--storage Storage path, where we save the logs and database

--baseurl The base URL for reverse proxy scenarios

--help Display this help screen.

--version Display version information.

We are running on
/opt/ombi
[41m[30mfail[39m[22m[49m: Ombi.Api.Api[1000]
StatusCode: BadRequest, Reason: Bad Request, RequestUri: http://192.168.0.24:8989/sonarr/api/series/
[41m[30mfail[39m[22m[49m: Ombi.Api.Api[1000]
StatusCode: BadRequest, Reason: Bad Request, RequestUri: http://192.168.0.24:8989/sonarr/api/series/
[41m[30mfail[39m[22m[49m: Ombi.Api.Api[1000]
StatusCode: BadRequest, Reason: Bad Request, RequestUri: http://192.168.0.24:8989/sonarr/api/series/0`

JSKershaw on 15 Feb 2019

Any ideas what I can do to get my Docker instance running with these new updates? I downloaded the latest linuxserver container but that didn't do anything for me. Do I need to switch to a development version?

clambert11 on 17 Feb 2019

Yes you will need to use the lsiodev container

tidusjar on 17 Feb 2019

👍1

Currently running 4256. I'm logged in but it's telling me the database is locked when adding a movie. Just wanted to report it. https://pastebin.com/wuZumupp

clambert11 on 23 Feb 2019

I've tried running a bunch of different versions and they are all telling me the database is locked. I don't really want to start from scratch as I had a lot of notification configs that I was using and having to go recreate them would be very difficult.

We are running on

i
Hosting environment: Production
Content root path: /opt/ombi
Now listening on: http://[::]:3579
Application started. Press Ctrl+C to shut down.
[41m[30mfail[39m[22m[49m: Ombi.ErrorHandlingMiddleware[0]
Something bad happened, ErrorMiddleware caught this
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.

at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText)
at Microsoft.Data.Sqlite.SqliteTransaction.Commit()
at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.Commit()
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(DbContext _, ValueTuple`2 parameters, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList`1 entriesToSave, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.AspNetCore.Identity.EntityFrameworkCore.UserStore`9.UpdateAsync(TUser user, CancellationToken cancellationToken)
at Microsoft.AspNetCore.Identity.UserManager`1.UpdateUserAsync(TUser user)
at Ombi.Controllers.TokenController.CreateToken(Boolean rememberMe, OmbiUser user) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 127
at Ombi.Controllers.TokenController.OAuth(Int32 pinId) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 194
at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)

at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext)
at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext)
at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 51
at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24

Daedilus on 24 Feb 2019

Same issue here, logs same as deadilus. Redid Ombi yesterday and was working fine. Removed all .db files and started over, connected ombi to Plex and than put original database back added some new users, tested a local admin user and all was working. Today can’t login and again database locked. Was on docker develop, tried older versions but nothing works.

Edit: made a identical ombi instance yesterday for 4K request, this one also got the same issue. Not even in production yet so nothing was changed in that database.

Iguana9999phil on 25 Feb 2019

Can someone with the current issue please create me a user to login and then send me their databases please with the login info to [email protected] and reference this issue. Databases needed is Ombi.db OmbiSettings and ombiexternal

tidusjar on 25 Feb 2019

Can someone please try out build 3.0.4286 (latest dev) https://ci.appveyor.com/project/tidusjar/requestplex/builds/22640365/artifacts

Unfortunately this is not an easy fix and there is going to be a lot of incremental changes to fix this.

tidusjar on 25 Feb 2019

I’m on the docker dev branch, is that one auto updated? It says 3.0.4287-ls9 So guess so
Edit: guess not as it says 3.0.4275 Develop in the about screen. I’m unable to create a user, would a VPS with ombi and the affected db’s be handy for you for debugging etc instead of sending the database via mail?

Iguana9999phil on 26 Feb 2019

I might also have this problem, but I cannot login.

It loops "Authenticating Loading.... Please Wait"

build_version | Linuxserver.io version:- v3.0.4256-pkg-46432ad1-dev-fab689a096cd9ee84c108a5aadc978e02e3a6e26 Build-date:- 2019-02-22T20:47:26+00:00
-- | --
com.docker.compose.config-hash | 032e81e3085090d5eacb332623b5b284400b8a0910fef2770c32205b7edba74b
com.docker.compose.container-number | 1
com.docker.compose.oneoff | False
com.docker.compose.project | opt
com.docker.compose.service | ombi
com.docker.compose.version | 1.21.2

Chrome console:

Failed to load resource: the server responded with a status of 500 ()
app.js:1530 e {headers: t, status: 500, statusText: "OK", url: "https://ombi.domain.com/api/v1/token/1846591516", ok: false, …}

Contents of that error:

error: {error: "SQLite Error 5: 'database is locked'."}
headers: t {normalizedNames: Map(0), lazyUpdate: null, lazyInit: ƒ}
message: "Http failure response for https://ombi.domain.com/api/v1/token/1846591516: 500 OK"
name: "HttpErrorResponse"
ok: false
status: 500
statusText: "OK"
url: "https://ombi.domain.com/api/v1/token/1846591516"
__proto__: Object

Ombi Log:
https://pastebin.com/CUV8QXKe

Orgv2 log:
February 25, 2019 9:44 PM | SYSTEM | IP ADDRESS | OMBI Connect Function - Error: cURL error 28: Operation timed out after 10000 milliseconds with 0 bytes received

Since database & settings integrity isn't important for me (Literally takes 4 minutes to setup ombi) I just deleted it and reinstalled with the linuxserver/ombi:latest docker container & fixed my problems. Figured I should post this info here if it might help.

SCRPD on 26 Feb 2019

@SCRPD Do you still have the old DB that was causing the issue?

That's the one that seems to be the most common where the user cannot log in due to the DB being locked.

tidusjar on 26 Feb 2019

@tidusjar I have a backup of that DB. I can send you that info after work today.

SCRPD on 26 Feb 2019

@tidusjar

Sent you an email.

SCRPD on 26 Feb 2019

I've just pushed some changes to develop that hopefully will help.

Can someone please try the latest develop and let me know?

tidusjar on 6 Mar 2019

So I tried updating Docker container linuxserver/ombi:devlopment and it still seems to be on 4287. I used to be on lsiodev/ombi-preview:latest (mentioned to use above in the thread) but when that container didn't seem to be updating Rox said to switch to linuxserver/ombi:devlopment. What container should I actually be using for development? My database isn't currently locked, so I'm probably not going to be of much help at the moment but I do want to assure I'm using the proper container.

clambert11 on 6 Mar 2019

I've just pushed some changes to develop that hopefully will help.

Can someone please try the latest develop and let me know?

I updated my linuxserver docker container to development and tried logging in. Same locking issue. Here are the logs.
`Hello, welcome to Ombi
Valid options are:
Ombi 3.0.4287-develop
Copyright (C) 2019 Ombi

--host (Default: http://:5000) Set to a semicolon-separated (;) list
of URL prefixes to which the server should respond. For example,
http://localhost:123. Use "" to indicate that the server should
listen for requests on any IP address or hostname using the
specified port and protocol (for example, http://*:5000). The
protocol (http:// or https://) must be included with each URL.
Supported formats vary between servers.

--storage Storage path, where we save the logs and database

--baseurl The base URL for reverse proxy scenarios

--demo Demo mode, you will never need to use this, fuck that fruit
company...

--help Display this help screen.

--version Display version information.

We are running on
/opt/ombi
Hosting environment: Production
Content root path: /opt/ombi
Now listening on: http://[::]:3579
Application started. Press Ctrl+C to shut down.
fail: Ombi.Api.Api[1000]
StatusCode: BadRequest, Reason: Bad Request, RequestUri: http://192.168.1.104:8989/api/series/
fail: Ombi.Api.Api[1000]
StatusCode: BadRequest, Reason: Bad Request, RequestUri: http://192.168.1.104:8989/api/series/
fail: Ombi.Api.Api[1000]
StatusCode: BadRequest, Reason: Bad Request, RequestUri: http://192.168.1.104:8989/api/series/0
fail: Ombi.ErrorHandlingMiddleware[0]
Something bad happened, ErrorMiddleware caught this
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText)
at Microsoft.Data.Sqlite.SqliteTransaction.Commit()
at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.Commit()
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(DbContext _, ValueTuple2 parameters, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList1 entriesToSave, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.AspNetCore.Identity.EntityFrameworkCore.UserStore9.UpdateAsync(TUser user, CancellationToken cancellationToken) at Microsoft.AspNetCore.Identity.UserManager1.UpdateUserAsync(TUser user)
at Ombi.Controllers.TokenController.CreateToken(Boolean rememberMe, OmbiUser user) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 127
at Ombi.Controllers.TokenController.GetToken(UserAuthModel model) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 72
at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext)
at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware.InvokeCore(HttpContext context)
at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 51
at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24
`

bobnvic on 7 Mar 2019

So I tried updating Docker container linuxserver/ombi:devlopment and it still seems to be on 4287. I used to be on lsiodev/ombi-preview:latest (mentioned to use above in the thread) but when that container didn't seem to be updating Rox said to switch to linuxserver/ombi:devlopment. What container should I actually be using for development? My database isn't currently locked, so I'm probably not going to be of much help at the moment but I do want to assure I'm using the proper container.

If you copy/pasted the linuxserver/ombi:devlopment part, then you probably want to check your spelling. Should be linuxserver/ombi:development. It worked for me.

bobnvic on 7 Mar 2019

Was this the first time you’ve pushed changes? My docker is on develop and restarts every 4 hours, since a couple of days iGu-AnaCloud started to work again and haven’t have issues yet. Can add users and everything seems fine.

Iguana9999phil on 7 Mar 2019

I have pushed a few different incremental changes but this was quite a big change. It looks like the builds have not been working due to some dependency changes in the pipeline that I didn't notice.

But i've now fixed that and develop builds should be running successfully

tidusjar on 7 Mar 2019

Nice! Thanks Jamie. Everything seems good now. I honestly haven't had an issue myself with the db locking in a couple weeks but will definitely update here if anything happens again. Thanks for all the help!

clambert11 on 7 Mar 2019

My recent update will fix the issue, but it's not the fix I want going forward 😡

tidusjar on 7 Mar 2019

Just to be sure, develop branch for docker is linuxserver/ombi:development? I’m on that and since today its having the same issues again.

Iguana9999phil on 8 Mar 2019

Yeah, that's right. What version are you on? It should be 3.0.4032 as of today. I'm sure if you are still having problems he'd like a copy of your db and maybe your logs.

clambert11 on 8 Mar 2019

You mean 3.0.4302-develop I hope ;-) Anyway seems docker didn’t pull the latest develop image needed to do it manually. Running 3.04302-develop now and sadly still the same issue.

For completion the latest entry in the logs:
2019-03-08 17:01:59.417 +08:00 [Error] Something bad happened, ErrorMiddleware caught this
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText)
at Microsoft.Data.Sqlite.SqliteTransaction.Commit()
at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.Commit()
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(DbContext _, ValueTuple2 parameters, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList1 entriesToSave, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.AspNetCore.Identity.EntityFrameworkCore.UserStore9.UpdateAsync(TUser user, CancellationToken cancellationToken) at Microsoft.AspNetCore.Identity.UserManager1.UpdateUserAsync(TUser user)
at Ombi.Controllers.TokenController.CreateToken(Boolean rememberMe, OmbiUser user) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 127
at Ombi.Controllers.TokenController.GetToken(UserAuthModel model) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 72
at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter() at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync() at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context) at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext)
at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext) at Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware.InvokeCore(HttpContext context)
at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 51 at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24

Iguana9999phil on 8 Mar 2019

I was running Ombi 3.0.4119-master when I initially opened my ticket with the issue in this thread. I just checked it out again today for the hell of it and its now working and I can login just fine. Current version is Ombi 3.0.4256-master. I guess it updated itself?

Arindrew on 8 Mar 2019

Still can’t login, any updates or tips on how to export the info in the db? Can’t login so can’t add a user to send the database.

Iguana9999phil on 11 Mar 2019

Just wanted to add I am also experiencing this issue. Tried updating to Ombi 3.0.4302-develop but issues persist (can't login). Will watch this thread.

Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText)
at Microsoft.Data.Sqlite.SqliteTransaction.Commit()
at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.Commit()
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(DbContext _, ValueTuple2 parameters, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList1 entriesToSave, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.AspNetCore.Identity.EntityFrameworkCore.UserStore9.UpdateAsync(TUser user, CancellationToken cancellationToken) at Microsoft.AspNetCore.Identity.UserManager1.UpdateUserAsync(TUser user)
at Ombi.Controllers.TokenController.CreateToken(Boolean rememberMe, OmbiUser user) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 127
at Ombi.Controllers.TokenController.GetToken(UserAuthModel model) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 72
at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext)
at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware.InvokeCore(HttpContext context)
at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 51
at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24
fail: Ombi.ErrorHandlingMiddleware[0]
Something bad happened, ErrorMiddleware caught this
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText)
at Microsoft.Data.Sqlite.SqliteTransaction.Commit()
at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.Commit()
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(DbContext _, ValueTuple2 parameters, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList1 entriesToSave, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.AspNetCore.Identity.EntityFrameworkCore.UserStore9.UpdateAsync(TUser user, CancellationToken cancellationToken) at Microsoft.AspNetCore.Identity.UserManager1.UpdateUserAsync(TUser user)
at Ombi.Controllers.TokenController.CreateToken(Boolean rememberMe, OmbiUser user) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 127
at Ombi.Controllers.TokenController.GetToken(UserAuthModel model) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 72
at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext)
at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware.InvokeCore(HttpContext context)
at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 51
at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24
fail: Ombi.ErrorHandlingMiddleware[0]
Something bad happened, ErrorMiddleware caught this
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText)
at Microsoft.Data.Sqlite.SqliteTransaction.Commit()
at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.Commit()
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(DbContext _, ValueTuple2 parameters, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList1 entriesToSave, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.AspNetCore.Identity.EntityFrameworkCore.UserStore9.UpdateAsync(TUser user, CancellationToken cancellationToken) at Microsoft.AspNetCore.Identity.UserManager1.UpdateUserAsync(TUser user)
at Ombi.Controllers.TokenController.CreateToken(Boolean rememberMe, OmbiUser user) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 127
at Ombi.Controllers.TokenController.GetToken(UserAuthModel model) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 72
at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext)
at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware.InvokeCore(HttpContext context)
at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 51
at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24
fail: Ombi.ErrorHandlingMiddleware[0]
Something bad happened, ErrorMiddleware caught this
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText)
at Microsoft.Data.Sqlite.SqliteTransaction.Commit()
at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.Commit()
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(DbContext _, ValueTuple2 parameters, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList1 entriesToSave, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.AspNetCore.Identity.EntityFrameworkCore.UserStore9.UpdateAsync(TUser user, CancellationToken cancellationToken) at Microsoft.AspNetCore.Identity.UserManager1.UpdateUserAsync(TUser user)
at Ombi.Controllers.TokenController.CreateToken(Boolean rememberMe, OmbiUser user) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 127
at Ombi.Controllers.TokenController.GetToken(UserAuthModel model) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 72
at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext)
at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware.InvokeCore(HttpContext context)
at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 51
at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24

alimbocl on 11 Mar 2019

Currently experiencing this on the latest linuxserver docker.

jjbrunton on 11 Mar 2019

Just pushed another build to dev with more changes that should improve/fix this, it looks like I made a change a few days ago but in the v4 branch and not dev... 🤦‍♂️

tidusjar on 14 Mar 2019

Does it take a while for the new build to show up in the docker images? Pulled the latest earlier today and checked after reading your post its still the latest. I’ll try it tomorrow am (my time)

Iguana9999phil on 14 Mar 2019

Yeah it takes around 20 minutes for the build atleast. I'm not sure how long it will take for the docker image.

The build itself has now finished so try now? I'm pretty sure that the lsiodev/ombi-preview container updates on a docker restart.

tidusjar on 14 Mar 2019

Still happening on Ombi 3.0.4319-develop. This happens during login after passing credentials. This basically hangs the login process and cannot get into the app.

fail: Ombi.ErrorHandlingMiddleware[0]
Something bad happened, ErrorMiddleware caught this
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText)
at Microsoft.Data.Sqlite.SqliteTransaction.Commit()
at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.Commit()
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(DbContext _, ValueTuple2 parameters, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList1 entriesToSave, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.AspNetCore.Identity.EntityFrameworkCore.UserStore9.UpdateAsync(TUser user, CancellationToken cancellationToken) at Microsoft.AspNetCore.Identity.UserManager1.UpdateUserAsync(TUser user)
at Ombi.Controllers.TokenController.<>c__DisplayClass7_0.<b__1>d.MoveNext() in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 153
--- End of stack trace from previous location where exception was thrown ---
at Ombi.Helpers.GlobalMutex.LockT
at Ombi.Controllers.TokenController.CreateToken(Boolean rememberMe, OmbiUser user) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 153
at Ombi.Controllers.TokenController.GetToken(UserAuthModel model) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 72
at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext)
at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware.InvokeCore(HttpContext context)
at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 51
at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24

alimbocl on 15 Mar 2019

Nuts. Does anyone know the build# that was stable before this started happening? I would like to roll back to that until this resolved?

Mfellner77 on 15 Mar 2019

yup just updated and still the same, cleared browser cache and cookies to be sure. I’ve tested previous build but the also had that issue for me.

Iguana9999phil on 15 Mar 2019

I initially installed Ombi on Feb 25th with the latest version (via a tar.gz). Whatever version was the latest on that date worked. I still have the .gz too, just not sure where to look for the version. Maybe someone else can confirm a newer release works...

Sent from ProtonMail Mobile

On Thu, Mar 14, 2019 at 7:07 PM, Mfellner77 notifications@github.com wrote:

Nuts. Does anyone know the build# that was stable before this started happening? I would like to roll back to that until this resolved?

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub, or mute the thread.

Arindrew on 15 Mar 2019

This version is running stable for me.

Version | 3.0.3988
-- | --
Branch | master

Mfellner77 on 15 Mar 2019

Thanks! Installed it and is working for me. For docker users it’s linuxserver/ombi:132 release.

Iguana9999phil on 15 Mar 2019

👍1

Thanks @Iguana9999phil I'll stick to this release until this is resolved. First time i've been able to login, in awhile :)

cliff85 on 15 Mar 2019

@cliff85 same here finally can add the latest users. This older release feels faster too, maybe it’s fast enough for pruning all the already available media manually 😉

Iguana9999phil on 15 Mar 2019

I'm not a programmer, but I have reverted to the 3.0.3988 release as well, so far so good. However is does make me think the problem cannot be with needing to split the database more. Something must have changed between 3988 and Current that is impacting the login mechanics. I just have no idea what it could be.

gamechld on 16 Mar 2019

@gamechld I can confirm the same as well. I rolled back to 3988 on Ubuntu and its been working great.

infamouswb on 17 Mar 2019

Has anyone tried develop yet since I made some changes that should work. Just need someone to test it?

tidusjar on 17 Mar 2019

alimbocl Tested on Ombi 3.0.4319-develop - and reported the same issue. Is there a newer release that can be tested in non-prod environments?

Mfellner77 on 17 Mar 2019

That is the latest develop branch. Can you please upload a log with the error on the develop build?

tidusjar on 18 Mar 2019

I just went back and check the difference between 3988 and 4036 which was the next master release.

The only thing that changed was we added a new job that runs daily. But I did notice there was a misconfiguration of the job setup that we had a duplicate job that was introduced which is very suspect.

I've removed this in 3.0.4323 so i would be interested in seeing the results of this.

tidusjar on 18 Mar 2019

For Science! I will try 4323-Dev and report back. However, I do caution that the issue was very sporadic for me, sometimes would take several days to present itself. Will keep you all posted.

gamechld on 19 Mar 2019

Same Issue.

[41m[30mfail[39m[22m[49m: Ombi.ErrorHandlingMiddleware[0]
Something bad happened, ErrorMiddleware caught this
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.

at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText)
at Microsoft.Data.Sqlite.SqliteTransaction.Commit()
at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.Commit()
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(DbContext _, ValueTuple2 parameters, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList1 entriesToSave, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.AspNetCore.Identity.EntityFrameworkCore.UserStore9.UpdateAsync(TUser user, CancellationToken cancellationToken) at Microsoft.AspNetCore.Identity.UserManager1.UpdateUserAsync(TUser user)
at Ombi.Controllers.TokenController.CreateToken(Boolean rememberMe, OmbiUser user) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 127
at Ombi.Controllers.TokenController.OAuth(Int32 pinId) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 194
at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)

at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext)
at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext)
at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 51
at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24

RCFilm on 19 Mar 2019

has anyone found a fix?

RCFilm on 19 Mar 2019

I changed over to the development build, posted about 11 hours ago. Yet, i was still unable to login with the web interface. my mobile app tokens still work.

RCFilm on 19 Mar 2019

@RCFilm, fix for now is reverting to build 3988 (132 for docker) Since my last post it still works as it should and no complaints from users that they cannot log-in.

Iguana9999phil on 19 Mar 2019

👍1

@RCFilm, fix for now is reverting to build 3988 (132 for docker) Since my last post it still works as it should and no complaints from users that they cannot log-in.

That did the trick. Thank you.
Please post on this thread when fixed for the new releases.

RCFilm on 19 Mar 2019

I first noticed the problem when one of my clients wasn't able to log in. During troubleshooting, I logged myself out and was subsequently not able to login. So, the problem may not present itself until you log out and try to log back in. It seems currently logged in users are unaffected by this problem - at least in my experience.

Arindrew on 19 Mar 2019

Exact the same experience as Arindrew. Users told me they had issues with log in while I was still able to access it for a week. Logged out and then the problems started. For now i’ll stay on build 3988 as it works well and none of the added features (if any) in later releases are interesting to me.
Between this happening and getting burned by latest Plex release (cannot play media on iOS web, took me a day to figure that out) I’ve disabled pulling latest docker releases as well.

Iguana9999phil on 19 Mar 2019

You guys may not see the issue until you log out and back in, but if you look in the console you will see many errors and yelling about the database being locked if another user has already ran into the issue.

I'd like to try the 3.0.4323-Dev as requested but I'm still a bit shaky on how to navigate the site, can someone tell me where to grab a specific release from the Develop branch?

gamechld on 19 Mar 2019

Hello,
Sorry for my late answer I was busy.

I just went back and check the difference between 3988 and 4036 which was the next master release.

The only thing that changed was we added a new job that runs daily. But I did notice there was a misconfiguration of the job setup that we had a duplicate job that was introduced which is very suspect.

I've removed this in 3.0.4323 so i would be interested in seeing the results of this.

It seems to be a very good move because like I said in my previous comment :

https://github.com/tidusjar/Ombi/issues/2750#issuecomment-457562237

In my case, it still works now since this comment with 3988 whereas the problem comes quick enough when I tested newer versions.

I will test 3.0.4323 soon and I will come back here keep you in touch.

xp-1000 on 19 Mar 2019

@gamechld here is the latest dev release as of 19/03/2019 @ 15:16:00 GMT
https://ci.appveyor.com/project/tidusjar/requestplex/builds/23154537/artifacts

tidusjar on 19 Mar 2019

@gamechld here is the latest dev release as of 19/03/2019 @ 15:16:00 GMT
https://ci.appveyor.com/project/tidusjar/requestplex/builds/23154537/artifacts

Thanks, I'll give it a shot. Sorry, I knew how to get latest develop, but wasn't sure if I should try latest or if there was a way to get 3.0.4323 specifically. I assume latest will still have the change from 4323 you wanted to test. Trying it now, will report back!

gamechld on 19 Mar 2019

Huh, I ran into a snag with the developer build. My Requests, User Management, and Settings pages wouldn't load. That was with a nuked folder and the 4 .db files copied over.

gamechld on 19 Mar 2019

Wouldn't load in what way?

So you were able to login which you couldn't previously due to the locked db?

tidusjar on 20 Mar 2019

Wouldn't load in what way?

So you were able to login which you couldn't previously due to the locked db?

(for master branch) The login issue isn't something that presents immediately. It could be days before the login issue with database lock actually happens. It could be as frequent as 2-3 times a day, to as infrequent as once in 4 days. But on version 3988 it never happened.

(on testing developer branch) Upon a fresh install with copied .db files, I can login but cannot access those 3 sections (My Requests, User Management, and Settings). It occurs to me, that I didn't try from different browsers, maybe it was a browser issue. Checking now.

edit: Ok, I'm running developer now, 4324. Don't know what my issue was yesterday, even though I clean installed it 3 times. But it's working now, must've been my web browser screwing up. I will keep everyone posted if I run into the database locked issue. Might be a few days.

gamechld on 20 Mar 2019

Can you upload a log? How long have you tried waiting?

On Wed, 20 Mar 2019, 5:23 pm gamechld, notifications@github.com wrote:

Wouldn't load in what way?

So you were able to login which you couldn't previously due to the locked
db?

(for master branch) The login issue isn't something that presents
immediately. It could be days before the login issue with database lock
actually happens. It could be as frequent as 2-3 times a day, to as
infrequent as once in 4 days. But on version 3988 it never happened.

(on testing developer branch) Upon a fresh install with copied .db files,
I can login but cannot access those 3 sections (My Requests, User
Management, and Settings).

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
https://github.com/tidusjar/Ombi/issues/2750#issuecomment-474942667, or mute
the thread
https://github.com/notifications/unsubscribe-auth/AGVaLE1w6eA-b7eAkQ-r_GV3txHnG9Qgks5vYm6VgaJpZM4aLmgw
.

tidusjar on 20 Mar 2019

I just booted up the developer build today, so I'll let it run for a few days, hopefully the issue will already be resolved and I won't have anything to show. If it runs for a week solid without the problem then it's probably been fixed.

gamechld on 20 Mar 2019

This is happening to me as well. Trying to log in yields

2019-03-20 17:19:48.703 -06:00 [Error] Something bad happened, ErrorMiddleware caught this Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery() at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText) at Microsoft.Data.Sqlite.SqliteTransaction.Commit() at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.Commit() at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(DbContext _, ValueTuple2 parameters, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList1 entriesToSave, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Microsoft.AspNetCore.Identity.EntityFrameworkCore.UserStore9.UpdateAsync(TUser user, CancellationToken cancellationToken)
at Microsoft.AspNetCore.Identity.UserManager1.UpdateUserAsync(TUser user) at Ombi.Controllers.TokenController.CreateToken(Boolean rememberMe, OmbiUser user) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 127 at Ombi.Controllers.TokenController.GetToken(UserAuthModel model) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 72 at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync() at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync() at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter() at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context) at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync() at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync() at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext) at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context) at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext) at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext) at Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware.InvokeCore(HttpContext context) at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 51 at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24

I've tried a few things (restarting, rebuilding container, dereferencing db) and nothing seems to work. The only thing that appears to work is removing the DB's, restarting and going through the initial process and then restoring a DB backup after.

hacktek on 21 Mar 2019

@hacktek Ah that's interesting. I'm just running it out of a folder on Windows, and I can recover from the error just by closing it and opening it again. What version are you running? If you want to revert to stable, try 3.0.3988. If you want to help test the fixes, grab the developer release.

gamechld on 21 Mar 2019

I'll try and see which version it is if I can actually log in. I've found that my method _seemed_ to work but only because I was already logged in. If I do it from an incognito window it doesn't seem to properly restore to a working state. I think this certainly needs a DB switch.

If this matters, I have the Mellow Discord request bot connected to Ombi but I don't believe that's the issue because the bot doesn't contact Ombi unless someone tries to request something.

hacktek on 21 Mar 2019

So I'm running version 3.0.4256.

I'm able to return it to a working state by doing the following...

1/ Run this script which stops the container, deletes the DBs and restarts the container.

!/bin/sh

printf "Stopping container..."
echo "\n"
docker stop ombi

printf "Deleting databases..."
echo "\n"
rm /opt/appdata/ombi/*.db

printf "Starting fresh container..."
echo "\n"
docker start ombi

2/ Open the web interface and do the wizard.

3/ Run this script to restore OmbiSettings.db and OmbiExternal.db only.

!/bin/sh

printf "Determining latest backup..."
echo "\n"
BACKUP=$(borgmatic --list | tail -1 | awk '{print $1}')

printf "Restoring latest backup..."
echo "\n"
borgmatic --extract --archive "$BACKUP" --restore-path opt/appdata/ombi --verbosity 1

printf "Copying databases..."
echo "\n"
cp ~/opt/appdata/ombi/OmbiSettings.db /opt/appdata/ombi/OmbiSettings.db
cp ~/opt/appdata/ombi/OmbiExternal.db /opt/appdata/ombi/OmbiExternal.db

If I restore Ombi.db I can't log back in. This also breaks the Discord bot because the API key changes. I also don't know what else could be breaking by not restoring Ombi.db.

Also, if I do it all at once (without doing the wizard in between steps 1 and 2) I can't log in either, it says the username and password are wrong.

hacktek on 21 Mar 2019

@hacktek Try reverting to 3.0.3988 for now. Restore your .db files into a clean 3988 install, I think that'll get you back on your feet.

gamechld on 21 Mar 2019

Tried Build: 3.0.4334, still having the same issues, reverting back to 3.0.3988

log-20190321.txt

5drH64gDnDJb on 21 Mar 2019

@hacktek Try reverting to 3.0.3988 for now. Restore your .db files into a clean 3988 install, I think that'll get you back on your feet.

I'll have to look into how to do that. I'm using the linuxserver.io docker container and they seem to only have the latest dev and stable versions only.

hacktek on 21 Mar 2019

Ok @5drH64gDnDJb can you try 3.0.4336 since i've made another change from the info in your logs

tidusjar on 21 Mar 2019

OK I was able to roll back by replacing the ombi files with the ones from 3.0.3988 within the container and commiting. Restoring the DBs seems to have worked.

hacktek on 21 Mar 2019

Ok @5drH64gDnDJb can you try 3.0.4336 since i've made another change from the info in your logs

trying it now, I'll let you know, If I have the issue, it should show up anywhere from an hour to 24 hours

Edit: So far so good, eight hours have gone by and no issues!

5drH64gDnDJb on 21 Mar 2019

Should I continue testing 4324, or do you want me to update to latest as well?

gamechld on 21 Mar 2019

@tidusjar Dev-4324 failed :(

info: Ombi.Schedule.Jobs.Plex.PlexContentSync[0] Starting Plex Content Cacher info: Ombi.Schedule.Jobs.Plex.PlexContentSync[0] Starting to cache the content on server VikFlix info: Ombi.Schedule.Jobs.Plex.PlexContentSync[0] Starting Plex Content Cacher info: Ombi.Schedule.Jobs.Plex.PlexContentSync[0] Starting to cache the content on server VikFlix infofail: Ombi.Schedule.Jobs.Plex.PlexContentSync[0] Starting Plex Content Cacher : Ombi.ErrorHandlingMiddleware[0] Something bad happened, ErrorMiddleware caught this Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery() at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText) at Microsoft.Data.Sqlite.SqliteTransaction.Commit() at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.Commit() at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(DbContext _, ValueTuple2 parameters, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList1 entriesToSave, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Ombi.Store.Repository.BaseRepository2.b__15_0() in C:\projects\requestplex\src\Ombi.Store\Repository\BaseRepository.cs:line 86
at Ombi.Helpers.GlobalMutex.LockT
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList1 entriesToSave, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Ombi.Store.Repository.BaseRepository2.b__15_0() in C:\projects\requestplex\src\Ombi.Store\Repository\BaseRepository.cs:line 86
at Ombi.Helpers.GlobalMutex.LockT
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList1 entriesToSave, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Microsoft.AspNetCore.Identity.EntityFrameworkCore.UserStore9.UpdateAsync(TUser user, CancellationToken cancellationToken)
at Microsoft.AspNetCore.Identity.UserManager1.UpdateUserAsync(TUser user) at Ombi.Controllers.TokenController.<>c__DisplayClass7_0.<<CreateToken>b__1>d.MoveNext() in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 153 --- End of stack trace from previous location where exception was thrown --- at Ombi.Helpers.GlobalMutex.Lock[T](Func1 func)
at Ombi.Controllers.TokenController.CreateToken(Boolean rememberMe, OmbiUser user) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 153
at Ombi.Controllers.TokenController.GetToken(UserAuthModel model) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 72
at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext)
at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware.InvokeCore(HttpContext context)
at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 51
at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24
failfail: Ombi.Api.Api[1000]
StatusCode: BadRequest, Reason: Bad Request, RequestUri: http://192.168.1.160:8989/api/series/
: Ombi.ErrorHandlingMiddleware[0]
Something bad happened, ErrorMiddleware caught this
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText)
at Microsoft.Data.Sqlite.SqliteTransaction.Commit()
at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.Commit()
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(DbContext _, ValueTuple2 parameters, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList1 entriesToSave, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.AspNetCore.Identity.EntityFrameworkCore.UserStore9.UpdateAsync(TUser user, CancellationToken cancellationToken) at Microsoft.AspNetCore.Identity.UserManager1.UpdateUserAsync(TUser user)
at Ombi.Controllers.TokenController.<>c__DisplayClass7_0.<b__1>d.MoveNext() in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 153
--- End of stack trace from previous location where exception was thrown ---
at Ombi.Helpers.GlobalMutex.Lock[T](Func1 func) at Ombi.Controllers.TokenController.CreateToken(Boolean rememberMe, OmbiUser user) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 153 at Ombi.Controllers.TokenController.GetToken(UserAuthModel model) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 72 at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync() at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync() at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter() at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context) at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync() at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync() at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext) at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context) at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext) at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext) at Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware.InvokeCore(HttpContext context) at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 51 at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24

gamechld on 22 Mar 2019

Ok @5drH64gDnDJb can you try 3.0.4336 since i've made another change from the info in your logs

I'm going to say you fixed the issue in this version, I should of ran into a problem by now.

5drH64gDnDJb on 22 Mar 2019

@5drH64gDnDJb Can you post an update in a few days? I'll give that a shot if you are stable for a few days.

gamechld on 22 Mar 2019

@5drH64gDnDJb Can you post an update in a few days? I'll give that a shot if you are stable for a few days.

will do!

5drH64gDnDJb on 22 Mar 2019

Looks like I spoke too soon, issue is now a little different, I'm getting the database lock but I am able to log in, but if I try to request something, it does nothing. I currently have a script that tries to login and if it fails it alerts, but I didnt have a process to try to request something.

log-20190322.txt

5drH64gDnDJb on 23 Mar 2019

Ok thanks for that feedback.

I've just kicked off another build with more changes. It removed the job that was added in the build when the dB started locking up.

Sorry.to.keep asking you guys to test this, but I'm unable to recreate it!

tidusjar on 23 Mar 2019

@tidusjar, does it make sense to log additional information when that exception gets thrown, such as other in-flight database transactions/threads?

rickatnight11 on 23 Mar 2019

Ok thanks for that feedback.

I've just kicked off another build with more changes. It removed the job that was added in the build when the dB started locking up.

Sorry.to.keep asking you guys to test this, but I'm unable to recreate it!

np, I'll update once it's available, I'll also send the logs to my splunk instance so I can alert off the database lock.

Edit: I have update too 3.0.4340, I'll begin testing, thanks for the quick update.

5drH64gDnDJb on 23 Mar 2019

Hello,

I am testing 3.0.4340 for few hours now and it works.

I do not still have authentification problems with database locked.
Everything seem to work.

I still have database lock error only on one thing : when I save settings for notifications (I tested discord and gotify and both are affected, I don't know for other services.

``2019-03-23 02:38:25.934 +01:00 [Error] Something bad happened, ErrorMiddleware caught this Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery() at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText) at Microsoft.Data.Sqlite.SqliteTransaction.Commit() at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.Commit() at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(DbContext _, ValueTuple2 parameters, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList1 entriesToSave, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Ombi.Store.Repository.NotificationTemplatesRepository.UpdateRange(IEnumerable1 templates) in C:\projects\requestplex\src\Ombi.Store\Repository\NotificationTemplatesRepository.cs:line 59
at Ombi.Controllers.SettingsController.DiscordNotificationSettings(DiscordNotificationsViewModel model) in C:\projects\requestplex\src\Ombi\Controllers\SettingsController.cs:line 725
at lambda_method(Closure , Object )
at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext)
at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext)
at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 51
at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24
````

Thanks for your work, I will come back tell you If I have more information.

EDIT: updating user details also causes database lock error.

xp-1000 on 23 Mar 2019

Version: 3.0.4340, here is the error log

log-20190322.txt

5drH64gDnDJb on 23 Mar 2019

Is there a log file, or do you just paste from the console window?

gamechld on 23 Mar 2019

Not sure if this is helpful or not, but I've had the problem for a few days as well. I tried recreating the container, and a few times even deleted it. I learned that I also had to go in and delete /opt/ombi before it was fully purged. Only then was I able to finally create a login.

Granted, I had to redo all my settings but I don't have anything mission critical.

Hopefully, this might be useful to anybody who is following along but doesn't want to use the dev code and has no problem with starting over.

columbusgeek on 23 Mar 2019

@5drH64gDnDJb Can you please run the latest dev build, but the log, can you include events before the DB started to get locked?
Because that's the information I'm trying to find, what is causing the lock :)

tidusjar on 25 Mar 2019

@5drH64gDnDJb Can you please run the latest dev build, but the log, can you include events before the DB started to get locked?
Because that's the information I'm trying to find, what is causing the lock :)

Will do, I cleared out the current logs so I dont mix up the old logs with this new dev version, I'll upload all the logs if see the lock.

5drH64gDnDJb on 25 Mar 2019

@tidusjar Are there log files in the windows version? Or is copying the output from the console window the correct method?

gamechld on 25 Mar 2019

@tidusjar Are there log files in the windows version? Or is copying the output from the console window the correct method?

Should be under your main folder Ombi > Logs (folder)

5drH64gDnDJb on 25 Mar 2019

👍1

Also another build is available that I'm feeling confident about

tidusjar on 26 Mar 2019

@tidusjar, everything is working great so far, only issue I see is that when I add a new tv show > select All Seasons, in sonarr its added but it doesn't select any of the seasons. Just thought I would give u heads up, would you like me to try the latest dev release, and would you like me to create a new issue for the All Seasons problem? Thanks for all the help

5drH64gDnDJb on 26 Mar 2019

Ok excellent. What version is that on?

tidusjar on 26 Mar 2019

Ok excellent. What version is that on?

Version 3.0.4346

5drH64gDnDJb on 26 Mar 2019

Hello,

I tested 3.0.4348 version and I still have database lock errors in both cases I described :
https://github.com/tidusjar/Ombi/issues/2750#issuecomment-475828716

But I did not find other problems, ombi works for request and issues as far as I tested.
Thanks

xp-1000 on 26 Mar 2019

I think I have realised what the issue is finally.

Please delete your Schedules.db and restart ombi. It will work fine then

tidusjar on 26 Mar 2019

I think I have realised what the issue is finally.

Please delete your Schedules.db and restart ombi. It will work fine then

Done, deleted Schedules.db and updated to your latest dev version, thanks!

5drH64gDnDJb on 26 Mar 2019

I've just pushed another update that deletes the schedules.db on start, I am not 99.99% sure it's the SQLite library I am using with the internal scheduler. Deleting the schedules.db will 100% fix this issue, since it seems to be trying to queue up many jobs on start locking up the entire db.

I am closing this as a resolution (FINALLY!).

Please let me know if this is not the case for you.

Thank everyone for their patience and help with this.

tidusjar on 26 Mar 2019

Will there be any ramifications for us from deleting schedules.db?

Funny thing is I was 4 days into testing 4340 and it didn't lock up for me, but that's not a guarantee, especially since it seems others did get a lockup. I have now swapped over to 4350.

gamechld on 27 Mar 2019

There are none, it's a db for keeping track of the schedule jobs.

tidusjar on 27 Mar 2019

Hello @tidusjar
I stopped ombi, upgraded to 3.0.4350, removed schedules.db then restarted ombi and I still have lock problem on notifications configuration (submit button) and user details configuration.

xp-1000 on 27 Mar 2019

Hmm my bad I just restarted again and the problem seems not appear anymore.
Good job thans for your work.

xp-1000 on 27 Mar 2019

Since I now know it's the scheduling system, i'm going to revert some of my changes I made to attempt to fix this.

tidusjar on 27 Mar 2019

I'm still having issues with a DB being locked.
I deleted the schedules.db and all is well for a bit then it happens again.

`Valid options are:
Ombi 4.0.4364-featurev4
Copyright (C) 2019 Ombi

--host (Default: http://*:5000) Set to a semicolon-separated (;) list
of URL prefixes to which the server should respond. For example,
http://localhost:123. Use "*" to indicate that the server should
listen for requests on any IP address or hostname using the
specified port and protocol (for example, http://*:5000). The
protocol (http:// or https://) must be included with each URL.
Supported formats vary between servers.

--storage Storage path, where we save the logs and database

--baseurl The base URL for reverse proxy scenarios

--demo Demo mode, you will never need to use this, fuck that fruit
company...

--help Display this help screen.

--version Display version information.




We are running on

i
Hosting environment: Production
Content root path: /opt/ombi
Now listening on: http://[::]:3579
Application started. Press Ctrl+C to shut down.
[41m[30mfail[39m[22m[49m: Ombi.ErrorHandlingMiddleware[0]
Something bad happened, ErrorMiddleware caught this
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.

at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText)
at Microsoft.Data.Sqlite.SqliteTransaction.Commit()
at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.Commit()
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(DbContext _, ValueTuple`2 parameters, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList`1 entriesToSave, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.AspNetCore.Identity.EntityFrameworkCore.UserStore`9.UpdateAsync(TUser user, CancellationToken cancellationToken)
at Microsoft.AspNetCore.Identity.UserManager`1.UpdateUserAsync(TUser user)
at Ombi.Controllers.V1.TokenController.CreateToken(Boolean rememberMe, OmbiUser user) in C:\projects\requestplex\src\Ombi\Controllers\V1\TokenController.cs:line 151
at Ombi.Controllers.V1.TokenController.GetToken(UserAuthModel model) in C:\projects\requestplex\src\Ombi\Controllers\V1\TokenController.cs:line 70
at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)

at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
at Microsoft.AspNetCore.Routing.EndpointMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.Routing.EndpointRoutingMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext)
at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware.InvokeCore(HttpContext context)
at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 51
at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24
[41m[30mfail[39m[22m[49m: Ombi.ErrorHandlingMiddleware[0]
Something bad happened, ErrorMiddleware caught this
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.

at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText)
at Microsoft.Data.Sqlite.SqliteTransaction.Commit()
at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.Commit()
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(DbContext _, ValueTuple`2 parameters, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList`1 entriesToSave, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
at Microsoft.AspNetCore.Identity.EntityFrameworkCore.UserStore`9.UpdateAsync(TUser user, CancellationToken cancellationToken)
at Microsoft.AspNetCore.Identity.UserManager`1.UpdateUserAsync(TUser user)
at Ombi.Controllers.V1.TokenController.CreateToken(Boolean rememberMe, OmbiUser user) in C:\projects\requestplex\src\Ombi\Controllers\V1\TokenController.cs:line 151
at Ombi.Controllers.V1.TokenController.GetToken(UserAuthModel model) in C:\projects\requestplex\src\Ombi\Controllers\V1\TokenController.cs:line 70
at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)

at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
at Microsoft.AspNetCore.Routing.EndpointMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.Routing.EndpointRoutingMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext)
at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware.InvokeCore(HttpContext context)
at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 51
at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24`

Daedilus on 1 Apr 2019

Same for me

lucacri on 6 Apr 2019

Delete the schedule db. The other guy is running v4 which is not yet ready.

tidusjar on 6 Apr 2019

Still having the same issue, i have to delete schedule db every day for this to work, any work around to make this an automated task? It's becoming a pain in the butt. I really love this app just want to make it work 100% of the time. Any suggestions would be greatly appreciated.

danstraughn on 7 Apr 2019

I'm in the same boat as @danstraughn, I can keep on play whack-a-mole and delete+restart it, but it's not feasible

lucacri on 7 Apr 2019

Same here, isn't it possible to do an easy rollback to an earlier version of the ombi app till this gets fixed?

Please advice if possible as this early fix as others also are saying is really becoming an unstable resolution for us all. But keep in mind that we need to keep our db, so if it is possible to just revert the app (not the db or settings). As the others say, love you app and I have also donated to keep your development, but we would like to see some kind of other possible solution soon on the app until this is fixed.

estavez on 8 Apr 2019

Can someone please send me their schedules db when it causes the issue.

In Dev branch it will fix the issue on a restart.

tidusjar on 8 Apr 2019

👍1

I'm running 3.0.4256 and have not seen the issues from before. I mostly call requests via the mellow discord bot if that makes a difference. Something that I _have_ noticed is that sometimes shows get added to Sonarr with no seasons monitored, either via the bot or manually. There doesn't seem to be any rhyme or reason to it and I'm pretty sure this started around the time I updated to the dev branch, which I've only done once on the version posted above.

hacktek on 8 Apr 2019

Can someone please send me their schedules db when it causes the issue.

In Dev branch it will fix the issue on a restart.

I will zip it and send it to you in the AM when the issue will happen again.

danstraughn on 8 Apr 2019

Can someone please send me their schedules db when it causes the issue.
In Dev branch it will fix the issue on a restart.

I will zip it and send it to you in the AM when the issue will happen again.

Here is the schedules db as requested. Just rename the extension from .d_ to .db.

Thanks for all your help.

Schedules.zip

danstraughn on 9 Apr 2019

Same here, isn't it possible to do an easy rollback to an earlier version of the ombi app till this gets fixed?

Please advice if possible as this early fix as others also are saying is really becoming an unstable resolution for us all. But keep in mind that we need to keep our db, so if it is possible to just revert the app (not the db or settings). As the others say, love you app and I have also donated to keep your development, but we would like to see some kind of other possible solution soon on the app until this is fixed.

@estavez Master Branch version 3988 should be stable.

gamechld on 9 Apr 2019

Same here again, replacing schedule didnt help - replacing the setting file did? Running version 3.0.4256 docker
Seems that after a while you just cant login?

casperse on 11 Apr 2019

My work-around was to add a cronjob to delete Schedules.db and restart the docker container everyday:

crontab -e
# add the following line
22 2 * * * /bin/rm /<ombi config folder>/Schedules.db && /usr/bin/docker restart <ombi docker container name>

Obviously only works if you're using the docker container, a slightly different command would be needed if you're running directly.

jasongi on 14 Apr 2019

This has been fixed in the develop branch! 🎉 🎈

I have now replaced the scheduling system in Ombi! We are now using Quartz.Net rather than hangfire (Hangfire was causing this issue).

Please install dev and check it out!

tidusjar on 14 Apr 2019

🎉1

Version | 3.0.4437

Centos 7

Logs Attached

Crashed here:

   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
   at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
   at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
   at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext)
   at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext)
   at Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware.InvokeCore(HttpContext context)
   at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 51
   at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24

Unhandled Exception: Microsoft.Data.Sqlite.SqliteException: SQLite Error 5: 'database is locked'.
   at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
   at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext()
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteAsync(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.BufferlessMoveNext(DbContext _, Boolean buffer, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.MoveNext(CancellationToken cancellationToken)
   at System.Linq.AsyncEnumerable.FirstOrDefault_[TSource](IAsyncEnumerable`1 source, CancellationToken cancellationToken) in D:\a\1\s\Ix.NET\Source\System.Interactive.Async\First.cs:line 144
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.TaskResultAsyncEnumerable`1.Enumerator.MoveNext(CancellationToken cancellationToken)
   at System.Linq.AsyncEnumerable.SelectEnumerableAsyncIterator`2.MoveNextCore(CancellationToken cancellationToken) in D:\a\1\s\Ix.NET\Source\System.Interactive.Async\Select.cs:line 106
   at System.Linq.AsyncEnumerable.AsyncIterator`1.MoveNext(CancellationToken cancellationToken) in D:\a\1\s\Ix.NET\Source\System.Interactive.Async\AsyncIterator.cs:line 98
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.MoveNext(CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExecuteSingletonAsyncQuery[TResult](QueryContext queryContext, Func`2 compiledQuery, IDiagnosticsLogger`1 logger, Type contextType)
   at Ombi.Core.Engine.MovieRequestEngine.CheckForSubscription(HideResult shouldHide, MovieRequests x) in C:\projects\requestplex\src\Ombi.Core\Engine\MovieRequestEngine.cs:line 271
   at Ombi.Core.Engine.MovieRequestEngine.<>c__DisplayClass15_0.<<GetRequests>b__5>d.MoveNext() in C:\projects\requestplex\src\Ombi.Core\Engine\MovieRequestEngine.cs:line 194
--- End of stack trace from previous location where exception was thrown ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location where exception was thrown ---
   at System.Threading.ThreadPoolWorkQueue.Dispatch()
Aborted

Now when trying to add a new show:

2019-04-18 00:34:23.455 -04:00 [Error] Something bad happened, ErrorMiddleware caught this
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
   at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText)
   at Microsoft.Data.Sqlite.SqliteTransaction.Commit()
   at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.Commit()
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(DbContext _, ValueTuple`2 parameters, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at Ombi.Store.Repository.Requests.TvRequestRepository.InternalSaveChanges() in C:\projects\requestplex\src\Ombi.Store\Repository\Requests\TvRequestRepository.cs:line 157
   at Ombi.Store.Repository.Requests.TvRequestRepository.Add(TvRequests request) in C:\projects\requestplex\src\Ombi.Store\Repository\Requests\TvRequestRepository.cs:line 111
   at Ombi.Core.Engine.TvRequestEngine.AddRequest(TvRequests model) in C:\projects\requestplex\src\Ombi.Core\Engine\TvRequestEngine.cs:line 558
   at Ombi.Core.Engine.TvRequestEngine.RequestTvShow(TvRequestViewModel tv) in C:\projects\requestplex\src\Ombi.Core\Engine\TvRequestEngine.cs:line 131
   at Ombi.Controllers.RequestController.RequestTv(TvRequestViewModel tv) in C:\projects\requestplex\src\Ombi\Controllers\RequestController.cs:line 285
   at lambda_method(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
   at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
   at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
   at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext)
   at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext)
   at Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware.InvokeCore(HttpContext context)
   at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 51
   at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24
2019-04-18 00:34:28.287 -04:00 [Debug] Batch acquisition of 0 triggers
2019-04-18 00:34:51.323 -04:00 [Debug] Batch acquisition of 1 triggers
2019-04-18 00:35:00.005 -04:00 [Debug] Calling Execute on job DVR.ISickRageSync
2019-04-18 00:35:00.010 -04:00 [Debug] Batch acquisition of 1 triggers
2019-04-18 00:35:00.079 -04:00 [Debug] Trigger instruction : NoInstruction
2019-04-18 00:35:01.001 -04:00 [Debug] Batch acquisition of 1 triggers
2019-04-18 00:35:01.001 -04:00 [Debug] Calling Execute on job DVR.IRadarrSync
2019-04-18 00:35:01.002 -04:00 [Debug] Calling Execute on job DVR.ISonarrSync
2019-04-18 00:35:01.002 -04:00 [Debug] Batch acquisition of 1 triggers
2019-04-18 00:35:01.003 -04:00 [Debug] Trigger instruction : NoInstruction
2019-04-18 00:35:01.012 -04:00 [Debug] Calling Execute on job System.IResendFailedRequests
2019-04-18 00:35:01.019 -04:00 [Debug] Batch acquisition of 0 triggers
2019-04-18 00:35:22.740 -04:00 [Debug] Trigger instruction : NoInstruction
2019-04-18 00:35:28.498 -04:00 [Debug] Batch acquisition of 0 triggers
2019-04-18 00:35:49.734 -04:00 [Information] Default Quartz.NET properties loaded from embedded resource file
2019-04-18 00:35:50.018 -04:00 [Debug] TaskSchedulingThreadPool configured with max concurrency of 10 and TaskScheduler ThreadPoolTaskScheduler.
2019-04-18 00:35:50.054 -04:00 [Information] Initialized Scheduler Signaller of type: Quartz.Core.SchedulerSignalerImpl
2019-04-18 00:35:50.074 -04:00 [Information] Quartz Scheduler v."3.0.7.0" created.
2019-04-18 00:35:50.081 -04:00 [Information] RAMJobStore initialized.
2019-04-18 00:35:50.119 -04:00 [Information] Scheduler meta-data: Quartz Scheduler (v3.0.7.0) 'DefaultQuartzScheduler' with instanceId 'NON_CLUSTERED'
  Scheduler class: 'Quartz.Core.QuartzScheduler' - running locally.
  NOT STARTED.
  Currently in standby mode.
  Number of jobs executed: 0
  Using thread pool 'Quartz.Simpl.DefaultThreadPool' - with 10 threads.
  Using job-store 'Quartz.Simpl.RAMJobStore' - which does not support persistence. and is not clustered.

log-20190418.txt

ChrisMiller128 on 18 Apr 2019

After updating to 3.0.4437 now I'm getting database locks again

log-20190418.txt

5drH64gDnDJb on 19 Apr 2019

👍2

Database locks again here as well. Can I provide any specific logs that would be helpful? After a container redeployment it seems to be working again.

simon021 on 24 Apr 2019

Does this happen on 3.0.4489?

tidusjar on 24 Apr 2019

~I haven't had any issues on 3.0.4489 or 3.0.4522. Ran the former for about 5 days without issue.~

jeffkeller87 on 30 Apr 2019

Having this issue with Ombi 3.0.4256-master docker container. Removing schedules.db does not fix the issue.

lastb0isct on 3 May 2019

Originally, in my case, database locks were preventing users from logging in (throwing a bad password message). Now that I am on 3.0.4522, I don't have this particular issue.

But I am now getting database lock messages in the logs when trying to approve requests. When clicking "Approve", the button changes to "Mark Available" but no notification ever appears indicating that the approval went through. If I log out and then log back in, the button has changed back to "Approve" and no new entries have been added to Sonarr/Radarr. Examining the logs shows:

2019-05-03 16:20:20.511 -04:00 [Error] Something bad happened, ErrorMiddleware caught this
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
   at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText)
   at Microsoft.Data.Sqlite.SqliteTransaction.Commit()
   at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.Commit()
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(DbContext _, ValueTuple`2 parameters, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at Ombi.Store.Repository.Requests.TvRequestRepository.InternalSaveChanges() in C:\projects\requestplex\src\Ombi.Store\Repository\Requests\TvRequestRepository.cs:line 157
   at Ombi.Store.Repository.Requests.TvRequestRepository.UpdateChild(ChildRequests request) in C:\projects\requestplex\src\Ombi.Store\Repository\Requests\TvRequestRepository.cs:line 152
   at Ombi.Core.Engine.TvRequestEngine.ApproveChildRequest(Int32 id) in C:\projects\requestplex\src\Ombi.Core\Engine\TvRequestEngine.cs:line 389
   at Ombi.Controllers.RequestController.ApproveChild(TvUpdateModel model) in C:\projects\requestplex\src\Ombi\Controllers\RequestController.cs:line 418
   at lambda_method(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
   at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
   at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
   at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext)
   at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext)
   at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 51
   at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24

jeffkeller87 on 3 May 2019

I'm having the same problem as Jeff now, except I am on 3.0.4434 (develop).

Arindrew on 3 May 2019

Version 3.0.4538, you can login but has issues as soon as you try to request something.

log-20190506.txt

5drH64gDnDJb on 6 May 2019

Getting a database locked error on my docker image:

Linuxserver.io version:- v3.0.4256-ls17 Build-date:- 2019-05-07T07:23:55+01:00

      Something bad happened, ErrorMiddleware caught this,
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.,
   at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db),
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior),
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery(),
   at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText),
   at Microsoft.Data.Sqlite.SqliteTransaction.Commit(),
   at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.Commit(),
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(DbContext _, ValueTuple`2 parameters, CancellationToken cancellationToken),
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList`1 entriesToSave, CancellationToken cancellationToken),
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken),
   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken),
   at Microsoft.AspNetCore.Identity.EntityFrameworkCore.UserStore`9.UpdateAsync(TUser user, CancellationToken cancellationToken),
   at Microsoft.AspNetCore.Identity.UserManager`1.UpdateUserAsync(TUser user),
   at Ombi.Controllers.TokenController.CreateToken(Boolean rememberMe, OmbiUser user) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 127,
   at Ombi.Controllers.TokenController.GetToken(UserAuthModel model) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 72,
   at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments),
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync(),
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync(),
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context),
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted),
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync(),
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter(),
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context),
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted),
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync(),
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync(),
   at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext),
   at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context),
   at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext),
   at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext),
   at Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware.InvokeCore(HttpContext context),
   at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 51,
   at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24,

Deleted the Schedules.db and it let me in, going to verify that it sticks this time.

Yep, still getting the same error as above after only a day.

lastb0isct on 9 May 2019

👍1

I seem to be having the same issue. and as @lastb0isct pointed out after I delete the schedules database and restart ombi it works again, able to log in and request but after about 24 hours or so it just seems to go back to locking the db.

2019-05-16 20:35:21.775 -05:00 [Error] Something bad happened, ErrorMiddleware caught this
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
   at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext()
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteAsync(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.BufferlessMoveNext(DbContext _, Boolean buffer, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.MoveNext(CancellationToken cancellationToken)
   at System.Linq.AsyncEnumerable.FirstOrDefault_[TSource](IAsyncEnumerable`1 source, CancellationToken cancellationToken) in D:\a\1\s\Ix.NET\Source\System.Interactive.Async\First.cs:line 144
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.TaskResultAsyncEnumerable`1.Enumerator.MoveNext(CancellationToken cancellationToken)
   at System.Linq.AsyncEnumerable.SelectEnumerableAsyncIterator`2.MoveNextCore(CancellationToken cancellationToken) in D:\a\1\s\Ix.NET\Source\System.Interactive.Async\Select.cs:line 106
   at System.Linq.AsyncEnumerable.AsyncIterator`1.MoveNext(CancellationToken cancellationToken) in D:\a\1\s\Ix.NET\Source\System.Interactive.Async\AsyncIterator.cs:line 98
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.MoveNext(CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExecuteSingletonAsyncQuery[TResult](QueryContext queryContext, Func`2 compiledQuery, IDiagnosticsLogger`1 logger, Type contextType)
   at Microsoft.AspNetCore.Identity.UserManager`1.FindByNameAsync(String userName)
   at Ombi.Controllers.TokenController.DoesUserRequireAPassword(UserAuthModel model) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 222
   at lambda_method(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
   at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
   at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
   at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext)
   at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext)
   at Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware.InvokeCore(HttpContext context)
   at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 51
   at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24
2019-05-16 20:35:40.180 -05:00 [Error] Something bad happened, ErrorMiddleware caught this
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
   at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
   at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText)
   at Microsoft.Data.Sqlite.SqliteTransaction.Commit()
   at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.Commit()
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(DbContext _, ValueTuple`2 parameters, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IReadOnlyList`1 entriesToSave, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
   at Microsoft.AspNetCore.Identity.EntityFrameworkCore.UserStore`9.UpdateAsync(TUser user, CancellationToken cancellationToken)
   at Microsoft.AspNetCore.Identity.UserManager`1.UpdateUserAsync(TUser user)
   at Ombi.Controllers.TokenController.CreateToken(Boolean rememberMe, OmbiUser user) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 127
   at Ombi.Controllers.TokenController.GetToken(UserAuthModel model) in C:\projects\requestplex\src\Ombi\Controllers\TokenController.cs:line 72
   at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
   at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
   at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
   at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext)
   at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext)
   at Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware.InvokeCore(HttpContext context)
   at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ApiKeyMiddlewear.cs:line 51
   at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\ErrorHandlingMiddlewear.cs:line 24

darkcloud784 on 17 May 2019

👍1

Same issue cant login what can I do? replace some files (I have weekly backup)
Update replaced schedules.db and restarted and I can login again (Sorry forgot this been some time since I had this problem)

casperse on 19 May 2019

Also now getting this from the debian repo

lisim on 25 May 2019

For people who are having the original issue. Upgrade to develop.

I am closing this since the original issue has been fixed.

If you are having issues with the develop branch please raise a new issue and follow the issue template

tidusjar on 25 May 2019

Anyone know if the linuxserver containers have this fix in them?
https://hub.docker.com/r/linuxserver/ombi/tags

EDIT there's a development tag. I'll try that.

RyanEwen on 29 May 2019

development tag fixed it for me in docker

lastb0isct on 29 May 2019

I'm on linuxservers development tag, but still getting the authentication loop. I don't see a schedules.db inside my /config directory to delete? Is it somewhere else?

derekross on 20 Jul 2019

linuxserver/development and issue is still present for me

CountParadox on 13 Sep 2019

Pretty sure I'm also having this issue but I'm on master/3.0.4680 - Users cannot log in until I restart the ombi service. It works for a currently undetermined amount of time and then breaks and I have to restart the service again. I've tried downgrading a few versions but still get the same issues...
(System: Ubuntu 16.04.6 LTS)

ZuluWhiskey on 13 Sep 2019

@ZuluWhiskey I'm having similar issues, logins were sometimes failing and other slowness/failures were happening (ex. requests could be created, but the 'requests' view wouldn't show the new requests). Logs all point to sqlite db lock issues.

A potential solution is manually backing up the sqlite databases and replacing the existing databases with the backups. I did that tonight, and everything seems to be working, no errors in my logs yet. I can type up some quick instructions on the process if anyone wants them. I'll also follow up if the errors return.

nonissue on 20 Sep 2019

@ZuluWhiskey 20 hours later and things are still stable, looking promising.

nonissue on 20 Sep 2019

@nonissue That sounds pretty positive! How did you achieve this as I don’t quite follow your initial response with regards to backing up and then utilising said backup? (Unless I’ve misunderstood of course!)

ZuluWhiskey on 20 Sep 2019

@nonissue I am having similar issues and would love to know in more detail how you solved it also. Thanks!

danielcbaldwin on 20 Sep 2019

Ah so the sqlite backup of the databases didn't work -- the errors started happening after about 15-16 hours, but I tried some other stuff last night and it might be resolved? I can't remember exactly what I did, but if no errors pop up by tomorrow, I'll retrace my steps and update you folks @danielcbaldwin @ZuluWhiskey.

nonissue on 22 Sep 2019

@nonissue Are things still stable? I am having the exact same issue and cannot figure it out. I am on the latest release and have deleted my Schedules.db file. Typically after a restart of Ombi the issues return in less then 24 hours. If you are stable and can determine what steps you took I would really appreciate it.

DillonsFlix on 24 Sep 2019

👍1

@DillonsFlix I think things are stable. Just looked at my logs for the last few days, and there are only 2-3 sqlite lock errors a day, and they seem to be related to the plex user importer. Previously I was getting dozens and dozens of sqlite errors everyday, and they didn't give any clear indication of which process was calling them (as far as I could tell).

Are you using ombi in a docker container or standalone? I'm using hotio/ombi.

I think what ultimately fixed my issue was repairing the permissions on all the ombi database files. While poking around, I noticed that the ombi database files had different permissions compared to those of a clean install. For some reason, they were marked as executable. I spun up a new install of ombi from scratch, and while looking at the files it bootstraps, I noticed that they weren't marked as executable.

If you're using a shell, you can view a list of files in a directory with their permissions with ls -la.

I think the correct permissions are:

-rw-r--r--

Which is what mine currently read. Keep in mind I'm running things in docker, so there is a possibility this may not apply to a standalone config.

I also noticed that I had two app config folders (the second one was nested in the first one). I'm not sure when/how this happened (I think I previously migrated from linuxservers docker image for ombi to the hotio one). It could have been something I did myself as well by mistake. Anyway, I removed the duplicate entry, and now my 'config' folder contains only an 'app' folder, and then all the persistent ombi data is in there.

I hope this helps, I wish I could be more specific about how exactly it got fixed. If any of this isn't clear, let me know. If you give me more info about your config I might be able to add insight.

nonissue on 3 Oct 2019

Here's a screenshot with the result of running ls -la in my stable ombi config folder
apw-cat local - 2019-10-02 at 9 35 55 PM

nonissue on 3 Oct 2019

Still experiencing this issue on 3.0.4892.

My permssions are the same as the previous comment.

Restarting Ombi fixes the issue so I guess it must be an issue on the application side rather than the database saying it's locked?

dippynark on 26 Nov 2019

Same here, still experiencing db lock on 3.0.4892

here is the recurring message in the log

2019-12-04 22:19:52.403 +00:00 [Error] Something bad happened, ErrorMiddleware caught this
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteAsync(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable1.AsyncEnumerator.BufferlessMoveNext(DbContext _, Boolean buffer, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable1.AsyncEnumerator.MoveNext(CancellationToken cancellationToken) at System.Linq.AsyncEnumerable.WhereEnumerableAsyncIterator1.MoveNextCore(CancellationToken cancellationToken) in D:\a\1\s\Ix.NET\Source\System.Interactive.Async\Where.cs:line 106
at System.Linq.AsyncEnumerable.AsyncIterator1.MoveNext(CancellationToken cancellationToken) in D:\a\1\s\Ix.NET\Source\System.Interactive.Async\AsyncIterator.cs:line 98 at System.Linq.AsyncEnumerable.FirstOrDefault_[TSource](IAsyncEnumerable1 source, CancellationToken cancellationToken) in D:\a\1\s\Ix.NET\Source\System.Interactive.Async\First.cs:line 144
at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.TaskResultAsyncEnumerable1.Enumerator.MoveNext(CancellationToken cancellationToken) at System.Linq.AsyncEnumerable.SelectEnumerableAsyncIterator2.MoveNextCore(CancellationToken cancellationToken) in D:\a\1\s\Ix.NET\Source\System.Interactive.Async\Select.cs:line 106
at System.Linq.AsyncEnumerable.AsyncIterator1.MoveNext(CancellationToken cancellationToken) in D:\a\1\s\Ix.NET\Source\System.Interactive.Async\AsyncIterator.cs:line 98 at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.ExceptionInterceptor1.EnumeratorExceptionInterceptor.MoveNext(CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExecuteSingletonAsyncQueryTResult
at Ombi.Core.Engine.Interfaces.BaseEngine.GetUser() in C:\projects\requestplex\src\Ombi.Core\Engine\Interfaces\BaseEngine.cs:line 32
at Ombi.Core.Engine.BaseMediaEngine.HideFromOtherUsers() in C:\projects\requestplex\src\Ombi.Core\Engine\BaseMediaEngine.cs:line 113
at Ombi.Core.Engine.TvRequestEngine.GetTotal() in C:\projects\requestplex\src\Ombi.Core\Engine\TvRequestEngine.cs:line 512
at Ombi.Controllers.RequestController.GetTotalTV() in C:\projects\requestplex\src\Ombi\Controllers\RequestController.cs:line 202
at lambda_method(Closure , Object )
at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext)
at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext)
at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\Middleware\ApiKeyMiddlewear.cs:line 51
at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\Middleware\ErrorHandlingMiddlewear.cs:line 24
2019-12-04 22:20:00.564 +00:00 [Debug] Batch acquisition of 0 triggers
2019-12-04 22:20:21.676 +00:00 [Error] Something bad happened, ErrorMiddleware caught this
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteAsync(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable1.AsyncEnumerator.BufferlessMoveNext(DbContext _, Boolean buffer, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable1.AsyncEnumerator.MoveNext(CancellationToken cancellationToken) at System.Linq.AsyncEnumerable.WhereEnumerableAsyncIterator1.MoveNextCore(CancellationToken cancellationToken) in D:\a\1\s\Ix.NET\Source\System.Interactive.Async\Where.cs:line 106
at System.Linq.AsyncEnumerable.AsyncIterator1.MoveNext(CancellationToken cancellationToken) in D:\a\1\s\Ix.NET\Source\System.Interactive.Async\AsyncIterator.cs:line 98 at System.Linq.AsyncEnumerable.FirstOrDefault_[TSource](IAsyncEnumerable1 source, CancellationToken cancellationToken) in D:\a\1\s\Ix.NET\Source\System.Interactive.Async\First.cs:line 144
at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.TaskResultAsyncEnumerable1.Enumerator.MoveNext(CancellationToken cancellationToken) at System.Linq.AsyncEnumerable.SelectEnumerableAsyncIterator2.MoveNextCore(CancellationToken cancellationToken) in D:\a\1\s\Ix.NET\Source\System.Interactive.Async\Select.cs:line 106
at System.Linq.AsyncEnumerable.AsyncIterator1.MoveNext(CancellationToken cancellationToken) in D:\a\1\s\Ix.NET\Source\System.Interactive.Async\AsyncIterator.cs:line 98 at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.ExceptionInterceptor1.EnumeratorExceptionInterceptor.MoveNext(CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExecuteSingletonAsyncQueryTResult
at Ombi.Core.Engine.Interfaces.BaseEngine.GetUser() in C:\projects\requestplex\src\Ombi.Core\Engine\Interfaces\BaseEngine.cs:line 32
at Ombi.Core.Engine.BaseMediaEngine.HideFromOtherUsers() in C:\projects\requestplex\src\Ombi.Core\Engine\BaseMediaEngine.cs:line 113
at Ombi.Core.Engine.MusicRequestEngine.GetRequests(Int32 count, Int32 position, OrderFilterModel orderFilter) in C:\projects\requestplex\src\Ombi.Core\Engine\MusicRequestEngine.cs:line 140
at Ombi.Controllers.MusicRequestController.GetRequests(Int32 count, Int32 position, Int32 orderType, Int32 statusType, Int32 availabilityType) in C:\projects\requestplex\src\Ombi\Controllers\MusicRequestController.cs:line 47
at lambda_method(Closure , Object )
at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIIndexMiddleware.Invoke(HttpContext httpContext)
at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext)
at Ombi.ApiKeyMiddlewear.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\Middleware\ApiKeyMiddlewear.cs:line 51
at Ombi.ErrorHandlingMiddleware.Invoke(HttpContext context) in C:\projects\requestplex\src\Ombi\Middleware\ErrorHandlingMiddlewear.cs:line 24

GeneralDoddi on 4 Dec 2019

Please use MySql If you are experiencing this.

tidusjar on 4 Dec 2019

Ombi: SQLite Error 5: 'database is locked'.

Most helpful comment

All 156 comments

!/bin/sh

!/bin/sh

Related issues