Valerii Kravchuk added a comment - 2016-07-13 08:13 MDEV-10165 , even though it's based on the same test case, is about different problem. So, this is NOT a duplicate. I'll confirm this on MariaDB 10.1.15 soon formally.

Valerii Kravchuk added a comment - 2016-07-13 08:30 So, on MariaDB 10.1.15 I get the following useless ERROR and table is not created as soon as I add row_format=DYNAMIC as previous warnings suggested: ... -> COLUMN303 VARCHAR(3), -> COLUMN304 DECIMAL(30,10), -> COLUMN305 DATE, -> COLUMN306 VARCHAR(63), -> COLUMN307 TEXT(630), -> COLUMN308 VARCHAR(63), -> COLUMN309 VARCHAR(255), -> COLUMN310 VARCHAR(3), -> COLUMN311 VARCHAR(3), -> CREATED_DATE DATETIME(6), -> ENTITY_ID VARCHAR(20), -> CONSTRAINT test_PK PRIMARY KEY (test_ID) -> ) engine=InnoDB row_format=DYNAMIC; ERROR 1118 (42000): 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. MariaDB [test]> select version(); +-----------------+ | version() | +-----------------+ | 10.1.15-MariaDB | +-----------------+ 1 row in set (0.00 sec)   MariaDB [test]> show variables like 'char%'; +--------------------------+--------------------------------------------+ | Variable_name | Value | +--------------------------+--------------------------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /home/openxs/dbs/maria10.1/share/charsets/ | +--------------------------+--------------------------------------------+ 8 rows in set (0.00 sec)   MariaDB [test]> I think this is related to upstream https://bugs.mysql.com/bug.php?id=79941

ManasaTulluri added a comment - 2016-09-08 09:05 - edited Hi, Currently we have ignored the warning...and still testing if there are any issues with data loading..Kindly let us know if there is any enhancement or any other fix to resolve the below warning ? 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.

