Why Does Clean Library NOT ACTUALLY DO THAT??

Very frustrating, and from searches for similar issues, this appears to happen to many other users.

When you run a Clean Library, there are still paths/entries in there that are not cleaned. Why does this process fail, or is it that the support information is actually inaccurate and misleading and that old paths/files are not cleaned at all?

I have repeatedly cleaned my DB (MySQL) but on restart every time i get old NFS paths which no longer exist (but Kodi is really bad at parsing invalid NFS path lists it seems so this takes 20 seconds for each path! why does it not time out quicker??).

The total number of NFS path entries did decrease after the first Clean today, but there are still some present.

Please help