MySQL error 2006: mysql server has gone away

Avatar
  • updated
  • Answered

MySQL error 2006: mysql server has gone awayWhen upgrading SuiteCRM, the process fails.

SuiteCRm Logs show:
Mon Jul 15 09:51:13 2019 [1802307][1][FATAL] Query Failed: CREATE TABLE temp (id varchar(36)): MySQL error 2006: MySQL server has gone awayMon Jul 15 09:51:13 2019 [1802307][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone awayMon Jul 15 09:51:13 2019 [1802307][1][FATAL] Mysqli_query failed.Mon Jul 15 09:51:13 2019 [1802307][1][FATAL] Query Failed: INSERT INTO temp (id) VALUES ('abcdef0123456789abcdef0123456789abcd'): MySQL error 2006: MySQL server has gone awayMon Jul 15 09:51:13 2019 [1802307][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone awayMon Jul 15 09:51:13 2019 [1802307][1][FATAL] Mysqli_query failed.Mon Jul 15 09:51:13 2019 [1802307][1][FATAL] Query Failed: UPDATE temp SET id = '100000000000000000000000000000000000' WHERE id = 'abcdef0123456789abcdef0123456789abcd': MySQL error 2006: MySQL server has gone awayMon Jul 15 09:51:13 2019 [1802307][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone awayMon Jul 15 09:51:13 2019 [1802307][1][FATAL] Mysqli_query failed.Mon Jul 15 09:51:13 2019 [1802307][1][FATAL] Query Failed: SELECT id FROM temp WHERE id='100000000000000000000000000000000000' LIMIT 0,1: MySQL error 2006: MySQL server has gone awayMon Jul 15 09:51:13 2019 [1802307][1][FATAL] Get One Failed:SELECT id FROM temp WHERE id='100000000000000000000000000000000000': MySQL error 2006: MySQL server has gone awayMon Jul 15 09:51:13 2019 [1802307][1][FATAL] Mysqli_query failed.Mon Jul 15 09:51:13 2019 [1802307][1][FATAL] Query Failed: DELETE FROM temp WHERE id = '100000000000000000000000000000000000': MySQL error 2006: MySQL server has gone away



Avatar
JT S.
  • Answered

I recommend contacting Live Support with more info on how you got the error.