Details
-
Bug
-
Resolution: Fixed
-
Medium
-
Severity 3 - Minor
-
Description
NOTE: This bug report is for Confluence Cloud. Using Confluence Server? See the corresponding bug report.
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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':
,
'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:
>,
COOKIES:
,
META:
>,
'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:
>,
COOKIES:
,
META:
>,
'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'},
,
,
,
,
,
,
,
,
],
'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:
>,
COOKIES:
,
META:
>}
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:
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:
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:
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')
Attachments
Issue Links
- is related to
-
CONFSERVER-47060 Related Questions is performing poorly
- Closed