Error: 2006 MySQL server has gone away
Hi!
I use this mysql:
(Synology NAS server)
Server: Localhost via UNIX socket
Server type: MariaDB
Server version: 5.5.34-MariaDB - Source distribution
Protokoll version: 10
I should use a big INSERT query (29 columns and 80,000 rows) into an InnoDB table.
And I get this message:
Error while sending QUERY packet. PID=7032
Error: 2006 => MySQL server has gone away
We set the max_allowed_packet: 1,048,576
We increased the timeouts, but no effect.
Subject
Written By
Posted
Error: 2006 MySQL server has gone away
March 17, 2014 03:04AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.