400 Error - There was an issue saving progress

[TheQwenton]

If this is a feature request, request here instead. Feature requests will be deleted from Github.

Please put as much information as possible to help me understand your issue. OS, browser, version are very important!

Describe the bug The error "Error 400 - There was an issue saving progress" keeps appearing when I am reading manga while on Chrome on Window 11, safari on the Ipad mini 6th generation (newest). This has been happening for some time now and has never gone away. Unraid is running in a docker container on my Unraid server.

Unraid configuration settings

Steps to reproduce the behavior

1. Log in
2. Open up manga or book to read
3. Read Manga, and continue to click through pages
4. Error appears consistently in bottom right corner

Expected behavior

1. Error does not appear when clicking through pages

Screenshots

Desktop (please complete the following information):

• OS: Windows 11
• Browser: Chrome
• Version: Latest? Logging in as admin and checking Server Settings>System shows nothing. I keep the docker container on Unraid on the latest version

Smartphone (please complete the following information):

• Device: Ipad Mini 6th Generation
• OS: Ipad OS 17 (latest)
• Browser: Safari
• Version: 16.5 (latest)

Additional Information Pulled logs from logs folder. This is the error message that keeps occuring [Kavita] [2023-08-24 22:36:49.996 -05:00 192] [Error] API.Services.ReaderService Could not save progress Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details. ---> 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.SqliteDataRecord.Dispose() at Microsoft.Data.Sqlite.SqliteDataReader.NextResult() at System.Data.Common.DbDataReader.NextResultAsync(CancellationToken cancellationToken) --- End of stack trace from previous location --- at Microsoft.EntityFrameworkCore.Update.AffectedCountModificationCommandBatch.ConsumeAsync(RelationalDataReader reader, CancellationToken cancellationToken) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.AffectedCountModificationCommandBatch.ConsumeAsync(RelationalDataReader reader, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList1 entriesToSave, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at API.Data.UnitOfWork.CommitAsync() in /home/runner/work/Kavita/Kavita/API/Data/UnitOfWork.cs:line 87 at API.Services.ReaderService.SaveReadingProgress(ProgressDto progressDto, Int32 userId) in /home/runner/work/Kavita/Kavita/API/Services/ReaderService.cs:line 306

[TheQwenton]

Here is the full logs from today. kavita20230824.log

[majora2007]

See our FAQ. You need to switch to WAL.

[TheQwenton]

See our FAQ. You need to switch to WAL I downloaded DB Browser and suggested and attempted the change. After switching now, my comic load incredibly slow and most of the time never at all. This was not an issue before. Does WAL have something to do with that?

[TheQwenton]

I was able to fix this issue by switching my data base to WAL. Did this in DB Browser (SQLite) by changing this option. I will open a separate issue for HTTP GET requests not going through.

[Melechtna]

Would have been very nice if there was more here than "read our faq". On Linux, getting the same error, and no where in the entire guide can I see anything about creating or attaching a database.

Edit: Looks like it creates its own, which makes sense, but it looks like it's using SQLite3, after some more digging, I found out you can do so in the terminal with

sqlite3 /opt/Kavita/config/kavita.db

Adjust the directory above to whever you're doing this. It will then drop you in an sqlite shell, and you simply run,

PRAGMA journal_mode=WAL;

It should respond simply with, wal. And it's best to confirm that this set by running,

PRAGMA journal_mode;

And it should then return just, wal. From there it should start working properly.