Openelec queries MySQL DB every 10 minutes
#1
Hey everyone,

i'm not really sure if it's a XBMC thing or if it is skin related, but every 10 minutes this happens:

Code:
09:29:22 2540.905762 T:2913543248   DEBUG: RunQuery took 1051 ms for 1091 items query: select * from movieview  WHERE ((movieview.playCount IS NULL OR movieview.playCount < 1))
09:29:25 2544.554443 T:2913543248   DEBUG: RunQuery took 1482 ms for 3760 items query: select * from episodeview  WHERE ((episodeview.playCount IS NULL OR episodeview.playCount < 1))
09:29:32 2551.140137 T:2913543248   DEBUG: RunQuery took 5 ms for 0 items query: select * from musicvideoview
09:29:32 2551.166748 T:2913543248   DEBUG: GetAlbumsByWhere query: SELECT albumview.* FROM albumview  WHERE albumview.strAlbum <> ''
09:29:32 2551.168945 T:2913543248   DEBUG: GetAlbumsByWhere - query took 1 ms
09:29:32 2551.201416 T:2913543248   DEBUG: GetArtistsByWhere query: SELECT artistview.* FROM artistview  WHERE (artistview.idArtist IN (SELECT song_artist.idArtist FROM song_artist) OR artistview.idArtist IN (SELECT album_artist.idArtist FROM album_artist)) and artistview.strArtist != '' and artistview.strArtist <> 'Verschiedene Interpreten'
09:29:32 2551.204346 T:2913543248   DEBUG: Time to retrieve artists from dataset = 5
09:29:32 2551.246826 T:2913543248   DEBUG: GetSongsByWhere query = SELECT songview.* FROM songview  WHERE ((CAST(songview.iTimesPlayed as DECIMAL(5,1)) < 1))
09:29:33 2551.836426 T:2913543248   DEBUG: Skin Widgets: Total time needed to request random queries: 0:00:12.022679

Here is the complete log: http://pastebin.com/ZvpNaVEs

I don't know why this happens, but it prevents my NAS from sleeping. But i want it to sleep, when i'm not at home or not using XBMC. Blush

Any ideas? Thanks in advance.
Reply
#2
Which Skin do you run? We had the same behaviour in the "Amber" skin caused from a widget
http://forums.openmediavault.org/index.p...#post38523
Philips TV with Kodi 20.2 with IPTV --- Orbsmart 500 Android 21 alpha/beta as Online-radio/TV in the kitchen
Reply
#3
Metropolis - but Amber is installed and so is the Skin Widgets addon with that weird option. Never would have found that....
Thank you!
Reply
#4
Sorry to resurrect the dead here, but im having this exact same problem but i only have Aeon Nox and confluence installed...

the only difference is mine only happens every 20 minutes and there is no mention of the "Skin Widgets" addon

Thanks,
Reply

Logout Mark Read Team Forum Stats Members Help
Openelec queries MySQL DB every 10 minutes0