[MDEV-20346] Cannot create a certain table: Row size too large - Jira

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
Component/s: Server, Storage Engine - InnoDB
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

is duplicated by

MDEV-20256 "Row size too large" on latest release (10.3.17)

Closed

relates to

MDEV-16969 Fix error message as promised in upstream Bug #69336

Open

MDEV-19292 "Row size too large" error when creating table with lots columns when row format is DYNAMIC or COMPRESSED

Closed

MDEV-20448 Add link to release notes about "Row size too large" errors

Closed

MDEV-23521 Implement an InnoDB row format that can use overflow pages for smaller columns

Open

Activity

Ascending order - Click to sort in descending order

Geoff Montee (Inactive) added a comment - 2019-08-14 19:00 - edited

martin.kirchner@cas.de,

The problem here is that InnoDB has a maximum row size in MariaDB and MySQL that is roughly equivalent to half of innodb_page_size. InnoDB's row formats work around this problem by storing certain kinds of variable-length columns on overflow pages. However, different row formats can store different types of data on overflow pages. The DYNAMIC row format is the default row format in MariaDB 10.2 and later. For varchar columns, this row format can only store them on overflow pages if they are 256 bytes or longer:

All InnoDB row formats can store certain kinds of data in overflow pages. This allows for the maximum row size of an InnoDB table to be larger than the maximum amount of data that can be stored in the row's main data page. See Maximum Row Size for more information about the other factors that can contribute to the maximum row size for InnoDB tables.

In the DYNAMIC row format variable-length columns, such as columns using the VARBINARY, VARCHAR, BLOB and TEXT data types, can be completely stored in overflow pages.

InnoDB only considers using overflow pages if the table's row size is greater than half of innodb_page_size. If the row size is greater than this, then InnoDB chooses variable-length columns to be stored on overflow pages until the row size is less than half of innodb_page_size.

For BLOB and TEXT columns, only values longer than 40 bytes are considered for storage on overflow pages. For VARBINARY and VARCHAR columns, only values longer than 255 bytes are considered for storage on overflow pages. Bytes that are stored to track a value's length do not count towards these limits. These limits are only based on the length of the actual column's data.

These limits differ from the limits for the COMPACT row format, where the limit is 767 bytes for all types.

Fixed-length columns greater than 767 bytes are encoded as variable-length columns, so they can also be stored in overflow pages if the table's row size is greater than half of innodb_page_size. Even though a column using the CHAR data type can hold at most 255 characters, a CHAR column can still exceed 767 bytes in some cases. For example, a char(255) column can exceed 767 bytes if the character set is utf8mb4.

If a column is chosen to be stored on overflow pages, then the entire value of the column is stored on overflow pages, and only a 20-byte pointer to the column's first overflow page is stored on the main page. Each overflow page is the size of innodb_page_size. If a column is too large to be stored on a single overflow page, then it is stored on multiple overflow pages. Each overflow page contains part of the data and a 20-byte pointer to the next overflow page, if a next page exists.

This behavior differs from the behavior of the COMPACT row format, which always stores the column prefix on the main page. This allows tables using the DYNAMIC row format to contain a high number of columns using the VARBINARY, VARCHAR, BLOB and TEXT data types.

https://mariadb.com/kb/en/library/innodb-dynamic-row-format/#overflow-pages-with-the-dynamic-row-format

Prior to MariaDB 10.2.26, 10.3.17, and 10.4.7, MariaDB didn't properly calculate the row sizes while executing DDL, so "unsafe" tables could be created, even with innodb_strict_mode=ON set. This was fixed by ~~MDEV-19292~~. As a side effect, tables that could be created in previous versions may get rejected after the latest releases.

You have two options here:

1.) Disable InnoDB strict mode. i.e. this succeeds in MariaDB 10.2.26:

SET SESSION innodb_strict_mode=OFF;

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 ROW_FORMAT=DYNAMIC DEFAULT CHARSET=UTF8;

2.) Keep InnoDB strict mode enabled, but change some of those varchar(N) columns to varchar(N >= 256 bytes). If the table's default character set is UTF8, then that means that N would have to be 86 or more. i.e. this also succeeds in MariaDB 10.2.26:

