92 Error during updrade to 10.0.2

Hi,

i was trying to install projeqtor 10.0.2 while installing i found issue,

Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1118 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

After debug i found database table CHARSET and COLLATE are changes to utf8mb4

there are some tables who have varchar columns with 4000 length those columns are causing this issue.

when i am trying with utf8 it working and causing error when its utf8mb4

CREATE TABLE `prepq_issue` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`idProject` int(12) unsigned DEFAULT NULL,
`name` varchar(100) DEFAULT NULL,
`description` varchar(4000) DEFAULT NULL,
`idIssueType` int(12) unsigned DEFAULT NULL,
`cause` varchar(4000) DEFAULT NULL,
`impact` varchar(4000) DEFAULT NULL,
`idPriority` int(12) unsigned DEFAULT NULL,
`creationDate` date DEFAULT NULL,
`idUser` int(12) unsigned DEFAULT NULL,
`idStatus` int(12) unsigned DEFAULT NULL,
`idResource` int(12) unsigned DEFAULT NULL,
`initialEndDate` date DEFAULT NULL,
`actualEndDate` date DEFAULT NULL,
`closureDate` date DEFAULT NULL,
`result` varchar(4000) DEFAULT NULL,
`comment` varchar(4000) DEFAULT NULL,
`idle` int(1) unsigned DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE utf8_general_ci ;

I think you should use small number for those varchars.present in opportunity, risk, issue  tables.


 

Hello,

For information, the MariaDB config you ask for is the default value since 10.2.2 (mariadb.com/kb/en/innodb-system-variable...b_default_row_format).

But I still have tried to set this parameter to MariaDB and I get the same errrors.

Regards,

Hi,

I tried to do what you suggested but i wasn't able to do
i got this error

#1193 - Unknown system variable 'innodb_default_row_format'

This is because "innodb_default_row_format" variable was Introduced in version 5.7.9 of MySQL, ( dev.mysql.com/doc/mysqld-version-referen...var-changes-5-7.html ) its not there in MySQL 5.6

And according to Compatibility Matrix projeqtor works on MySQL 5.6 ( www.projeqtor.org/en/product-en/technica...uct-prerequisites-en )

its also not working on Barracuda format of mysql 5.6.

Setting innodb_default_row_format to dynamic also not working on MySQL 5.7.37

65535 is a total size of all fields of table excluding BLOB and TEXT ( dev.mysql.com/doc/mysql-reslimits-excerp...umn-count-limit.html )

But 4000 x 4 = 16000 < 65535 this is not a case here
if i count only varchar(4000) of table that is 4000 x 4 x 5= 80000 > 65535