Re: Mysql connector python 3

François,

Thanks for the offer, however I will be trying to change to mysqlclient instead of the mysql-connector-python connector. I can only do this by releasing to our production servers, which will not be until Tuesday. So unfortunately I will have to wait until then.

Regards,

Andréas

2014-12-05 14:19 GMT+01:00 François Schiettecatte <fschiettecatte@gmail.com>:

Andreas

I have had to use this workaround for scripts that run a long time between database accesses:

from django.db import connection

def checkConnection():

    # Check the connection, close if needed
    try:
        connection.connection.ping()
#         print 'INFO: connection.connection.ping()'
    except:
        connection.close()
#         print 'INFO: connection.close()'


Call checkConnection() before you do a database access, you may need to play around with where you put this. The code I have is crawler which uses the django models to add data to a  database, so a lot of time elapses between the start of the script and when the data is actually inserted into the database, so plenty of time for connections to time out.

I spent a while tracking this down a while back but was not able to fully sort  out the issue, I came away with the impression that there was a bug somewhere in the connection pool code. If you like I have a little spare time today and can dig into this again.

François

> On Dec 5, 2014, at 4:08 AM, Andreas Kuhne <andreas.kuhne@suitopia.com> wrote:
>
> Hi Collin,
>
> Thanks!
>
> I tried the CONN_MAX_AGE setting and it didn't work. We still get problems, so I'll have to try changing the connector. The only thing left I think.
>
> Regards,
>
> Andréas
>
> 2014-12-05 5:07 GMT+01:00 Collin Anderson <cmawebsite@gmail.com>:
> Hi Andréas,
>
> If it helps, mysqlclient (python3-compatible fork of mysqldb) is Django's recommended connector/driver.
>
> https://pypi.python.org/pypi/mysqlclient
> https://docs.djangoproject.com/en/dev/ref/databases/#mysql-db-api-drivers
>
> Collin
>
>
> On Thursday, December 4, 2014 1:50:09 PM UTC-5, Andréas Kühne wrote:
> Hi all,
>
> We went live with a new website, completely rewritten in python 3 and with django 1.6 (upgrade to 1.7 is in progress) on November the 18th. Of course there were some minor issues, but most of them have been resolved and so far everything is working really nice.
>
> HOWEVER... We are having major issues with the mysql-connector-python pip package. We are running the latest stable version (2.0.2), but it seems as if the connector looses it's connection every now and then. This is really irritating as it can happen 10-15 times / day. This means that a lot of our customers are probably having problems. The exception we are getting is:
> mysql.connector.errors.InterfaceError: 2013: Lost connection to MySQL server during query
>
> We are running on AWS with a RDS instance for the mysql server. This worked perfectly in our previous configuration with python 2.7 and the mysqldb connector.
>
> Is mysql-connector-python not ready for a production system? Is there anyone else who has had the same problems?
>
> Is there any other python 3 compatible connector that we can use instead? We are also using south, so it has to be compatible with south as well.
>
> Regards,
>
> Andréas
>
> --
> You received this message because you are subscribed to the Google Groups "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
> To post to this group, send email to django-users@googlegroups.com.
> Visit this group at http://groups.google.com/group/django-users.
> To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/8283294e-2d8d-487c-9bb1-f96c06ef46a5%40googlegroups.com.
>
> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> You received this message because you are subscribed to the Google Groups "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
> To post to this group, send email to django-users@googlegroups.com.
> Visit this group at http://groups.google.com/group/django-users.

> To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CALXYUbmPrpEwHbrNn29HQ_%2BtDGYgeCdeV9PqyikJLq9C-V2zdQ%40mail.gmail.com.
> For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/D2E85288-5BD9-4C78-92BC-474EEF82E6C9%40gmail.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CALXYUbkMmrGhTYqdrzUTTozR7XxJWtf%2BVa4ErFWetPj4CxH3SA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.