New issue 161: No such table error with celery
https://bitbucket.org/conservancy/kallithea/issues/161/no-such-table-error-with-celery
Michael DePalatis:
I am trying to get Celery working on an installation of Kallithea (version
0.3) but have run into several issues. The latest involves an error while
creating a repository. Full traceback:
```
[2015-10-06 12:13:49,885: ERROR/MainProcess] Task
kallithea.lib.celerylib.tasks.create_repo[b7a88ea0-f70f-4f01-bbbc-1ef5da35d641]
raised exception: SQLAlchemyError('(OperationalError) no such table: users',)
Traceback (most recent call last):
File
"/home/iontrap/kallithea/lib/python2.7/site-packages/celery/execute/trace.py",
line 34, in trace
return cls(states.SUCCESS, retval=fun(*args, **kwargs))
File
"/home/iontrap/kallithea/lib/python2.7/site-packages/celery/task/base.py", line
234, in __call__
return self.run(*args, **kwargs)
File
"/home/iontrap/kallithea/lib/python2.7/site-packages/celery/app/__init__.py",
line 141, in run
return fun(*args, **kwargs)
File "<string>", line 2, in create_repo
File
"/home/iontrap/kallithea/local/lib/python2.7/site-packages/Kallithea-0.3-py2.7.egg/kallithea/lib/celerylib/__init__.py",
line 123, in __wrapper
ret = func(*fargs, **fkwargs)
File
"/home/iontrap/kallithea/local/lib/python2.7/site-packages/Kallithea-0.3-py2.7.egg/kallithea/lib/celerylib/tasks.py",
line 348, in create_repo
cur_user = UserModel(DBS)._get_user(cur_user)
File
"/home/iontrap/kallithea/local/lib/python2.7/site-packages/Kallithea-0.3-py2.7.egg/kallithea/model/__init__.py",
line 114, in _get_user
callback=User.get_by_username)
File
"/home/iontrap/kallithea/local/lib/python2.7/site-packages/Kallithea-0.3-py2.7.egg/kallithea/model/__init__.py",
line 95, in _get_instance
return cls.get(instance)
File
"/home/iontrap/kallithea/local/lib/python2.7/site-packages/Kallithea-0.3-py2.7.egg/kallithea/model/db.py",
line 122, in get
return cls.query().get(id_)
File
"/home/iontrap/kallithea/lib/python2.7/site-packages/sqlalchemy/orm/query.py",
line 775, in get
return self._load_on_ident(key)
File
"/home/iontrap/kallithea/lib/python2.7/site-packages/sqlalchemy/orm/query.py",
line 2514, in _load_on_ident
return q.one()
File
"/home/iontrap/kallithea/lib/python2.7/site-packages/sqlalchemy/orm/query.py",
line 2184, in one
ret = list(self)
File
"/home/iontrap/kallithea/local/lib/python2.7/site-packages/Kallithea-0.3-py2.7.egg/kallithea/lib/caching_query.py",
line 83, in __iter__
return Query.__iter__(self)
File
"/home/iontrap/kallithea/lib/python2.7/site-packages/sqlalchemy/orm/query.py",
line 2227, in __iter__
return self._execute_and_instances(context)
File
"/home/iontrap/kallithea/lib/python2.7/site-packages/sqlalchemy/orm/query.py",
line 2242, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File
"/home/iontrap/kallithea/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1449, in execute
params)
File
"/home/iontrap/kallithea/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1584, in _execute_clauseelement
compiled_sql, distilled_params
File
"/home/iontrap/kallithea/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1698, in _execute_context
context)
File
"/home/iontrap/kallithea/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1691, in _execute_context
context)
File
"/home/iontrap/kallithea/lib/python2.7/site-packages/sqlalchemy/engine/default.py",
line 331, in do_execute
cursor.execute(statement, parameters)
OperationalError: (OperationalError) no such table: users
None
```
As an aside, some of the other issues I have found stem from requiring such an
old version of Celery. I have begun work on a fork to test that more recent
versions of Celery can be used instead.
_______________________________________________
kallithea-general mailing list
[email protected]
http://lists.sfconservancy.org/mailman/listinfo/kallithea-general
