Solved - An unknown error occurred in SQL

Solved An unknown error occurred in SQL - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: Solved An unknown error occurred in SQL (/showthread.php?tid=366145)

Pages: 1 2

An unknown error occurred in SQL - mara.pavelka - 2021-12-24

I have a shared database on my NAS and now Kodi 19.3 won't run on any Android or LibreELEC device except a PC. It always freezes on the splash screen. The last lines in the log are:

Quote:2021-12-24 14:01:52.960 T:1298 INFO <general>: MYSQL: Connected to version 10.5.13-MariaDB-log
2021-12-24 14:01:52.994 T:1298 ERROR <general>: SQL: [Marek19Videos119] An unknown error occurred
Query: SELECT idVersion FROM version
2021-12-24 14:01:52.996 T:1298 ERROR <general>: Process error processing job

For the full log see ayikajexoq.kodi (paste)

RE: An unknown error occurred in SQL - mara.pavelka - 2021-12-24

Nevermind, I found solution here: https://forum.kodi.tv/showthread.php?tid=357217 Smile

An unknown error occurred in SQL - Klojum - 2021-12-24

Thread marked solved.

RE: An unknown error occurred in SQL - mara.pavelka - 2021-12-25

So unfortunately, it worked only for a while, but now all devices except PC are unable to connect to the database again Sad

sort_buffer_size is still set to 10M. The log is here

RE: An unknown error occurred in SQL - Karellen - 2021-12-25

(2021-12-25, 15:15)mara.pavelka Wrote: The log is here

Please enable debug mode and component logging for databases

RE: An unknown error occurred in SQL - mara.pavelka - 2021-12-25

Is this better?

RE: An unknown error occurred in SQL - Karellen - 2021-12-25

(2021-12-25, 20:03)mara.pavelka Wrote: Is this better?

Yes.
Are you sure you increased sort_buffer_size size in my.cnf ?
I don't know how large your library is, but maybe try increasing it again.

RE: An unknown error occurred in SQL - mara.pavelka - 2021-12-25

My library isn't very big yet because I deleted it all and started over. It contains about 100 movies.

I'm using MariaDB via Docker in OMV6, so I'm editing the custom.cnf file. When I increased the sort_buffer_size to 10M, Kodi stopped freezing on startup, but the Movies section on the tablet says there are no entries in it, while the PC displays and plays them all without problem. When I tried increasing connect_timeout from 5 to 10, the list of added movies finally appeared on the tablet. But when I want to start any one, I get an error that one or more items failed to play, and when I click OK Kodi crashes. Increasing sort_buffer_size to 100M and connect_timeout to 100 doesn't help. The new log is here.

RE: An unknown error occurred in SQL - black_eagle - 2021-12-26

(2021-12-25, 20:57)mara.pavelka Wrote: But when I want to start any one, I get an error that one or more items failed to play

Thats because the file you tried to play uses a local filepath W:/Filmy HD 2/The Last Duel (2021)/ and they need to use a network path such as smb:// or nfs://

If you want to use a shared db, you must use network paths when first scanning in your videos else the library will only work on the machine you did the scanning on. So, even if you scan on the same machine that is hosting the files, you must still add the network path to Kodi before scanning the files. In your case you appear to have a mix of both local and network paths.

There is a guide on using smb with Kodi in the wiki here.

RE: An unknown error occurred in SQL - mara.pavelka - 2021-12-26

Thank you very much @black_eagle, i's working now Smile

I don't know why I started using local paths, even though I bolded in the installation notes that I had to use network paths.

RE: An unknown error occurred in SQL - black_eagle - 2021-12-26

No worries, it's an easy mistake to make in the beginning. Glad you're all sorted now Cool

RE: An unknown error occurred in SQL - mara.pavelka - 2021-12-26

It's still not solved Sad

When I added a few movies and TV shows, it seemed fine. Everything showed up, both on the PC and on other devices, and playback seemed to work as well.

But now I have tried adding more media and the behavior is very strange. When I have Kodi opened on my PC and on my tablet at the same time, if I start playback on the PC and quit it, the tablet either says this file is no longer available or the whole Kodi freezes or crashes when I try to start the same video. And as soon as I add a new movie to the database on the PC and then switch to Series and back to Movies on the tablet, the Movies entry is empty. It's similar with series. I always have to exit Kodi on the tablet, restart the mariadb conejner and then it shows up again Sad

Here is the log after crashing when trying to play the same movie on the tablet after I started and quit it on the PC. And here after trying to restart Kodi and then crashing again.

EDIT: It seems that after each operation on one device, I have to restart the mariadb container to make it work on the other device. So maybe the wrong container or version? Now I'm using linuxserver/mariadb image and MariaDB is version 10.5.13.

RE: An unknown error occurred in SQL - black_eagle - 2021-12-26

From your log it looks like there are issues with your shared db. Can you export it and share a link to it (you can edit your post and delete the link so only team members will be able to see it)? If you are not sure how to export the db, please say so and I can guide you.

RE: An unknown error occurred in SQL - mara.pavelka - 2021-12-28

You're right, it definitely looks like a problem with the existing database. Or with the container, because I tried deleting and recreating the relevant databases for Kodi, but that didn't help.

Now I tried using the newly installed container from official mariadb and everything works fine. I can see all entries on all devices and can play all media, even the same movie on multiple devices simultaneously.

Could I ask you for the exact procedure on how to export the database and then upload it so only team members can see it?

RE: An unknown error occurred in SQL - Klojum - 2021-12-28

(2021-12-28, 10:02)mara.pavelka Wrote: on how to export the database

You should have PM options by now, so, Zip a SQL dump export, and attach it to the PM message. Or upload the file via a dropbox account or other file upload option, and post its URL.