Medusa: Can't re-add show using other Indexer

[kantjer]

Before submitting your issue:

Enable debug logging in Medusa settings, reproduce the error (be sure to disable after the bug is fixed)

Branch/Commit: master/c65ca2607fae74405dcceaaf8c02f3d29d0313ea
OS: DSM 6.1.7-15284
What you did: removed show to add again through TVDBv2
What happened: Could not add show through TVDBv2 because it was previously added through TMDB
What you expected: followed advise from error, removed show but still show can't be added through other indexer (see log, log was taken after show was removed)

Reason I want to do that is that a few shows that are added via TMDB are missing Fanart/Poster

Logs:

2018-06-21 20:01:51 INFO     SHOWQUEUE-ADD :: [c65ca26] Trying to clean any empty folder under /volume1/downloads/complete/TV series/Reverie
2018-06-21 20:01:51 WARNING  SHOWQUEUE-ADD :: [c65ca26] Could not add the show Reverie, as it already is in your library. Error: The show Reverie has already been added by the indexer TMDB. Please remove the show, before you can add it through TVDBv2.
2018-06-21 20:01:51 DEBUG    SHOWQUEUE-ADD :: [c65ca26] Show already in database. [328549] Reverie
2018-06-21 20:01:48 DEBUG    SHOWQUEUE-ADD :: [c65ca26] Looking for externals using Trakt and tmdb id 71716
2018-06-21 20:01:47 DEBUG    SHOWQUEUE-ADD :: [c65ca26] Trying other indexer: TMDB get_id_by_external
2018-06-21 20:01:47 DEBUG    SHOWQUEUE-ADD :: [c65ca26] User-Agent: Medusa/0.2.5 (Linux; 3.10.102; 58978f6e-729c-11e8-9874-0011324e4744)
2018-06-21 20:01:47 DEBUG    SHOWQUEUE-ADD :: [c65ca26] GET URL: http://api.tvmaze.com/shows/24715 [Status: 200]
2018-06-21 20:01:46 DEBUG    SHOWQUEUE-ADD :: [c65ca26] User-Agent: Medusa/0.2.5 (Linux; 3.10.102; 58978f6e-729c-11e8-9874-0011324e4744)
2018-06-21 20:01:46 DEBUG    SHOWQUEUE-ADD :: [c65ca26] GET URL: http://api.tvmaze.com/shows/24715 [Status: 200]
2018-06-21 20:01:46 DEBUG    SHOWQUEUE-ADD :: [c65ca26] User-Agent: Medusa/0.2.5 (Linux; 3.10.102; 58978f6e-729c-11e8-9874-0011324e4744)
2018-06-21 20:01:46 DEBUG    SHOWQUEUE-ADD :: [c65ca26] GET URL: http://api.tvmaze.com/lookup/shows?imdb=tt6461746 [Status: 301]
2018-06-21 20:01:46 DEBUG    SHOWQUEUE-ADD :: [c65ca26] Trying other indexer: TVmaze get_id_by_external
2018-06-21 20:01:46 DEBUG    SHOWQUEUE-ADD :: [c65ca26] User-Agent: Medusa/0.2.5 (Linux; 3.10.102; 58978f6e-729c-11e8-9874-0011324e4744)
2018-06-21 20:01:46 DEBUG    SHOWQUEUE-ADD :: [c65ca26] GET URL: https://api.thetvdb.com/series/328549/episodes/query?page=1 [Status: 200]
2018-06-21 20:01:44 DEBUG    SHOWQUEUE-ADD :: [c65ca26] Getting all episodes of 328549
2018-06-21 20:01:44 DEBUG    SHOWQUEUE-ADD :: [c65ca26] Disabling Plex fallback as fallback timeout was reached
2018-06-21 20:01:44 DEBUG    SHOWQUEUE-ADD :: [c65ca26] User-Agent: Medusa/0.2.5 (Linux; 3.10.102; 58978f6e-729c-11e8-9874-0011324e4744)
2018-06-21 20:01:44 DEBUG    SHOWQUEUE-ADD :: [c65ca26] GET URL: https://api.thetvdb.com/series/328549 [Status: 200]
2018-06-21 20:01:42 DEBUG    SHOWQUEUE-ADD :: [c65ca26] Getting all show data for 328549
2018-06-21 20:01:42 DEBUG    SHOWQUEUE-ADD :: [c65ca26] Disabling Plex fallback as fallback timeout was reached
2018-06-21 20:01:42 DEBUG    SHOWQUEUE-ADD :: [c65ca26] Getting all series data for 328549
2018-06-21 20:01:42 DEBUG    SHOWQUEUE-ADD :: [c65ca26] Configured language en override show language of en
2018-06-21 20:01:42 INFO     SHOWQUEUE-ADD :: [c65ca26] TVDBv2: {u'session': <medusa.session.core.MedusaSession object at 0x70f11850>, u'cache': u'/volume1/@appstore/sickbeard-custom/var/cache/indexers/TVDBv2', u'language': u'en', u'use_zip': True}
2018-06-21 20:01:42 INFO     SHOWQUEUE-ADD :: [c65ca26] Starting to add show by ShowDir: /volume1/downloads/complete/TV series/Reverie
2018-06-21 20:01:39 DEBUG    Thread_4 :: [c65ca26] Using custom UI <class 'medusa.classes.AllShowsListUI'>
2018-06-21 20:01:39 DEBUG    Thread_4 :: [c65ca26] User-Agent: Medusa/0.2.5 (Linux; 3.10.102; 58978f6e-729c-11e8-9874-0011324e4744)
2018-06-21 20:01:39 DEBUG    Thread_4 :: [c65ca26] GET URL: https://api.thetvdb.com/search/series?name=reverie [Status: 200]
2018-06-21 20:01:37 DEBUG    Thread_4 :: [c65ca26] Searching for show: reverie
2018-06-21 20:01:37 DEBUG    Thread_4 :: [c65ca26] Disabling Plex fallback as fallback timeout was reached
2018-06-21 20:01:37 DEBUG    Thread_4 :: [c65ca26] Searching for Show with searchterm(s): Reverie on indexer: TVDBv2
2018-06-21 20:01:06 INFO     SHOWQUEUE-REMOVE-SHOW :: [c65ca26] 71716: Removing Reverie

