Hello,
I'm setting up a MailScanner + Baruwa FreeBSD box and am having issues
with Celery, I think. I've had an Ubuntu box in production for over a
year with Baruwa, but this one's not so smooth. Looking at my
production server, I have a few celery-related tables in my MySQL
'baruwa' database, which don't exist on this server.
I've followed the docs on the Baruwa site and have everything
installed and mostly functioning. I can access the Baruwa web
interface, but the tasks that depend on celery fail (e.g. preview
message, delete message, release, etc).
Here's what I see in the celery log:
[2012-11-01 21:48:02,083: CRITICAL/MainProcess] Task
preview-message[e7c88089-8e23-48e4-8f2f-ff4b1e46c956] INTERNAL ERROR:
DatabaseError(1146, "Table 'baruwa.celery_taskmeta' doesn't exist")
Traceback (most recent call last):
File
"/usr/local/lib/python2.7/site-packages/celery-3.0.11-py2.7.egg/celery/task/trace.py",
line 258, in trace_task
store_result(uuid, retval, SUCCESS)
File
"/usr/local/lib/python2.7/site-packages/celery-3.0.11-py2.7.egg/celery/backends/base.py",
line 257, in store_result
self._store_result(task_id, result, status, traceback, **kwargs)
File
"/usr/local/lib/python2.7/site-packages/django_celery-3.0.11-py2.7.egg/djcelery/backends/database.py",
line 27, in _store_result
traceback=traceback, children=self.current_task_children())
File
"/usr/local/lib/python2.7/site-packages/django_celery-3.0.11-py2.7.egg/djcelery/managers.py",
line 41, in _inner
return fun(*args, **kwargs)
File
"/usr/local/lib/python2.7/site-packages/django_celery-3.0.11-py2.7.egg/djcelery/managers.py",
line 174, in store_result
"meta": {"children": children}})
File
"/usr/local/lib/python2.7/site-packages/django_celery-3.0.11-py2.7.egg/djcelery/managers.py",
line 83, in update_or_create
return self.get_query_set().update_or_create(**kwargs)
File
"/usr/local/lib/python2.7/site-packages/django_celery-3.0.11-py2.7.egg/djcelery/managers.py",
line 67, in update_or_create
obj, created = self.get_or_create(**kwargs)
File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py",
line 445, in get_or_create
return self.get(**lookup), False
File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py",
line 361, in get
num = len(clone)
File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py",
line 85, in __len__
self._result_cache = list(self.iterator())
File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py",
line 291, in iterator
for row in compiler.results_iter():
File
"/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py",
line 763, in results_iter
for rows in self.execute_sql(MULTI):
File
"/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py",
line 818, in execute_sql
cursor.execute(sql, params)
File
"/usr/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py",
line 114, in execute
return self.cursor.execute(query, args)
File
"/usr/local/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-freebsd-9.1-RC2-amd64.egg/MySQLdb/cursors.py",
line 174, in execute
self.errorhandler(self, exc, value)
File
"/usr/local/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-freebsd-9.1-RC2-amd64.egg/MySQLdb/connections.py",
line 36, in defaulterrorhandler
raise errorclass, errorvalue
DatabaseError: (1146, "Table 'baruwa.celery_taskmeta' doesn't exist")
What's responsible for creating those tables? Have I missed
something? RabbitMQ and Celery are both running, and I don't see any
indication of issues outside of the "baruwa.celery_*" tables not
existing.
I'll supply any configurations and other details that may be helpful.
With all of this, does anyone have any insight?
This is Baruwa 1.1.2.
Any nudge in the right direction is greatly appreciated!
Thanks,
Josh
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
