MYSQL server has gone away on MariaDB

Question

I was using a cron function where Server type was MySQL and faced no issues , However I recently migrated to a different server where : Server type: MariaDB

And I get this error : Query error: MySQL server has gone away

The SQL query I am using is not that big .

Please assist .

Possible duplicate of [ERROR 2006 (HY000): MySQL server has gone away](https://stackoverflow.com/questions/10474922/error-2006-hy000-mysql-server-has-gone-away) — Sᴀᴍ Onᴇᴌᴀ, Oct 10 '17 at 11:23
max_allowed_packet is set to: 1073741824 wait_timeout it set to 28800 — Ritika Arora, Oct 10 '17 at 11:27
trigger the error then check the logs using `$ tail /var/log/mysql/error.log` — Thomas G, Oct 10 '17 at 11:29
Is that the batch or the interactive, session or global, `wait_timeout`? — Rick James, Oct 10 '17 at 15:34

score -2 · Answer 1 · answered Oct 13 '17 at 06:37

-2

Hi Thanks for the comments , The Issue was from server side, The server was restarting itself and database connectivity was getting lost for that short period of time.

Thank You

answered Oct 13 '17 at 06:37

Ritika Arora

35
1
1
9

MYSQL server has gone away on MariaDB

1 Answers1