[Devel] [Kaboom at OH] [celery at linode.openhatch.org] Error: Task mysite.search.tasks.GrabLaunchpadBugs (646866ee-b6a9-48fe-b530-efacb9e03de5): (1054, "Unknown column 'search_project.icon' in 'field list'")

[Asheesh Laroia]

fixed by restarting celery

These were automatic jobs, so no harm done to any users

Excerpts from mr_website's message of Sun Nov 22 02:44:13 UTC 2009:
> Task mysite.search.tasks.GrabLaunchpadBugs with id
> 646866ee-b6a9-48fe-b530-efacb9e03de5 raised exception: (1054, "Unknown column
> 'search_project.icon' in 'field list'")
> 
> 
> Task was called with args:[] kwargs:{}.
> The contents of the full traceback was:
> 
> Traceback (most recent call last):
> 
>   File
> "/home/deploy/milestone-a.buildout/eggs/celery-0.6.0-py2.5.egg/celery/worker/job
> .py", line 84, in jail
>     result = func(*args, **kwargs)
> 
>   File
> "/home/deploy/milestone-a.buildout/eggs/celery-0.6.0-py2.5.egg/celery/task/base.
> py", line 123, in __call__
>     return self.run(*args, **kwargs)
> 
>   File "/home/deploy/milestone-a.buildout/mysite/search/tasks/__init__.py",
> line 18, in run
>     openhatch_project=openhatch_proj)
> 
>   File "/home/deploy/milestone-a.buildout/mysite/search/launchpad_crawl.py",
> line 130, in grab_lp_bugs
>     handle_launchpad_bug_update(query_data, new_data)
> 
>   File "/home/deploy/milestone-a.buildout/mysite/search/launchpad_crawl.py",
> line 59, in handle_launchpad_bug_update
>     name=query_data['project'])
> 
>   File
> "/home/deploy/milestone-a.buildout/parts/production/django/db/models/manager.py"
> , line 123, in get_or_create
>     return self.get_query_set().get_or_create(**kwargs)
> 
>   File
> "/home/deploy/milestone-a.buildout/parts/production/django/db/models/query.py",
> line 328, in get_or_create
>     return self.get(**kwargs), False
> 
>   File
> "/home/deploy/milestone-a.buildout/parts/production/django/db/models/query.py",
> line 300, in get
>     num = len(clone)
> 
>   File
> "/home/deploy/milestone-a.buildout/parts/production/django/db/models/query.py",
> line 81, in __len__
>     self._result_cache = list(self.iterator())
> 
>   File
> "/home/deploy/milestone-a.buildout/parts/production/django/db/models/query.py",
> line 238, in iterator
>     for row in self.query.results_iter():
> 
>   File
> "/home/deploy/milestone-a.buildout/parts/production/django/db/models/sql/query.p
> y", line 287, in results_iter
>     for rows in self.execute_sql(MULTI):
> 
>   File
> "/home/deploy/milestone-a.buildout/parts/production/django/db/models/sql/query.p
> y", line 2369, in execute_sql
>     cursor.execute(sql, params)
> 
>   File
> "/home/deploy/milestone-a.buildout/parts/production/django/db/backends/mysql/bas
> e.py", line 84, in execute
>     return self.cursor.execute(query, args)
> 
>   File
> "/home/deploy/milestone-a.buildout/eggs/MySQL_python-1.2.3c1-py2.5-linux-i686.eg
> g/MySQLdb/cursors.py", line 173, in execute
>     self.errorhandler(self, exc, value)
> 
>   File
> "/home/deploy/milestone-a.buildout/eggs/MySQL_python-1.2.3c1-py2.5-linux-i686.eg
> g/MySQLdb/connections.py", line 36, in defaulterrorhandler
>     raise errorclass, errorvalue
> 
> OperationalError: (1054, "Unknown column 'search_project.icon' in 'field list'")
>