I have a Python program that calls stored procedures and functions from a MySQL server installed on a Linux machine. For defining MySQL stored procedures I used SQLlog.
On Linux I get 'Lost connection to MySQL server during query' error after the first call of a procedure. On the Windows machine it works.
Is it because I defined the stored procedures from the Windows machine? The DEFINER has something to do with his?
I'm using Python 2.4, MySQL 5.0, MySQLdb 1.2.1_p2.
Thank you.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm using DictCursor class.
I installed MySQLdb 1.2.2b2. It works for a while, then the same error appears:
Exception _mysql_exceptions.OperationalError: (2013, 'Lost connection to MySQL server during query') in <bound method DictCursor.del of <MySQLdb.cursors.DictCursor object at 0xb7c8a34c>> ignored
Thank you again.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have a Python program that calls stored procedures and functions from a MySQL server installed on a Linux machine. For defining MySQL stored procedures I used SQLlog.
On Linux I get 'Lost connection to MySQL server during query' error after the first call of a procedure. On the Windows machine it works.
Is it because I defined the stored procedures from the Windows machine? The DEFINER has something to do with his?
I'm using Python 2.4, MySQL 5.0, MySQLdb 1.2.1_p2.
Thank you.
1.2.2b1 or b2 has a fix for this. Or stop using SSCursor classes (you don't say you are using them, but I'm guessing you are).
I'm using DictCursor class.
I installed MySQLdb 1.2.2b2. It works for a while, then the same error appears:
Exception _mysql_exceptions.OperationalError: (2013, 'Lost connection to MySQL server during query') in <bound method DictCursor.del of <MySQLdb.cursors.DictCursor object at 0xb7c8a34c>> ignored
Thank you again.