#21597: (2006, 'MySQL server has gone away') in django1.6 when wait_timeout
passed
-------------------------------------+-------------------------------------
Reporter: ekeydar@… | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 1.6
(models, ORM) | Resolution:
Severity: Normal | Triage Stage: Accepted
Keywords: mysql | Needs documentation: 0
Has patch: 0 | Patch needs improvement: 0
Needs tests: 0 | UI/UX: 0
Easy pickings: 0 |
-------------------------------------+-------------------------------------
Comment (by jeroen.pulles@…):
I've checked with my existing long running processes on Django 1.5
installations, running the same mysql-python and libmysqlclient.so, with
tcpdump:
They do set the interactive flag on the MySQL connection. That explains
for me why I never experienced the Gone Away's before. Django doesn't
notice that the underlying connection went away and came back.
I haven't had enough time to find out (dig down deep enough) what makes
this flag appear on the connection in the 1.5 situation and what changed
in 1.6 that is relevant to this problem. (a) My suspicion is that it isn't
directly related to the connection persistence mechanism. (b) To me it
doesn't seem to be in any way related to the transactions mechanisms: My
transactions happen fast enough and it's fine that things break if the
transaction takes longer than wait_timeout (e.g. more than two minutes);
The same application that works fine in 1.5 also works in 1.6 with the
interactive flag set.
JeroenP
--
Ticket URL: <https://code.djangoproject.com/ticket/21597#comment:16>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/075.b2586ecd8514ce14b1f4c3d758d6776e%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
