dcol 175 Posted April 24, 2019 Posted April 24, 2019 How do I do a database cleanup. Or at least cleanup the following I have tons of items in the LiveTV>Recording listings that do not exist in the library. Many come from another server that is not even on line at the moment. There are even items from the Movies library in there. And tons of old recordings I have deleted a long time ago. I want to clean it up. How do I do that?
dcol 175 Posted April 24, 2019 Author Posted April 24, 2019 Doesn't work. All the old stuff still there
dcol 175 Posted April 24, 2019 Author Posted April 24, 2019 I can see tons of old deleted episodes listed in the LiveTV/Recordings. I am manually deleting the media now, but there are over 500 of them. Seems when I dlete shows thay don't get removed from the database. And it looks like it has benn happening for months. And whats worse, is there are shows from another server that never even existed in this library. The TVshows library is fine. It is just the LiveTV/Recording listing. The latest listings works, but if I select all of them, I get old stuff. This is a real problem for AndroidTV where it does not show the Latest listing rather the bad list which looks like everything I ever recorded.
dcol 175 Posted April 24, 2019 Author Posted April 24, 2019 (edited) Another issue Is I can't get rid of ones that do exist that do not belong there. As an example, I have a SciFi movie in the movie library called '2036 Origin Unknown'. I copied it to a temp location, then deleted the media from the LiveTV>Recording listing. It went away. Then I copied the movie back and bingo, it reappeared in the LiveTV>Recording listing. Then I moved it to another folder in the movie library and it came back to the Recording listing. This movie was never even recorded. It was ripped and copied directly to the movie library. I just looked deeper and there are a whole bunch of random movies in the recording listing. None were recordings. I think this issue goes deeper than just a messed up database. This can't be right. What's going on here. Never seen this issue before 4.1.0.26 Edited April 24, 2019 by dcol
dcol 175 Posted April 24, 2019 Author Posted April 24, 2019 Ok, I guess that LiveTV>Recording just shows any video that was put in any library. Very confusing. Not a live TV function at all. You should rethink this feature or remove it
jad3675 26 Posted April 24, 2019 Posted April 24, 2019 Ok, I guess that LiveTV>Recording just shows any video that was put in any library. Very confusing. Not a live TV function at all. You should rethink this feature or remove it It only works that way if you have added that path to the Live/TV Library. By default it only has the path you set under DVR. John
dcol 175 Posted April 25, 2019 Author Posted April 25, 2019 (edited) Not true. I can look under LiveTV/recordings and see shows that I have recorded and deleted months ago. How do you explain that? It also has shows I recorded on another server and I never had that library's folders in this server. My guess is there was a beta that had a bug and caused the issue, now I am stuck with hundreds of bogus shows in the listing. Regardless of reasons or 'that can't happen' responses. The data is there and I want to get rid of it. All I asked for is a way to clean up the database. Does anyone know how to do this? Is there a file I can delete to cause a rebuild of a new fresh database? Or should I just delete the entire Emby folder and start over, which seems pretty drastic to me. Maybe the 'scan and find new and missing items' should also find and delete removed items as well. Edited April 25, 2019 by dcol
jad3675 26 Posted April 25, 2019 Posted April 25, 2019 (edited) Not true. I can look under LiveTV/recordings and see shows that I have recorded and deleted months ago. How do you explain that? It also has shows I recorded on another server and I never had that library's folders in this server. My guess is there was a beta that had a bug and caused the issue, now I am stuck with hundreds of bogus shows in the listing. Regardless of reasons or 'that can't happen' responses. The data is there and I want to get rid of it. All I asked for is a way to clean up the database. Does anyone know how to do this? Is there a file I can delete to cause a rebuild of a new fresh database? Or should I just delete the entire Emby folder and start over, which seems pretty drastic to me. Maybe the 'scan and find new and missing items' should also find and delete removed items as well. That makes no sense - the libraries in emby only know about the media that exists in paths that you specify for each library. If I delete media either via the OS or emby GUI, emby does remove it from the library during its scan. If you want to start from scratch, backup and then delete your library.db file. You'll be starting from scratch though. From the admin panel, you could also delete the library that contains your recorded TV. John Edited April 25, 2019 by jad3675
dcol 175 Posted April 25, 2019 Author Posted April 25, 2019 (edited) Maybe makes no sense, but clearly I see shows and movies in the LiveTV/Recording on the stable server that I have only recorded in the beta server and do not exist in any library now but still show up in LiveTV/Recording right now. All the deleted shows and movies are still there under LiveTV>Recordings. They do not show in the actual TVshow or Movie library, just in the LiveTV>Recordings listing. This is where I see all the old deleted shows and movies listed from months past and from the other server. Maybe this is the normal behavior. idk. I really just wanted to cleanup the LiveTV>Recordings listings. With all the hundreds of listings there, it is impossible to use. Especially on AndroidTV because it does not default to 'Latest Recordings' like the web browser does. And the filters don't work the way I want in AndroidTV where all the images are messed up only in the LiveTV>Recordings listings. Every other category is fine. Edited April 25, 2019 by dcol
emveepee 132 Posted June 7, 2019 Posted June 7, 2019 I want to go back and fourth between two different instances of NextPVR with different configurations and I'd like to be able to clean out the recordings, schedules, and guide, but I can't see a way to do this. Martin
dcol 175 Posted June 8, 2019 Author Posted June 8, 2019 Emby is slowly breaking off from NextPVR. Already some of the NPVR data does not make it to Emby anymore. I am migrating away from NPVR for this very reason.
Luke 42078 Posted June 8, 2019 Posted June 8, 2019 Who said emby is breaking off from next pvr? The plugin is still available.
emveepee 132 Posted June 8, 2019 Posted June 8, 2019 @@dcol can you tell me what data is missing from NextPVR as I am work with sub to get more data from version 5(ie season and episode which probably weren't important to Sven rather than less. There should be more art too. However to get there I do need to be able to clean my database for things like MediaItems type 3, 8 and 27 since I believe those are getting confused with my type 31 record since they seem to linger when I move from v4. If deleting library.db is all that it takes I am good with that. Martin
CBers 7450 Posted June 8, 2019 Posted June 8, 2019 How do I do a database cleanup. Or at least cleanup the following @@dcol https://emby.media/community/index.php?/topic/58164-fr-ability-to-compact-the-database
dcol 175 Posted June 8, 2019 Author Posted June 8, 2019 I have learned that deleting the library.db clears the database. But sometimes I would like to correct small DB issues like removing a mapped channel. It would be nice to be able to make small changes to the DB. As far as NPVR goes, the show labels are not imported, such as 'New' 'Repeat' Also some of the art is not importing any more. Also I no longer see the red dot in the guide for the shows that are set to record. Also I can no longer set a recording in Emby that goes to NPVR. Just get a spinning circle. Need I go on about the plug-in.
emveepee 132 Posted June 8, 2019 Posted June 8, 2019 If you are using Schedules Direct you should should get I have learned that deleting the library.db clears the database. But sometimes I would like to correct small DB issues like removing a mapped channel. It would be nice to be able to make small changes to the DB. As far as NPVR goes, the show labels are not imported, such as 'New' 'Repeat' Also some of the art is not importing any more. Also I no longer see the red dot in the guide for the shows that are set to record. Also I can no longer set a recording in Emby that goes to NPVR. Just get a spinning circle. Need I go on about the plug-in. Did you move off Schedules Direct for NextPVR by any chance? Otherwise the plugin hasn't really changed you are talking server issues. There was a stupid Emby change to reload recordings as Internet streams and not dynamically but that doesn't explain what you are seeing but I will investigate as I work through v5. Martin
dcol 175 Posted June 8, 2019 Author Posted June 8, 2019 Using SD in NextPVR. Always have with only one IPTV provider. After NPVR records it gets converted by MCEBuddy then gets sent to the Emby library. Emby then picks it up normally and gets the artwork. But anything to do with the guide itself in Emby has issues. By the way, in Emby, there are no items setup in LiveTV. NPVR plugin is the only source. The guide is there, but no labels or schedules are there. I have to do everything in NPVR.
emveepee 132 Posted June 8, 2019 Posted June 8, 2019 By the way, in Emby, there are no items setup in LiveTV. NPVR plugin is the only source. The guide is there, but no labels or schedules are there. I have to do everything in NPVR. Sounds like you need to make a post in the NextPVR forum with logs etc. I don't see that with v4 Martin
dcol 175 Posted June 8, 2019 Author Posted June 8, 2019 Using 4.2.4 NPVR and I did post there and they said that Emby needs to redo the API, or something like that. Not an NPVR issue.
emveepee 132 Posted June 9, 2019 Posted June 9, 2019 Using 4.2.4 NPVR and I did post there and they said that Emby needs to redo the API, or something like that. Not an NPVR issue. Ok I found what I believe you are referring too, but no sign of a log whatsoever https://emby.media/community/index.php?/topic/70875-show-tags-not-shown-in-emby-guide-from-npvr/ The extra info provided in this thread makes it sound like the web server isn't working and you are seeing stale information which to keep this post on topic would help with a cleanup. I'd be happy to continue to help you out in the other thread. Martin
dcol 175 Posted June 9, 2019 Author Posted June 9, 2019 I will direct future NVPR topics to the other thread. Thank you
mcoyle76 2 Posted May 6, 2020 Posted May 6, 2020 There should be a plugin developed, or something built into emby to cleanup the database when you delete an album, or whatever from emby. I deleted an album, and re-added it, and the same metadata information came back after re-adding it, and the data for the album was still in the database. I tried a metadata refresh, and it did no good. I had to delete the database, and have emby recreate it then the album metadata loaded like it did the first time the album was added to emby. There should also be a tool, or something to optimize the database if you have a lot of data added to emby.
dcol 175 Posted May 6, 2020 Author Posted May 6, 2020 The closest thing we have is the <VacuumDatabaseOnStartup> in programdata\confi\system.xml. Not sure how much that does though. I find just deleting the library.db and metadata folder every so often is the only method available to get a complete cleanup. But that takes a long time and removes any custom data. Like to see some other suggestions.
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