Using django 1.2.3 with celery 2.0.3 and django-celery 2.0.3 and mysql
5.1.41 on kubuntu 10.04, I receive the following error:
OperationalError(2013, 'Lost connection to MySQL server during query').
The error occurs every time the task is executed and seems to be
related to the execution time, in fact when I process smaller files
(let's say 8000 lines) everything is fine and task ends with success.
The current files count about 242000 lines and execution started at
13:17:01 and failed at 16:08:47.
I noticed using htop that cpu load is about 100% on both cores;
(Intel(R) Xeon(R) CPU 3040 @ 1.86GHz). Could this cause the mysql
error 2013?
The python code is quite long, and I am not copying it here because
the error is mysql related...
Does anybody have any ideas?
[2010-10-09 15:50:15,265: ERROR/MainProcess] Task
igs.tasks.advanced_statistics[e886e849-cfcc-42b9-a171-0a2d56778f6b]
raised exception: OperationalError(2013, 'Lost connection to MySQL
server during query')
Traceback (most recent call last):
File
"/usr/local/lib/python2.6/dist-packages/celery-2.0.3-py2.6.egg/celery/worker/job.py",
line 86, in execute_safe
return self.execute(*args, **kwargs)
File
"/usr/local/lib/python2.6/dist-packages/celery-2.0.3-py2.6.egg/celery/worker/job.py",
line 101, in execute
return super(WorkerTaskTrace, self).execute()
File
"/usr/local/lib/python2.6/dist-packages/celery-2.0.3-py2.6.egg/celery/execute/trace.py",
line 62, in execute
retval = self._trace()
File
"/usr/local/lib/python2.6/dist-packages/celery-2.0.3-py2.6.egg/celery/execute/trace.py",
line 76, in _trace
return handler(trace.retval, trace.exc_type, trace.tb, trace.strtb)
File
"/usr/local/lib/python2.6/dist-packages/celery-2.0.3-py2.6.egg/celery/worker/job.py",
line 122, in handle_failure
exc = self.task.backend.mark_as_failure(self.task_id, exc, strtb)
File
"/usr/local/lib/python2.6/dist-packages/celery-2.0.3-py2.6.egg/celery/backends/base.py",
line 46, in mark_as_failure
traceback=traceback)
File
"/usr/local/lib/python2.6/dist-packages/celery-2.0.3-py2.6.egg/celery/backends/base.py",
line 152, in store_result
return self._store_result(task_id, result, status, traceback)
File
"/usr/local/lib/python2.6/dist-packages/django_celery-2.0.3-py2.6.egg/djcelery/backends/database.py",
line 12, in _store_result
traceback=traceback)
File
"/usr/local/lib/python2.6/dist-packages/django_celery-2.0.3-py2.6.egg/djcelery/managers.py",
line 42, in _inner
transaction.rollback_unless_managed()
File
"/usr/local/lib/python2.6/dist-packages/Django-1.2.3-py2.6.egg/django/db/transaction.py",
line 188, in rollback_unless_managed
connection._rollback()
File
"/usr/local/lib/python2.6/dist-packages/Django-1.2.3-py2.6.egg/django/db/backends/mysql/base.py",
line 306, in _rollback
BaseDatabaseWrapper._rollback(self)
File
"/usr/local/lib/python2.6/dist-packages/Django-1.2.3-py2.6.egg/django/db/backends/__init__.py",
line 36, in _rollback
return self.connection.rollback()
OperationalError: (2013, 'Lost connection to MySQL server during query')
skype: masdero, icq: 473891447, yim: mas_dero, msn: [email protected]
------------
Mi scriva in italiano; Write me in English; Skribu al mi Esperante!
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
