Solve `MySQL server has gone away` issue

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.

:woman_mechanic: 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 the max_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:

    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.