Related Questions is performing poorly

Now with 6000+ questions, the javascript related questions action is performing poorly.

To replicate, type in a question in the ask field, on a large database. Notice that it's a several second delay, or in some cases quite a long delay.

Dogslow hit this, at one point:

Undead request intercepted at: 13-01-2012 22:02:41 UTC

POST http://answers.atlassian.com/questions/related_questions/
Thread ID: 47448573493728
Process ID: 10104
Parent PID: 7901
Started: 13-01-2012 22:02:12 UTC

File "/opt/python/domains/atlassian.com/answers/bin/gunicorn_django", line 8, in <module>
load_entry_point('gunicorn==0.12.0', 'console_scripts', 'gunicorn_django')()
File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/gunicorn/app/djangoapp.py", line 148, in run
DjangoApplication("%prog [OPTIONS] [SETTINGS_PATH]").run()
File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/gunicorn/app/base.py", line 131, in run
Arbiter(self).run()
File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/gunicorn/arbiter.py", line 158, in run
self.manage_workers()
File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/gunicorn/arbiter.py", line 416, in manage_workers
self.spawn_workers()
File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/gunicorn/arbiter.py", line 468, in spawn_workers
self.spawn_worker()
File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/gunicorn/arbiter.py", line 442, in spawn_worker
worker.init_process()
File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/gunicorn/workers/base.py", line 102, in init_process
self.run()
File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/gunicorn/workers/sync.py", line 35, in run
self.handle(client, addr)
File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/gunicorn/workers/sync.py", line 70, in handle
self.handle_request(req, client, addr)
File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/gunicorn/workers/sync.py", line 97, in handle_request
respiter = self.wsgi(environ, resp.start_response)
File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/core/handlers/wsgi.py", line 248, in _call_
response = self.get_response(request)
File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/core/handlers/base.py", line 100, in get_response
response = callback(request, *callback_args, **callback_kwargs)
File "/opt/python/domains/atlassian.com/answers/ADM-19711/forum/views/commands.py", line 624, in related_questions
for q in questions.filter_state(deleted=False)[0:10]]), mimetype="application/json")
File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/models/query.py", line 105, in _result_iter
self._fill_cache()
File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/models/query.py", line 783, in _fill_cache
self._result_cache.append(self._iter.next())
File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/models/query.py", line 271, in iterator
for row in compiler.results_iter():
File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/models/sql/compiler.py", line 677, in results_iter
for rows in self.execute_sql(MULTI):
File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/models/sql/compiler.py", line 732, in execute_sql
cursor.execute(sql, params)
File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/backends/postgresql_psycopg2/base.py", line 44, in execute
return self.cursor.execute(query, args)

Full backtrace with local variables:

File "/opt/python/domains/atlassian.com/answers/bin/gunicorn_django", line 8, in <module>
load_entry_point('gunicorn==0.12.0', 'console_scripts', 'gunicorn_django')()

Arguments: <module>()
Local variables:

{'__builtins__': <module '__builtin__' (built-in)>, '__doc__': None, '__file__': '/opt/python/domains/atlassian.com/answers/bin/gunicorn_django', '__name__': '__main__', '__package__': None, '__requires__': 'gunicorn==0.12.0', 'load_entry_point': <function load_entry_point at 0x2b277cc37578>, 'sys': <module 'sys' (built-in)>}

File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/gunicorn/app/djangoapp.py", line 148, in run
DjangoApplication("%prog [OPTIONS] [SETTINGS_PATH]").run()

Arguments: run()
Local variables:

{'DjangoApplication': <class 'gunicorn.app.djangoapp.DjangoApplication'>}

File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/gunicorn/app/base.py", line 131, in run
Arbiter(self).run()

Arguments: run(self=<gunicorn.app.djangoapp.DjangoApplication object at 0x12ea9810>)
Local variables:

{'self': <gunicorn.app.djangoapp.DjangoApplication object at 0x12ea9810>}

File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/gunicorn/arbiter.py", line 158, in run
self.manage_workers()

Arguments: run(self=<gunicorn.arbiter.Arbiter object at 0x13094a90>)
Local variables:

{'self': <gunicorn.arbiter.Arbiter object at 0x13094a90>, 'sig': None}

File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/gunicorn/arbiter.py", line 416, in manage_workers
self.spawn_workers()

Arguments: manage_workers(self=<gunicorn.arbiter.Arbiter object at 0x13094a90>)
Local variables:

{'self': <gunicorn.arbiter.Arbiter object at 0x13094a90>}

File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/gunicorn/arbiter.py", line 468, in spawn_workers
self.spawn_worker()

Arguments: spawn_workers(self=<gunicorn.arbiter.Arbiter object at 0x13094a90>)
Local variables:

{'i': 0, 'self': <gunicorn.arbiter.Arbiter object at 0x13094a90>}

File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/gunicorn/arbiter.py", line 442, in spawn_worker
worker.init_process()

Arguments: spawn_worker(self=<gunicorn.arbiter.Arbiter object at 0x13094a90>)
Local variables:

{'pid': 0, 'self': <gunicorn.arbiter.Arbiter object at 0x13094a90>, 'worker': <gunicorn.workers.sync.SyncWorker object at 0x13337b10>, 'worker_pid': 10104}

File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/gunicorn/workers/base.py", line 102, in init_process
self.run()

