unresolved "missing at mdblist" titles in Analyzer

[nonstatic]

Hi, I just did a one-way sync from tmdb to mdblist. there were 9 titles which are unresolved, the analyzer says mdblist ID missing (EDIT: I meant "missing at mdblist") but 8/9 of them do exist in mdblist.

I'm not sure what ID format to type, and how to resolve those titles once I save the correct ID?

[cenodude]

Hi,

Let me first check it out, cause changing ID formats should almost never be needed, especially not from TMDB to MDBList.

Can you give me some titles that are unresolved. And what feature do you use, watchlist or ratings?

[nonstatic]

Thanks for the reply. I'm only syncing watchlist one-way at the moment on a new install to try things out. Here are 3 of the unresolved titles:

https://mdblist.com/movie/3duz4-baby-invasion
https://mdblist.com/movie/2wn92-the-promised-land
https://mdblist.com/movie/2yy69-hippo

I did manage to find the 9th title in mdblist, so they all do exist there: https://mdblist.com/movie/28e28-canary-4

Not sure if this is helpful, but all 9 titles were already in my mdblist watchlist (I was syncing a very large 5000+ title watchlist which had about 500 extra titles in tmdb vs mdblist).

EDIT: I just merged another trakt csv list into my tmdb watchlist and performed another one-way sync to mdblist watchlist. result: 5 of the previous titles are now blackboxed and there are 12 titles which the Analyzer says are "missing at mdblist" but they do also exist at mdblist like the previous titles.

It seems some of the previous 9 unresolved titles fixed themselves when syncing again, but I just tried doing that again and it didn't change anything with the current 12 unresolved titles.

[cenodude]

Oke i did test it with v0.9.16 and the just released v0.9.17 but i dont have any issues syncing these titles.

And yes, titles get blackboxed when the sync orchestrator is unable to match items. This can be configured in your pair config under blackbox. However i would keep it at default.

So this is my advice:

• First update your image to the new v0.9.17 release, its just released.
• Enable debug in Settings - Settings Overview - Maintenance

• Then open Settings - Maintenance and Clean Everything

After that try to sync again.. If you still have issues, copy/paste the Sync output in View Detals.

[nonstatic]

Thanks, I've followed the instructions and still get 12 unresolved. Here is the Sync output from View Details:

