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

Record size greater than 64k

    XMLWordPrintable

Details

    Description

      ERROR 1118 (42000): Row size too large. The maximum row size for the used table
      type, not counting BLOBs, is 65535. This includes storage overhead, check the ma
      nual. You have to change some columns to TEXT or BLOBs

      I don't want use blobs for long varbinary fields because there is possibility to index by them. The user in their CMS has possibility to "alter table add column" to configure their database. The length exceeded today 65535 and system is blocked. I retested the system on Windows. I don;t know what error is issued on production version.

      This bug probably by compatibility is present also in MariaDB.

      Attachments

        Activity

          People

            serg Sergei Golubchik
            MariaDB/MySQL user MariaDB/MySQL user
            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.