Arguments: init_process(self=<gunicorn.workers.sync.SyncWorker object at 0x13337b10>)
Local variables:

{'self': <gunicorn.workers.sync.SyncWorker object at 0x13337b10>}

File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/gunicorn/workers/sync.py", line 35, in run
self.handle(client, addr)

Arguments: run(self=<gunicorn.workers.sync.SyncWorker object at 0x13337b10>)
Local variables:

{'addr': '', 'client': <socket._socketobject object at 0x191f80c0>, 'e': error(11, 'Resource temporarily unavailable'), 'ret': ([<gunicorn.sock.UnixSocket object at 0x13337890>], [], []), 'self': <gunicorn.workers.sync.SyncWorker object at 0x13337b10>}

File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/gunicorn/workers/sync.py", line 70, in handle
self.handle_request(req, client, addr)

Arguments: handle(self=<gunicorn.workers.sync.SyncWorker object at 0x13337b10>, client=<socket._socketobject object at 0x191f80c0>, addr='')
Local variables:

{'addr': '', 'client': <socket._socketobject object at 0x191f80c0>, 'parser': <gunicorn.http.parser.RequestParser object at 0x13231710>, 'req': <gunicorn.http.message.Request object at 0x18e476d0>, 'self': <gunicorn.workers.sync.SyncWorker object at 0x13337b10>}

File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/gunicorn/workers/sync.py", line 97, in handle_request
respiter = self.wsgi(environ, resp.start_response)

Arguments: handle_request(self=<gunicorn.workers.sync.SyncWorker object at 0x13337b10>, req=<gunicorn.http.message.Request object at 0x18e476d0>, client=<socket._socketobject object at 0x191f80c0>, addr='')
Local variables:

{'addr': '',
'client': <socket._socketobject object at 0x191f80c0>,
'environ':

{'CONTENT_LENGTH': '221', 'CONTENT_TYPE': 'application/x-www-form-urlencoded; charset=UTF-8', 'CSRF_COOKIE': 'ff6399f094fe74d45038f71eddad2b8d', 'HTTP_ACCEPT': 'application/json, text/javascript, */*', 'HTTP_ACCEPT_CHARSET': 'ISO-8859-1,utf-8;q=0.7,*;q=0.7', 'HTTP_ACCEPT_ENCODING': 'gzip, deflate', 'HTTP_ACCEPT_LANGUAGE': 'nl,en-us;q=0.7,en;q=0.3', 'HTTP_CACHE_CONTROL': 'no-cache', 'HTTP_CONNECTION': 'close', 'HTTP_COOKIE': '__utma=80426056.1835459137.1326489839.1326489839.1326491716.2; __utmc=80426056; __utmz=80426056.1326489839.1.1.utmcsr=forums.atlassian.com|utmccn=(referral)|utmcmd=referral|utmcct=/message.jspa; __unam=3b7d60-134d8f4995a-5665e696-1; _GPL_it=1; __utmb=80426056.8.10.1326491716; __utmv=80426056.|1=ft=forums.atlassian.com!referral!!message.jspa!referral=1; sessionid=9d4df20fd4bade9a2f615ab8475cba4c; __utma=215707591.139972727.1326491746.1326491746.1326491746.1; __utmb=215707591.2.10.1326491746; __utmc=215707591; __utmz=215707591.1326491746.1.1.utmcsr=atlassian.com|utmccn=(referral)|utmcmd=referral|utmcct=/resources/support; __utmv=215707591.|1=ft=forums.atlassian.com!referral!!message.jspa!referral=1; csrftoken=ff6399f094fe74d45038f71eddad2b8d', 'HTTP_DNT': '1', 'HTTP_HOST': 'answers.atlassian.com', 'HTTP_PRAGMA': 'no-cache', 'HTTP_REFERER': 'https://answers.atlassian.com/questions/ask/', 'HTTP_USER_AGENT': 'Mozilla/5.0 (Windows NT 5.1; rv:8.0.1) Gecko/20100101 Firefox/8.0.1', 'HTTP_X_CSRFTOKEN': 'ff6399f094fe74d45038f71eddad2b8d', 'HTTP_X_FORWARDED_FOR': '80.254.148.123, 172.16.3.45', 'HTTP_X_REAL_IP': '80.254.148.123', 'HTTP_X_REQUESTED_WITH': 'XMLHttpRequest', 'PATH_INFO': u'/questions/related_questions/', 'QUERY_STRING': '', 'RAW_URI': '/questions/related_questions/', 'REMOTE_ADDR': '172.16.3.45', 'REMOTE_PORT': '80', 'REQUEST_METHOD': 'POST', 'SCRIPT_NAME': u'', 'SERVER_NAME': 'answers.atlassian.com', 'SERVER_PORT': '80', 'SERVER_PROTOCOL': 'HTTP/1.0', 'SERVER_SOFTWARE': 'gunicorn/0.12.0', 'gunicorn.socket': <socket._socketobject object at 0x191f80c0>, 'wsgi.errors': <open file '<stderr>', mode 'w' at 0x2b277a4591e0>, 'wsgi.input': <gunicorn.http.body.Body object at 0x1629ff10>, 'wsgi.multiprocess': True, 'wsgi.multithread': False, 'wsgi.run_once': False, 'wsgi.url_scheme': 'http', 'wsgi.version': (1, 0)}

,
'req': <gunicorn.http.message.Request object at 0x18e476d0>,
'resp': <gunicorn.http.wsgi.Response object at 0x1629f250>,
'self': <gunicorn.workers.sync.SyncWorker object at 0x13337b10>}

