[DaveBlake]

Still have not managed to fix this. In fact I've noticed that there are numerous inconsistencies in my library that the 'clean' command does not remove. There are lots of artist entries that are empty and cleaning the library does not remove them. Double entries here and there. What causes the 'clean' command to miss this? Even when I've successfully used the 'clean' command it still takes four or five goes before it removed what I wanted removed.

I don't know what is wrong for you, if you are selecting to clean the music library then it sounds very odd.

If you just want a solution for you then I suggest you go to file view and remove the music source(s). Then stop Kodi and delete MyMusic60.db from the userdata folder. Finally restart Kodi and add music source(s), rescan etc.

The downside of that fresh start to the music library is that you will lose any playback history or user ratings that you have added manually.

But if you would like to make your MyMusic60.db and sources.xml files available to me, and then names of the poorly tagged albums that triggered this issue, then I will have a look and see if I can see what has happened. The clean process does remove orphaned records, and there is no obvious reason for it to fail.

Do I have to learn how to use SQL to resolve this?

No. I am happy to do that SQL work for you.