SET SESSION innodb_strict_mode=ON;

CREATE TABLE `address0` (

`GGUID` binary(16) NOT NULL COMMENT 'Primary Key',

`InsertUser` varchar(86) NOT NULL COMMENT 'The person that created the record',

`UpdateUser` varchar(86) 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(256) 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(256) DEFAULT NULL,

`ADDRESSLETTER` varchar(150) DEFAULT NULL,

`ADDRESSTERM` varchar(86) DEFAULT NULL,

`BANKACCOUNTHOLDER` varchar(86) DEFAULT NULL,

`BANKACCOUNTNR` varchar(86) DEFAULT NULL,

`BANKZIPNR` varchar(86) DEFAULT NULL,

`BIRTHDAY` datetime DEFAULT NULL,

`CHECKEDBYUSERON` datetime DEFAULT NULL,

`CHRISTIANNAME` varchar(86) 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(86) DEFAULT NULL COMMENT 'Customer ID/number',

`DEPARTMENT` varchar(255) DEFAULT NULL,

`FAXFIELDSTR1` varchar(86) DEFAULT NULL,

`FAXFIELDSTR4` varchar(86) DEFAULT NULL,

`FAXFIELDSTR5` varchar(86) DEFAULT NULL,

`FINANCIALINSTITUTE` varchar(100) DEFAULT NULL,

`FIRSTCONTACT` varchar(86) 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(86) DEFAULT NULL,

`GWIBAN` varchar(86) DEFAULT NULL,

`GWNAMEPREFIX` varchar(86) DEFAULT NULL,

`GWSTATE1` varchar(86) DEFAULT NULL,

`GWSTATE2` varchar(86) DEFAULT NULL,

`GWSTATE3` varchar(86) DEFAULT NULL,

`GWSTATE4` varchar(86) 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(86) 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(86) DEFAULT NULL,

`MASTERADDRESSID2` varchar(86) DEFAULT NULL,

`MASTERADDRESSID3` varchar(86) DEFAULT NULL,

`MASTERADDRESSID4` varchar(86) 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(86) DEFAULT NULL,

`PHONEFIELDSTR10` varchar(86) DEFAULT NULL,

`PHONEFIELDSTR2` varchar(86) DEFAULT NULL,

`PHONEFIELDSTR3` varchar(86) DEFAULT NULL,

`PHONEFIELDSTR4` varchar(86) DEFAULT NULL,

`PHONEFIELDSTR5` varchar(86) DEFAULT NULL,

`PHONEFIELDSTR7` varchar(86) DEFAULT NULL,

`PHONEFIELDSTR9` varchar(86) DEFAULT NULL,

`PHONEID10` varchar(86) DEFAULT NULL,

`PHONEID2` varchar(86) DEFAULT NULL,

`PHONEID3` varchar(86) DEFAULT NULL,

`PHONEID4` varchar(86) DEFAULT NULL,

`PHONEID5` varchar(86) DEFAULT NULL,

`PHONEID7` varchar(86) DEFAULT NULL,

`PHONEID9` varchar(86) DEFAULT NULL,

`STANDARDPHONE1` int(11) DEFAULT NULL,

`STANDARDPHONE2` int(11) DEFAULT NULL,

`POBOX1` varchar(86) DEFAULT NULL,

`POBOX2` varchar(86) DEFAULT NULL,

`POBOX4` varchar(86) DEFAULT NULL,

`POBOXTOWN1` varchar(86) DEFAULT NULL COMMENT 'Town for POBOX1',

`POBOXTOWN2` varchar(86) DEFAULT NULL COMMENT 'Town for POBOX2',

`POBOXTOWN4` varchar(86) DEFAULT NULL COMMENT 'Town for POBOX4',

`POBOXZIP1` varchar(86) DEFAULT NULL,

`POBOXZIP2` varchar(86) DEFAULT NULL,

`POBOXZIP4` varchar(86) 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(86) DEFAULT NULL,

`STREET2` varchar(86) DEFAULT NULL,

`STREET3` varchar(86) DEFAULT NULL,

`STREET4` varchar(86) DEFAULT NULL,

`SUBURB1` varchar(86) DEFAULT NULL,

`SUBURB2` varchar(86) DEFAULT NULL,

`SUBURB3` varchar(86) DEFAULT NULL,

`SUBURB4` varchar(86) DEFAULT NULL,

`TITLE` varchar(86) DEFAULT NULL,

`TOWN1` varchar(86) DEFAULT NULL,

`TOWN2` varchar(86) DEFAULT NULL,

`TOWN3` varchar(86) DEFAULT NULL,

`TOWN4` varchar(86) DEFAULT NULL,

`TURNOVERTAXID` varchar(86) DEFAULT NULL,

`WWWFIELDSTR0` varchar(100) DEFAULT NULL,

`WWWFIELDSTR1` varchar(100) DEFAULT NULL,

`WWWFIELDSTR5` varchar(100) DEFAULT NULL,

`ZIP1` varchar(86) DEFAULT NULL,

`ZIP2` varchar(86) DEFAULT NULL,

`ZIP3` varchar(86) DEFAULT NULL,

`ZIP4` varchar(86) DEFAULT NULL,

`DEACTIVATED` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Indicates a deactivated address',

`CATEGORY` varbinary(256) DEFAULT NULL,

`BRANCH` varbinary(256) DEFAULT NULL,

`CLASSIFICATION` varbinary(256) DEFAULT NULL,

`ACTIVITY_TYPE_ALLOWED` varbinary(256) DEFAULT NULL,

`ACTIVITY_TYPE_PREFERRED` varbinary(256) DEFAULT NULL,

`RegistrationNumber` varchar(86) DEFAULT NULL,

`RegistrationCourt` varchar(86) DEFAULT NULL,

`EBIDNumber` varchar(86) DEFAULT NULL COMMENT 'ID in Unternehmensverzeichnis',

`EBIDStatus` varchar(86) 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(256) DEFAULT NULL COMMENT 'see forum mainz',

`GeoCodeStatus` varbinary(256) DEFAULT NULL,

`GeoTileId` varchar(86) 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 ROW_FORMAT=DYNAMIC DEFAULT CHARSET=UTF8;

See also:

https://mariadb.com/kb/en/library/innodb-row-formats-overview/#upgrading-causes-row-size-too-large-errors

https://mariadb.com/kb/en/library/troubleshooting-row-size-too-large-errors-with-innodb/

Geoff Montee (Inactive) added a comment - 2019-08-14 19:00 - edited martin.kirchner@cas.de , The problem here is that InnoDB has a maximum row size in MariaDB and MySQL that is roughly equivalent to half of innodb_page_size. InnoDB's row formats work around this problem by storing certain kinds of variable-length columns on overflow pages. However, different row formats can store different types of data on overflow pages. The DYNAMIC row format is the default row format in MariaDB 10.2 and later. For varchar columns, this row format can only store them on overflow pages if they are 256 bytes or longer: All InnoDB row formats can store certain kinds of data in overflow pages. This allows for the maximum row size of an InnoDB table to be larger than the maximum amount of data that can be stored in the row's main data page. See Maximum Row Size for more information about the other factors that can contribute to the maximum row size for InnoDB tables. In the DYNAMIC row format variable-length columns, such as columns using the VARBINARY, VARCHAR, BLOB and TEXT data types, can be completely stored in overflow pages. InnoDB only considers using overflow pages if the table's row size is greater than half of innodb_page_size. If the row size is greater than this, then InnoDB chooses variable-length columns to be stored on overflow pages until the row size is less than half of innodb_page_size. For BLOB and TEXT columns, only values longer than 40 bytes are considered for storage on overflow pages. For VARBINARY and VARCHAR columns, only values longer than 255 bytes are considered for storage on overflow pages. Bytes that are stored to track a value's length do not count towards these limits. These limits are only based on the length of the actual column's data. These limits differ from the limits for the COMPACT row format, where the limit is 767 bytes for all types. Fixed-length columns greater than 767 bytes are encoded as variable-length columns, so they can also be stored in overflow pages if the table's row size is greater than half of innodb_page_size. Even though a column using the CHAR data type can hold at most 255 characters, a CHAR column can still exceed 767 bytes in some cases. For example, a char(255) column can exceed 767 bytes if the character set is utf8mb4. If a column is chosen to be stored on overflow pages, then the entire value of the column is stored on overflow pages, and only a 20-byte pointer to the column's first overflow page is stored on the main page. Each overflow page is the size of innodb_page_size. If a column is too large to be stored on a single overflow page, then it is stored on multiple overflow pages. Each overflow page contains part of the data and a 20-byte pointer to the next overflow page, if a next page exists. This behavior differs from the behavior of the COMPACT row format, which always stores the column prefix on the main page. This allows tables using the DYNAMIC row format to contain a high number of columns using the VARBINARY, VARCHAR, BLOB and TEXT data types. https://mariadb.com/kb/en/library/innodb-dynamic-row-format/#overflow-pages-with-the-dynamic-row-format Prior to MariaDB 10.2.26, 10.3.17, and 10.4.7, MariaDB didn't properly calculate the row sizes while executing DDL, so "unsafe" tables could be created, even with innodb_strict_mode=ON set. This was fixed by MDEV-19292 . As a side effect, tables that could be created in previous versions may get rejected after the latest releases. You have two options here: 1.) Disable InnoDB strict mode. i.e. this succeeds in MariaDB 10.2.26: SET SESSION innodb_strict_mode=OFF; 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 ROW_FORMAT=DYNAMIC DEFAULT CHARSET=UTF8; 2.) Keep InnoDB strict mode enabled, but change some of those varchar(N) columns to varchar(N >= 256 bytes). If the table's default character set is UTF8, then that means that N would have to be 86 or more. i.e. this also succeeds in MariaDB 10.2.26: SET SESSION innodb_strict_mode=ON; CREATE TABLE `address0` ( `GGUID` binary(16) NOT NULL COMMENT 'Primary Key', `InsertUser` varchar(86) NOT NULL COMMENT 'The person that created the record', `UpdateUser` varchar(86) 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(256) 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(256) DEFAULT NULL, `ADDRESSLETTER` varchar(150) DEFAULT NULL, `ADDRESSTERM` varchar(86) DEFAULT NULL, `BANKACCOUNTHOLDER` varchar(86) DEFAULT NULL, `BANKACCOUNTNR` varchar(86) DEFAULT NULL, `BANKZIPNR` varchar(86) DEFAULT NULL, `BIRTHDAY` datetime DEFAULT NULL, `CHECKEDBYUSERON` datetime DEFAULT NULL, `CHRISTIANNAME` varchar(86) 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(86) DEFAULT NULL COMMENT 'Customer ID/number', `DEPARTMENT` varchar(255) DEFAULT NULL, `FAXFIELDSTR1` varchar(86) DEFAULT NULL, `FAXFIELDSTR4` varchar(86) DEFAULT NULL, `FAXFIELDSTR5` varchar(86) DEFAULT NULL, `FINANCIALINSTITUTE` varchar(100) DEFAULT NULL, `FIRSTCONTACT` varchar(86) 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(86) DEFAULT NULL, `GWIBAN` varchar(86) DEFAULT NULL, `GWNAMEPREFIX` varchar(86) DEFAULT NULL, `GWSTATE1` varchar(86) DEFAULT NULL, `GWSTATE2` varchar(86) DEFAULT NULL, `GWSTATE3` varchar(86) DEFAULT NULL, `GWSTATE4` varchar(86) 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(86) 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(86) DEFAULT NULL, `MASTERADDRESSID2` varchar(86) DEFAULT NULL, `MASTERADDRESSID3` varchar(86) DEFAULT NULL, `MASTERADDRESSID4` varchar(86) 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(86) DEFAULT NULL, `PHONEFIELDSTR10` varchar(86) DEFAULT NULL, `PHONEFIELDSTR2` varchar(86) DEFAULT NULL, `PHONEFIELDSTR3` varchar(86) DEFAULT NULL, `PHONEFIELDSTR4` varchar(86) DEFAULT NULL, `PHONEFIELDSTR5` varchar(86) DEFAULT NULL, `PHONEFIELDSTR7` varchar(86) DEFAULT NULL, `PHONEFIELDSTR9` varchar(86) DEFAULT NULL, `PHONEID10` varchar(86) DEFAULT NULL, `PHONEID2` varchar(86) DEFAULT NULL, `PHONEID3` varchar(86) DEFAULT NULL, `PHONEID4` varchar(86) DEFAULT NULL, `PHONEID5` varchar(86) DEFAULT NULL, `PHONEID7` varchar(86) DEFAULT NULL, `PHONEID9` varchar(86) DEFAULT NULL, `STANDARDPHONE1` int(11) DEFAULT NULL, `STANDARDPHONE2` int(11) DEFAULT NULL, `POBOX1` varchar(86) DEFAULT NULL, `POBOX2` varchar(86) DEFAULT NULL, `POBOX4` varchar(86) DEFAULT NULL, `POBOXTOWN1` varchar(86) DEFAULT NULL COMMENT 'Town for POBOX1', `POBOXTOWN2` varchar(86) DEFAULT NULL COMMENT 'Town for POBOX2', `POBOXTOWN4` varchar(86) DEFAULT NULL COMMENT 'Town for POBOX4', `POBOXZIP1` varchar(86) DEFAULT NULL, `POBOXZIP2` varchar(86) DEFAULT NULL, `POBOXZIP4` varchar(86) 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(86) DEFAULT NULL, `STREET2` varchar(86) DEFAULT NULL, `STREET3` varchar(86) DEFAULT NULL, `STREET4` varchar(86) DEFAULT NULL, `SUBURB1` varchar(86) DEFAULT NULL, `SUBURB2` varchar(86) DEFAULT NULL, `SUBURB3` varchar(86) DEFAULT NULL, `SUBURB4` varchar(86) DEFAULT NULL, `TITLE` varchar(86) DEFAULT NULL, `TOWN1` varchar(86) DEFAULT NULL, `TOWN2` varchar(86) DEFAULT NULL, `TOWN3` varchar(86) DEFAULT NULL, `TOWN4` varchar(86) DEFAULT NULL, `TURNOVERTAXID` varchar(86) DEFAULT NULL, `WWWFIELDSTR0` varchar(100) DEFAULT NULL, `WWWFIELDSTR1` varchar(100) DEFAULT NULL, `WWWFIELDSTR5` varchar(100) DEFAULT NULL, `ZIP1` varchar(86) DEFAULT NULL, `ZIP2` varchar(86) DEFAULT NULL, `ZIP3` varchar(86) DEFAULT NULL, `ZIP4` varchar(86) DEFAULT NULL, `DEACTIVATED` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Indicates a deactivated address', `CATEGORY` varbinary(256) DEFAULT NULL, `BRANCH` varbinary(256) DEFAULT NULL, `CLASSIFICATION` varbinary(256) DEFAULT NULL, `ACTIVITY_TYPE_ALLOWED` varbinary(256) DEFAULT NULL, `ACTIVITY_TYPE_PREFERRED` varbinary(256) DEFAULT NULL, `RegistrationNumber` varchar(86) DEFAULT NULL, `RegistrationCourt` varchar(86) DEFAULT NULL, `EBIDNumber` varchar(86) DEFAULT NULL COMMENT 'ID in Unternehmensverzeichnis', `EBIDStatus` varchar(86) 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(256) DEFAULT NULL COMMENT 'see forum mainz', `GeoCodeStatus` varbinary(256) DEFAULT NULL, `GeoTileId` varchar(86) 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 ROW_FORMAT=DYNAMIC DEFAULT CHARSET=UTF8; See also: https://mariadb.com/kb/en/library/innodb-row-formats-overview/#upgrading-causes-row-size-too-large-errors https://mariadb.com/kb/en/library/troubleshooting-row-size-too-large-errors-with-innodb/

Geoff Montee (Inactive) added a comment - 2019-08-14 19:20

I'll go ahead and close this one as a duplicate of ~~MDEV-20256~~.

Geoff Montee (Inactive) added a comment - 2019-08-14 19:20 I'll go ahead and close this one as a duplicate of MDEV-20256 .

People

Assignee:: Eugene Kosov (Inactive)

Reporter:: Martin Kirchner

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2019-08-14 13:20

Updated:: 2019-10-23 13:30

Resolved:: 2019-08-14 19:20

Git Integration

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

MariaDB Server