File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/core/handlers/wsgi.py", line 248, in _call_
response = self.get_response(request)

Arguments: _call_(self=<django.core.handlers.wsgi.WSGIHandler object at 0x12ff7dd0>, environ=<dict object at 0x2aaaacad7d40 (really long repr)>, start_response=<bound method Response.start_response of <gunicorn.http.wsgi.Response object at 0x1629f250>>)
Local variables:

{'environ':

{'CONTENT_LENGTH': '221', 'CONTENT_TYPE': 'application/x-www-form-urlencoded; charset=UTF-8', 'CSRF_COOKIE': 'ff6399f094fe74d45038f71eddad2b8d', 'HTTP_ACCEPT': 'application/json, text/javascript, */*', 'HTTP_ACCEPT_CHARSET': 'ISO-8859-1,utf-8;q=0.7,*;q=0.7', 'HTTP_ACCEPT_ENCODING': 'gzip, deflate', 'HTTP_ACCEPT_LANGUAGE': 'nl,en-us;q=0.7,en;q=0.3', 'HTTP_CACHE_CONTROL': 'no-cache', 'HTTP_CONNECTION': 'close', 'HTTP_COOKIE': '__utma=80426056.1835459137.1326489839.1326489839.1326491716.2; __utmc=80426056; __utmz=80426056.1326489839.1.1.utmcsr=forums.atlassian.com|utmccn=(referral)|utmcmd=referral|utmcct=/message.jspa; __unam=3b7d60-134d8f4995a-5665e696-1; _GPL_it=1; __utmb=80426056.8.10.1326491716; __utmv=80426056.|1=ft=forums.atlassian.com!referral!!message.jspa!referral=1; sessionid=9d4df20fd4bade9a2f615ab8475cba4c; __utma=215707591.139972727.1326491746.1326491746.1326491746.1; __utmb=215707591.2.10.1326491746; __utmc=215707591; __utmz=215707591.1326491746.1.1.utmcsr=atlassian.com|utmccn=(referral)|utmcmd=referral|utmcct=/resources/support; __utmv=215707591.|1=ft=forums.atlassian.com!referral!!message.jspa!referral=1; csrftoken=ff6399f094fe74d45038f71eddad2b8d', 'HTTP_DNT': '1', 'HTTP_HOST': 'answers.atlassian.com', 'HTTP_PRAGMA': 'no-cache', 'HTTP_REFERER': 'https://answers.atlassian.com/questions/ask/', 'HTTP_USER_AGENT': 'Mozilla/5.0 (Windows NT 5.1; rv:8.0.1) Gecko/20100101 Firefox/8.0.1', 'HTTP_X_CSRFTOKEN': 'ff6399f094fe74d45038f71eddad2b8d', 'HTTP_X_FORWARDED_FOR': '80.254.148.123, 172.16.3.45', 'HTTP_X_REAL_IP': '80.254.148.123', 'HTTP_X_REQUESTED_WITH': 'XMLHttpRequest', 'PATH_INFO': u'/questions/related_questions/', 'QUERY_STRING': '', 'RAW_URI': '/questions/related_questions/', 'REMOTE_ADDR': '172.16.3.45', 'REMOTE_PORT': '80', 'REQUEST_METHOD': 'POST', 'SCRIPT_NAME': u'', 'SERVER_NAME': 'answers.atlassian.com', 'SERVER_PORT': '80', 'SERVER_PROTOCOL': 'HTTP/1.0', 'SERVER_SOFTWARE': 'gunicorn/0.12.0', 'gunicorn.socket': <socket._socketobject object at 0x191f80c0>, 'wsgi.errors': <open file '<stderr>', mode 'w' at 0x2b277a4591e0>, 'wsgi.input': <gunicorn.http.body.Body object at 0x1629ff10>, 'wsgi.multiprocess': True, 'wsgi.multithread': False, 'wsgi.run_once': False, 'wsgi.url_scheme': 'http', 'wsgi.version': (1, 0)}

,
'request': <WSGIRequest
GET:<QueryDict: {}>,
POST:<QueryDict:

{u'title': [u"When Using Lotus Notes w're having problems with slow loading of JIRA mails (up t. Is there a setting in Lotus notus which can prevent the loading of these symbols? Or is there an a solution on the site of JIRA?"]}

>,
COOKIES:

{'_GPL_it': '1', '__unam': '3b7d60-134d8f4995a-5665e696-1', '__utma': '215707591.139972727.1326491746.1326491746.1326491746.1', '__utmb': '215707591.2.10.1326491746', '__utmc': '215707591', '__utmv': '215707591.|1=ft=forums.atlassian.com!referral!!message.jspa!referral=1', '__utmz': '215707591.1326491746.1.1.utmcsr=atlassian.com|utmccn=(referral)|utmcmd=referral|utmcct=/resources/support', 'csrftoken': 'ff6399f094fe74d45038f71eddad2b8d', 'sessionid': '9d4df20fd4bade9a2f615ab8475cba4c'}

,
META:

{'CONTENT_LENGTH': '221', 'CONTENT_TYPE': 'application/x-www-form-urlencoded; charset=UTF-8', 'CSRF_COOKIE': 'ff6399f094fe74d45038f71eddad2b8d', 'HTTP_ACCEPT': 'application/json, text/javascript, */*', 'HTTP_ACCEPT_CHARSET': 'ISO-8859-1,utf-8;q=0.7,*;q=0.7', 'HTTP_ACCEPT_ENCODING': 'gzip, deflate', 'HTTP_ACCEPT_LANGUAGE': 'nl,en-us;q=0.7,en;q=0.3', 'HTTP_CACHE_CONTROL': 'no-cache', 'HTTP_CONNECTION': 'close', 'HTTP_COOKIE': '__utma=80426056.1835459137.1326489839.1326489839.1326491716.2; __utmc=80426056; __utmz=80426056.1326489839.1.1.utmcsr=forums.atlassian.com|utmccn=(referral)|utmcmd=referral|utmcct=/message.jspa; __unam=3b7d60-134d8f4995a-5665e696-1; _GPL_it=1; __utmb=80426056.8.10.1326491716; __utmv=80426056.|1=ft=forums.atlassian.com!referral!!message.jspa!referral=1; sessionid=9d4df20fd4bade9a2f615ab8475cba4c; __utma=215707591.139972727.1326491746.1326491746.1326491746.1; __utmb=215707591.2.10.1326491746; __utmc=215707591; __utmz=215707591.1326491746.1.1.utmcsr=atlassian.com|utmccn=(referral)|utmcmd=referral|utmcct=/resources/support; __utmv=215707591.|1=ft=forums.atlassian.com!referral!!message.jspa!referral=1; csrftoken=ff6399f094fe74d45038f71eddad2b8d', 'HTTP_DNT': '1', 'HTTP_HOST': 'answers.atlassian.com', 'HTTP_PRAGMA': 'no-cache', 'HTTP_REFERER': 'https://answers.atlassian.com/questions/ask/', 'HTTP_USER_AGENT': 'Mozilla/5.0 (Windows NT 5.1; rv:8.0.1) Gecko/20100101 Firefox/8.0.1', 'HTTP_X_CSRFTOKEN': 'ff6399f094fe74d45038f71eddad2b8d', 'HTTP_X_FORWARDED_FOR': '80.254.148.123, 172.16.3.45', 'HTTP_X_REAL_IP': '80.254.148.123', 'HTTP_X_REQUESTED_WITH': 'XMLHttpRequest', 'PATH_INFO': u'/questions/related_questions/', 'QUERY_STRING': '', 'RAW_URI': '/questions/related_questions/', 'REMOTE_ADDR': '172.16.3.45', 'REMOTE_PORT': '80', 'REQUEST_METHOD': 'POST', 'SCRIPT_NAME': u'', 'SERVER_NAME': 'answers.atlassian.com', 'SERVER_PORT': '80', 'SERVER_PROTOCOL': 'HTTP/1.0', 'SERVER_SOFTWARE': 'gunicorn/0.12.0', 'gunicorn.socket': <socket._socketobject object at 0x191f80c0>, 'wsgi.errors': <open file '<stderr>', mode 'w' at 0x2b277a4591e0>, 'wsgi.input': <gunicorn.http.body.Body object at 0x1629ff10>, 'wsgi.multiprocess': True, 'wsgi.multithread': False, 'wsgi.run_once': False, 'wsgi.url_scheme': 'http', 'wsgi.version': (1, 0)}

>,
'self': <django.core.handlers.wsgi.WSGIHandler object at 0x12ff7dd0>,
'settings': <django.conf.LazySettings object at 0x12f84250>,
'start_response': <bound method Response.start_response of <gunicorn.http.wsgi.Response object at 0x1629f250>>}

