Sometimes VNSI hangs in recordings, SQL errors in log
#1
These errors are in the logs. Sometimes Kodi hangs with the circle and I need to reboot to wake it up again. My VNSI backend is Linux Mint with VDR 2.4.1. Could this be the reason for slowness and occational hanging? What SQL DB is it talking about? I use MySQL for libraries, but not for VNSI.

Quote:2019-08-10 19:10:17.925 T:3674297056   ERROR: SQL: Field not found: files.idFile
2019-08-10 19:10:17.926 T:3674297056   ERROR: GetFileId (pvr://recordings/tv/active/Husjakt på Hawaii ®/Husjakt%20p%c3%a5%20Hawaii%20®%20(12%3a13%2fs11)%20Deep%20Dive%20on%20Maui.%20Amerikansk%20livsstilserie., TV%20(FEM%20HD), 20190713_030500, 859667842.pvr) failed
2019-08-10 19:10:17.965 T:4072165376   ERROR: SQL: Field not found: files.idFile
2019-08-10 19:10:17.966 T:4072165376   ERROR: GetFileId (pvr://recordings/tv/active/Drømmen om et øyliv/Dr%c3%b8mmen%20om%20et%20%c3%b8yliv%20(11%3a14%2fs13)%20Planting%20Roots%20on%20North%20Carolina%27s%20Outer%20Banks., TV%20(FEM%20HD), 20190808_082500, 856312437.pvr) failed
2019-08-10 19:10:17.993 T:4072165376   ERROR: SQL: Field not found: path.idPath
2019-08-10 19:10:17.994 T:4072165376   ERROR: GetPathId unable to getpath (select idPath from path where strPath='pvr://recordings/tv/active/Sommerhytta/')
2019-08-10 19:10:18.005 T:3674297056   ERROR: SQL: Field not found: files.idFile
2019-08-10 19:10:18.006 T:3674297056   ERROR: GetFileId (pvr://recordings/tv/active/Sommerhytta/Sommerhytta%20(30%3a40%2fs3)%20Norsk%20realityserie%20fra%202019., TV%20(TV2%20HD), 20190507_170000, 860459800.pvr) failed
2019-08-10 19:10:18.024 T:3674297056   ERROR: SQL: Field not found: path.idPath
2019-08-10 19:10:18.025 T:3674297056   ERROR: GetPathId unable to getpath (select idPath from path where strPath='pvr://recordings/tv/active/Sommerhytta/')
2019-08-10 19:10:18.037 T:4072165376   ERROR: SQL: Field not found: files.idFile
2019-08-10 19:10:18.037 T:4072165376   ERROR: GetFileId (pvr://recordings/tv/active/Sommerhytta/Sommerhytta%20(30%3a40%2fs3)%20Norsk%20realityserie%20fra%202019., TV%20(TV2%20HD), 20190507_170000, 860459800.pvr) failed
2019-08-10 19:10:18.054 T:3674297056   ERROR: SQL: Field not found: files.idFile
2019-08-10 19:10:18.055 T:3674297056   ERROR: GetFileId (pvr://recordings/tv/active/Kjøp og salg med eiendomsbrødrene/Kj%c3%b8p%20og%20salg%20med%20eiendomsbr%c3%b8drene%20(19%3a13%2fs2)%20Steph%20%26%20Micah.%20Kanadisk%20realityserie%20fra%202011., TV%20(VOX%20HD), 20190724_162000, 88384202.pvr) failed
2019-08-10 19:10:18.376 T:3674297056   ERROR: SQL: Field not found: files.idFile
2019-08-10 19:10:18.376 T:3674297056   ERROR: GetFileId (pvr://recordings/tv/active/Husfikserne/Husfikserne%20(1%3a14%2fs4)%20Bright%2c%20Open%20Design%20Transforms%20Couple%27s%20First%20Home%20Together., TV%20(VOX%20HD), 20190719_153000, 917127484.pvr) failed
2019-08-10 19:10:18.415 T:3674297056   ERROR: SQL: Field not found: files.idFile
2019-08-10 19:10:18.415 T:3674297056   ERROR: GetFileId (pvr://recordings/tv/active/Husjakt på Hawaii ®/Husjakt%20p%c3%a5%20Hawaii%20®%20(9%3a13%2fs8)%20Outdoor%20Life%20on%20the%20Big%20Island.%20Amerikansk%20livsstilserie., TV%20(FEM%20HD), 20190705_015500, 918072506.pvr) failed
2019-08-10 19:10:19.034 T:3674297056   ERROR: SQL: Field not found: path.idPath
2019-08-10 19:10:19.034 T:3674297056   ERROR: GetPathId unable to getpath (select idPath from path where strPath='pvr://recordings/tv/active/Kjøp og salg med eiendomsbrødrene ®/')
2019-08-10 19:10:19.305 T:3674297056   ERROR: SQL: Field not found: files.idFile
2019-08-10 19:10:19.305 T:3674297056   ERROR: GetFileId (pvr://recordings/tv/active/Husfikserne ®/Husfikserne%20®%20(13%3a14%2fs4)%20The%20Colossal%20Crawford%20Reno.%20Amerikansk%20livsstilserie%20fra%202016., TV%20(VOX%20HD), 20190807_110000, 988040470.pvr) failed
 
Reply
#2
Go easy on the posting of log snippets into the forum, we prefer to have it pasted to a pastebin website such as https://paste.kodi.tv .

Kodi uses local and possibly a MySQL database. If you had posted the full debug log (wiki) file, things may have been clear already. Possibly the PVR SQLite database file got corrupted.
Got a Kodi problem? Provide us with a full Debug log (wiki) || Usefull pages: First time user (wiki) || Troubleshooting (wiki) || Free content (wiki) || Forum rules (wiki) || VPN policy (wiki)
Reply
#3
Ok, thank for responding.  I have gotten rid of the SQL errors but still my client freezes when deleting a recording. I can see in the server side logs that the recording gets deleted but the client does not respond after. Even clicking back etc does not work. I will do a debug log and send over in the pastebin. Sorry for not using it previously as I thought a few lines would not be an issue.
Reply
#4
Wrong links
Reply
#5
Updated logs

Client: alugacecuz.kodi (paste)
Server: ipizakeveg (paste)

This time it did not crash until I had deleted a few recordings. But finally the freeze came. At the same time PVR server said: "VNSI: Requesting clients to reload recordings list (1)"
Reply
 
Thread Rating:
  • 0 Vote(s) - 0 Average



Logout Mark Read Team Forum Stats Members Help
Sometimes VNSI hangs in recordings, SQL errors in log00