Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
10.3.11
-
None
-
Production
Description
SQL Error with MariaDB Server when trying to inject large SQL. I am using MariaDB Server with KODI and when KODI trying to insert the SQL info for Movies it's giving an error.
This issue already investigated by the KODI team and confirmed it's an issue with the DB server.
Error Log:
https://paste.osmc.tv/xanimufope.xml
Kodi Team Findings:
https://forum.kodi.tv/showthread.php?tid=129821&pid=2871660#pid2871660
===========
2019-07-26 11:40:57.345 T:2449461984 ERROR: SQL: [MyVideos116] Undefined MySQL error: Code (1406)
|
2019-07-26 11:40:57.441 T:2449461984 ERROR: SetDetailsForMovie (nfs://192.168.1.117/volume1/4K_Content/4K Movies/The.Avengers.2012.2160p/The.Avengers.2012.2160p.mkv) failed
|
2019-07-26 11:40:57.888 T:2449461984 DEBUG: Mysql rollback transactionXMLCopy
|
|
A known issue that is related to the shared MariaDB/MySQL setup and can happen with these hugely popular movies. It is caused by too many artwork links at the scraper site which cannot be accommodated in the shared database. It is not an issue with the Kodi's default SQL database.
=======