"Couldn't import episode...constraint failed column Path is not unique"

Help & Support
1

NzbDrone suddenly stopped importing episodes from my Drone Factory folder. Here’s an example of the errors I am seeing:

“Couldn’t import episode /home/admin/Downloads/NzbDrone/Drone Factory/Greys.Anatomy.S05E24.720p.BluRay.x264-SiNNERS/Greys.Anatomy.S05E24.720p.BluRay.x264-SiNNERS.mkv: constraint failed
column Path is not unique”

What does this mean? How to fix?

2

Please enable debug logging, clear your log files (System -> Logs -> Files) and post the contents after seeing this error again. https://github.com/NzbDrone/NzbDrone/wiki/Log-Files

3

Not sure if it is the same problem, but I got this when I accidentally modified the path of one series to be the top level directory of all my series. i.e. C:\TV instead of C:\TV\Whatever. Not surprisingly it messed up the database (seriesid) when I subsequently did an “Update series info and scan disk” for this series as it scanned my entire directory structure and added any newly found episodes to the wrong series.

It would be nice if drone could give a warning about this, but I’m not entirely sure how.

4

@Torrox it should prevent you from doing it (if that folder is a root folder, set via add series), this was added in a recent version.

5

I woke up and a few imported but not all. Here is the output I get after enabling debug and clearing the logs: http://pastebin.com/HuaPKpDr

Thanks for your help.

6

And just in case, I cleared the logs and enabled trace logging. Heres the output (removed API key): http://pastebin.com/2am7piYw

7

Did the episode for S10E02 import properly (the logs don’t show it)? The logs also don’t see what led to the failure for S10E01.

The trace logs don’t show any information about the import because its already running, perhaps the issues are related to having to copy to BitCasa.

Also check your series paths on the Series Editor page to make sure they are correct.

8

Yes S10E01 & S10E2 imported just fine. Hmm, ok I will do more digging.