Lost connection to MySQL server during query

by

The mysql docs have a whole page dedicated to this error:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

of note are

  • You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld receives a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection. If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by setting the server’s max_allowed_packet variable, which has a default value of 1MB. You may also need to increase the maximum packet size on the client end. More information on setting the packet size is given in Section B.5.2.10, “Packet too large”.

  • You can get more information about the lost connections by starting mysqld with the –log-warnings=2 option. This logs some of the disconnected errors in the hostname.err file

More Related Contents:

  1. Python read from txt and save into mysql
  2. How to install Python MySQLdb module using pip?
  3. How to convert SQL Query result to PANDAS Data Structure?
  4. Escape string Python for MySQL
  5. pip install mysqlclient returns “fatal error C1083: Cannot open file: ‘mysql.h’: No such file or directory
  6. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  7. Enable Python to Connect to MySQL via SSH Tunnelling
  8. Inserting a Python datetime.datetime object into MySQL
  9. How to replace Django’s primary key with a different integer that is unique for that table
  10. MySQL — Joins Between Databases On Different Servers Using Python?
  11. Using a Python dict for a SQL INSERT statement
  12. How do I escape % from python mysql query
  13. Bulk insert with SQLAlchemy ORM
  14. RuntimeError: working outside of application context
  15. Why are some mysql connections selecting old data the mysql database after a delete + insert?
  16. ImportError: No module named MySQLdb
  17. Can’t install mysql-python (newer versions) in Windows
  18. Using Django database layer outside of Django?
  19. How to move a model between two Django apps (Django 1.7)
  20. How do i cast char to integer while querying in django ORM?
  21. flake8 complains on boolean comparison “==” in filter clause
  22. How do I get time from a datetime.timedelta object?
  23. Reverse engineer SQLAlchemy declarative class definition from existing MySQL database?
  24. Print results in MySQL format with Python
  25. Python’s MySqlDB not getting updated row
  26. Django + MySQL on Mac OS 10.6.2 Snow Leopard
  27. Imploding a list for use in a Python MySQL IN clause
  28. Single Django model, multiple tables?
  29. flask-login: can’t understand how it works
  30. How to disable query cache with mysql.connector

Leave a Comment