MySQL: Packet for query is too large
When uploading a file into Cascade Server, users may see an
error similar to the following message:
An error occurred during editing: Error persisting this bean to storage:
com.mysql.jdbc.PacketTooBigException: Packet for query is too large
(####### > #######). You can change this value on the server by setting
the 'max_allowed_packet'variable.
This error means that the file being uploaded is greater than the maximum size allowed by MySQL.
To correct this problem, modify the max_allowed_packet value in the my.cnf/my.ini file (located in the root directory of MySQL) and specify a larger value. For example, in the [mysqld] section add:
max_allowed_packet=200M
MySQL will require a restart after this change has been made.