Log spam from JSON query - Printable Version +- Kodi Community Forum (https://forum.kodi.tv) +-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33) +--- Forum: Music Support (https://forum.kodi.tv/forumdisplay.php?fid=263) +--- Thread: Log spam from JSON query (/showthread.php?tid=356182) |
Log spam from JSON query - scott967 - 2020-08-01 I have a script that runs when home window is activated to show album widgets. The script only shows 15 widgets, but uses a JSON call GetAlbumsByWhere query: SELECT albumview.* FROM albumview WHERE albumview.strReleaseType = 'album' ORDER BY albumview.idAlbum The problem is this spams my log with GetSongsByWhereJSON entiries. Is there any way to cut down the amount of these log entries? scott s. . RE: Log spam from JSON query - DaveBlake - 2020-08-02 My first thought is that you are using skin helper service - that is verbose/uses lots of JSON, and I can't quite make sense of what you are saying (GetAlbumsByWhere isn't a JSON call, and the JSON calls that use it don't also use GetSongsByWhereJSON). Can you clarify the JSON used, and/or let me have a log snippet that shows what you mean. RE: Log spam from JSON query - scott967 - 2020-08-02 What happens is for testing I created a large album smart playlist (928 items). The script creates 12 random widgets of albums from the PLAYLIST path and filename via Code: xbmc.executeJSONRPC('{"jsonrpc": "2.0", "method": "Files.GetDirectory", "params": {"directory": "%s", "media": "music", "properties": ["dateadded"], "sort": {"method": "random"}}, "id": 1}' %(PLAYLIST)) When that call is made what is getting logged Code: T:11720 DEBUG <general>: CMusicDatabase::GetAlbumsByWhere query: SELECT albumview.* FROM albumview WHERE albumview.strReleaseType = 'album' ORDER BY albumview.idAlbum The last 2 GetSongsByWhere repeat 100s of times as it iterates through all the albums (I assume -- the idAlbum is different in each logged line). I guess I could write something to strip out those lines form the logs, in the mean time pare down the playlist. Note it's only a problem for reading through logs trying to find things among all those query logged lines. scott s. . RE: Log spam from JSON query - DaveBlake - 2020-08-06 I can't reproduce the database queries and logging you are seeing, best give example of %(PLAYLIST) @scott967. I can't think what Files.GetDirectory request you give an album query followed by song queries for each album |