[DaveBlake]

Ahhhh ... I still get this ominous query even with confluence!?

Then it isn't skin related. But what is calling for unplayed songs? Ahhhh!

Could it be, as this query takes about 15s, that kodi is scanning further and mem is filling up?

Isn't that 15mins, or have I been misreading?

What happens if you aren't scanning. Just start and wait. Can you see a log of all the MySQL activity. I want to catch it even it ithappens quickly on a server that isn't receiving scanned data.