[i] Triggered sync run 1775210864
SYNC start: orchestrator pairs run_id=1775210864
[i] Running single pair: TMDB → MDBLIST (pair_910fddc0d156)
[i] Orchestrator module: /app/cw_platform/orchestrator/init.py
{"event":"debug","msg":"run.kwargs.ignored","keys":["use_snapshot"]}
{"event":"health","provider":"MDBLIST","instance":"default","status":"ok","ok":true,"latency_ms":120,"details":{"disabled":["playlists"]},"features":{"watchlist":true,"ratings":true,"history":true,"playlists":false},"api":{"user":{"status":200,"retry_after":null,"rate":{"limit":null,"remaining":null,"reset":null}}}}
{"event":"api:hit","provider":"MDBLIST","endpoint":"health:user","status":200}
{"event":"health","provider":"TMDB","instance":"default","status":"ok","ok":true,"latency_ms":188,"details":null,"features":{},"api":{}}
{"event":"run:start","dry_run":false,"mode":"v3"}
{"event":"run:pair","i":1,"n":1,"src":"TMDB","dst":"MDBLIST","src_instance":"default","dst_instance":"default","mode":"one-way","features":["watchlist"]}
{"event":"feature:start","src":"TMDB","dst":"MDBLIST","feature":"watchlist"}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":100}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":200}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":300}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":400}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":519}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":619}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":719}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":819}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":919}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":1019}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":1119}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":1219}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":1319}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":1419}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":1519}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":1619}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":1719}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":1819}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":1919}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":2019}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":2138}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":2238}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":2338}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":2438}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":2538}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":2638}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":2757}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":2857}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":2957}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":3057}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":3176}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":3276}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":3376}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":3495}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":3595}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":3695}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":3795}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":3895}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":3995}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":4095}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":4195}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":4295}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":4395}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":4495}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":4595}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":4695}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":4795}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":4895}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":4995}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":5095}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":5195}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":5295}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":5395}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":5495}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":5595}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":5710}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":5823}
{"event":"snapshot:progress","dst":"TMDB","feature":"watchlist","done":5845,"final":true,"ok":true}
{"event":"debug","msg":"snapshot","provider":"TMDB","feature":"watchlist","count":5845,"raw_count":5845}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":200,"total":200}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":400,"total":400}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":600,"total":600}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":800,"total":800}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":1000,"total":1000}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":1200,"total":1200}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":1400,"total":1400}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":1600,"total":1600}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":1800,"total":1800}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":2000,"total":2000}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":2200,"total":2200}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":2400,"total":2400}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":2600,"total":2600}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":2800,"total":2800}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":3000,"total":3000}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":3200,"total":3200}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":3400,"total":3400}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":3600,"total":3600}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":3800,"total":3800}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":4000,"total":4000}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":4200,"total":4200}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":4400,"total":4400}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":4600,"total":4600}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":4800,"total":4800}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":5000,"total":5000}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":5200,"total":5200}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":5400,"total":5400}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":5600,"total":5600}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":5800,"total":5800}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":5837,"total":5837}
{"event":"snapshot:progress","dst":"MDBLIST","feature":"watchlist","done":5837,"total":5837}
{"event":"debug","msg":"snapshot","provider":"MDBLIST","feature":"watchlist","count":5837,"raw_count":5837}
{"event":"one:plan","src":"TMDB","dst":"MDBLIST","feature":"watchlist","adds":12,"removes":0,"updates":0,"src_count":5845,"dst_count":5837}
{"event":"apply:add:start","dst":"MDBLIST","feature":"watchlist","count":12}
{"event":"apply:unresolved","provider":"MDBLIST","feature":"watchlist","count":12}
{"event":"apply:add:done","dst":"MDBLIST","feature":"watchlist","count":0,"attempted":12,"added":0,"skipped":0,"skipped_exact":0,"skipped_inferred":0,"skip_basis":"inferred_remainder","unresolved":12,"errors":0}
{"event":"feature:done","src":"TMDB","dst":"MDBLIST","feature":"watchlist"}
{"event":"debug","msg":"tombstones.marked","feature":"watchlist","added":0,"scope":"none"}
{"event":"stats:overview","overview":{"now":0,"unresolved":12}}
{"event":"debug","msg":"state.persisted","providers":10,"wall":2}
{"event":"api:totals","totals":{"total":1,"providers":{"MDBLIST":{"total":1,"by_endpoint":{"health:user":1},"by_feature":{},"by_method":{},"by_status":{"200":1,"2xx":1},"latency_ms_avg":null,"latency_ms_samples":0}}}}
{"event":"run:done","updated":0,"added":0,"added_provider_reported":0,"removed":0,"skipped":0,"skipped_exact":0,"skipped_inferred":0,"attempted_add_duplicate_keys":0,"unresolved":12,"errors":0,"pairs":1,"mode":"v3"}
{"event":"debug","msg":"state.persisted","providers":2,"wall":5850}
{"event":"debug","msg":"hidefile.cleared","feature":"watchlist","scope":"end-of-run"}
{"event":"http:overview","window_hours":24,"data":{}}
{"event":"stats:overview","overview":{}}
[i] Done. Total added: 0, Total removed: 0, Total updated: 0, Total skipped: 0, Total unresolved: 12, Total errors: 0, Total blocked: 0
[SYNC] exit code: 0

[cenodude]

Your logs looks fine. What does the analyzer has to say? can you provide the list of unrsolved items or a couple of them..

Can you also upload your /config/state.json please

[nonstatic]

Hey thanks for following up. It turns out 11/12 titles were either tmdb's or mdblist's fault.

The most common issue was tmdb having duplicate entries for movies which were actually tv miniseries. In those cases, Crosswatch was trying to match the tmdb movie id to mdblist which (correctly) only had the series. Those tmdb id's shouldn't exist, so that's their fault.

A few are just not in mdblist at all. 1 had the right cover art in mdblist but completely incorrect metadata/title. 1 was in mdblist but didn't have the tmdb or imdb id's linked there.

I corrected what I could manually. I intend to use mdblist as the source for syncs moving forward, so this is really just a one-time issue. I was surprised to see so many duplicate entries in tmdb!

Thanks again for a great tool, I'm going to set up scrobbling and ratings sync now.

[cenodude]

You're welcome.