File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/core/handlers/base.py", line 100, in get_response
response = callback(request, *callback_args, **callback_kwargs)

Arguments: get_response(self=<django.core.handlers.wsgi.WSGIHandler object at 0x12ff7dd0>, request=<django.core.handlers.wsgi.WSGIRequest object at 0x1629fc90 (really long repr)>)
Local variables:

{'callback': <function related_questions at 0x1412b9b0>,
'callback_args': (),
'callback_kwargs': {},
'exceptions': <module 'django.core.exceptions' from '/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/core/exceptions.pyc'>,
'middleware_method': <bound method CsrfViewMiddleware.process_view of <django.middleware.csrf.CsrfViewMiddleware object at 0x141a3c50>>,
'request': <WSGIRequest
GET:<QueryDict: {}>,
POST:<QueryDict:

{u'title': [u"When Using Lotus Notes w're having problems with slow loading of JIRA mails (up t. Is there a setting in Lotus notus which can prevent the loading of these symbols? Or is there an a solution on the site of JIRA?"]}

>,
COOKIES:

{'_GPL_it': '1', '__unam': '3b7d60-134d8f4995a-5665e696-1', '__utma': '215707591.139972727.1326491746.1326491746.1326491746.1', '__utmb': '215707591.2.10.1326491746', '__utmc': '215707591', '__utmv': '215707591.|1=ft=forums.atlassian.com!referral!!message.jspa!referral=1', '__utmz': '215707591.1326491746.1.1.utmcsr=atlassian.com|utmccn=(referral)|utmcmd=referral|utmcct=/resources/support', 'csrftoken': 'ff6399f094fe74d45038f71eddad2b8d', 'sessionid': '9d4df20fd4bade9a2f615ab8475cba4c'}

,
META:

{'CONTENT_LENGTH': '221', 'CONTENT_TYPE': 'application/x-www-form-urlencoded; charset=UTF-8', 'CSRF_COOKIE': 'ff6399f094fe74d45038f71eddad2b8d', 'HTTP_ACCEPT': 'application/json, text/javascript, */*', 'HTTP_ACCEPT_CHARSET': 'ISO-8859-1,utf-8;q=0.7,*;q=0.7', 'HTTP_ACCEPT_ENCODING': 'gzip, deflate', 'HTTP_ACCEPT_LANGUAGE': 'nl,en-us;q=0.7,en;q=0.3', 'HTTP_CACHE_CONTROL': 'no-cache', 'HTTP_CONNECTION': 'close', 'HTTP_COOKIE': '__utma=80426056.1835459137.1326489839.1326489839.1326491716.2; __utmc=80426056; __utmz=80426056.1326489839.1.1.utmcsr=forums.atlassian.com|utmccn=(referral)|utmcmd=referral|utmcct=/message.jspa; __unam=3b7d60-134d8f4995a-5665e696-1; _GPL_it=1; __utmb=80426056.8.10.1326491716; __utmv=80426056.|1=ft=forums.atlassian.com!referral!!message.jspa!referral=1; sessionid=9d4df20fd4bade9a2f615ab8475cba4c; __utma=215707591.139972727.1326491746.1326491746.1326491746.1; __utmb=215707591.2.10.1326491746; __utmc=215707591; __utmz=215707591.1326491746.1.1.utmcsr=atlassian.com|utmccn=(referral)|utmcmd=referral|utmcct=/resources/support; __utmv=215707591.|1=ft=forums.atlassian.com!referral!!message.jspa!referral=1; csrftoken=ff6399f094fe74d45038f71eddad2b8d', 'HTTP_DNT': '1', 'HTTP_HOST': 'answers.atlassian.com', 'HTTP_PRAGMA': 'no-cache', 'HTTP_REFERER': 'https://answers.atlassian.com/questions/ask/', 'HTTP_USER_AGENT': 'Mozilla/5.0 (Windows NT 5.1; rv:8.0.1) Gecko/20100101 Firefox/8.0.1', 'HTTP_X_CSRFTOKEN': 'ff6399f094fe74d45038f71eddad2b8d', 'HTTP_X_FORWARDED_FOR': '80.254.148.123, 172.16.3.45', 'HTTP_X_REAL_IP': '80.254.148.123', 'HTTP_X_REQUESTED_WITH': 'XMLHttpRequest', 'PATH_INFO': u'/questions/related_questions/', 'QUERY_STRING': '', 'RAW_URI': '/questions/related_questions/', 'REMOTE_ADDR': '172.16.3.45', 'REMOTE_PORT': '80', 'REQUEST_METHOD': 'POST', 'SCRIPT_NAME': u'', 'SERVER_NAME': 'answers.atlassian.com', 'SERVER_PORT': '80', 'SERVER_PROTOCOL': 'HTTP/1.0', 'SERVER_SOFTWARE': 'gunicorn/0.12.0', 'gunicorn.socket': <socket._socketobject object at 0x191f80c0>, 'wsgi.errors': <open file '<stderr>', mode 'w' at 0x2b277a4591e0>, 'wsgi.input': <gunicorn.http.body.Body object at 0x1629ff10>, 'wsgi.multiprocess': True, 'wsgi.multithread': False, 'wsgi.run_once': False, 'wsgi.url_scheme': 'http', 'wsgi.version': (1, 0)}

>,
'resolver': <RegexURLResolver urls (None:None) ^/>,
'response': None,
'self': <django.core.handlers.wsgi.WSGIHandler object at 0x12ff7dd0>,
'settings': <django.conf.LazySettings object at 0x12f84250>,
'urlconf': 'urls',
'urlresolvers': <module 'django.core.urlresolvers' from '/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/core/urlresolvers.pyc'>}

