Movies Duplicate Empty can't delete

Server Version#: 1.30.2.6563
Docker linux

Hello,
i got a very strange issue, i got some movies with duplicate that are empty and when i click delete on the empty file, it won’t work.
Moreover i can’t empty the trash for the movie Section (probably because of that ?)
Has anyone faced the same issue ? And/or know a fix ?
Same with plex_dupefinder, it cannot remove the duplicate.
Thanks

so i decided to open up the DB in a sqlite browser, and it seems that the second file that is empty is linked to this : “iva://api.internetvideoarchive.com/2.0/DataService/VideoAssets(547099)”

If you click on that View XML link does it show that same iva URL?

is the /data/Movies the only folder set for that library?

hum yes i see the same iva, but it is the extra it seems. not the weird ghost file.
And yes /data/Movies is the only library.

here is the full XML

This XML file does not appear to have any style information associated with it. The document tree is shown below.
<MediaContainer size="1" allowSync="1" identifier="com.plexapp.plugins.library" librarySectionID="2" librarySectionTitle="Films" librarySectionUUID="92fde2e7-608e-4ce2-b0a4-ed501b0d4cdf" mediaTagPrefix="/system/bundle/media/flags/" mediaTagVersion="1673372551">
<Video ratingKey="903176" key="/library/metadata/903176" guid="plex://movie/5d9f38f29dd5f4001e847669" studio="France 2 Cinéma" type="movie" title="Cornouaille" librarySectionTitle="Films" librarySectionID="2" librarySectionKey="/library/sections/2" contentRating="11" summary="Odile est une jeune femme indépendante et rationnelle à l'existence bien réglée. Pourtant, alors qu'elle prend possession de la maison de sa tante dont elle vient d'hériter en Bretagne, la réalité, petit à petit, commence à lui échapper… Est-ce l'endroit qui est hanté ? La mémoire d'Odile qui, en se réveillant, lui joue des tours ? Ou bien Loïc, son prétendu « ami d'enfance retrouvé », qui l'entraîne vers d'étranges chemins ? Dans les brouillards de cette Cornouaille mystérieuse, rien ne se passe comme Odile l'attendait..." rating="5.0" audienceRating="6.0" year="2012" thumb="/library/metadata/903176/thumb/1675061139" art="/library/metadata/903176/art/1675061139" duration="5726347" originallyAvailableAt="2012-08-14" addedAt="1633247923" updatedAt="1675061139" audienceRatingImage="themoviedb://image.rating" primaryExtraKey="/library/metadata/903179">
<Media id="988218" duration="5726347" bitrate="2727" width="1920" height="820" aspectRatio="2.35" audioChannels="6" audioCodec="aac" videoCodec="h264" videoResolution="1080" container="mp4" videoFrameRate="24p" optimizedForStreaming="0" audioProfile="lc" has64bitOffsets="0" videoProfile="high"> </Media>
<Media id="990418" duration="5726347" bitrate="2727" width="1920" height="820" aspectRatio="2.35" audioChannels="6" audioCodec="aac" videoCodec="h264" videoResolution="1080" container="mp4" videoFrameRate="24p" optimizedForStreaming="0" audioProfile="lc" has64bitOffsets="0" videoProfile="high">
<Part accessible="1" exists="1" id="1753217" key="/library/parts/1753217/1671380981/file.mp4" duration="5726347" file="/data/Movies/Cornouaille (2012) {tmdb-123221}/Cornouaille.2012.Bluray-1080p.x264.AAC[FR] {imdb-tt2062507}.mp4" size="1951878066" audioProfile="lc" container="mp4" has64bitOffsets="0" optimizedForStreaming="0" videoProfile="high">
<Stream id="7274349" streamType="1" default="1" codec="h264" index="0" bitrate="2498" bitDepth="8" chromaLocation="left" chromaSubsampling="4:2:0" codedHeight="832" codedWidth="1920" frameRate="24.000" hasScalingMatrix="0" height="820" level="41" profile="high" refFrames="4" scanType="progressive" streamIdentifier="1" width="1920" displayTitle="1080p (H.264)" extendedDisplayTitle="1080p (H.264)"> </Stream>
<Stream id="7274350" streamType="2" selected="1" default="1" codec="aac" index="1" channels="6" bitrate="224" language="Français" languageTag="fr" languageCode="fra" audioChannelLayout="5.1" profile="lc" samplingRate="48000" streamIdentifier="2" displayTitle="Français (AAC 5.1)" extendedDisplayTitle="Français (AAC 5.1)"> </Stream>
<Stream id="7274351" key="/library/streams/7274351" streamType="3" selected="1" codec="srt" language="Anglais" languageTag="en" languageCode="eng" format="srt" displayTitle="Anglais (SRT Externe)" extendedDisplayTitle="Anglais (SRT Externe)"> </Stream>
<Stream id="7274352" key="/library/streams/7274352" streamType="3" codec="srt" language="Russe" languageTag="ru" languageCode="rus" format="srt" displayTitle="Russe (SRT Externe)" extendedDisplayTitle="Russe (SRT Externe)"> </Stream>
</Part>
</Media>
<Genre id="21" filter="genre=21" tag="Drama"/>
<Director id="1120087" filter="director=1120087" tag="Anne Le Ny"/>
<Writer id="1054944" filter="writer=1054944" tag="Luc Béraud"/>
<Writer id="1086175" filter="writer=1086175" tag="Anne Le Ny"/>
<Producer id="1017293" filter="producer=1017293" tag="Bruno Levy"/>
<Country id="2182" filter="country=2182" tag="France"/>
<Guid id="imdb://tt2062507"/>
<Guid id="tmdb://123221"/>
<Guid id="tvdb://61106"/>
<Rating image="imdb://image.rating" value="4.9" type="audience"/>
<Rating image="rottentomatoes://image.rating.spilled" value="2.3" type="audience"/>
<Rating image="themoviedb://image.rating" value="6.0" type="audience"/>
<Role id="1035116" filter="actor=1035116" tag="Vanessa Paradis" tagKey="5d776835961905001eb94173" role="Odile" thumb="https://metadata-static.plex.tv/d/people/d6e0fc59549f907ba1001f82f09fe45f.jpg"/>
<Role id="1048004" filter="actor=1048004" tag="Samuel Le Bihan" tagKey="5d7768243c3c2a001fbca957" role="Loïc" thumb="https://metadata-static.plex.tv/d/people/dfa72f4b5d05f37d2f10f74acf2fefd7.jpg"/>
<Role id="1098686" filter="actor=1098686" tag="Jonathan Zaccaï" tagKey="5d77682f7228e5001f1ddcfa" role="Fabrice" thumb="https://metadata-static.plex.tv/6/people/6ea758399dac3ffde4aca6c8a3e1605e.jpg"/>
<Role id="1046538" filter="actor=1046538" tag="Laurent Stocker" tagKey="5d77682b880197001ec91cf5" role="Maître Mevel" thumb="https://metadata-static.plex.tv/people/5d77682b880197001ec91cf5.jpg"/>
<Role id="1120088" filter="actor=1120088" tag="Martin Jobert" tagKey="5d776848961905001eb97ca0" role="Erwan" thumb="https://metadata-static.plex.tv/people/5d776848961905001eb97ca0.jpg"/>
<Role id="1077353" filter="actor=1077353" tag="Catherine Vinatier" tagKey="5d776834103a2d001f567978" role="Cathy" thumb="https://metadata-static.plex.tv/people/5d776834103a2d001f567978.jpg"/>
<Role id="1069535" filter="actor=1069535" tag="Aurore Clément" tagKey="5d77682654c0f0001f301b9e" role="La mère d'Odile" thumb="https://metadata-static.plex.tv/people/5d77682654c0f0001f301b9e.jpg"/>
<Role id="1111134" filter="actor=1111134" tag="Thibault Vinçon" tagKey="5d77683361141d001fb1513e" role="Thomas" thumb="https://metadata-static.plex.tv/0/people/0f6f619edf52d792536ca5577cff55b9.jpg"/>
<Role id="1073819" filter="actor=1073819" tag="Thomas Blanchard" tagKey="5d7768a2decfcd001f2ee91b" role="Antoine" thumb="https://metadata-static.plex.tv/people/5d7768a2decfcd001f2ee91b.jpg"/>
<Role id="1120089" filter="actor=1120089" tag="Damien Dorsaz" tagKey="5d776a4796b655001fde9328" role="Le père d'Odile" thumb="https://metadata-static.plex.tv/9/people/9bb8191e6ea137e3948f4b86f4837e2c.jpg"/>
<Role id="1120090" filter="actor=1120090" tag="Jaïa Caltagirone" tagKey="5d776abffb0d55001f54fb31" role="Katel" thumb="https://metadata-static.plex.tv/people/5d776abffb0d55001f54fb31.jpg"/>
<Role id="1120091" filter="actor=1120091" tag="Catherine Morlot" tagKey="5d776d73594b2b001e709bcd" role="Bernadette"/>
<Role id="1082088" filter="actor=1082088" tag="Édith Le Merdy" tagKey="5d776836e6d55c002040d558" role="L'agent immobilier" thumb="https://metadata-static.plex.tv/people/5d776836e6d55c002040d558.jpg"/>
<Role id="1120092" filter="actor=1120092" tag="Stefan Drößler" tagKey="5d776b2bad5437001f795e60" role="Le client taxi"/>
<Field locked="1" name="rating"/>
<Field locked="1" name="contentRating"/>
<Field locked="1" name="originallyAvailableAt"/>
<Field locked="1" name="year"/>
<Field locked="1" name="genre"/>
<Preferences>
<Setting id="languageOverride" label="Langue des métadonnées" summary="Langue à utiliser pour les métadonnées de l'élément telles que le synopsis et le titre" type="text" default="" value="" hidden="0" advanced="0" group="" enumValues=":Bibliothèque par défaut|de-DE:Allemand|en-US:Anglais|en-AU:Anglais (Australie)|en-CA:Anglais (Canada)|en-GB:Anglais (R.-U.)|ar-SA:Arabe (Arabie saoudite)|bg-BG:Bulgare|ca-ES:Catalan|zh-CN:Chinois|zh-HK:Chinois (Hong Kong)|zh-TW:Chinois (Taïwan)|ko-KR:Coréen|hr-HR:Croate|da-DK:Danois|es-ES:Espagnol|es-MX:Espagnol (Mexique)|et-EE:Estonien|fi-FI:Finnois|fr-FR:Français|fr-CA:Français (Canada)|el-GR:Grec|he-IL:Hébreu|hi-IN:Hindi|hu-HU:Hongrois|id-ID:Indonésien|it-IT:Italien|ja-JP:Japonais|lv-LV:Letton|lt-LT:Lituanien|nl-NL:Néerlandais|nb-NO:Norvégien bokmål|fa-IR:Persan|pl-PL:Polonais|pt-BR:Portugais|pt-PT:Portugais (Portugal)|ro-RO:Roumain|ru-RU:Russe|sk-SK:Slovaque|sv-SE:Suédois|cs-CZ:Tchèque|th-TH:Thaï|tr-TR:Turc|uk-UA:Ukrainien|vi-VN:Vietnamien"/>
<Setting id="useOriginalTitle" label="Utiliser le titre original" summary="Utiliser le titre original pour cet élément sans tenir compte de la langue de la bibliothèque." type="int" default="-1" value="-1" hidden="0" advanced="0" group="" enumValues="-1:Bibliothèque par défaut|0:Non|1:Oui"/>
</Preferences>
<Extras size="1">
<Video ratingKey="903179" key="/library/metadata/903179" guid="iva://api.internetvideoarchive.com/2.0/DataService/VideoAssets(547099)" type="clip" title="Cornouaille" summary="" index="1" thumb="/library/metadata/903179/thumb/1633247928" primaryGuid="plex://movie/5d9f38f29dd5f4001e847669" subtype="trailer" duration="76000" addedAt="1633247928" extraType="1">
<Media id="694671" duration="76000" bitrate="5000" width="1920" height="818" aspectRatio="2.35" audioCodec="aac" videoCodec="h264" videoResolution="1080" container="mp4" optimizedForStreaming="1" protocol="mp4" premium="1">
<Part id="1443379" duration="76000" container="mp4" key="/services/iva/assets/547099/video.mp4?fmt=4&bitrate=5000">
<Stream id="5610697" streamType="1" codec="h264" index="0" bitrate="5000" height="818" width="1920" displayTitle="1080p (H.264)" extendedDisplayTitle="1080p (H.264)"> </Stream>
<Stream id="5610698" streamType="2" selected="1" codec="aac" index="1" channels="2" displayTitle="Inconnu (AAC Stereo)" extendedDisplayTitle="Inconnu (AAC Stereo)"> </Stream>
</Part>
</Media>
<Media id="694672" duration="76000" bitrate="2500" width="1280" height="545" aspectRatio="2.35" audioCodec="aac" videoCodec="h264" videoResolution="720" container="mp4" optimizedForStreaming="1" protocol="mp4" premium="1">
<Part id="1443380" duration="76000" container="mp4" key="/services/iva/assets/547099/video.mp4?fmt=4&bitrate=2500">
<Stream id="5610699" streamType="1" codec="h264" index="0" bitrate="2500" height="545" width="1280" displayTitle="720p (H.264)" extendedDisplayTitle="720p (H.264)"> </Stream>
<Stream id="5610700" streamType="2" selected="1" codec="aac" index="1" channels="2" displayTitle="Inconnu (AAC Stereo)" extendedDisplayTitle="Inconnu (AAC Stereo)"> </Stream>
</Part>
</Media>
<Media id="694673" duration="76000" bitrate="750" width="480" height="204" aspectRatio="2.35" audioCodec="aac" videoCodec="h264" videoResolution="sd" container="mp4" optimizedForStreaming="1" protocol="mp4" premium="1">
<Part id="1443381" duration="76000" container="mp4" key="/services/iva/assets/547099/video.mp4?fmt=4&bitrate=750">
<Stream id="5610701" streamType="1" codec="h264" index="0" bitrate="750" height="204" width="480" displayTitle="SD (H.264)" extendedDisplayTitle="SD (H.264)"> </Stream>
<Stream id="5610702" streamType="2" selected="1" codec="aac" index="1" channels="2" displayTitle="Inconnu (AAC Stereo)" extendedDisplayTitle="Inconnu (AAC Stereo)"> </Stream>
</Part>
</Media>
</Video>
</Extras>
<Related>
<Hub hubKey="/library/metadata/1057502" key="/library/metadata/903176/similar" title="Films associés" type="movie" hubIdentifier="movie.similar" context="hub.movie.similar" size="1" more="1" style="shelf">
<Video ratingKey="1057502" key="/library/metadata/1057502" guid="plex://movie/5f409a051ae7100041167234" studio="Carnival Films" type="movie" title="Downton Abbey II : Une nouvelle ère" titleSort="Downton Abbey II : Une nouvelle ere" librarySectionTitle="Films" librarySectionID="2" librarySectionKey="/library/sections/2" originalTitle="Downton Abbey: A New Era" contentRating="13" summary="1928. Les Crawley et leurs domestiques assistent tous au mariage de Tom Branson et de Lucy Smith, fille de Lady Bagshaw. Lord Grantham explique à ses proches que le notaire de famille se rendra prochainement à Downton, à la demande de la Douairière, et qu’il compte sur leur présence à tous. En effet, Violet a hérité d’une villa dans le sud de la France qu’elle souhaite à son tour léguer à la fille de Lady Sybil et de Branson. Mais cette décision met celui-ci mal à l’aise. Sans comprendre pourquoi le regretté marquis de Montmirail s’est montré aussi généreux avec sa mère, Lord Grantham reçoit un appel téléphonique intriguant : un certain M. Barber, réalisateur pour le cinéma, souhaite tourner son nouveau film muet, The Gambler, à Downton Abbey. Si Robert estime que l’idée est grotesque, Lady Mary, de son côté, considère qu’il est difficile de refuser l’offre de la production face aux travaux de rénovation qui attend la famille." rating="7.4" audienceRating="7.2" userRating="8.0" lastRatedAt="1670144868" year="2022" tagline="Découvrez le mystère. Imaginez les possibilités. Vivez une nouvelle ère." thumb="/library/metadata/1057502/thumb/1658604168" art="/library/metadata/1057502/art/1658604168" duration="7496512" originallyAvailableAt="2022-04-27" addedAt="1657357105" updatedAt="1658604168" audienceRatingImage="themoviedb://image.rating" chapterSource="media" primaryExtraKey="/library/metadata/1057503">
<Media id="925512" duration="7496512" bitrate="4954" width="1920" height="1080" aspectRatio="1.78" audioChannels="6" audioCodec="ac3" videoCodec="h264" videoResolution="1080" container="mkv" videoFrameRate="24p" videoProfile="high">
<Part id="1687993" key="/library/parts/1687993/1657356480/file.mkv" duration="7496512" file="/data/Movies/Downton Abbey A New Era (2022) {tmdb-820446}/Downton.Abbey-.A.New.Era.2022.Bluray-1080p.x264.AC3[FR].[FR]-ROMKENT {imdb-tt11703710}.mkv" size="4642638367" container="mkv" videoProfile="high">
<Stream id="6870151" streamType="1" default="1" codec="h264" index="0" bitrate="4506" bitDepth="8" chromaLocation="left" chromaSubsampling="4:2:0" codedHeight="1088" codedWidth="1920" colorPrimaries="bt709" colorRange="tv" colorSpace="bt709" colorTrc="bt709" frameRate="23.976" hasScalingMatrix="0" height="1080" level="50" profile="high" refFrames="4" scanType="progressive" width="1920" displayTitle="1080p (H.264)" extendedDisplayTitle="1080p (H.264)"> </Stream>
<Stream id="6870152" streamType="2" selected="1" default="1" codec="ac3" index="1" channels="6" bitrate="448" language="Français" languageTag="fr" languageCode="fra" audioChannelLayout="5.1(side)" samplingRate="48000" title="VFF AC3 5.1" displayTitle="Français (AC3 5.1)" extendedDisplayTitle="VFF AC3 5.1 (Français)"> </Stream>
<Stream id="6870153" streamType="3" selected="1" default="1" forced="1" codec="pgs" index="2" bitrate="0" language="Français" languageTag="fr" languageCode="fra" headerCompression="1" title="sup fr forced" displayTitle="Français Forcé(e) (PGS)" extendedDisplayTitle="sup fr forced (PGS)"> </Stream>
<Stream id="6870154" streamType="3" codec="pgs" index="3" bitrate="46" language="Français" languageTag="fr" languageCode="fra" headerCompression="1" title="sup fr complets" displayTitle="Français (PGS)" extendedDisplayTitle="sup fr complets (PGS)"> </Stream>
</Part>
</Media>
<Genre id="255" filter="genre=255" tag="Romance"/>
<Genre id="21" filter="genre=21" tag="Drama"/>
<Director id="1124447" filter="director=1124447" tag="Simon Curtis"/>
<Writer id="1132190" filter="writer=1132190" tag="Julian Fellowes"/>
<Producer id="1132215" filter="producer=1132215" tag="Julian Fellowes"/>
<Producer id="1132216" filter="producer=1132216" tag="Gareth Neame"/>
<Producer id="1132217" filter="producer=1132217" tag="Liz Trubridge"/>
<Country id="3445" filter="country=3445" tag="United Kingdom"/>
<Guid id="imdb://tt11703710"/>
<Guid id="tmdb://820446"/>
<Guid id="tvdb://159406"/>
<Rating image="imdb://image.rating" value="7.5" type="audience"/>
<Rating image="rottentomatoes://image.rating.upright" value="9.7" type="audience"/>
<Rating image="rottentomatoes://image.rating.ripe" value="8.6" type="critic"/>
<Rating image="themoviedb://image.rating" value="7.2" type="audience"/>
<Collection id="1426684" filter="collection=1426684" tag="Downton Abbey - Saga" guid="plex://collection/61dc3e4639cfa3f0ffb08425" summary="Les héritiers de Downton Abbey ayant péri lors du naufrage du Titanic, la famille Crawley se retrouve dans une situation délicate : le domaine est soumis à l’entail, c'est-à-dire qu'il doit intégralement passer à un héritier mâle, le titre de Lord Grantham, le domaine et la fortune de la famille étant indissociables. Les trois filles ne peuvent prétendre ni au titre ni à l'héritage. Matthew Crawley, un lointain cousin, est le nouvel héritier. Il arrive à Downton Abbey où il découvre un style de vie nouveau pour lui, avec des règles très strictes qui régissent la vie entre aristocrates et serviteurs."/>
<Collection id="1507786" filter="collection=1507786" tag="Sélection de Common Sense"/>
<Role id="1069080" filter="actor=1069080" tag="Hugh Bonneville" tagKey="5d7768263c3c2a001fbcaff7" role="Robert Crawley" thumb="https://metadata-static.plex.tv/people/5d7768263c3c2a001fbcaff7.jpg"/>
<Role id="1025878" filter="actor=1025878" tag="Maggie Smith" tagKey="5d7768278718ba001e311e44" role="Violet Crawley" thumb="https://metadata-static.plex.tv/f/people/f29c1c0c646413633f270e797138b3d1.jpg"/>
<Role id="1065331" filter="actor=1065331" tag="Jim Carter" tagKey="5d77682a5af944001f1f7921" role="Charles Carson" thumb="https://metadata-static.plex.tv/1/people/10fd0b8a546c535a4864a62b0f67d66b.jpg"/>
<Role id="1086989" filter="actor=1086989" tag="Michelle Dockery" tagKey="5d7768382ec6b5001f6bc83c" role="Lady Mary Josephine Talbot" thumb="https://metadata-static.plex.tv/b/people/b23bee76646fda2da70bbab62b851566.jpg"/>
<Role id="1065302" filter="actor=1065302" tag="Elizabeth McGovern" tagKey="5d77682585719b001f3a088d" role="Cora Crawley" thumb="https://metadata-static.plex.tv/people/5d77682585719b001f3a088d.jpg"/>
<Role id="1062539" filter="actor=1062539" tag="Imelda Staunton" tagKey="5d77682854c0f0001f301f07" role="Maud Bagshaw" thumb="https://metadata-static.plex.tv/e/people/e913abf23336015a121f2dbcd16479fc.jpg"/>
<Role id="1052809" filter="actor=1052809" tag="Penelope Wilton" tagKey="5d776825eb5d26001f1dd0d7" role="Isobel Merton" thumb="https://metadata-static.plex.tv/people/5d776825eb5d26001f1dd0d7.jpg"/>
<Role id="1050562" filter="actor=1050562" tag="Robert James-Collier" tagKey="5d7769ab51dd69001fe1a0b9" role="Thomas Barrow" thumb="https://metadata-static.plex.tv/9/people/9f1eaede7b597c3c8fa59733ca922724.jpg"/>
<Role id="1051241" filter="actor=1051241" tag="Lesley Nicol" tagKey="5d7768368718ba001e314f52" role="Beryl Patmore" thumb="https://image.tmdb.org/t/p/original/yYSsFAMn7rETaZ55Xsewx1CzHrW.jpg"/>
<Role id="1103876" filter="actor=1103876" tag="Allen Leech" tagKey="5d776845eb5d26001f1e4456" role="Tom Branson" thumb="https://metadata-static.plex.tv/d/people/d69cff2af4dabc0162fb5439bf0eef7b.jpg"/>
<Role id="1132191" filter="actor=1132191" tag="Laura Carmichael" tagKey="5d776889ebdf2200209c1c59" role="Lady Edith Pelham" thumb="https://metadata-static.plex.tv/people/5d776889ebdf2200209c1c59.jpg"/>
<Role id="1037609" filter="actor=1037609" tag="Phyllis Logan" tagKey="5d776836eb5d26001f1e0f56" role="Mrs Hughes" thumb="https://metadata-static.plex.tv/people/5d776836eb5d26001f1e0f56.jpg"/>
<Role id="1076094" filter="actor=1076094" tag="Dominic West" tagKey="5d7768293c3c2a001fbcb98a" role="Guy Dexter" thumb="https://metadata-static.plex.tv/9/people/94a349f73c2ab3a0a8b383639e59cd6b.jpg"/>
<Role id="1132193" filter="actor=1132193" tag="Harry Hadden-Paton" tagKey="5d776846e6d55c002040fbf9" role="Bertie Hexham" thumb="https://metadata-static.plex.tv/people/5d776846e6d55c002040fbf9.jpg"/>
<Role id="1027441" filter="actor=1027441" tag="Hugh Dancy" tagKey="5d776828961905001eb91670" role="Jack Barber" thumb="https://metadata-static.plex.tv/0/people/00b36b21ddb168a1cd453b28c5048474.jpg"/>
<Role id="1092371" filter="actor=1092371" tag="Brendan Coyle" tagKey="5d776827103a2d001f56458a" role="John Bates" thumb="https://metadata-static.plex.tv/people/5d776827103a2d001f56458a.jpg"/>
<Role id="1132192" filter="actor=1132192" tag="Joanne Froggatt" tagKey="5d77687e594b2b001e68dda4" role="Anna Bates" thumb="https://metadata-static.plex.tv/e/people/e65a1249e90614094a946dfe8d0dc284.jpg"/>
<Role id="1127071" filter="actor=1127071" tag="Raquel Cassidy" tagKey="5d77686d5af944001f202e39" role="Phyllis Baxter" thumb="https://metadata-static.plex.tv/e/people/ef0b48e200a44308be0cd9032d5964f2.jpg"/>
<Role id="1050575" filter="actor=1050575" tag="Kevin Doyle" tagKey="5d7768392ec6b5001f6bc912" role="Joseph Molesley" thumb="https://metadata-static.plex.tv/people/5d7768392ec6b5001f6bc912.jpg"/>
<Role id="1124081" filter="actor=1124081" tag="Michael Fox" tagKey="5d776abcad5437001f787449" role="Andy Parker" thumb="https://metadata-static.plex.tv/people/5d776abcad5437001f787449.jpg"/>
<Role id="1109392" filter="actor=1109392" tag="Laura Haddock" tagKey="5d77682a103a2d001f565459" role="Myrna Dagleish" thumb="https://metadata-static.plex.tv/6/people/64ba4eaaa31ad3f2481289803570ed4a.jpg"/>
<Role id="1041106" filter="actor=1041106" tag="Nathalie Baye" tagKey="5d7768273c3c2a001fbcb1e7" role="Mme de Montmirail" thumb="https://image.tmdb.org/t/p/original/9WZnFcyqdixlOfqHKBXq0l0Rc4L.jpg"/>
<Role id="1132198" filter="actor=1132198" tag="Fifi Hart" tagKey="5d777068dd931c001e38c859" role="Sybbie Branson" thumb="https://metadata-static.plex.tv/b/people/bb805014d14aa3f0627cbcff1d83277e.jpg"/>
<Role id="1272363" filter="actor=1272363" tag="Jonathan Coy" tagKey="5d7768348718ba001e31428d" role="Murray" thumb="https://metadata-static.plex.tv/b/people/b2176aac7343a89f88d1e0d7e59cc895.jpg"/>
<Role id="1117282" filter="actor=1117282" tag="Samantha Bond" tagKey="5d776827103a2d001f564579" role="Lady Rosamund Painswick" thumb="https://metadata-static.plex.tv/8/people/80e8d1da47682719eaabd9efc31c52ac.jpg"/>
<Role id="1115906" filter="actor=1115906" tag="Tuppence Middleton" tagKey="5d77684ee870fd001f19dc65" role="Lucy Branson" thumb="https://metadata-static.plex.tv/e/people/e2916397ce2564874c2bbc2d0edd0657.jpg"/>
<Role id="1023146" filter="actor=1023146" tag="Douglas Reith" tagKey="5d7768298718ba001e312484" role="Lord Merton" thumb="https://metadata-static.plex.tv/people/5d7768298718ba001e312484.jpg"/>
<Role id="1132199" filter="actor=1132199" tag="Oliver Barker" tagKey="5d776aea96b655001fdfd7b5" role="George"/>
<Role id="1132200" filter="actor=1132200" tag="Zac Barker" tagKey="5d776aea96b655001fdfd7b4" role="George"/>
<Role id="1111462" filter="actor=1111462" tag="Sophie McShera" tagKey="5d7769c1ad5437001f767199" role="Daisy Parker" thumb="https://metadata-static.plex.tv/d/people/d9c440eb5e8ca65923ac98274d97f0db.jpg"/>
<Role id="1046191" filter="actor=1046191" tag="Sue Johnston" tagKey="5d77682aeb5d26001f1de2f2" role="Gladys Denker" thumb="https://metadata-static.plex.tv/people/5d77682aeb5d26001f1de2f2.jpg"/>
<Role id="1098686" filter="actor=1098686" tag="Jonathan Zaccaï" tagKey="5d77682f7228e5001f1ddcfa" role="Montmirail" thumb="https://metadata-static.plex.tv/6/people/6ea758399dac3ffde4aca6c8a3e1605e.jpg"/>
<Role id="1132195" filter="actor=1132195" tag="Charlie Watson" tagKey="600eec28af294a002b9f10b8" role="Albert" thumb="https://image.tmdb.org/t/p/original/5e8Za3eiZhxmLhcUJUtTgfF342B.jpg"/>
<Role id="1426678" filter="actor=1426678" tag="Archer Robbins" tagKey="62681cd5a81b62ef164c538c" role="Johnnie"/>
<Role id="1132201" filter="actor=1132201" tag="Eva Samms" tagKey="600eec28af294a002b9f10b9" role="Marigold"/>
<Role id="1132202" filter="actor=1132202" tag="Karina Samms" tagKey="600eec28af294a002b9f10ba" role="Marigold"/>
<Role id="1120957" filter="actor=1120957" tag="Paul Copley" tagKey="5d776829999c64001ec2cf65" role="Mason" thumb="https://metadata-static.plex.tv/people/5d776829999c64001ec2cf65.jpg"/>
<Role id="1026219" filter="actor=1026219" tag="Alex MacQueen" tagKey="5d77683d8a7581001f12e707" role="Mr Stubbins" thumb="https://metadata-static.plex.tv/people/5d77683d8a7581001f12e707.jpg"/>
<Role id="1134810" filter="actor=1134810" tag="David Robb" tagKey="5d77682e85719b001f3a2402" role="Dr Clarkson" thumb="https://metadata-static.plex.tv/people/5d77682e85719b001f3a2402.jpg"/>
<Role id="1426679" filter="actor=1426679" tag="Megan Barker" tagKey="62640a618d64525af94b8095" role="Caroline Talbot (uncredited)"/>
<Label id="1507705" filter="label=1507705" tag="Films de Prime Video"/>
<Label id="1507890" filter="label=1507890" tag="Alcohol:Mild"/>
<Label id="1507699" filter="label=1507699" tag="Films de NOW"/>
<Chapter id="462" filter="thumb=462" index="1" startTimeOffset="0" endTimeOffset="546296"/>
<Chapter id="462" filter="thumb=462" index="2" startTimeOffset="546296" endTimeOffset="1163200"/>
<Chapter id="462" filter="thumb=462" index="3" startTimeOffset="1163200" endTimeOffset="1753090"/>
<Chapter id="462" filter="thumb=462" index="4" startTimeOffset="1753090" endTimeOffset="2337540"/>
<Chapter id="462" filter="thumb=462" index="5" startTimeOffset="2337540" endTimeOffset="2610360"/>
<Chapter id="462" filter="thumb=462" index="6" startTimeOffset="2610360" endTimeOffset="2987360"/>
<Chapter id="462" filter="thumb=462" index="7" startTimeOffset="2987360" endTimeOffset="3401440"/>
<Chapter id="462" filter="thumb=462" index="8" startTimeOffset="3401440" endTimeOffset="3764760"/>
<Chapter id="462" filter="thumb=462" index="9" startTimeOffset="3764760" endTimeOffset="4090380"/>
<Chapter id="462" filter="thumb=462" index="10" startTimeOffset="4090380" endTimeOffset="4560560"/>
<Chapter id="462" filter="thumb=462" index="11" startTimeOffset="4560560" endTimeOffset="4881790"/>
<Chapter id="462" filter="thumb=462" index="12" startTimeOffset="4881790" endTimeOffset="5303550"/>
<Chapter id="462" filter="thumb=462" index="13" startTimeOffset="5303550" endTimeOffset="5582790"/>
<Chapter id="462" filter="thumb=462" index="14" startTimeOffset="5582790" endTimeOffset="5869660"/>
<Chapter id="462" filter="thumb=462" index="15" startTimeOffset="5869660" endTimeOffset="6236020"/>
<Chapter id="462" filter="thumb=462" index="16" startTimeOffset="6236020" endTimeOffset="6569190"/>
<Chapter id="462" filter="thumb=462" index="17" startTimeOffset="6569190" endTimeOffset="6739860"/>
<Chapter id="462" filter="thumb=462" index="18" startTimeOffset="6739860" endTimeOffset="7168500"/>
<Chapter id="462" filter="thumb=462" index="19" startTimeOffset="7168500" endTimeOffset="7238980"/>
<Chapter id="462" filter="thumb=462" index="20" startTimeOffset="7238980" endTimeOffset="7496510"/>
<Review id="65885" filter="art=65885" tag="Donald Clarke" text="Everyone, upstairs and downstairs, is merrily bourgeois together content to hug and kiss as if parlourmaids cleaned the dishes as a favour without any money changing hands." image="rottentomatoes://image.review.fresh" link="https://www.irishtimes.com/culture/film/downton-abbey-a-new-era-review-both-aristocrats-and-servants-sound-too-middle-class-1.4862362" source="Irish Times"/>
<Review id="79099" filter="art=79099" tag="Linda Marric" text="Often the film feels like a parody of itself...but it works" image="rottentomatoes://image.review.fresh" link="https://www.thejc.com/life-and-culture/all/downton-abbey-a-new-era-film-review-often-the-film-feels-like-a-parody-of-itself-but-it-works-3VC1PcHUhcLYeh5hvjbJT6" source="The Jewish Chronicle"/>
<Review id="3385" filter="art=3385" tag="Peter Bradshaw" text="There is something diverting about the deadly serious melodrama and bizarre glassy-eyed pathos that Downton 2 is serving up." image="rottentomatoes://image.review.fresh" link="https://www.theguardian.com/film/2022/apr/26/downton-abbey-a-new-era-review-cheerfully-risible-second-helping-of-snobby-melodrama" source="Guardian"/>
<Review id="79098" filter="art=79098" tag="Robbie Collin" text="Gosford Park it isn’t – but nor is it just TV writ large. Unlike the previous Downton film, this one feels cinematically worthwhile." image="rottentomatoes://image.review.fresh" link="https://www.telegraph.co.uk/films/2022/04/26/downton-abbey-new-era-review-plenty-surprises-iconic-moment/" source="Daily Telegraph (UK)"/>
<Review id="7717" filter="art=7717" tag="Helen O'Hara" text="Its an unlikely but pleasant fantasy where good things just happen, the rich are benevolent and the poor all muddle along nicely." image="rottentomatoes://image.review.rotten" link="https://www.timeout.com/movies/downton-abbey-a-new-era-2022" source="Time Out"/>
<Review id="4357" filter="art=4357" tag="Leah Greenblatt" text="A New Era is strictly high-toned formula, from its God's-eye opening over spire-tipped turrets and green-velvet lawns to its soft-focus finish, but it feels like home." image="rottentomatoes://image.review.fresh" link="https://ew.com/movies/movie-reviews/downton-abbey-a-new-era-big-screen-review/" source="Entertainment Weekly"/>
<Review id="3753" filter="art=3753" tag="Charlotte O'Sullivan" text="When Fellowes slips in a reference to David Copperfield, it’s hard not to cringe. Dickens, Shakespeare, Wilde and Christie. Fellowes loves these writers, but -- unlike them -- his success doesn’t seem built to last." image="rottentomatoes://image.review.rotten" link="https://www.standard.co.uk/culture/film/downton-abbey-a-new-era-film-review-b996256.html" source="London Evening Standard"/>
<Review id="5318" filter="art=5318" tag="Kate Erbland" text="Is there still life in these bones, basically? The answer is yes, with caveats, many of them on display in Simon Curtis’ fluffy, frothy, occasionally quite moving, and often scattered-feeling followup, Downton Abbey: A New Era." image="rottentomatoes://image.review.fresh" link="https://www.indiewire.com/2022/04/downton-abbey-a-new-era-review-1234719190/" source="indieWire"/>
<Review id="8461" filter="art=8461" tag="Clarisse Loughrey" text="The humour never evolves far beyond chortling about the French or treating the working class as a quaint sideshow attraction." image="rottentomatoes://image.review.rotten" link="https://www.independent.co.uk/arts-entertainment/films/reviews/downton-abbey-2-review-sequel-b2065524.html" source="Independent (UK)"/>
<Review id="1426680" filter="art=1426680" tag="Saskia Lloyd Gaiger" text="Claustrophobic Marks-and-Spencer’s mildness quickly decomposes in memory." image="rottentomatoes://image.review.rotten" link="https://lwlies.com/reviews/downton-abbey-a-new-era/" source="Little White Lies"/>
<Review id="84782" filter="art=84782" tag="James Dyer" text="Soapy it may be, but for those who’ve poshed it up with the Crawleys since the very start, this is an affectionate, escapist hug of a movie — like being wrapped in a doily." image="rottentomatoes://image.review.fresh" link="https://www.empireonline.com/movies/reviews/downton-abbey-a-new-era/" source="Empire Magazine"/>
<Review id="2844" filter="art=2844" tag="Sandra Hall" text="This is filmmaking by numbers, but you can’t really complain. It’s arranged around the need to give all the main cast members their moment in the sun, whether it’s shining on the Mediterranean or the lush lawns and fields of Downton. " image="rottentomatoes://image.review.fresh" link="https://www.smh.com.au/culture/movies/downton-2-is-the-perfect-escapist-s-paradise-20220427-p5agir.html" source="Sydney Morning Herald"/>
<Review id="11585" filter="art=11585" tag="Wendy Ide" text="The title of the second Downton Abbey movie promises a new era, but in fact this is a reheated serving of reassuringly familiar comfort food for fans of the series." image="rottentomatoes://image.review.rotten" link="https://www.theguardian.com/film/2022/apr/30/downton-abbey-a-new-era-review-an-artless-cash-in-with-the-crawleys" source="Observer (UK)"/>
<Review id="118372" filter="art=118372" tag="Danny Leigh" text="The escapism is by now machine-tooled, actual drama smoothed into a sedative comic blur. Even at a funeral the emotional stakes are so low you barely notice them." image="rottentomatoes://image.review.rotten" link="https://www.ft.com/content/76c4aed5-f2fa-4d68-8e47-77bff2953748" source="Financial Times"/>
<Field locked="1" name="rating"/>
<Field locked="1" name="contentRating"/>
<Field locked="1" name="genre"/>
<Field locked="1" name="collection"/>
<Field locked="1" name="label"/>
<Field locked="1" name="audienceRating"/>
<Field locked="1" name="userRating"/>
</Video>
</Hub>
<Hub hubKey="/library/metadata/994280" key="/library/sections/2/all?actor=1035116&id!=903176" title="Plus avec Vanessa Paradis" type="movie" hubIdentifier="movie.same.actor.0" context="hub.movie.same.actor" size="1" more="1" style="shelf">
<Video ratingKey="994280" key="/library/metadata/994280" guid="plex://movie/5d776cfc7a53e9001e74ded6" studio="TF1 Films Production" type="movie" title="1 chance sur 2" originalTitle="Une chance sur deux" contentRating="fr/TP" summary="Alice sort de prison après avoir purgé une peine de huit mois ferme pour vol de voiture. Sa mère qui vient de mourir lui a laissé une cassette ou elle lui avoue le mystère de sa naissance. Alice n'a jamais connu son père. Il y a vingt ans, sa mère a aimé deux hommes. L'un des deux l'a conçue sans le savoir puisqu'elle ne leur a rien dit. Alice va découvrir deux gros gabarits. Avant de savoir lequel des deux est son papa, elle va les entraîner dans une sacrée aventure." rating="5.8" audienceRating="5.9" year="1998" tagline="C'est l'un des deux" thumb="/library/metadata/994280/thumb/1673902996" art="/library/metadata/994280/art/1673902996" duration="6544021" originallyAvailableAt="1998-03-25" addedAt="1633524061" updatedAt="1673902996" audienceRatingImage="themoviedb://image.rating" chapterSource="media">
<Media id="802961" duration="6544021" bitrate="12833" width="1920" height="816" aspectRatio="2.35" audioChannels="6" audioCodec="dca-ma" videoCodec="h264" videoResolution="1080" container="mkv" videoFrameRate="24p" audioProfile="ma" videoProfile="high">
<Part id="1564425" key="/library/parts/1564425/1606905062/file.mkv" duration="6544021" file="/data/Movies/Half a Chance (1998) {tmdb-49938}/Half.a.Chance.1998.Bluray-1080p.x264.DTS-HD.MA[FR].[EN+FR+DE]-JdVeP {imdb-tt0119247}.mkv" size="10497803692" audioProfile="ma" container="mkv" videoProfile="high"/>
</Media>
<Genre tag="Action"/>
<Genre tag="Adventure"/>
<Director tag="Patrice Leconte"/>
<Writer tag="Patrice Leconte"/>
<Writer tag="Patrick Dewolf"/>
<Country tag="France"/>
<Role tag="Jean-Paul Belmondo"/>
<Role tag="Alain Delon"/>
<Role tag="Vanessa Paradis"/>
</Video>
</Hub>
<Hub hubKey="/library/metadata/876793" key="/library/sections/2/all?actor=1048004&id!=903176" title="Plus avec Samuel Le Bihan" type="movie" hubIdentifier="movie.same.actor.1" context="hub.movie.same.actor" size="1" more="1" style="shelf">
<Video ratingKey="876793" key="/library/metadata/876793" guid="plex://movie/5d776841e6d55c002040efc5" studio="Bac Films" type="movie" title="3 zéros" titleSort="3 zeros" summary="A Fleury-Mérogis, un match de foot a lieu dans la cour de prison. Tibor Kovacs, un jeune Hongrois, fait des prodiges avec le ballon. Véritable virtuose du football, il rêve de jouer en équipe de France. Pour Manu, son compagnon de cellule, Tibor est un cadeau du ciel. A la veille de leur sortie de prison, les deux compères décident d'unir leurs destins : Tibor deviendra le plus grand joueur du monde, et Manu son agent. Ce dernier se rend alors à Copacabana pour convaincre "Monsieur" Alain Colonna, une ancienne légende du football international en retraite anticipée au Brésil, de reprendre du service." rating="4.3" audienceRating="4.7" year="2002" tagline="Tous Les Coups Sont Permis!" thumb="/library/metadata/876793/thumb/1645385740" art="/library/metadata/876793/art/1645385740" duration="5612040" originallyAvailableAt="2002-04-24" addedAt="1633149732" updatedAt="1645385740" audienceRatingImage="themoviedb://image.rating">
<Media id="644127" duration="5612040" bitrate="1390" width="1280" height="720" aspectRatio="1.78" audioChannels="2" audioCodec="mp3" videoCodec="h264" videoResolution="720" container="avi" videoFrameRate="PAL" videoProfile="high">
<Part id="1392523" key="/library/parts/1392523/1589957406/file.avi" duration="5612040" file="/data/Movies/Shooting Stars (2002) {tmdb-18419}/3.zéros.2002.DVD.h264.MP3-Radarr.avi" size="974865548" container="avi" videoProfile="high"/>
</Media>
<Genre tag="Comedy"/>
<Director tag="Fabien Onteniente"/>
<Writer tag="Emanuel Booz"/>
<Country tag="France"/>
<Role tag="Samuel Le Bihan"/>
<Role tag="Gérard Lanvin"/>
<Role tag="Lorànt Deutsch"/>
</Video>
</Hub>
</Related>
</Video>
</MediaContainer>

