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.
Application
Views: 10