Kodi Community Forum

I'm getting random database errors in kodi on my Raspberry Pi 4B running LibreElec 10.0.1 (Kodi Matrix 19.3) after I migrated to a new docker mariadb (LinuxServer MariaDB)
I'm not sure what is wrong as my Kodi 19.3 on my Windows desktop has no issues communicating with the database.
The strangest thing of all is that the Pi has the exact same advancedsettings.xml and even temporarily worked with the database but got caught in a crash-restart loop after a reboot.
I have currently set the bind address of the MariaDB 10.5.13 server is 0.0.0.0 and the default-authentication-plugin is set to mysql_native_password.

This is my KODI.log from the Failed folder in smb: https://paste.kodi.tv/uwifazoliw.kodi
This is my advancedsettings.xml: https://paste.kodi.tv/odotesamuj (Note: the loglevel is currently there to be able to output debug logging for the log above and the ip and password have been modified but match the exact server ip and mysql user password.)

I would love if anyone can point out anything I might have missed or anything I could possibly to get it working again.

(2021-12-17, 23:18)Yami no Senshi Wrote: [ -> ]This is my KODI.log from the Failed folder in smb: https://paste.kodi.tv/uwifazoliw.kodi

On line 1217 of your log, there is an error message. The fix is in this post here... https://forum.kodi.tv/showthread.php?tid=357217

Hopefully that will fix the remaining errors. Lets see.

Thanks!

My Kodi booted again and seems to be working at a quick glance.
I'll do some more thorough testing tomorrow to see if this is another magical fluke like I had earlier today or if it is truly fixed.
I'm hoping the latter so thanks again for the swift reply!

I did some more testing and put some load ion it and everything seems to work correctly now.
Thanks again for the help, consider the question solved.

Thread marked solved.

I'm afraid I'll have to reopen this issue as it seems the error is back.
Since the last time I had this issue I added multiple new entries without any issues.
However, a few days ago after I opened kodi on my desktop and manually refreshed data for an entry which wasn't scraping correctly the issue came back.
So now the kodi on my raspberry pi is stuck again in a crash loop.

Initially the problem went away when I changed the sort_buffer_size of the database from 4M to 10M so I tried increasing it to 16M this time with no improvement.
I also tried deleting the kodi user and recreating it while making sure to use the native_mysql_authentication for it.
Besides that I noticed that the database errors can both occur for entries which have been in the database for a while or which are new.
Sometimes the missing result set error still pops up but it is not reliably present in the error log.

new Kodi log: https://paste.kodi.tv/aponurubof.kodi

I would greatly appreciate it if someone can help me with this again as I've been banging my head against it for three days straight by now.