Oh it seems i was looking into the metadata_items for the ID we see from “Media id=xx” when i need to look for this id in media_items
So i see the 2 id in the database, linked to the same movie, but for weird reason i can’t delete the ‘ghost one’ from plex.

in the database, both media_id points to the same file it seems as the resolution, codec, and time are the same.


i have currently 88 movies that are duplicates, and most of them with this issue. This is preventing me from cleaning up trash in this library, and perhaps, this is what is preventing the blob database to be backuped for like a year ?

The IVA URL is for extras. not the main movie

this first <media> has no file associated with it.

<Media id="988218" duration="5726347" bitrate="2727" width="1920" height="820" aspectRatio="2.35" audioChannels="6" audioCodec="aac" videoCodec="h264" videoResolution="1080" container="mp4" videoFrameRate="24p" optimizedForStreaming="0" audioProfile="lc" has64bitOffsets="0" videoProfile="high"> </Media>

Possibly. I can’t think of how it got like that though. Would need to delete the rows that have no file associated directly in DB. Are you comfortable with SQLite to do that yourself?

Hi,

yeah i got no clue how this happened.

Just confirm me, i need to remove the entry that has media id without associated file from the “media_item” table only ?
no other table use this as foreign key somewhere ?

Regards

hum i can’t seem to find the right query to execute this safely
are you able to help me get the right one ?
Also i see that i can’t empty trash in my “TV Show” library too, but it doesn’t look like i have the same kind of issue.
For the movie library plex refuse to let me see it in folder view

i have done a database corruption repair procedure, following the KB given by plex on both db files, the blob one is now very small, hopefully it will backup next time.
But it hasn’t fixed anything else :confused:
Can’t go further than that now.
thanks

Would you mind messaging me copy of your DB file ( you can get it from the troubeshooting section of settings)

hum i could but it’s 1.5Gb

sending you a link to download from my private nextcloud, it’s 420Mb zipped in tar.gz