File "/opt/python/domains/atlassian.com/answers/ADM-19711/forum/views/commands.py", line 624, in related_questions
for q in questions.filter_state(deleted=False)[0:10]]), mimetype="application/json")

Arguments: related_questions(request=<django.core.handlers.wsgi.WSGIRequest object at 0x1629fc90 (really long repr)>)
Local variables:

{'_[1]': [

{'score': 0, 'summary': u'I have an AJAX file upload form that needs a JSON response:Here is response Request Header:Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8Response comes as header:Content-Type: application/json;charset=UTF-8And I get error in JavaScript:\r\nmissing }

in XML expression\r\n \r\n0},su',
'title': u'Problem in file upload form on Confluence',
'url': '/questions/26769/problem-in-file-upload-form-on-confluence'},

{'score': 0, 'summary': u'We are trying to upgrade from 4.3.4 to 4.4.1. We finished the install and restarted JIRA. A reindex starts and gets to 99%, then it crashes with no error messages. Not sure what to do at this point. Cannot bring JIRA back up.\r\n \r\nhere is the log file\r\n \r\n****************JIRA starting...*************', 'title': u'Upgrading from 4.3.4 to 4.4.1 - reindex completes at 99% with a system crash', 'url': '/questions/11712/upgrading-from-4-3-4-to-4-4-1-reindex-completes-at-99-with-a-system-crash'}

,

{'score': -2, 'summary': u'Can you please populate the following document to determine if the Confluence application is compliant for USA governement use?\r\nPlease do not direct me back to the government VPAT page. I work for one of these agencies.\r\nGovernment Product Accessibility Template for Web Application\r\nSummary\r\n&mid', 'title': u'Please complete the following form to determine if Confluence is compliant for USA Government use. (GPAT)', 'url': '/questions/15970/please-complete-the-following-form-to-determine-if-confluence-is-compliant-for-usa-government-use-gpat'}

,

{'score': 0, 'summary': u'Hi All,\r\nWe have upgraded our jira recently from ver 3.13.5 to ver 4.2.4 using the alternate approach of direct DB upgrade. However after the upgrade we are facing lots of issues.\r\nWe have 573 projects with total of 228585 issues on our JIRA instance\r\nOur instance freezes very frequently. The ongoin', 'title': u'Jira hanging frequently after the upgrade from 3.13.5 to 4.2.4', 'url': '/questions/28132/jira-hanging-frequently-after-the-upgrade-from-3-13-5-to-4-2-4'}

,

{'score': 1, 'summary': u'I could not update to JIRA Verison 4.4x because of Bug JRA-26083. So I want to change the version-tab in the jira-project-config-plugin in that way, that with a button beside the "Merge", the list of the versions toggle beetween the unarchived and the archived versions.\r\nI think I must update the ve', 'title': u'Workaround Manage Versions Bug JRA-26083: Project config Versions problem when loading large list of versions', 'url': '/questions/25904/workaround-manage-versions-bug-jra-26083-project-config-versions-problem-when-loading-large-list-of-versions'}

,

{'score': 0, 'summary': u'hi\r\nBest way to not hardcode fields names in Code?\r\nboth below ways are not flexible as mentioned below\r\n\r\nOne way is using Custom field ID, but thats not practical because IDs are different across test instances & prod instance.\r\nUsing customfield IDs by Names stops us from editing the field Na', 'title': u'Best way to not hard code custom field names in Code?', 'url': '/questions/24118/best-way-to-not-hard-code-custom-field-names-in-code'}

,

{'score': 0, 'summary': u'I am using Bamboo 3.3 on Ubuntu Lucid with a single remote agent on Windows 7 and sometimes the remote agent throws the following exception repeatedly:\r\n \r\nSTATUS | wrapper | 2011/12/16 00:17:48 | Launching a JVM...INFO | jvm 442 | 2011/12/16 00:17:48 | Wrapper (Version 3.2.3-atlassian-1) http:/', 'title': u'Exception on Windows Remote Agent', 'url': '/questions/25873/exception-on-windows-remote-agent'}

,

{'score': 0, 'summary': u"Hi all. I'm writing a JIRA plugin with a gadget that uses JIRA REST services to retrieve different information using AJAX and displays this within UI blocks with visual effects. Don't ask me why :). The one point of the UI is the UI should display the projects that are currently avaliable for logged", 'title': u'Need review of the approach "Select all assignees for all issues in the particular project"', 'url': '/questions/26843/need-review-of-the-approach-select-all-assignees-for-all-issues-in-the-particular-project'}

,

{'score': 0, 'summary': u'Hello, i made a gadget and proved it succesfully in the atlassian plugin sdk and in a testing instance of jira 4.1.2.\r\nI decided to prove it on another Jira testing instance and the gadget is not loading when jira starts. Here i attach the log:\r\n\r\n2011-09-14 11:13:14,576 Thread-1 ERROR [atlass', 'title': u'Gadget not loading When Jira starts', 'url': '/questions/11678/gadget-not-loading-when-jira-starts'}

,

{'score': 0, 'summary': u'How can I get the source code for the latest version of the JIRA Importers Plugin (JIM)?\r\nMy organization has a download licence, and I’ve downloaded the source code to Jira proper. That has an older version of the JIRA Importers Plugin. But I wanted to get the latest version (currently 3.5.', 'title': u'How can I get the source code for the latest version of the JIRA Importers Plugin (JIM)?', 'url': '/questions/21805/how-can-i-get-the-source-code-for-the-latest-version-of-the-jira-importers-plugin-jim'}

],
'can_rank': True,
'questions': [<Question: Problem in file upload form on Confluence>, <Question: Upgrading from 4.3.4 to 4.4.1 - reindex completes at 99% with a system crash>, <Question: Please complete the following form to determine if Confluence is compliant for USA Government use. (GPAT)>, <Question: Jira hanging frequently after the upgrade from 3.13.5 to 4.2.4>, <Question: Workaround Manage Versions Bug JRA-26083: Project config Versions problem when loading large list of versions>, <Question: Best way to not hard code custom field names in Code?>, <Question: Exception on Windows Remote Agent>, <Question: Need review of the approach "Select all assignees for all issues in the particular project">, <Question: Gadget not loading When Jira starts>, <Question: How can I get the source code for the latest version of the JIRA Importers Plugin (JIM)?>, <Question: How to get option id from selectlist custome filed?>, <Question: how can i display the UUID for jira mobile connect within jira?>, <Question: One repository or many?>, <Question: [Plugin SDK]Error changing gadget version from 4.0.1 to 4.3>, <Question: In Jira 5 external javascript library doesn't included for customfield in "create issue" popup on dashboard>, <Question: Bulk operations on Issues in JIRA>, <Question: Jira Studio "limitations">, <Question: How can I copy Summary and Description when creating a SubTask?>, <Question: History on comment update>, <Question: Diff. in filter output between TWO Dates>, '...(remaining elements truncated)...'],
'request': <WSGIRequest
GET:<QueryDict: {}>,
POST:<QueryDict:

{u'title': [u"When Using Lotus Notes w're having problems with slow loading of JIRA mails (up t. Is there a setting in Lotus notus which can prevent the loading of these symbols? Or is there an a solution on the site of JIRA?"]}

>,
COOKIES:

{'_GPL_it': '1', '__unam': '3b7d60-134d8f4995a-5665e696-1', '__utma': '215707591.139972727.1326491746.1326491746.1326491746.1', '__utmb': '215707591.2.10.1326491746', '__utmc': '215707591', '__utmv': '215707591.|1=ft=forums.atlassian.com!referral!!message.jspa!referral=1', '__utmz': '215707591.1326491746.1.1.utmcsr=atlassian.com|utmccn=(referral)|utmcmd=referral|utmcct=/resources/support', 'csrftoken': 'ff6399f094fe74d45038f71eddad2b8d', 'sessionid': '9d4df20fd4bade9a2f615ab8475cba4c'}

,
META:

{'CONTENT_LENGTH': '221', 'CONTENT_TYPE': 'application/x-www-form-urlencoded; charset=UTF-8', 'CSRF_COOKIE': 'ff6399f094fe74d45038f71eddad2b8d', 'HTTP_ACCEPT': 'application/json, text/javascript, */*', 'HTTP_ACCEPT_CHARSET': 'ISO-8859-1,utf-8;q=0.7,*;q=0.7', 'HTTP_ACCEPT_ENCODING': 'gzip, deflate', 'HTTP_ACCEPT_LANGUAGE': 'nl,en-us;q=0.7,en;q=0.3', 'HTTP_CACHE_CONTROL': 'no-cache', 'HTTP_CONNECTION': 'close', 'HTTP_COOKIE': '__utma=80426056.1835459137.1326489839.1326489839.1326491716.2; __utmc=80426056; __utmz=80426056.1326489839.1.1.utmcsr=forums.atlassian.com|utmccn=(referral)|utmcmd=referral|utmcct=/message.jspa; __unam=3b7d60-134d8f4995a-5665e696-1; _GPL_it=1; __utmb=80426056.8.10.1326491716; __utmv=80426056.|1=ft=forums.atlassian.com!referral!!message.jspa!referral=1; sessionid=9d4df20fd4bade9a2f615ab8475cba4c; __utma=215707591.139972727.1326491746.1326491746.1326491746.1; __utmb=215707591.2.10.1326491746; __utmc=215707591; __utmz=215707591.1326491746.1.1.utmcsr=atlassian.com|utmccn=(referral)|utmcmd=referral|utmcct=/resources/support; __utmv=215707591.|1=ft=forums.atlassian.com!referral!!message.jspa!referral=1; csrftoken=ff6399f094fe74d45038f71eddad2b8d', 'HTTP_DNT': '1', 'HTTP_HOST': 'answers.atlassian.com', 'HTTP_PRAGMA': 'no-cache', 'HTTP_REFERER': 'https://answers.atlassian.com/questions/ask/', 'HTTP_USER_AGENT': 'Mozilla/5.0 (Windows NT 5.1; rv:8.0.1) Gecko/20100101 Firefox/8.0.1', 'HTTP_X_CSRFTOKEN': 'ff6399f094fe74d45038f71eddad2b8d', 'HTTP_X_FORWARDED_FOR': '80.254.148.123, 172.16.3.45', 'HTTP_X_REAL_IP': '80.254.148.123', 'HTTP_X_REQUESTED_WITH': 'XMLHttpRequest', 'PATH_INFO': u'/questions/related_questions/', 'QUERY_STRING': '', 'RAW_URI': '/questions/related_questions/', 'REMOTE_ADDR': '172.16.3.45', 'REMOTE_PORT': '80', 'REQUEST_METHOD': 'POST', 'SCRIPT_NAME': u'', 'SERVER_NAME': 'answers.atlassian.com', 'SERVER_PORT': '80', 'SERVER_PROTOCOL': 'HTTP/1.0', 'SERVER_SOFTWARE': 'gunicorn/0.12.0', 'gunicorn.socket': <socket._socketobject object at 0x191f80c0>, 'wsgi.errors': <open file '<stderr>', mode 'w' at 0x2b277a4591e0>, 'wsgi.input': <gunicorn.http.body.Body object at 0x1629ff10>, 'wsgi.multiprocess': True, 'wsgi.multithread': False, 'wsgi.run_once': False, 'wsgi.url_scheme': 'http', 'wsgi.version': (1, 0)}

>}

