Error during Import of a room: Packet for query is too large
Issue Symptoms
Prerequisites: your platform must have “asset storage” in the database (mysql).
An error occurs during the import of a big room. In the logs, you have:
Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (3557 > 3072).
You can change this value on the server by setting the max_allowed_packet' variable.
Workaround
Connect to your mysql database with the root user account and run the following line:
mysql> SET GLOBAL max_allowed_packet=XXXX;
XXX corresponds to a new value in bits. For instance, to set the value to 10Mb you need to convert it in bits with the following formula: 10*1024*1024 = 10485760.
Prerequisites: your platform must have “asset storage” in the database (mysql).
An error occurs during the import of a big room. In the logs, you have:
Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (3557 > 3072).
You can change this value on the server by setting the max_allowed_packet' variable.
Workaround
Connect to your mysql database with the root user account and run the following line:
mysql> SET GLOBAL max_allowed_packet=XXXX;
XXX corresponds to a new value in bits. For instance, to set the value to 10Mb you need to convert it in bits with the following formula: 10*1024*1024 = 10485760.
Views: 72