Remove Old Cached Data Failed

[scegg 12]

When running "Remove Old Cached Data", error reports:

Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown. at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc) at SQLitePCL.pretty.StatementImpl.MoveNext() at InfuseSync.Storage.SqliteExtensions.ExecuteNonQuery(IStatement statement) at InfuseSync.Storage.Db.<>c__DisplayClass18_0.b__0(IDatabaseConnection db) at SQLitePCL.pretty.DatabaseConnection.<>c__DisplayClass20_0.b__0(IDatabaseConnection db) at SQLitePCL.pretty.DatabaseConnection.RunInTransaction[T](IDatabaseConnection This, Func`2 f, TransactionMode mode) at SQLitePCL.pretty.DatabaseConnection.RunInTransaction(IDatabaseConnection This, Action`1 action, TransactionMode mode) at SQLitePCL.pretty.DatabaseConnection.RunInTransaction(IDatabaseConnection This, Action`1 action) at InfuseSync.Storage.Db.DeleteOldData(Int64 timestamp) at InfuseSync.ScheduledTasks.HousekeepingTask.Execute(CancellationToken cancellationToken, IProgress`1 progress) at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options)

 

It can repo always.

 

Emby Version: Docker 4.8.11.0

[scegg 12]

It seems to be related to InfuseSync? I have 1.5.1.0 installed.

 

I remove the InfuseSync and restart emby. The scheduled task is gone.

 

And after reinstall InfuseSync back, the error comes back too.

Edited March 26, 2025 by scegg

[scegg 12]

2025-03-26 08:35:51.904 Info Server: http/1.1 POST http://host3:8096/emby/ScheduledTasks/Running/6c59161bf3e7372fd91d14552ab99ae5?X-Emby-Client=Emby Web&X-Emby-Device-Name=Edge Windows&X-Emby-Device-Id=6e3b78b3-ece2-46e2-8be7-268a973ef3de&X-Emby-Client-Version=4.8.11.0&X-Emby-Token=x_secret2_x&X-Emby-Language=en-us. Source Ip: host4, UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36 Edg/134.0.0.0
2025-03-26 08:35:51.904 Info TaskManager: Executing Remove Old Cached Data
2025-03-26 08:35:51.904 Info Server: http/1.1 Response 204 to host4. Time: 1ms. POST http://host3:8096/emby/ScheduledTasks/Running/6c59161bf3e7372fd91d14552ab99ae5?X-Emby-Client=Emby Web&X-Emby-Device-Name=Edge Windows&X-Emby-Device-Id=6e3b78b3-ece2-46e2-8be7-268a973ef3de&X-Emby-Client-Version=4.8.11.0&X-Emby-Token=x_secret2_x&X-Emby-Language=en-us
2025-03-26 08:35:51.913 Info App: Sqlite: 779 - index corruption at line 97159 of [831d0fb283]
2025-03-26 08:35:51.913 Info App: Sqlite: 779 - statement aborts at 13: [delete from user_info where LastModified < @Timestamp;] database disk image is malformed
2025-03-26 08:35:51.914 Error TaskManager: Error
*** Error Report ***
Version: 4.8.11.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.60-qnap (root@Q64-102-94) (x86_64-QNAP-linux-gnu-gcc (toolchain config: [gcc-4.9.2 binutils-2.25 glibc-2.21]) 4.9.2, GNU ld (GNU Bi
Framework: .NET 6.0.36
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()

[scegg 12]

Checking library:

PRAGMA integrity_check;

reports ok

Edited March 26, 2025 by scegg

[scegg 12]

Ahha.

 

Realized that the schedule task is processing only infuse_sync.db and the file won't be removed with plugin uninstalling.

Deleting infuse_sync.db while emby stopped then restart. Everything is fine now.

[Luke 42078]

8 hours ago, scegg said:

2025-03-26 08:35:51.904 Info Server: http/1.1 POST http://host3:8096/emby/ScheduledTasks/Running/6c59161bf3e7372fd91d14552ab99ae5?X-Emby-Client=Emby Web&X-Emby-Device-Name=Edge Windows&X-Emby-Device-Id=6e3b78b3-ece2-46e2-8be7-268a973ef3de&X-Emby-Client-Version=4.8.11.0&X-Emby-Token=x_secret2_x&X-Emby-Language=en-us. Source Ip: host4, UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36 Edg/134.0.0.0
2025-03-26 08:35:51.904 Info TaskManager: Executing Remove Old Cached Data
2025-03-26 08:35:51.904 Info Server: http/1.1 Response 204 to host4. Time: 1ms. POST http://host3:8096/emby/ScheduledTasks/Running/6c59161bf3e7372fd91d14552ab99ae5?X-Emby-Client=Emby Web&X-Emby-Device-Name=Edge Windows&X-Emby-Device-Id=6e3b78b3-ece2-46e2-8be7-268a973ef3de&X-Emby-Client-Version=4.8.11.0&X-Emby-Token=x_secret2_x&X-Emby-Language=en-us
2025-03-26 08:35:51.913 Info App: Sqlite: 779 - index corruption at line 97159 of [831d0fb283]
2025-03-26 08:35:51.913 Info App: Sqlite: 779 - statement aborts at 13: [delete from user_info where LastModified < @Timestamp;] database disk image is malformed
2025-03-26 08:35:51.914 Error TaskManager: Error
*** Error Report ***
Version: 4.8.11.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.60-qnap (root@Q64-102-94) (x86_64-QNAP-linux-gnu-gcc (toolchain config: [gcc-4.9.2 binutils-2.25 glibc-2.21]) 4.9.2, GNU ld (GNU Bi
Framework: .NET 6.0.36
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()

Hi, please take a look at this and let us know if it helps get you squared away:

Corrupt Database

[scegg 12]

9 hours ago, Luke said:

Hi, please take a look at this and let us know if it helps get you squared away:

Corrupt Database

Yes. This helps a lot but not directly. The plugin use a dedicated database located in the same folder. Removing it can solve the problem.

[scegg 12]

It always happened after several days later than removing the database files created by infuse plugins.

Have to remove those database files repeatly.

[Luke 42078]

You mean you still have to do that?

[scegg 12]

17 minutes ago, Luke said:

You mean you still have to do that?

Yes.

This issue is reported to infuse community and have no result currently. (https://community.firecore.com/t/infusesync-for-emby-not-work-with-last-emby-version-4-8-10/51201)

 

[Luke 42078]

OK now I understand. I bet most of what the plugin does is probably not needed anymore, except maybe for tracking deletions. The kodi sync plugin by comparison also has it's own data store, but it's only used to keep a record of deletions, and everything else is handled via core functions:

https://github.com/MediaBrowser/Emby.Kodi.SyncQueue

[scegg 12]

Just now, Luke said:

OK now I understand. I bet most of what the plugin does is probably not needed anymore, except maybe for tracking deletions. The kodi sync plugin by comparison also has it's own data store, but it's only used to keep a record of deletions, and everything else is handled via core functions:

https://github.com/MediaBrowser/Emby.Kodi.SyncQueue

By FireCore support, "InfuseSync is a plugin for Emby and Jellyfin media servers that tracks all media changes to decrease sync times when using Library Mode in Infuse."

NVM. If there is nothing wrong about emby, leave this problem with firecore.

[Luke 42078]

Right, I understand what it is, however I think a lot of this code was written prior to Emby Server adding it's own functions to determine changes. So nowadays it might be doing more work than is necessary. But I guess that's another discussion.