File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/models/query.py", line 105, in _result_iter
self._fill_cache()

Arguments: _result_iter(self=<forum.models.node.NodeQuerySet object at 0x131b03d0 (really long repr)>)
Local variables:

{'pos': 0, 'self': [<Question: Problem in file upload form on Confluence>, <Question: Upgrading from 4.3.4 to 4.4.1 - reindex completes at 99% with a system crash>, <Question: Please complete the following form to determine if Confluence is compliant for USA Government use. (GPAT)>, <Question: Jira hanging frequently after the upgrade from 3.13.5 to 4.2.4>, <Question: Workaround Manage Versions Bug JRA-26083: Project config Versions problem when loading large list of versions>, <Question: Best way to not hard code custom field names in Code?>, <Question: Exception on Windows Remote Agent>, <Question: Need review of the approach "Select all assignees for all issues in the particular project">, <Question: Gadget not loading When Jira starts>, <Question: How can I get the source code for the latest version of the JIRA Importers Plugin (JIM)?>], 'upper': 0}

File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/models/query.py", line 783, in _fill_cache
self._result_cache.append(self._iter.next())

Arguments: _fill_cache(self=<forum.models.node.NodeQuerySet object at 0x131b03d0 (really long repr)>, num=None)
Local variables:

{'i': 0, 'num': None, 'self': [<Question: Problem in file upload form on Confluence>, <Question: Upgrading from 4.3.4 to 4.4.1 - reindex completes at 99% with a system crash>, <Question: Please complete the following form to determine if Confluence is compliant for USA Government use. (GPAT)>, <Question: Jira hanging frequently after the upgrade from 3.13.5 to 4.2.4>, <Question: Workaround Manage Versions Bug JRA-26083: Project config Versions problem when loading large list of versions>, <Question: Best way to not hard code custom field names in Code?>, <Question: Exception on Windows Remote Agent>, <Question: Need review of the approach "Select all assignees for all issues in the particular project">, <Question: Gadget not loading When Jira starts>, <Question: How can I get the source code for the latest version of the JIRA Importers Plugin (JIM)?>]}

