Your browser was unable to load all of the resources. They may have been blocked by your firewall, proxy or browser configuration.
Press Ctrl+F5 or Ctrl+Shift+R to have your browser try again.

MySQLSyntaxErrorException: Row size too large #20

arthurhenrique · 6 years ago

I've got this MySQL Exception when running a JOB that contains several Sync Step to Perforce.

In a specific step raises this exception:
Caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

Please, What can I have to change to solve this?

Quickbuild version 6.1

replies 4
views 1839
stars 0

robinshen ADMIN · 6 years ago

QB6.1 is pretty old. Please test with QB9 to see if the issue still exist.

1 Reply

arthurhenrique · 6 years ago

This would be great, but I'm not have this option. :sweat:

arthurhenrique · 6 years ago

I fix that problem altering table qb_build and qb_configuration to row_format = compressed.
Thank you.

WEAVER · 6 years ago

I struggled with the same error code recently, due to a change in MySQL Server 5.6.20. I was able to solve the problem by changing the innodb_log_file_size in the my.ini text file.