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

Cannot create a certain table: Row size too large

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.3.17, 10.4.7
    • Fix Version/s: N/A
    • Labels:
      None
    • Environment:
      Docker on Windows 10 and Ubuntu 18.04

      Description

      • Start database:
        docker run --name mymariadb --rm -p 3306:3306 -e MYSQL_ROOT_PASSWORD=secret -d mariadb:10.4.7
      • Execute the queries below.

      ==> You'll get an error: /* SQL Fehler (1118): Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. */

      I tried out several versions:

      Database Error
      MariaDB 10.4.6 no
      MariaDB 10.4.7 yes
      MariaDB 10.3.16 no
      MariaDB 10.3.17 yes
      MySQL 5.7.24 no

      I'd guess it's related to MDEV-19292.

       
      CREATE DATABASE bug;
      USE bug;
      CREATE TABLE `address0` ( `GGUID` binary(16) NOT NULL COMMENT 'Primary Key', `InsertUser` varchar(40) NOT NULL COMMENT 'The person that created the record', `UpdateUser` varchar(40) NOT NULL COMMENT 'The person that last updated the record', `InsertTimestamp` datetime NOT NULL COMMENT 'Creation time of record', `UpdateTimestamp` datetime NOT NULL COMMENT 'Update time of record', `OwnerName` varchar(200) DEFAULT NULL COMMENT 'The names of the permission owners', `OwnerGUID` binary(16) NOT NULL COMMENT 'The GGUID of the owner, i.e. the creator', `ForeignEditPermission` int(11) NOT NULL COMMENT 'The maximum permission a user can have when using foreign editpermissions', `IsDeleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Indicates if a record is deleted', `IsTemplate` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Indicates if a record is a template', `XRMType` varbinary(17) DEFAULT NULL, `ADDRESSCHECKEDBY1` binary(16) DEFAULT NULL, `ADDRESSCHECKEDBY2` binary(16) DEFAULT NULL, `ADDRESSCHECKEDBY3` binary(16) DEFAULT NULL, `ADDRESSCHECKEDBY4` binary(16) DEFAULT NULL, `ADDRESSCHECKEDON1` datetime DEFAULT NULL, `ADDRESSCHECKEDON2` datetime DEFAULT NULL, `ADDRESSCHECKEDON3` datetime DEFAULT NULL, `ADDRESSCHECKEDON4` datetime DEFAULT NULL, `Gender` varbinary(17) DEFAULT NULL, `ADDRESSLETTER` varchar(150) DEFAULT NULL, `ADDRESSTERM` varchar(30) DEFAULT NULL, `BANKACCOUNTHOLDER` varchar(60) DEFAULT NULL, `BANKACCOUNTNR` varchar(20) DEFAULT NULL, `BANKZIPNR` varchar(20) DEFAULT NULL, `BIRTHDAY` datetime DEFAULT NULL, `CHECKEDBYUSERON` datetime DEFAULT NULL, `CHRISTIANNAME` varchar(30) DEFAULT NULL, `COMPNAME` varchar(80) DEFAULT NULL, `COUNTRY1` char(2) DEFAULT NULL, `COUNTRY2` char(2) DEFAULT NULL, `COUNTRY3` char(2) DEFAULT NULL, `COUNTRY4` char(2) DEFAULT NULL, `CUSTOMERID` varchar(40) DEFAULT NULL COMMENT 'Customer ID/number', `DEPARTMENT` varchar(255) DEFAULT NULL, `FAXFIELDSTR1` varchar(30) DEFAULT NULL, `FAXFIELDSTR4` varchar(30) DEFAULT NULL, `FAXFIELDSTR5` varchar(30) DEFAULT NULL, `FINANCIALINSTITUTE` varchar(100) DEFAULT NULL, `FIRSTCONTACT` varchar(30) DEFAULT NULL, `FIRSTCONTACTDATE` datetime DEFAULT NULL, `FUNCTION` varchar(100) DEFAULT NULL, `GWADDITIONALINFO1` varchar(100) DEFAULT NULL, `GWADDITIONALINFO2` varchar(100) DEFAULT NULL, `GWADDITIONALINFO3` varchar(100) DEFAULT NULL, `GWADDITIONALINFO4` varchar(100) DEFAULT NULL, `GWADDRESSFORMAT` char(3) DEFAULT 'DE', `GWBIC` varchar(11) DEFAULT NULL, `GWIBAN` varchar(42) DEFAULT NULL, `GWNAMEPREFIX` varchar(15) DEFAULT NULL, `GWSTATE1` varchar(30) DEFAULT NULL, `GWSTATE2` varchar(30) DEFAULT NULL, `GWSTATE3` varchar(30) DEFAULT NULL, `GWSTATE4` varchar(30) DEFAULT NULL, `IMAGEGUID` binary(16) DEFAULT NULL, `IMAGEPATH` varchar(255) DEFAULT NULL, `IMFIELDSTR1` varchar(100) DEFAULT NULL, `IMFIELDSTR2` varchar(100) DEFAULT NULL, `IMFIELDSTR3` varchar(100) DEFAULT NULL, `IMFIELDSTR4` varchar(100) DEFAULT NULL, `IMFIELDSTR5` varchar(100) DEFAULT NULL, `IMFIELDSTR6` varchar(100) DEFAULT NULL, `INHOUSEZIP` varchar(20) DEFAULT NULL, `ISORGANISATION` tinyint(1) NOT NULL DEFAULT 0, `LINKEDUSERGUID` binary(16) DEFAULT NULL, `LINKEDUSERID` int(11) DEFAULT NULL, `MAILFIELDSTR1` varchar(100) DEFAULT NULL, `MAILFIELDSTR2` varchar(100) DEFAULT NULL, `MAILFIELDSTR3` varchar(100) DEFAULT NULL, `MAILFIELDSTR5` varchar(100) DEFAULT NULL, `MASTERADDRESSID1` varchar(60) DEFAULT NULL, `MASTERADDRESSID2` varchar(60) DEFAULT NULL, `MASTERADDRESSID3` varchar(60) DEFAULT NULL, `MASTERADDRESSID4` varchar(60) DEFAULT NULL, `NAME` varchar(100) DEFAULT NULL, `NOTES2` varchar(255) DEFAULT NULL, `NOTES2OverFlow` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Indicates that the value of NOTES2 exceeds the maximum length, the full content is saved in TextFieldContents', `PAYMENT` varchar(30) DEFAULT NULL, `PHONEFIELDSTR10` varchar(30) DEFAULT NULL, `PHONEFIELDSTR2` varchar(30) DEFAULT NULL, `PHONEFIELDSTR3` varchar(30) DEFAULT NULL, `PHONEFIELDSTR4` varchar(30) DEFAULT NULL, `PHONEFIELDSTR5` varchar(30) DEFAULT NULL, `PHONEFIELDSTR7` varchar(30) DEFAULT NULL, `PHONEFIELDSTR9` varchar(30) DEFAULT NULL, `PHONEID10` varchar(25) DEFAULT NULL, `PHONEID2` varchar(25) DEFAULT NULL, `PHONEID3` varchar(25) DEFAULT NULL, `PHONEID4` varchar(25) DEFAULT NULL, `PHONEID5` varchar(25) DEFAULT NULL, `PHONEID7` varchar(25) DEFAULT NULL, `PHONEID9` varchar(25) DEFAULT NULL, `STANDARDPHONE1` int(11) DEFAULT NULL, `STANDARDPHONE2` int(11) DEFAULT NULL, `POBOX1` varchar(15) DEFAULT NULL, `POBOX2` varchar(15) DEFAULT NULL, `POBOX4` varchar(15) DEFAULT NULL, `POBOXTOWN1` varchar(50) DEFAULT NULL COMMENT 'Town for POBOX1', `POBOXTOWN2` varchar(50) DEFAULT NULL COMMENT 'Town for POBOX2', `POBOXTOWN4` varchar(50) DEFAULT NULL COMMENT 'Town for POBOX4', `POBOXZIP1` varchar(15) DEFAULT NULL, `POBOXZIP2` varchar(15) DEFAULT NULL, `POBOXZIP4` varchar(15) DEFAULT NULL, `PRIMARYORGANISATION` binary(16) DEFAULT NULL, `REBATE` decimal(19,4) DEFAULT NULL, `STANDARDADDRESS` int(11) DEFAULT NULL COMMENT '0 = Business, 1 = Besuch, 2 = privat', `STANDARDEMAIL` int(11) DEFAULT NULL, `STREET1` varchar(50) DEFAULT NULL, `STREET2` varchar(50) DEFAULT NULL, `STREET3` varchar(50) DEFAULT NULL, `STREET4` varchar(50) DEFAULT NULL, `SUBURB1` varchar(50) DEFAULT NULL, `SUBURB2` varchar(50) DEFAULT NULL, `SUBURB3` varchar(50) DEFAULT NULL, `SUBURB4` varchar(50) DEFAULT NULL, `TITLE` varchar(30) DEFAULT NULL, `TOWN1` varchar(50) DEFAULT NULL, `TOWN2` varchar(50) DEFAULT NULL, `TOWN3` varchar(50) DEFAULT NULL, `TOWN4` varchar(50) DEFAULT NULL, `TURNOVERTAXID` varchar(30) DEFAULT NULL, `WWWFIELDSTR0` varchar(100) DEFAULT NULL, `WWWFIELDSTR1` varchar(100) DEFAULT NULL, `WWWFIELDSTR5` varchar(100) DEFAULT NULL, `ZIP1` varchar(15) DEFAULT NULL, `ZIP2` varchar(15) DEFAULT NULL, `ZIP3` varchar(15) DEFAULT NULL, `ZIP4` varchar(15) DEFAULT NULL, `DEACTIVATED` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Indicates a deactivated address', `CATEGORY` varbinary(81) DEFAULT NULL, `BRANCH` varbinary(17) DEFAULT NULL, `CLASSIFICATION` varbinary(17) DEFAULT NULL, `ACTIVITY_TYPE_ALLOWED` varbinary(81) DEFAULT NULL, `ACTIVITY_TYPE_PREFERRED` varbinary(17) DEFAULT NULL, `RegistrationNumber` varchar(15) DEFAULT NULL, `RegistrationCourt` varchar(30) DEFAULT NULL, `EBIDNumber` varchar(15) DEFAULT NULL COMMENT 'ID in Unternehmensverzeichnis', `EBIDStatus` varchar(27) DEFAULT 'nicht geprüft' COMMENT 'Check status of contact with Unternehmensverzeichnis', `UVZHasDifferentData` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Unternehmensverzeichnis has different data', `UVZLastCheck` datetime DEFAULT NULL COMMENT 'Last check of EBIDNumber or differing data in Unternehmensverzeichnis', `FANCOMMITMENT` int(11) DEFAULT NULL COMMENT 'see forum mainz', `FANSATISFACTION` int(11) DEFAULT NULL COMMENT 'see forum mainz', `FANPORTFOLIO` varbinary(17) DEFAULT NULL COMMENT 'see forum mainz', `GeoCodeStatus` varbinary(17) DEFAULT NULL, `GeoTileId` varchar(30) DEFAULT NULL COMMENT 'ID of a tile, i.e. a hierarchically numbered part of a map', `Longitude` double(12,9) DEFAULT NULL, `Latitude` double(12,9) DEFAULT NULL, `keepFieldsSychronized` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'See SDCOPEN-1453', `ADDRESSCHECKSTATUS` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`GGUID`), KEY `IDX_ADDRESS_InsertTimestamp` (`InsertTimestamp`), KEY `IDX_ADDRESS_UpdateTimestamp` (`UpdateTimestamp`), KEY `IDX_Birthday8` (`BIRTHDAY`), KEY `IDX_Name3` (`NAME`), KEY `IDX_Town15` (`TOWN1`), KEY `IDX_ADR_ChristianName` (`CHRISTIANNAME`), KEY `IDX_Address0_Town2` (`TOWN2`), KEY `IDX_Address0_Town3` (`TOWN3`), KEY `IDX_Address0_Town4` (`TOWN4`), KEY `IDX_Address0_IsOrganisation` (`ISORGANISATION`), KEY `IDX_ADDRESS_PRIMARYORGANISATION` (`PRIMARYORGANISATION`), KEY `IDX_ADDRESS0_Mail1` (`MAILFIELDSTR1`), KEY `IDX_ADDRESS0_Mail2` (`MAILFIELDSTR2`), KEY `IDX_ADDRESS0_Mail3` (`MAILFIELDSTR3`), KEY `IDX_ADDRESS0_Mail5` (`MAILFIELDSTR5`), KEY `IDX_ADDRESS0_CUSTOMERID` (`CUSTOMERID`), KEY `IDX_CompName1` (`COMPNAME`(50)), KEY `idx_ADDRESS_PhoneID2_CompName_Name_ChristianName` (`PHONEID2`,`COMPNAME`(50),`NAME`(50),`CHRISTIANNAME`), KEY `idx_ADDRESS_PhoneID3_CompName_Name_ChristianName` (`PHONEID3`,`COMPNAME`(50),`NAME`(50),`CHRISTIANNAME`), KEY `idx_ADDRESS_PhoneID4_CompName_Name_ChristianName` (`PHONEID4`,`COMPNAME`(50),`NAME`(50),`CHRISTIANNAME`), KEY `idx_ADDRESS_PhoneID5_CompName_Name_ChristianName` (`PHONEID5`,`COMPNAME`(50),`NAME`(50),`CHRISTIANNAME`), KEY `idx_ADDRESS_PhoneID7_CompName_Name_ChristianName` (`PHONEID7`,`COMPNAME`(50),`NAME`(50),`CHRISTIANNAME`), KEY `idx_ADDRESS_PhoneID9_CompName_Name_ChristianName` (`PHONEID9`,`COMPNAME`(50),`NAME`(50),`CHRISTIANNAME`), KEY `idx_ADDRESS_PhoneID10_CompName_Name_ChristianName` (`PHONEID10`,`COMPNAME`(50),`NAME`(50),`CHRISTIANNAME`), KEY `IDX_LINKEDUSERID` (`LINKEDUSERID`), KEY `IDX_EBIDSTATUS` (`EBIDStatus`), KEY `IDX_UVZLASTCHECK` (`UVZLastCheck`) ) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
      
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                kevg Eugene Kosov
                Reporter:
                martin.kirchner@cas.de Martin Kirchner
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: