Stack Overflow
Stack Overflow

Questions tagged [mysql-error-2006]

MySQL Error 2006: MySQL server has gone away

MySQL Error 2006: MySQL server has gone away

22 questions
323
votes
32 answers

MySQL error 2006: mysql server has gone away

I'm running a server at my office to process some files and report the results to a remote MySQL server. The files processing takes some time and the process dies halfway through with the following error: 2006, MySQL server has gone away I've…
floatleft
  • 6,243
  • 12
  • 43
  • 53
41
votes
8 answers

#2006 MySQL Server has gone away error in Wamp

Im using Wampserver version 2.0 . When i try to import a sql file, either through MySQL Query Browser or PHPMyAdmin,i get the following error. Error 2006: MySQL Server has gone away. The size of the file is 54,528 KB. In…
john
  • 411
  • 1
  • 4
  • 3
29
votes
13 answers

Getting MYSQL Error: "Error Code: 2006 - MySQL server has gone away"

I am getting following error, when I try to import MYSQL database: Error Code: 2013 - Lost connection to MySQL server during queryQuery: Error Code: 2006 - MySQL server has gone away Can someone let me know what is wrong?
meetpd
  • 9,150
  • 21
  • 71
  • 119
7
votes
3 answers

(2006, 'MySQL server has gone away') in WSGI django

I have a MySQL gone away with Django under WSGI. I found entries for this problem on stackoverflow, but nothing with Django specifically. Google does not help, except for workarounds (like polling the website every once in a while, or increasing the…
Stefano Borini
  • 138,652
  • 96
  • 297
  • 431
5
votes
1 answer

drupal views module mysql error

i have enabled the view module and get this when i go to structure>views in drupal 7 Additional uncaught exception thrown while handling exception. Original PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: DELETE…
chan
  • 51
  • 2
3
votes
1 answer

MySQL error 2006 MySQL server has gone away after upgrade to 5.6.10 using homebrew on Max OS X 10.8.3

I upgraded my installation of MySQL on my Mac OS X 10.8.3 using homebrew brew install mysql Everything seemed to go smoothly, but...not really, as it turns out. I cannot add a new user (neither through the command line nor through phpmyadmin. I…
Ali Samii
  • 1,672
  • 4
  • 28
  • 49
2
votes
2 answers

MySQL server has gone away

Here my code snippet: query.next(); qDebug()<
metdos
  • 13,411
  • 17
  • 77
  • 120
2
votes
2 answers

MySQL : Server has gone away

So I have this problem when I run a script with PHP PDO that I'm not able to resolve. My script is indexing informations from different databases on different server (mostly Select queries). When I was developing the script, all the databases were…
Cocotton
  • 910
  • 2
  • 7
  • 22
1
vote
2 answers

mysql database gone away error 2006

I am importing a sql file of 80 MB, and the mysql database goes away on error 2006. I increased the connect_timeout=2592000 and wait_timeout = 216000. What if anything else I need to import the sql file into the db. It gets stuck at 18236 line. …
X10nD
  • 21,638
  • 45
  • 111
  • 152
1
vote
0 answers

Error Code: 2006. MySQL server has gone away (MYSQL Workbench 6.36)

I'm having issues where the server will always have this 2006 error. I have changed the settings in the preferences and also in the cnf file(max_packet size). Every morning when I check the server it will show the 2006 error. I will have to go to…
Daniel
  • 105
  • 9
1
vote
1 answer

Possible reasons for "mysql server has gone away" error (php 5.4, mysqlnd)

We recently upgraded one of our webservers from PHP 5.3 (Debian Squeeze package, using libmysqlclient and APC) to PHP 5.4 (Debian Wheezy, Dotdeb package, using mysqlnd, Opcache and APCu). After working fine for almost one day, we experienced "mysql…
ak2
  • 457
  • 1
  • 5
  • 17
1
vote
1 answer

Mysql weird connection problem

I've a weird problem. I've mysql 5.1 installed on my ubuntu 9.04. I've used it a long time (say 3 month) and everything was going right. Until i faced this really weird problem. When i want to connect to a random database i get this message: ERROR…
santiagobasulto
  • 11,320
  • 11
  • 64
  • 88
0
votes
0 answers

Codeigniter gives 503 and 2006 Error for the portal hosted on Godaddy

HTTP Error 503. The service is unavailable. The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later. And any of the functions when two of my portals intracts the page stays…
A Raval
  • 1
0
votes
1 answer

mod_python/MySQL error on INSERT with a lot of data: "OperationalError: (2006, 'MySQL server has gone away')"

When doing an INSERT with a lot of data, ie: INSERT INTO table (mediumtext_field) VALUES ('...lots of text here: about 2MB worth...') MySQL returns "OperationalError: (2006, 'MySQL server has gone away')" This is happening within a minute of…
Carver
  • 3
  • 2
0
votes
1 answer

Solving “ERROR 2006 (HY000): MySQL server has gone away" in cyclical programs (mysql-connector-python)

I provided solution to similar problems with the one I met recently: I have Telegram (messenger) bot with MySQL user DB. There is connection to it in start of code causing connection was going away later about 10 hours. Therefore bot was returning…
SecorD
  • 7
  • 3
1
2