johnchimpo 7 Posted June 16, 2016 Share Posted June 16, 2016 This problem started with an update received in the last month (I have been on beta release and since this occurred have changed to stable updates only). Currently running ver 3.1.14.0. This library has been in use with emby since appx 2011. Either sonarr or emby created this issue with a recent update, but I do not believe it was a bug just a kink in the config that I had slipped through all these years with no problem. The issue is a duplication of server data for each episode that exist in the library one with the UNC path and one with the local drive path. (i.e. \\media01\television\12 monkeys\season 01\ep1.mp4 and H:\television\12 monkeys\season 01\ep1.mp4). I have solved the problem going forward - the issue was that emby libraries were configured for the UNC path and sonarr was saving media, sending notifications and writing metadata using the local path. However, all the thousands of episodes that existed on the server prior to the fix are still duplicated. All the metadata for each duplicate file is the same, watch states, etc., but I'm lost for how to eliminate the duplicate entries. I've tried all the server tasks, checked every setting in the dashboard, dug through the server data files (where I can't find the server's metadata exists), read the logs (no permissions issues have popped up). Any genius ideas out there to save me from a complete re-add of the library? Link to comment Share on other sites More sharing options...
Luke 37022 Posted June 16, 2016 Share Posted June 16, 2016 the notifications from sonarr won't cause any duplicates. they basically just tell us that something changed. it's like an automated way of scanning the library. I guess I would start by reviewing your library setup. have you configured any libraries mulitple times with different paths? Link to comment Share on other sites More sharing options...
johnchimpo 7 Posted June 16, 2016 Author Share Posted June 16, 2016 Library has been pointed only at the UNC path since the mb3 days. All collections are represented only once and there are no ccollections as sunflowers within another collection. Again this only has occurred with the TV collection. Sonarr has an option to write metadata specific to the emby server. I suspect that it hard coded the file path in its metadata. Link to comment Share on other sites More sharing options...
Luke 37022 Posted June 16, 2016 Share Posted June 16, 2016 Then maybe you could start by showing us the problem with screenshots, thanks. Link to comment Share on other sites More sharing options...
johnchimpo 7 Posted June 16, 2016 Author Share Posted June 16, 2016 Then maybe you could start by showing us the problem with screenshots, thanks. Attached. Season view. UNC link Local link Network folder This series was added to test after the fix was made in Sonarr. No duplicates and correct UNC link. This series existed before the fix. Episodes 21 & 24 added after the fix. Problem persists. Finally here is a screenshot of my libraries setup. Note: H:/Television is shared as \\MEDIA01\television so only one file exists of each episode. Playing either file works either locally, in MB-Classic locally, or web-remote. Link to comment Share on other sites More sharing options...
Solution Luke 37022 Posted June 16, 2016 Solution Share Posted June 16, 2016 Try running the clean database scheduled task. If the issue persists then you try deleting the library.db under the server's data folder. The reason such a drastic measure might be needed is that since you've said your installation is from 2011, a lot of things have changed internally over time and it's possible that you have very old content sitting in your database that the server is unable to cleanup for whatever reason. 1 Link to comment Share on other sites More sharing options...
johnchimpo 7 Posted June 16, 2016 Author Share Posted June 16, 2016 That is what I was expecting may be the only solution. I've run the clean database a dozen times (after each subsequent attempted fix) and no luck. Will deleting the library.db file be practically the same as creating a new library? Will all watched, favorite states, etc be erased? Link to comment Share on other sites More sharing options...
Luke 37022 Posted June 16, 2016 Share Posted June 16, 2016 deleting the library db will cause the server to rescan everything and will retain watched data. Link to comment Share on other sites More sharing options...
johnchimpo 7 Posted June 16, 2016 Author Share Posted June 16, 2016 deleting the library db will cause the server to rescan everything and will retain watched data. Wonderful. That is exactly what I'm hoping for. Will report back with results. Thank you Luke! Link to comment Share on other sites More sharing options...
johnchimpo 7 Posted June 16, 2016 Author Share Posted June 16, 2016 Update: Deleting library.db has fixed the problem of duplicate entries (so far none have been noticed). Still populating in metadata and artwork. A good amount of watched status was lost, however it appears to mostly revolve around a point close to one year ago. I believe this may coincide with my switch from SickBeard to Sonarr. I imagine there was an archaic convention being used that current builds no longer use. Marking this one solved for now. Thanks Luke. 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