Auto Organize DB Error

[keith2045 7]

My auto organize stopped working. Looking at the logs i noticed this

2023-11-09 20:50:51.080 Error Server: Error processing request
	*** Error Report ***
	Version: 4.7.14.0
	Command line: /system/EmbyServer.dll -programdata /config -ffdetect /bin/ffdetect -ffmpeg /bin/ffmpeg -ffprobe /bin/ffprobe -restartexitcode 3
	Operating system: Linux version 5.10.0-25-amd64 (debian-kernel@lists.debian.org) (gcc-10 (Debian 10.2.1-6) 10.2.1 20210110, GNU ld (GNU Binutils for Debian) 2.35.2) #1
	Framework: .NET 6.0.20
	OS/Process: x64/x64
	Runtime: system/System.Private.CoreLib.dll
	Processor count: 8
	Data path: /config
	Application path: /system
	SQLitePCL.pretty.SQLiteException: Corrupt: database disk image is malformed
	SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
	   at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
	   at SQLitePCL.pretty.StatementImpl.MoveNext()
	   at Emby.AutoOrganize.Data.SqliteExtensions.ExecuteQuery(IStatement This)+MoveNext()
	   at Emby.AutoOrganize.Data.SqliteFileOrganizationRepository.GetResults(FileOrganizationResultQuery query)
	   at Emby.AutoOrganize.Core.FileOrganizationService.GetResults(FileOrganizationResultQuery query)
	   at Emby.AutoOrganize.Api.FileOrganizationService.Get(GetFileOrganizationActivity request)
	   at Emby.Server.Implementations.Services.ServiceController.Execute(HttpListenerHost appHost, Object requestDto, IRequest req)
	   at Emby.Server.Implementations.Services.ServiceHandler.ProcessRequestAsync(HttpListenerHost httpHost, IServerApplicationHost appHost, IRequest httpReq, IResponse httpRes, RestPath restPath, String responseContentType, CancellationToken cancellationToken)
	   at Emby.Server.Implementations.HttpServer.HttpListenerHost.RequestHandler(IRequest httpReq, ReadOnlyMemory`1 urlString, ReadOnlyMemory`1 localPath, CancellationToken cancellationToken)
	Source: SQLitePCL.pretty
	TargetSite: Void CheckOk(SQLitePCLEx.sqlite3, Int32)

Which database file is it referring to?

Found these instructions, just not sure which DB https://emby.media/support/articles/Corrupt-Database.html

Thanks

[GrimReaper 4739]

10 minutes ago, keith2045 said:

Which database file is it referring to?

Found these instructions, just not sure which DB https://emby.media/support/articles/Corrupt-Database.html

library.db. Shut down Emby server before any operation. 

[Luke 42077]

The instructions are related to the library.db, but this error is for the autoorganize db. You can do the same procedure, just make sure to do it with the right .db file.

[keith2045 7]

Thanks