jriker1 16 Posted October 23, 2021 Share Posted October 23, 2021 (edited) I recently updated the Android TV app on my shield and can no longer delete any shows. Gives me VolleyError com.android.volleyServerError: Rebooted, killed the app and started it again. Edited October 23, 2021 by jriker1 Link to comment Share on other sites More sharing options...
jriker1 16 Posted October 23, 2021 Author Share Posted October 23, 2021 As of today the Scan Media job started failing. No updates pending. Getting: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown. at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc) at SQLitePCL.pretty.StatementImpl.MoveNext() at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItem(IDatabaseConnection db, BaseItem item, Int64 topParentId, Int64 userDataKeyId, IStatement insertItemStatement, IStatement updateItemStatement) at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItemsInTranscation(IDatabaseConnection db, List`1 tuples) at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItems(List`1 items, Action`1 afterSave, CancellationToken cancellationToken) at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItems(List`1 items, CancellationToken cancellationToken) at Emby.Server.Implementations.Library.LibraryManager.UpdateItems(List`1 items, BaseItem parent, ItemUpdateType updateReason, Boolean setDateLastSaved, Boolean saveMetadata, CancellationToken cancellationToken) at Emby.Server.Implementations.Library.LibraryManager.UpdateItem(BaseItem item, BaseItem parent, ItemUpdateType updateReason) at MediaBrowser.Controller.Entities.BaseItem.UpdateToRepository(ItemUpdateType updateReason) at MediaBrowser.Providers.Manager.MetadataService`2.SaveItem(MetadataResult`1 result, Boolean isFirstRefresh, LibraryOptions libraryOptions, ItemUpdateType reason, IDirectoryService directoryService, CancellationToken cancellationToken) at MediaBrowser.Providers.Manager.MetadataService`2.RefreshMetadata(BaseItem item, MetadataRefreshOptions refreshOptions, LibraryOptions libraryOptions, CancellationToken cancellationToken) at MediaBrowser.Controller.Entities.BaseItem.RefreshMetadata(MetadataRefreshOptions options, LibraryOptions libraryOptions, CancellationToken cancellationToken) at Emby.Server.Implementations.Library.LibraryManager.ValidateTopLibraryFolders(Boolean refreshMetadatas, CancellationToken cancellationToken) at Emby.Server.Implementations.Library.LibraryManager.PerformLibraryValidation(IProgress`1 progress, CancellationToken cancellationToken) at Emby.Server.Implementations.Library.LibraryManager.ValidateMediaLibraryInternal(IProgress`1 progress, CancellationToken cancellationToken) at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options) Link to comment Share on other sites More sharing options...
Happy2Play 8140 Posted October 23, 2021 Share Posted October 23, 2021 Please post the server log to see the exact error but will fall under the KB. https://support.emby.media/support/solutions/articles/44002210894 Link to comment Share on other sites More sharing options...
jriker1 16 Posted October 23, 2021 Author Share Posted October 23, 2021 Here you go. Think there are other threads I recently found with this same issue. Note I'll go thru that kb article however loosing my watched movies isn't an option here if that is what's going to happen. I backup my server daily. Can I just restore something? Think it would be an app issue because I'm not the only one that suddenly had this happen in the last few days. embyserver-1.txt Link to comment Share on other sites More sharing options...
Solution Happy2Play 8140 Posted October 23, 2021 Solution Share Posted October 23, 2021 1 minute ago, jriker1 said: Here you go. Think there are other threads I recently found with this same issue. Note I'll go thru that kb article however loosing my watched movies isn't an option here if that is what's going to happen. I backup my server daily. Can I just restore something? Think it would be an app issue because I'm not the only one that suddenly had this happen in the last few days. embyserver-1.txt 1.82 MB · 0 downloads No you have a Locked database which is way different then the Andriod issue. SQLitePCL.pretty.SQLiteException: Busy: database is locked Follow the Remove Locks sections of the KB. Link to comment Share on other sites More sharing options...
jriker1 16 Posted October 23, 2021 Author Share Posted October 23, 2021 Thanks I'll try. I have a bunch of references to shm and wal under users and authentication and displaypreferences. Should I be clearing these also? Link to comment Share on other sites More sharing options...
Happy2Play 8140 Posted October 23, 2021 Share Posted October 23, 2021 Just now, jriker1 said: Thanks I'll try. I have a bunch of references to shm and wal under users and authentication and displaypreferences. Should I be clearing these also? Technically when Emby is shutdown properly no db file should have remaining shm and wal files. I would clear all of them. Link to comment Share on other sites More sharing options...
jriker1 16 Posted October 23, 2021 Author Share Posted October 23, 2021 cleared all that out and good to go now for this issue. Thank you much!! 1 Link to comment Share on other sites More sharing options...
Luke 36881 Posted October 23, 2021 Share Posted October 23, 2021 Hi there, please attach the emby server log from when you tried to do this. Thanks. Link to comment Share on other sites More sharing options...
Happy2Play 8140 Posted October 23, 2021 Share Posted October 23, 2021 16 minutes ago, Luke said: Hi there, please attach the emby server log from when you tried to do this. Thanks. Wouldn't the OP other topic for Locked database cause this also? Log attached in that topic. https://emby.media/community/index.php?/topic/102778-scan-media-failing/&do=findComment&comment=1080974 Link to comment Share on other sites More sharing options...
Luke 36881 Posted October 23, 2021 Share Posted October 23, 2021 Yes it certainly could. Link to comment Share on other sites More sharing options...
Peter Nent 47 Posted October 23, 2021 Share Posted October 23, 2021 After the most recent update (4.7.0.15) of Emby, I'm confronted with a database issue. I followed the instructions: Corrupt Database : Emby: Installed DB Browser for SQLite (I've no experienace with it), checked the intigrity (found 4 errors), then fifirst I exported the database and afterwards, I imported that data into a new library-recovered.db database: that action is already running for approx. 2 days.....looking into Windows taskmanager (Windows Server 2016 DC), it consumes approx. 12% of CPU and 1.2GB memory and is still running .... Question: is there no easier way to repair the Emby database ? (origional library.db in C:\Users\Administrator\AppData\Roaming\Emby-Server\datain is approx. 1,039GB in size) Thanks & best regards, Peter Link to comment Share on other sites More sharing options...
Carlo 4328 Posted October 23, 2021 Share Posted October 23, 2021 Hi, something is wrong if this is taking 2 days to import. My database is larger than yours and on my i7 notebook can export/import in less than 10 minutes. If you like zip up your original library.db database and PM it to me. I'll see what I can do for you. Link to comment Share on other sites More sharing options...
jriker1 16 Posted October 23, 2021 Author Share Posted October 23, 2021 Yep they ended up being related thanks. 1 Link to comment Share on other sites More sharing options...
Carlo 4328 Posted October 24, 2021 Share Posted October 24, 2021 What did you end up finding out? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now