debug.log
[MDEV-20197] Can't insert SQL when size is large Created: 2019-07-28 Updated: 2019-08-08 Resolved: 2019-08-08 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Server |
| Affects Version/s: | 10.3.11 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | Dann Mendis | Assignee: | Sergei Golubchik |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Production |
||
| Attachments: |
debug.log
|
| 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: Kodi Team Findings: ===========
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. |
| Comments |
| Comment by Sergei Golubchik [ 2019-08-08 ] |
|
This is not a MariaDB bug. See the explanation in this kodi thread. MariaDB has a rich set of column types to suit various use cases. It appears that KODI uses type TEXT for the column c06 in the table tvshow. Columns of this type are limited to 64K bytes — https://mariadb.com/kb/en/library/text/ The workaround, suggested in the forum, is to change the column type to at least MEDUIMTEXT — https://mariadb.com/kb/en/library/mediumtext/ The proper fix, of course, is for KODI to create the table with that data type for large columns. |