[Uatschitchun]

I have debug on since possibly the very beginning

Ok, so I'm back home now. Scanning started this morning is still running, but has not reached the level I started this thread.
It's LE 7.95.2 right now, so not latest Beta

Did check some logging parallels:

mysql-slow.log:

Code:

# Time: 170213 15:53:07
# User@Host: kodi[kodi] @ libreraspi [192.168.5.20]
# Query_time: 12.660630  Lock_time: 0.001491 Rows_sent: 137472  Rows_examined: 753738
SET timestamp=1486997587;
SELECT songview.*, songartistview.* FROM songview JOIN songartistview ON songartistview.idsong = songview.idsong  WHERE ((CAST(songview.iTimesPlayed as DECIMAL(5,1)) < 1)) ORDER BY songartistview.idsong, songartistview.idRole, songartistview.iOrder;

At that time kodi.log shows:

Code:

15:53:06.697 T:1391403936   DEBUG: Mysql execute: UPDATE song SET dateAdded='2017-02-09 02:06:37' WHERE idSong=32129
15:53:08.013 T:1961804704   DEBUG: CAnnouncementManager - Announcement: OnUpdate from xbmc
15:53:08.013 T:1961804704   DEBUG: GOT ANNOUNCEMENT, type: 32, from xbmc, message OnUpdate

There are no Mysql timeouts

Code:

cat kodi.log | grep Undefinded

gives nothing

Found another:

mysql-slow:

Code:

# Time: 170213 17:07:08
# User@Host: kodi[kodi] @ libreraspi [192.168.5.20]
# Query_time: 15.029499  Lock_time: 0.001206 Rows_sent: 146388  Rows_examined: 805031
SET timestamp=1487002028;
SELECT songview.*, songartistview.* FROM songview JOIN songartistview ON songartistview.idsong = songview.idsong  WHERE ((CAST(songview.iTimesPlayed as DECIMAL(5,1)) < 1)) ORDER BY songartistview.idsong, songartistview.idRole, songartistview.iOrder;

and kodi.log:

Code:

17:07:08.572 T:1829761952   DEBUG: GetAlbumsByWhere - query took 2247 ms

memory usage goes up at this time (mysql-slow errors show up) but kodi did recover until now.

The last one at 17:18

Code:

# Time: 170213 17:18:22
# User@Host: kodi[kodi] @ libreraspi [192.168.5.20]
# Query_time: 13.821188  Lock_time: 0.002915 Rows_sent: 148206  Rows_examined: 814852
SET timestamp=1487002702;
SELECT songview.*, songartistview.* FROM songview JOIN songartistview ON songartistview.idsong = songview.idsong  WHERE ((CAST(songview.iTimesPlayed as DECIMAL(5,1)) < 1)) ORDER BY songartistview.idsong, songartistview.idRole, songartistview.iOrder;

lead to a hung up system cause of OOM

No ssh access possible anymore. I'll wait if kernel OOM manager kills/restarts kodi

I don't know what's causing these queries, but its corresponding to the "DEBUG: GetAlbumsByWhere - query"