webERP Forum
#2006 - MySQL server has gone away - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8)
+--- Thread: #2006 - MySQL server has gone away (/showthread.php?tid=8373)



#2006 - MySQL server has gone away - alanmi3833 - 10-15-2019

I am having trouble migrating my dataset to Linux getting the following error.
Running LinuxMint
RELEASE=19.1
CODENAME=tessa
EDITION="Cinnamon"
DESCRIPTION="Linux Mint 19.1 Tessa"
DESKTOP=Gnome
TOOLKIT=GTK
NEW_FEATURES_URL=https://www.linuxmint.com/rel_tessa_cinnamon_whatsnew.php
RELEASE_NOTES_URL=https://www.linuxmint.com/rel_tessa_cinnamon.php
USER_GUIDE_URL=https://www.linuxmint.com/documentation.php
GRUB_TITLE=Linux Mint 19.1 Cinnamon

See screenshot.
[attachment=1008]
Ok solved that one
Edit my.cnf and changed the following
Quote:max_allowed_packet=1M
to
Quote:max_allowed_packet=256M



RE: #2006 - MySQL server has gone away - TimSchofield - 10-15-2019

Hi Alan,

One possibility here is to increase the size of the max_allowed_packet setting. I am using Linux Mint, but use mariadb. On my system that setting is in the file /etc/mysql/mariadb.conf.d/50-server.cnf so you should find it somewhere like /etc/mysql/mysql.conf.d/50-server.cnf

By default it was set to 16M try increasing this to 60M. You will need to restart the mysql daemon after you change it.

Tim