[sharkykh]

Please enable debug logs and do the same steps you did.
We need the rest of the logs, as they may point to the cause of the issue.

[kantjer]

Debug was enabled when taking the log posted. I will check if it contains more relevant information when I get home

[kantjer]

Updated log in first post
Log was made with debug enabled

[sharkykh]

I need to see logs of the show removal, because from your logs it looks like you pressed the "Re-scan files" button.
Also, did you select the "Debug" level from the dropdown list on the "View Log" page?

[kantjer]

Updated log again
There is now debug option in dropdown list
only info, warning and error

If this isn't enough I will try again later with a clean log

[sharkykh]

@kantjer If there is no "Debug" level option, then debug is not enabled. Make sure it is enabled under General Config -> Advanced Settings, and make sure to save the config.

[kantjer]

@sharkykh now the log should be OK (I hope)

Removed show and renamed show directory before adding agin

[sharkykh]

That is now correct.
However, I'm still not able to understand what causes this to happen.
Are you using Trakt to add shows from your watchlist by any chance?

[kantjer]

No switched off Trakt a few weeks ago

[sharkykh]

Can you try removing the show, restarting Medusa and then trying to add the show back again with TVDB?

[kantjer]

Just found that even when selecting remove show it isn't removed at all
Nothing seems to happen.

Tried again after restarting Medusa.
I can't remove the show, tried a second show, same issue

[kantjer]

Quick check
Out of the 50+ shows in my library only are added using TMDB indexer
Those 2 seem to be locked and can't be removed. The rest seem to be OK.

Those same 2 are also the ones with missing artwork

[sharkykh]

Maybe your database is messed up somehow. Can you send me your main.db?

[kantjer]

@sharkykh

Got it [@sharkykh]

[sharkykh]

I'm able to remove Reverie using your database.
Maybe it's related to the fact you're moving the show folder?

Try... removing the show, wait a 5-10 seconds and manually navigate to http://localhost:8081/home/displayShow?indexername=tmdb&seriesid=71716
Does it load the show?

[kantjer]

what do you mean with moving the show folder?
When I just go the show and hit remove Medusa takes me back to the main show screen and Reverie is still there.

[sharkykh]

what do you mean with moving the show folder?

Earlier, you said:

Removed show and renamed show directory before adding agin

I thought you did that every time. Never mind.

When I just go the show and hit remove Medusa takes me back to the main show screen and Reverie is still there.

It takes a few seconds for Medusa to remove the show. Does it show up even after a few refreshes?
Does http://localhost:8081/home/displayShow?indexername=tmdb&seriesid=71716 work after you click remove?

[kantjer]

Yes, show is still there after hitting F5 a few times, also direct link is working
I can even start a re-scan.

All very weird

[sharkykh]

Well, I'm out of ideas.
I can send you your database without the two shows added from TMDB, if that helps.

[kantjer]

@sharkykh if you can do that that would be great.

Or can I with an SQLite editor remove the 2 shows (tv_shows) and their episodes (tv_episodes) from the database and place that back?

[sharkykh]

@kantjer You can try, but if you do be sure to save a backup first.

Here's the database:
----

[kantjer]

Thanks, placed your cleaned db back and added the shows again with TVDB.
All seems to be good and all before missing artwork problem is fixed.