Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-20197

Can't insert SQL when size is large

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Not a Bug
    • 10.3.11
    • N/A
    • Server
    • 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.
      =======

      Attachments

        Activity

          People

            serg Sergei Golubchik
            dann.mendis Dann Mendis
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.