scan libary failed

[CogyG 3]

He Guys,

 

I just got this message when scanning my libary?

Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
at SQLitePCL.pretty.SQLiteException.CheckOk (SQLitePCLEx.sqlite3 db, System.Int32 rc) [0x00017] in <3160c670dc5644c0a9f2a273b5e4e944>:0
at SQLitePCL.pretty.SQLiteException.CheckOk (SQLitePCLEx.sqlite3_stmt stmt, System.Int32 rc) [0x00006] in <3160c670dc5644c0a9f2a273b5e4e944>:0
at SQLitePCL.pretty.StatementImpl.MoveNext () [0x0004a] in <3160c670dc5644c0a9f2a273b5e4e944>:0
at Emby.Server.Implementations.Data.SqliteItemRepository.ExecuteWithStringFormatParam (SQLitePCL.pretty.IDatabaseConnection db, System.String query, System.String valueText, System.Int64[] values) [0x00034] in <8b98834ec7ec4ab3b9c3092251aa3269>:0
at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItemsInTransaction (SQLitePCL.pretty.IDatabaseConnection db, System.Int64[] ids, System.Boolean containsFolders, System.Boolean supportsPeople, System.Boolean supportsChapters, System.Boolean supportsCollections, System.Boolean supportsMediaStreams, System.Boolean supportsListItems, System.Boolean supportsExternalDatabases) [0x0023c] in <8b98834ec7ec4ab3b9c3092251aa3269>:0
at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItemsInChunks (System.Int64[] ids, SQLitePCL.pretty.IDatabaseConnection db, System.Boolean containsFolders, System.Boolean supportsPeople, System.Boolean supportsChapters, System.Boolean supportsCollections, System.Boolean supportsMediaStreams, System.Boolean supportsListItems, System.Boolean supportsExternalDatabases) [0x00031] in <8b98834ec7ec4ab3b9c3092251aa3269>:0
at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItems (System.Int64[] ids) [0x00049] in <8b98834ec7ec4ab3b9c3092251aa3269>:0
at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItems (MediaBrowser.Controller.Entities.BaseItem[] items) [0x0002b] in <8b98834ec7ec4ab3b9c3092251aa3269>:0
at Emby.Server.Implementations.Library.LibraryManager.DeleteItem (MediaBrowser.Controller.Entities.BaseItem item, MediaBrowser.Controller.Library.DeleteOptions options, MediaBrowser.Controller.Entities.BaseItem parent, System.Boolean notifyParentItem) [0x001d6] in <8b98834ec7ec4ab3b9c3092251aa3269>:0
at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal (System.IProgress`1[T] progress, System.Threading.CancellationToken cancellationToken, System.Boolean recursive, System.Boolean refreshChildMetadata, MediaBrowser.Controller.Providers.MetadataRefreshOptions refreshOptions, MediaBrowser.Controller.Providers.IDirectoryService directoryService) [0x0022e] in <ea29abd8f0ca46269160bb34e38b3817>:0
at MediaBrowser.Controller.Entities.Folder.ValidateSubFolders (MediaBrowser.Controller.Entities.BaseItem[] children, MediaBrowser.Controller.Providers.IDirectoryService directoryService, System.IProgress`1[T] progress, System.Threading.CancellationToken cancellationToken) [0x0013f] in <ea29abd8f0ca46269160bb34e38b3817>:0
at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal (System.IProgress`1[T] progress, System.Threading.CancellationToken cancellationToken, System.Boolean recursive, System.Boolean refreshChildMetadata, MediaBrowser.Controller.Providers.MetadataRefreshOptions refreshOptions, MediaBrowser.Controller.Providers.IDirectoryService directoryService) [0x0039b] in <ea29abd8f0ca46269160bb34e38b3817>:0
at Emby.Server.Implementations.Library.LibraryManager.PerformLibraryValidation (System.IProgress`1[T] progress, System.Threading.CancellationToken cancellationToken) [0x0014a] in &lt;8b98834ec7ec4ab3b9c3092251aa3269&gt;:0
at Emby.Server.Implementations.Library.LibraryManager.ValidateMediaLibraryInternal (System.IProgress`1[T] progress, System.Threading.CancellationToken cancellationToken) [0x00092] in &lt;8b98834ec7ec4ab3b9c3092251aa3269&gt;:0
at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal (MediaBrowser.Model.Tasks.TaskOptions options) [0x001b0] in &lt;8b98834ec7ec4ab3b9c3092251aa3269&gt;:0 </ea29abd8f0ca46269160bb34e38b3817></ea29abd8f0ca46269160bb34e38b3817></ea29abd8f0ca46269160bb34e38b3817>

[Luke 42077]

Hi, you'll probably need to go through the steps in this article here: https://support.emby.media/support/solutions/articles/44002210894-corrupt-database

If you can attach the complete server log file we'll be able to verify. Thanks.

[Happy2Play 9780]

@CogyG Can you provide the server log to see the exact error?

But may need to follow the KB depending on the error.

[CogyG 3]

On 10/29/2022 at 3:37 PM, Luke said:

Hi, you'll probably need to go through the steps in this article here: https://support.emby.media/support/solutions/articles/44002210894-corrupt-database

If you can attach the complete server log file we'll be able to verify. Thanks.

Thanks for the response. @cayars

i've attached the server log

 

My database files are on the Shield.

How can i acces these files?

 

Is it possile to just remove everything on the shield and reinstall server and client?

 

Edit: i think this all happend when i updated te server to 476, i'm now updating to 468..
Do you guys recommend the beta ? 

 

embyserver.txt

[Carlo 4560]

Hi CogyG,

I just removed the instructions I was about to post as I noticed your log showing you running an old server version.  We added a new feature in the version you were just using that helps to optimize the databases on shutdown/startup depending on settings.  This caused an issue for some people that were running Shields. We found the version of SQLite running on Android/Shield was slightly different and needed the code re-ordered, Luke made the changes and that fixed the issue if I remember correctly.

So what I'm going to suggest is to download and install 4.7.9 from here:
https://emby.media/server-android.html

Let us know, how you make out after installing the current version.

Carlo

[Happy2Play 9780]

There is a little guess work as the log does not have any 'SQLitePCL.pretty.SQLiteException' errors, just network errors.  Will guess a log after a library scan possibly.