When validating or uploading a large data set, you may encounter the following error:
This means that you need to modify the database timeout configuration so that the maximum allowed packet is increased, but this is done at the DBMS level.
Resolving this issue requires an IT adminsitrator. It is due to the current server configuration.
You can resolve this by increasing the max_allowed_packet
for the server by modifying the my.cnf
file and/or increasing it globally:
-
In
mariadb
, the following command sets themax_allowed_packet
limit to 1024M globally temporarily (no restart required)–SET GLOBAL max_allowed_packet=1024M;
-
For a permanent solution, modify your
my.cnf
file where you can set it below the[mysql]
or[mariadb]
heading:[mysql] max_allowed_packet = 1024M
You should now be able to validate/upload your large data sets in the WorkBench without any problems!
Let us know if you need any help with this process!
If these solutions do not solve your issue, we reccomend looking at Stack Overflow or other sites which may have useful instructions to resolve this problem.