Geoff Montee (Inactive) added a comment - 2019-08-14 19:14 Manasa , 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-storage-formats/#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 normally 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 test ( test_ID INT AUTO_INCREMENT NOT NULL, COLUMN1 VARCHAR(10), COLUMN2 VARCHAR(20), COLUMN3 VARCHAR(63), COLUMN4 VARCHAR(63), COLUMN5 VARCHAR(40), COLUMN6 VARCHAR(63), COLUMN7 VARCHAR(40), COLUMN8 VARCHAR(80), COLUMN9 VARCHAR(40), COLUMN10 VARCHAR(40), COLUMN11 DATE, COLUMN12 VARCHAR(15), COLUMN13 VARCHAR(40), COLUMN14 VARCHAR(241), COLUMN15 VARCHAR(241), COLUMN16 DATE, COLUMN17 DATETIME(6), COLUMN18 DATE, COLUMN19 VARCHAR(3), COLUMN20 DATETIME(6), COLUMN21 DATETIME(6), COLUMN22 VARCHAR(63), COLUMN23 VARCHAR(63), COLUMN24 VARCHAR(255), COLUMN25 VARCHAR(63), COLUMN26 VARCHAR(40), COLUMN27 VARCHAR(80), COLUMN28 VARCHAR(63), COLUMN29 VARCHAR(40), COLUMN30 VARCHAR(80), COLUMN31 VARCHAR(3), COLUMN32 DECIMAL(30,10), COLUMN33 DATE, COLUMN34 VARCHAR(63), COLUMN35 TEXT(630), COLUMN36 VARCHAR(40), COLUMN37 VARCHAR(241), COLUMN38 VARCHAR(3), COLUMN39 VARCHAR(241), COLUMN40 VARCHAR(241), COLUMN41 VARCHAR(241), COLUMN42 VARCHAR(63), COLUMN43 VARCHAR(40), COLUMN44 VARCHAR(3), COLUMN45 VARCHAR(63), COLUMN46 VARCHAR(63), COLUMN47 VARCHAR(40), COLUMN48 VARCHAR(80), COLUMN49 VARCHAR(63), COLUMN50 VARCHAR(40), COLUMN51 VARCHAR(80), COLUMN52 VARCHAR(63), COLUMN53 VARCHAR(40), COLUMN54 VARCHAR(80), COLUMN55 VARCHAR(63), COLUMN56 VARCHAR(40), COLUMN57 VARCHAR(80), COLUMN58 VARCHAR(63), COLUMN59 VARCHAR(40), COLUMN60 VARCHAR(80), COLUMN61 VARCHAR(63), COLUMN62 VARCHAR(40), COLUMN63 VARCHAR(80), COLUMN64 VARCHAR(63), COLUMN65 VARCHAR(40), COLUMN66 VARCHAR(80), COLUMN67 VARCHAR(255), COLUMN68 VARCHAR(255), COLUMN69 VARCHAR(63), COLUMN70 VARCHAR(63), COLUMN71 DATETIME(6), COLUMN72 VARCHAR(63), COLUMN73 VARCHAR(40), COLUMN74 VARCHAR(80), COLUMN75 VARCHAR(63), COLUMN76 VARCHAR(40), COLUMN77 VARCHAR(80), COLUMN78 VARCHAR(255), COLUMN79 VARCHAR(3), COLUMN80 VARCHAR(255), COLUMN81 VARCHAR(63), COLUMN82 VARCHAR(63), COLUMN83 VARCHAR(40), COLUMN84 VARCHAR(80), COLUMN85 VARCHAR(63), COLUMN86 VARCHAR(40), COLUMN87 VARCHAR(80), COLUMN88 VARCHAR(63), COLUMN89 VARCHAR(63), COLUMN90 VARCHAR(3), COLUMN91 VARCHAR(3), COLUMN92 DATETIME(6), COLUMN93 DATETIME(6), COLUMN94 VARCHAR(255), COLUMN95 VARCHAR(255), COLUMN96 DATE, COLUMN97 VARCHAR(63), COLUMN98 VARCHAR(276), COLUMN99 VARCHAR(63), COLUMN100 VARCHAR(40), COLUMN101 VARCHAR(80), COLUMN102 VARCHAR(63), COLUMN103 VARCHAR(40), COLUMN104 VARCHAR(80), COLUMN105 VARCHAR(63), COLUMN106 VARCHAR(40), COLUMN107 VARCHAR(80), COLUMN108 VARCHAR(63), COLUMN109 VARCHAR(40), COLUMN110 VARCHAR(80), COLUMN111 VARCHAR(63), COLUMN112 VARCHAR(63), COLUMN113 VARCHAR(63), COLUMN114 VARCHAR(40), COLUMN115 VARCHAR(80), COLUMN116 VARCHAR(3), COLUMN117 DECIMAL(30,10), COLUMN118 DECIMAL(8,7), COLUMN119 VARCHAR(63), COLUMN120 VARCHAR(40), COLUMN121 VARCHAR(80), COLUMN122 VARCHAR(3), COLUMN123 DECIMAL(30,10), COLUMN124 DECIMAL(8,7), COLUMN125 VARCHAR(241), COLUMN126 VARCHAR(3), COLUMN127 DECIMAL(30,10), COLUMN128 VARCHAR(3), COLUMN129 DECIMAL(30,10), COLUMN130 VARCHAR(255), COLUMN131 VARCHAR(255), COLUMN132 VARCHAR(63), COLUMN133 VARCHAR(63), COLUMN134 DATE, COLUMN135 DATE, COLUMN136 VARCHAR(315), COLUMN137 VARCHAR(63), COLUMN138 VARCHAR(40), COLUMN139 VARCHAR(80), COLUMN140 VARCHAR(63), COLUMN141 VARCHAR(40), COLUMN142 VARCHAR(80), COLUMN143 VARCHAR(3), COLUMN144 DECIMAL(30,10), COLUMN145 DATE, COLUMN146 VARCHAR(63), COLUMN147 TEXT(630), COLUMN148 DATE, COLUMN149 VARCHAR(63), COLUMN150 TEXT(630), COLUMN151 VARCHAR(63), COLUMN152 TEXT(630), COLUMN153 VARCHAR(63), COLUMN154 VARCHAR(4), COLUMN155 VARCHAR(63), COLUMN156 VARCHAR(4), COLUMN157 VARCHAR(63), COLUMN158 VARCHAR(4), COLUMN159 VARCHAR(63), COLUMN160 VARCHAR(63), COLUMN161 TEXT(630), COLUMN162 VARCHAR(63), COLUMN163 VARCHAR(4), COLUMN164 VARCHAR(63), COLUMN165 VARCHAR(63), COLUMN166 TEXT(630), COLUMN167 VARCHAR(4), COLUMN168 VARCHAR(63), COLUMN169 VARCHAR(63), COLUMN170 TEXT(630), COLUMN171 VARCHAR(4), COLUMN172 VARCHAR(63), COLUMN173 VARCHAR(4), COLUMN174 VARCHAR(63), COLUMN175 VARCHAR(63), COLUMN176 TEXT(630), COLUMN177 VARCHAR(63), COLUMN178 VARCHAR(4), COLUMN179 DECIMAL(28,10), COLUMN180 VARCHAR(63), COLUMN181 DECIMAL(8,7), COLUMN182 VARCHAR(63), COLUMN183 DECIMAL(1,0), COLUMN184 VARCHAR(63), COLUMN185 VARCHAR(63), COLUMN186 VARCHAR(63), COLUMN187 VARCHAR(63), COLUMN188 DATE, COLUMN189 DATE, COLUMN190 VARCHAR(63), COLUMN191 TEXT(630), COLUMN192 DATE, COLUMN193 DATE, COLUMN194 DATE, COLUMN195 DATE, COLUMN196 VARCHAR(63), COLUMN197 VARCHAR(4), COLUMN198 VARCHAR(63), COLUMN199 VARCHAR(4), COLUMN200 DECIMAL(8,7), COLUMN201 VARCHAR(3), COLUMN202 DECIMAL(30,10), COLUMN203 VARCHAR(63), COLUMN204 VARCHAR(4), COLUMN205 VARCHAR(63), COLUMN206 VARCHAR(4), COLUMN207 DECIMAL(8,7), COLUMN208 VARCHAR(3), COLUMN209 DECIMAL(30,10), COLUMN210 DATE, COLUMN211 VARCHAR(63), COLUMN212 TEXT(630), COLUMN213 DATE, COLUMN214 VARCHAR(63), COLUMN215 TEXT(630), COLUMN216 VARCHAR(63), COLUMN217 TEXT(630), COLUMN218 VARCHAR(63), COLUMN219 VARCHAR(4), COLUMN220 VARCHAR(63), COLUMN221 VARCHAR(4), COLUMN222 VARCHAR(63), COLUMN223 VARCHAR(4), COLUMN224 VARCHAR(63), COLUMN225 VARCHAR(63), COLUMN226 TEXT(630), COLUMN227 DECIMAL(18,12), COLUMN228 VARCHAR(63), COLUMN229 DATE, COLUMN230 VARCHAR(63), COLUMN231 TEXT(630), COLUMN232 DATE, COLUMN233 DATE, COLUMN234 DATE, COLUMN235 DATE, COLUMN236 VARCHAR(3), COLUMN237 DECIMAL(30,10), COLUMN238 VARCHAR(3), COLUMN239 DECIMAL(30,10), COLUMN240 VARCHAR(3), COLUMN241 VARCHAR(3), COLUMN242 VARCHAR(63), COLUMN243 VARCHAR(40), COLUMN244 VARCHAR(80), COLUMN245 VARCHAR(63), COLUMN246 VARCHAR(40), COLUMN247 VARCHAR(80), COLUMN248 VARCHAR(3), COLUMN249 DECIMAL(30,10), COLUMN250 DATE, COLUMN251 VARCHAR(63), COLUMN252 TEXT(630), COLUMN253 VARCHAR(63), COLUMN254 VARCHAR(40), COLUMN255 VARCHAR(80), COLUMN256 VARCHAR(63), COLUMN257 VARCHAR(40), COLUMN258 VARCHAR(80), COLUMN259 VARCHAR(3), COLUMN260 DECIMAL(30,10), COLUMN261 DATE, COLUMN262 VARCHAR(63), COLUMN263 TEXT(630), COLUMN264 VARCHAR(63), COLUMN265 VARCHAR(40), COLUMN266 VARCHAR(80), COLUMN267 VARCHAR(63), COLUMN268 VARCHAR(40), COLUMN269 VARCHAR(80), COLUMN270 VARCHAR(3), COLUMN271 DECIMAL(30,10), COLUMN272 DATE, COLUMN273 VARCHAR(63), COLUMN274 TEXT(630), COLUMN275 VARCHAR(63), COLUMN276 VARCHAR(40), COLUMN277 VARCHAR(80), COLUMN278 VARCHAR(63), COLUMN279 VARCHAR(40), COLUMN280 VARCHAR(80), COLUMN281 VARCHAR(3), COLUMN282 DECIMAL(30,10), COLUMN283 DATE, COLUMN284 VARCHAR(63), COLUMN285 TEXT(630), COLUMN286 VARCHAR(63), COLUMN287 VARCHAR(40), COLUMN288 VARCHAR(80), COLUMN289 VARCHAR(63), COLUMN290 VARCHAR(40), COLUMN291 VARCHAR(80), COLUMN292 VARCHAR(3), COLUMN293 DECIMAL(30,10), COLUMN294 DATE, COLUMN295 VARCHAR(63), COLUMN296 TEXT(630), COLUMN297 VARCHAR(63), COLUMN298 VARCHAR(40), COLUMN299 VARCHAR(80), COLUMN300 VARCHAR(63), COLUMN301 VARCHAR(40), COLUMN302 VARCHAR(80), COLUMN303 VARCHAR(3), COLUMN304 DECIMAL(30,10), COLUMN305 DATE, COLUMN306 VARCHAR(63), COLUMN307 TEXT(630), COLUMN308 VARCHAR(63), COLUMN309 VARCHAR(255), COLUMN310 VARCHAR(3), COLUMN311 VARCHAR(3), CREATED_DATE DATETIME(6), ENTITY_ID VARCHAR(20), CONSTRAINT test_PK PRIMARY KEY (test_ID) ) ENGINE=InnoDB ROW_FORMAT=DYNAMIC DEFAULT CHARSET=utf8mb4; 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. However, this fails for your specific table in MariaDB 10.2.26: SET SESSION innodb_strict_mode=ON;   CREATE TABLE test ( test_ID INT AUTO_INCREMENT NOT NULL, COLUMN1 VARCHAR(64), COLUMN2 VARCHAR(64), COLUMN3 VARCHAR(64), COLUMN4 VARCHAR(64), COLUMN5 VARCHAR(64), COLUMN6 VARCHAR(64), COLUMN7 VARCHAR(64), COLUMN8 VARCHAR(80), COLUMN9 VARCHAR(64), COLUMN10 VARCHAR(64), COLUMN11 DATE, COLUMN12 VARCHAR(64), COLUMN13 VARCHAR(64), COLUMN14 VARCHAR(241), COLUMN15 VARCHAR(241), COLUMN16 DATE, COLUMN17 DATETIME(6), COLUMN18 DATE, COLUMN19 VARCHAR(64), COLUMN20 DATETIME(6), COLUMN21 DATETIME(6), COLUMN22 VARCHAR(64), COLUMN23 VARCHAR(64), COLUMN24 VARCHAR(255), COLUMN25 VARCHAR(64), COLUMN26 VARCHAR(64), COLUMN27 VARCHAR(80), COLUMN28 VARCHAR(64), COLUMN29 VARCHAR(64), COLUMN30 VARCHAR(80), COLUMN31 VARCHAR(64), COLUMN32 DECIMAL(30,10), COLUMN33 DATE, COLUMN34 VARCHAR(64), COLUMN35 TEXT(630), COLUMN36 VARCHAR(64), COLUMN37 VARCHAR(241), COLUMN38 VARCHAR(64), COLUMN39 VARCHAR(241), COLUMN40 VARCHAR(241), COLUMN41 VARCHAR(241), COLUMN42 VARCHAR(64), COLUMN43 VARCHAR(64), COLUMN44 VARCHAR(64), COLUMN45 VARCHAR(64), COLUMN46 VARCHAR(64), COLUMN47 VARCHAR(64), COLUMN48 VARCHAR(80), COLUMN49 VARCHAR(64), COLUMN50 VARCHAR(64), COLUMN51 VARCHAR(80), COLUMN52 VARCHAR(64), COLUMN53 VARCHAR(64), COLUMN54 VARCHAR(80), COLUMN55 VARCHAR(64), COLUMN56 VARCHAR(64), COLUMN57 VARCHAR(80), COLUMN58 VARCHAR(64), COLUMN59 VARCHAR(64), COLUMN60 VARCHAR(80), COLUMN61 VARCHAR(64), COLUMN62 VARCHAR(64), COLUMN63 VARCHAR(80), COLUMN64 VARCHAR(64), COLUMN65 VARCHAR(64), COLUMN66 VARCHAR(80), COLUMN67 VARCHAR(255), COLUMN68 VARCHAR(255), COLUMN69 VARCHAR(64), COLUMN70 VARCHAR(64), COLUMN71 DATETIME(6), COLUMN72 VARCHAR(64), COLUMN73 VARCHAR(64), COLUMN74 VARCHAR(80), COLUMN75 VARCHAR(64), COLUMN76 VARCHAR(64), COLUMN77 VARCHAR(80), COLUMN78 VARCHAR(255), COLUMN79 VARCHAR(64), COLUMN80 VARCHAR(255), COLUMN81 VARCHAR(64), COLUMN82 VARCHAR(64), COLUMN83 VARCHAR(64), COLUMN84 VARCHAR(80), COLUMN85 VARCHAR(64), COLUMN86 VARCHAR(64), COLUMN87 VARCHAR(80), COLUMN88 VARCHAR(64), COLUMN89 VARCHAR(64), COLUMN90 VARCHAR(64), COLUMN91 VARCHAR(64), COLUMN92 DATETIME(6), COLUMN93 DATETIME(6), COLUMN94 VARCHAR(255), COLUMN95 VARCHAR(255), COLUMN96 DATE, COLUMN97 VARCHAR(64), COLUMN98 VARCHAR(276), COLUMN99 VARCHAR(64), COLUMN100 VARCHAR(64), COLUMN101 VARCHAR(80), COLUMN102 VARCHAR(64), COLUMN103 VARCHAR(64), COLUMN104 VARCHAR(80), COLUMN105 VARCHAR(64), COLUMN106 VARCHAR(64), COLUMN107 VARCHAR(80), COLUMN108 VARCHAR(64), COLUMN109 VARCHAR(64), COLUMN110 VARCHAR(80), COLUMN111 VARCHAR(64), COLUMN112 VARCHAR(64), COLUMN113 VARCHAR(64), COLUMN114 VARCHAR(64), COLUMN115 VARCHAR(80), COLUMN116 VARCHAR(64), COLUMN117 DECIMAL(30,10), COLUMN118 DECIMAL(8,7), COLUMN119 VARCHAR(64), COLUMN120 VARCHAR(64), COLUMN121 VARCHAR(80), COLUMN122 VARCHAR(64), COLUMN123 DECIMAL(30,10), COLUMN124 DECIMAL(8,7), COLUMN125 VARCHAR(241), COLUMN126 VARCHAR(64), COLUMN127 DECIMAL(30,10), COLUMN128 VARCHAR(64), COLUMN129 DECIMAL(30,10), COLUMN130 VARCHAR(255), COLUMN131 VARCHAR(255), COLUMN132 VARCHAR(64), COLUMN133 VARCHAR(64), COLUMN134 DATE, COLUMN135 DATE, COLUMN136 VARCHAR(315), COLUMN137 VARCHAR(64), COLUMN138 VARCHAR(64), COLUMN139 VARCHAR(80), COLUMN140 VARCHAR(64), COLUMN141 VARCHAR(64), COLUMN142 VARCHAR(80), COLUMN143 VARCHAR(64), COLUMN144 DECIMAL(30,10), COLUMN145 DATE, COLUMN146 VARCHAR(64), COLUMN147 TEXT(630), COLUMN148 DATE, COLUMN149 VARCHAR(64), COLUMN150 TEXT(630), COLUMN151 VARCHAR(64), COLUMN152 TEXT(630), COLUMN153 VARCHAR(64), COLUMN154 VARCHAR(64), COLUMN155 VARCHAR(64), COLUMN156 VARCHAR(64), COLUMN157 VARCHAR(64), COLUMN158 VARCHAR(64), COLUMN159 VARCHAR(64), COLUMN160 VARCHAR(64), COLUMN161 TEXT(630), COLUMN162 VARCHAR(64), COLUMN163 VARCHAR(64), COLUMN164 VARCHAR(64), COLUMN165 VARCHAR(64), COLUMN166 TEXT(630), COLUMN167 VARCHAR(64), COLUMN168 VARCHAR(64), COLUMN169 VARCHAR(64), COLUMN170 TEXT(630), COLUMN171 VARCHAR(64), COLUMN172 VARCHAR(64), COLUMN173 VARCHAR(64), COLUMN174 VARCHAR(64), COLUMN175 VARCHAR(64), COLUMN176 TEXT(630), COLUMN177 VARCHAR(64), COLUMN178 VARCHAR(64), COLUMN179 DECIMAL(28,10), COLUMN180 VARCHAR(64), COLUMN181 DECIMAL(8,7), COLUMN182 VARCHAR(64), COLUMN183 DECIMAL(1,0), COLUMN184 VARCHAR(64), COLUMN185 VARCHAR(64), COLUMN186 VARCHAR(64), COLUMN187 VARCHAR(64), COLUMN188 DATE, COLUMN189 DATE, COLUMN190 VARCHAR(64), COLUMN191 TEXT(630), COLUMN192 DATE, COLUMN193 DATE, COLUMN194 DATE, COLUMN195 DATE, COLUMN196 VARCHAR(64), COLUMN197 VARCHAR(64), COLUMN198 VARCHAR(64), COLUMN199 VARCHAR(64), COLUMN200 DECIMAL(8,7), COLUMN201 VARCHAR(64), COLUMN202 DECIMAL(30,10), COLUMN203 VARCHAR(64), COLUMN204 VARCHAR(64), COLUMN205 VARCHAR(64), COLUMN206 VARCHAR(64), COLUMN207 DECIMAL(8,7), COLUMN208 VARCHAR(64), COLUMN209 DECIMAL(30,10), COLUMN210 DATE, COLUMN211 VARCHAR(64), COLUMN212 TEXT(630), COLUMN213 DATE, COLUMN214 VARCHAR(64), COLUMN215 TEXT(630), COLUMN216 VARCHAR(64), COLUMN217 TEXT(630), COLUMN218 VARCHAR(64), COLUMN219 VARCHAR(64), COLUMN220 VARCHAR(64), COLUMN221 VARCHAR(64), COLUMN222 VARCHAR(64), COLUMN223 VARCHAR(64), COLUMN224 VARCHAR(64), COLUMN225 VARCHAR(64), COLUMN226 TEXT(630), COLUMN227 DECIMAL(18,12), COLUMN228 VARCHAR(64), COLUMN229 DATE, COLUMN230 VARCHAR(64), COLUMN231 TEXT(630), COLUMN232 DATE, COLUMN233 DATE, COLUMN234 DATE, COLUMN235 DATE, COLUMN236 VARCHAR(64), COLUMN237 DECIMAL(30,10), COLUMN238 VARCHAR(64), COLUMN239 DECIMAL(30,10), COLUMN240 VARCHAR(64), COLUMN241 VARCHAR(64), COLUMN242 VARCHAR(64), COLUMN243 VARCHAR(64), COLUMN244 VARCHAR(80), COLUMN245 VARCHAR(64), COLUMN246 VARCHAR(64), COLUMN247 VARCHAR(80), COLUMN248 VARCHAR(64), COLUMN249 DECIMAL(30,10), COLUMN250 DATE, COLUMN251 VARCHAR(64), COLUMN252 TEXT(630), COLUMN253 VARCHAR(64), COLUMN254 VARCHAR(64), COLUMN255 VARCHAR(80), COLUMN256 VARCHAR(64), COLUMN257 VARCHAR(64), COLUMN258 VARCHAR(80), COLUMN259 VARCHAR(64), COLUMN260 DECIMAL(30,10), COLUMN261 DATE, COLUMN262 VARCHAR(64), COLUMN263 TEXT(630), COLUMN264 VARCHAR(64), COLUMN265 VARCHAR(64), COLUMN266 VARCHAR(80), COLUMN267 VARCHAR(64), COLUMN268 VARCHAR(64), COLUMN269 VARCHAR(80), COLUMN270 VARCHAR(64), COLUMN271 DECIMAL(30,10), COLUMN272 DATE, COLUMN273 VARCHAR(64), COLUMN274 TEXT(630), COLUMN275 VARCHAR(64), COLUMN276 VARCHAR(64), COLUMN277 VARCHAR(80), COLUMN278 VARCHAR(64), COLUMN279 VARCHAR(64), COLUMN280 VARCHAR(80), COLUMN281 VARCHAR(64), COLUMN282 DECIMAL(30,10), COLUMN283 DATE, COLUMN284 VARCHAR(64), COLUMN285 TEXT(630), COLUMN286 VARCHAR(64), COLUMN287 VARCHAR(64), COLUMN288 VARCHAR(80), COLUMN289 VARCHAR(64), COLUMN290 VARCHAR(64), COLUMN291 VARCHAR(80), COLUMN292 VARCHAR(64), COLUMN293 DECIMAL(30,10), COLUMN294 DATE, COLUMN295 VARCHAR(64), COLUMN296 TEXT(630), COLUMN297 VARCHAR(64), COLUMN298 VARCHAR(64), COLUMN299 VARCHAR(80), COLUMN300 VARCHAR(64), COLUMN301 VARCHAR(64), COLUMN302 VARCHAR(80), COLUMN303 VARCHAR(64), COLUMN304 DECIMAL(30,10), COLUMN305 DATE, COLUMN306 VARCHAR(64), COLUMN307 TEXT(630), COLUMN308 VARCHAR(64), COLUMN309 VARCHAR(255), COLUMN310 VARCHAR(64), COLUMN311 VARCHAR(64), CREATED_DATE DATETIME(6), ENTITY_ID VARCHAR(64), CONSTRAINT test_PK PRIMARY KEY (test_ID) ) ENGINE=InnoDB ROW_FORMAT=DYNAMIC DEFAULT CHARSET=utf8mb4; The problem is that it runs into MariaDB's global maximum row size limit: 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 manual. You have to change some columns to TEXT or BLOBs https://mariadb.com/kb/en/library/innodb-storage-formats/#maximum-row-size As an alternative, you may want to consider breaking up this table into multiple tables, or upgrading to MariaDB 10.2 or later and using JSON: https://mariadb.com/kb/en/library/json-data-type/

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