File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/models/query.py", line 271, in iterator
for row in compiler.results_iter():

Arguments: iterator(self=<forum.models.node.NodeQuerySet object at 0x131b03d0 (really long repr)>)
Local variables:

{'aggregate_select': [],
'aggregate_start': 20,
'compiler': <django.db.models.sql.compiler.SQLCompiler object at 0x131b00d0>,
'db': 'default',
'extra_select': ['ranking'],
'fields': [<django.db.models.fields.AutoField object at 0x13d8d590>,
<django.db.models.fields.CharField object at 0x13d8df50>,
<django.db.models.fields.CharField object at 0x13d8df90>,
<django.db.models.fields.related.ForeignKey object at 0x13d8dfd0>,
<django.db.models.fields.TextField object at 0x13d91150>,
<django.db.models.fields.CharField object at 0x13d86b50>,
<django.db.models.fields.related.ForeignKey object at 0x13d86d90>,
<django.db.models.fields.related.ForeignKey object at 0x13d86e50>,
<django.db.models.fields.DateTimeField object at 0x13d86ed0>,
<django.db.models.fields.IntegerField object at 0x13d86f10>,
<django.db.models.fields.TextField object at 0x13d86f50>,
<django.db.models.fields.related.ForeignKey object at 0x13d86f90>,
<django.db.models.fields.related.ForeignKey object at 0x13d8d050>,
<django.db.models.fields.DateTimeField object at 0x13d8d0d0>,
<django.db.models.fields.related.OneToOneField object at 0x13d8d210>,
<forum.models.utils.PickledObjectField object at 0x13d8d2d0>,
<django.db.models.fields.related.ForeignKey object at 0x13d8d310>,
<django.db.models.fields.IntegerField object at 0x13d8d390>,
<django.db.models.fields.BooleanField object at 0x13d8d3d0>],
'fill_cache': False,
'index_start': 1,
'load_fields': [],
'max_depth': 5,
'model': <class 'forum.models.question.Question'>,
'only_load': {},
'pk_idx': 0,
'requested': None,
'self': [<Question: Problem in file upload form on Confluence>, <Question: Upgrading from 4.3.4 to 4.4.1 - reindex completes at 99% with a system crash>, <Question: Please complete the following form to determine if Confluence is compliant for USA Government use. (GPAT)>, <Question: Jira hanging frequently after the upgrade from 3.13.5 to 4.2.4>, <Question: Workaround Manage Versions Bug JRA-26083: Project config Versions problem when loading large list of versions>, <Question: Best way to not hard code custom field names in Code?>, <Question: Exception on Windows Remote Agent>, <Question: Need review of the approach "Select all assignees for all issues in the particular project">, <Question: Gadget not loading When Jira starts>, <Question: How can I get the source code for the latest version of the JIRA Importers Plugin (JIM)?>],
'skip': None}

File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/models/sql/compiler.py", line 677, in results_iter
for rows in self.execute_sql(MULTI):

Arguments: results_iter(self=<django.db.models.sql.compiler.SQLCompiler object at 0x131b00d0>)
Local variables:

{'fields': None, 'has_aggregate_select': False, 'resolve_columns': False, 'self': <django.db.models.sql.compiler.SQLCompiler object at 0x131b00d0>}

File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/models/sql/compiler.py", line 732, in execute_sql
cursor.execute(sql, params)

Arguments: execute_sql(self=<django.db.models.sql.compiler.SQLCompiler object at 0x131b00d0>, result_type='multi')