Tuesday, February 1, 2011

Django SQL Query does not stop

When I am in admin and I access of a certain model, Django calls mysql with an Query which increases mysql CPU load to 99% and it never returns.

If I copy the the SQL Query right into mysql the same thing happens, so it is actually kind of a mysql problem, but since Django created the query, I thought I might get help here.

I did not call any select_related or something.

On my dev machine I am using sqlite and the same query does not cause any trouble and returns within 4 ms.

There are less not more than 5 rows in each table, so database size cannot be a problem.

Any ideas? where to start debugging this?

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

No comments:

Post a Comment