← Back to team overview

maria-discuss team mailing list archive

Row size too large

 

after upgrade the first testserver to 10.0.15:

InnoDB: The total blob data length (13476124) is greater than 10% of the redo log file size (5120). Please increase innodb_log_file_size.

* previously no problems
* stopped server
* increased innodb_log_file_size to 128MB
* deleted ib_logfile*
* started server
* the same again

why - that's only a small test-vm with not much data?
____________________________________________

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

MariaDB [dbmail]> show create table dbmail_mimeparts;
+------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table


                                             |
+------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| dbmail_mimeparts | CREATE TABLE `dbmail_mimeparts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `hash` char(128) NOT NULL,
  `data` longblob NOT NULL,
  `size` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `hash` (`hash`)
) ENGINE=InnoDB AUTO_INCREMENT=43391 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED |
+------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)


Attachment: signature.asc
Description: OpenPGP digital signature


Follow ups