After I upgraded MySQL from 5.6 to 5.7 on Ubuntu 14.04, I started to have this problem on certain action. As I understand, the problem is that I am trying to get row that is too big from the table.
So, I managed to solve this problem by limiting columns on select part which was originally using select *
.
However, I want to solve this problem by changing the setting. (Because I might be able to face a situation where many columns for select are required)
I have tried to change
innodb_strict_mode = 0
max_allowed_packet = 512M
innodb_log_file_size = 128M
innodb_log_buffer_size = 256M
innodb_file_per_table = ON
all these values but without any luck.
Any advice or suggestion would be appreciated. Thank you
TIMESTAMP
is the only column that I can think of that grew in size (4 bytes to 5).