MySQL Forums
Forum List  »  PHP

Error: 2006 MySQL server has gone away
Posted by: béla béla
Date: March 17, 2014 03:04AM

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.

Options: ReplyQuote


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.