[alexalien]

I am running multiple KODI installations (all v15 RC2) using a central MySQL database.

When performing a cleanup of the video library (using the function under Settings > Video > Library) i get the following warnings and errors:

Code:

15:31:35 T:3948  NOTICE: CVideoDatabase::CleanDatabase: Starting videodatabase cleanup ..
15:32:23 T:3948 WARNING: XFILE::CFileFactory::CreateLoader - unsupported protocol(plugin) in plugin://plugin.video.prime_instant/?url=B00VVT7MQ4&mode=playVideo&name=Weekend+of+a+Champion&thumb=http%3A%2F%2Fecx.images-amazon.com%2Fimages%2FI%2F51HpcX5-1zL.jpg
15:32:23 T:3948 WARNING: XFILE::CFileFactory::CreateLoader - unsupported protocol(plugin) in plugin://plugin.video.prime_instant/?url=B00HX0N0BQ&mode=playVideo&name=Elysium&thumb=http%3A%2F%2Fecx.images-amazon.com%2Fimages%2FI%2F51oBZe7%252BKdL.jpg
15:32:23 T:3948 WARNING: XFILE::CFileFactory::CreateLoader - unsupported protocol(plugin) in plugin://plugin.video.mlbmc/?url=http%3A%2F%2Fmlb.mlb.com%2Fgen%2Fmultimedia%2Fdetail%2F9%2F8%2F3%2F142694983.xml&mode=2&name=Minnesota+Twins+%40+Boston+Red+Sox&podcasts=False
15:32:28 T:3948   ERROR: CCurlFile::Exists - Failed: Timeout was reached(28) for http://192.168.2.66:51000/stream/title7.m2ts
15:32:28 T:3948   ERROR: CUPnPDirectory::GetResource - unable to find uuid 6FF32089-DD72-4fa8-8B55-A0F3AF1BB5FF
15:32:33 T:3948   ERROR: CCurlFile::Exists - Failed: Timeout was reached(28) for http://192.168.2.66:51000/stream/title1.m2ts
15:32:33 T:3948   ERROR: CUPnPDirectory::GetResource - unable to find uuid 6FF32089-DD72-4fa8-8B55-A0F3AF1BB5FF
15:32:33 T:3948 WARNING: XFILE::CFileFactory::CreateLoader - unsupported protocol(plugin) in plugin://plugin.video.youtube/?action=play_video&videoid=YQUkX_XowqI
15:32:33 T:3948 WARNING: XFILE::CFileFactory::CreateLoader - unsupported protocol(plugin) in plugin://plugin.video.ardmediathek_de/?url=&mode=playLiveARD
...

The list goes on and on...

It seems as if every stream that was ever referenced (not necessarily played) is stored in the 'file' (and 'path') table of the database,
and the cleanup function can not really clean up these tables.

Is there a way to cleanup the 'files' and 'path' tables and get rid of all addon/stream data?

Is there a way to prevent these files/paths being stored in the database in the first place?

Thanks in advance for your insights!

[robnix]

I'm running into the exact same issue. My last database cleanup run took and hour and 17 minutes because of this.

[redstorm]

I too am suffering from this exact problem.

Update:

I think i may have worked around the issue by removing the offending paths from the database. (mysql in my case)

Code:

use MyVideos99;
select strPath from path where strPath LIKE '%http%';

verify that these are the paths that .kodi/temp/kodi.log is complaining about when cleaning the library.

Code:

delete from path where strPath LIKE '%http%';

After deleting them, running a clean database operation takes 0.02 seconds. instead of 12 minutes waiting for 28 timeouts on http files that no longer exist on the net.

Code:

13:11:29 T:140595539281920  NOTICE: CleanDatabase: Cleaning videodatabase done. Operation took 12:15
13:13:53 T:140595539281920  NOTICE: CleanDatabase: Cleaning videodatabase done. Operation took 00:02

The clean database should remove these when it finds it can no longer find the file.

[skylarking]

Look at 272112 (thread) where an database cleaner add-on is discussed.

One day, hopefully, such a function will be part of kodi core database cleaner