Strange Duplications happening in DB

[media@qna.net.au 0]

So was looking to do a double check on movie is  emby equals movies on disk and came across a strangle lot of duplications, where the same movie & the same path and file is now showing up multiple times as below

So I installed Report plugin to see how many of this have occurred and there is quite a few. 

It seems to be something to do with the metadata as you will see in the example below the only difference is the parent rating, community rating. I have check and double check single file in same directory. Strange right? 

So question anyone else seeing this problem? Is there a way to resolve it?
 

[Abobader 3470]

Hello media@qna.net.au,

** This is an auto reply **

Please wait for someone from staff support or our members to reply to you.

It's recommended to provide more info, as it explain in this thread:

Thank you.

Emby Team

[Luke 42083]

HI, that's strange. What version of the server are you on?

[media@qna.net.au 0]

Version 4.7.11.0

[Luke 42083]

OK, what should work, if you're willing, is to remove your entire movies library from the server, then complete a full scan of all libraries to clean out the database, and then add it back.

[media@qna.net.au 0]

Surely if I add it back then the double ups will be back? 
Just reread your comment, thought you were say database not library, the only issue with this is, it miss identifies a bundle of movies and I will need to go back through and work out which ones again and redo them, plus what will happen to my watch history?

 

 

Edited April 28, 2023 by media@qna.net.au

[Luke 42083]

No, probably not if both are cleaned out.

[media@qna.net.au 0]

Just reread your comment, thought you were say database not library, the only issue with this is, it miss identifies a bundle of movies and I will need to go back through and work out which ones again and redo them, plus what will happen to my watch history?

[Luke 42083]

Exactly, there's obviously a risk involved with doing it. Watch data is correlated with external ids (moviedb/imdb), not database ids, so generally that be fine, although you may still notice some loss of watch data for items whose external ids are not exactly the same as they were before.