2016-04-06, 08:19
hi Marcel
i may be reaching here, but hear me out please
it seems like a library scan my system runs out of RAM... LE kernel eventually kills kodi & things return to normal
in my crash.log the last lines show skin.helperService doing stuff onDatabaseUpdated.
it looks like some of the queries have a sane LIMIT of 10, but a few of the episode_view query grab EVERYTHING ? (17138 in my case)
also it happens again for "UpdateTotal(s)" ... wouldn't something like 'select count(idEpisode)' hit the mark much more efficiently than 'select *' ?
i may be reaching here, but hear me out please
it seems like a library scan my system runs out of RAM... LE kernel eventually kills kodi & things return to normal
in my crash.log the last lines show skin.helperService doing stuff onDatabaseUpdated.
it looks like some of the queries have a sane LIMIT of 10, but a few of the episode_view query grab EVERYTHING ? (17138 in my case)
also it happens again for "UpdateTotal(s)" ... wouldn't something like 'select count(idEpisode)' hit the mark much more efficiently than 'select *' ?
Code:
01:42:42 13873.570312 T:1766273952 NOTICE: Skin Helper Service --> Kodi_Monitor: onDatabaseUpdated: video
01:42:43 13874.063477 T:894432160 DEBUG: RunQuery took 661 ms for 10 items query: select * from episode_view ORDER BY dateAdded desc, idEpisode desc LIMIT 10
01:42:43 13874.476562 T:853537696 DEBUG: RunQuery took 176 ms for 1 items query: select * from movie_view JOIN sets ON movie_view.idSet = sets.idSet WHERE sets.idSet=151 ORDER BY sets.idSet
01:42:47 13878.564453 T:894432160 DEBUG: RunQuery took 173 ms for 10 items query: select * from musicvideo_view ORDER BY dateAdded desc, idMVideo desc LIMIT 10
01:42:48 13878.817383 T:853537696 DEBUG: RunQuery took 233 ms for 1 items query: select * from movie_view WHERE movie_view.idSet = 151
01:42:52 13882.880859 T:1301279648 DEBUG: RunQuery took 9551 ms for 17138 items query: select * from episode_view WHERE ((episode_view.playCount IS NULL OR episode_view.playCount = 0))
01:42:52 13882.939453 T:894432160 DEBUG: CRecentlyAddedJob::UpdateTotal() - Running RecentlyAdded home screen update
01:43:16 13907.387695 T:1686631328 DEBUG: RunQuery took 30812 ms for 17138 items query: select * from episode_view WHERE ((episode_view.playCount IS NULL OR episode_view.playCount = 0))
01:43:28 13920.006836 T:865072032 DEBUG: Thread JobWorker 865072032 terminating (autodelete)
