[DB-SIG] MySQL error 2013, 'Lost connection to MySQL server during query'

Lloyd Kvam pythontutor at venix.com
Tue May 20 17:09:40 EDT 2003

OperationalError: (2013, 'Lost connection to MySQL server during query'

I am getting occasional Lost Connection errors even when running against
localhost.  I do not have a reliable way to generate these errors, but they
occur too often to ignore.  I am starting to wonder if I could have made a
mistake in how I use the API.  I am using the MySQLdb module to connect to
a MySQL database.

The code uses the connection object:
	to get a cursor
	execute an SQL command
	save/print/use the result
I have not been closing cursors, but simply leaving them to get garbage
collected.  I have not been reusing cursors for successive queries.

Should I be closing cursors?  Would I be better off reusing the same
cursor where possible?

Any advice would be greatly appreciated.

Lloyd Kvam
Venix Corp.
1 Court Street, Suite 378
Lebanon, NH 03766-1358

voice:	603-443-6155
fax:	801-459-9582

More information about the DB-SIG mailing list