search

mysociety / citizenconnect

Citizen Connect project for the NHS: reporting problems, leaving reviews
https://www.nhs.uk/careconnect/choices
Other
1 stars 0 forks source link

Errors getting lock on problem when saving survey #1302

Open stevenday opened 10 years ago

stevenday commented 10 years ago

DatabaseError: could not obtain lock on row in relation "issues_problem"

Traceback (most recent call last):

  File "/usr/lib/python2.7/dist-packages/django/core/handlers/base.py", line 111, in get_response
    response = callback(request, *callback_args, **callback_kwargs)

  File "/usr/lib/python2.7/dist-packages/django/views/generic/base.py", line 48, in view
    return self.dispatch(request, *args, **kwargs)

  File "/usr/lib/python2.7/dist-packages/django/views/generic/base.py", line 69, in dispatch
    return handler(request, *args, **kwargs)

  File "/usr/lib/python2.7/dist-packages/django/views/generic/edit.py", line 190, in get
    self.object = self.get_object()

  File "/data/vhost/citizenconnect.mysociety.org/citizenconnect/issues/views.py", line 138, in get_object
    problem.save()

  File "/data/vhost/citizenconnect.mysociety.org/citizenconnect/issues/models.py", line 582, in save
    concurrency_check(self, *args, **kwargs)  # Do a concurrency check

  File "/data/vhost/citizenconnect.mysociety.org/virtualenv-citizenconnect/lib/python2.7/site-packages/concurrency/api.py", line 58, in concurrency_check
    _select_lock(model_instance)

  File "/data/vhost/citizenconnect.mysociety.org/virtualenv-citizenconnect/lib/python2.7/site-packages/concurrency/core.py", line 47, in _select_lock
    if not entry:

  File "/usr/lib/python2.7/dist-packages/django/db/models/query.py", line 130, in __nonzero__
    iter(self).next()

  File "/usr/lib/python2.7/dist-packages/django/db/models/query.py", line 118, in _result_iter
    self._fill_cache()

  File "/usr/lib/python2.7/dist-packages/django/db/models/query.py", line 892, in _fill_cache
    self._result_cache.append(self._iter.next())

  File "/usr/lib/python2.7/dist-packages/django/db/models/query.py", line 291, in iterator
    for row in compiler.results_iter():

  File "/usr/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 763, in results_iter
    for rows in self.execute_sql(MULTI):

  File "/usr/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 818, in execute_sql
    cursor.execute(sql, params)

  File "/usr/lib/python2.7/dist-packages/django/db/backends/postgresql_psycopg2/base.py", line 52, in execute
    return self.cursor.execute(query, args)

DatabaseError: could not obtain lock on row in relation "issues_problem"

<WSGIRequest
path:/careconnect/myhealthlondon/survey/y/7g-kvb-REDACTED,
GET:<QueryDict: {}>,
POST:<QueryDict: {}>,
COOKIES:{'csrftoken': 'REDACTED',
 'device': '3',
 'device_type': '0'},
META:{'CSRF_COOKIE': 'REDACTED',
 'DOCUMENT_ROOT': '/data/vhost/citizenconnect.mysociety.org/docs',
 'GATEWAY_INTERFACE': 'CGI/1.1',
 'HTTP_ACCEPT': 'text/html, application/xhtml+xml, */*',
 'HTTP_ACCEPT_ENCODING': 'gzip',
 'HTTP_ACCEPT_LANGUAGE': 'en-GB',
 'HTTP_COOKIE': 'csrftoken=REDACTED; device=3; device_type=0',
 'HTTP_DNT': '1',
 'HTTP_HOST': 'citizenconnect.mysociety.org',
 'HTTP_USER_AGENT': 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko',
 'HTTP_X_FORWARDED_FOR': 'REDACTED',
 'HTTP_X_FORWARDED_HOST': 'www.myhealth.london.nhs.uk',
 'HTTP_X_FORWARDED_PROTO': 'https',
 'HTTP_X_FORWARDED_SERVER': 'www.myhealth.london.nhs.uk',
 'HTTP_X_REAL_IP': 'REDACTED',
 'HTTP_X_VARNISH': '1549858135',
 'PATH_INFO': u'/careconnect/myhealthlondon/survey/y/REDACTED',
 'PATH_TRANSLATED': '/data/vhost/citizenconnect.mysociety.org/citizenconnect/citizenconnect/wsgi.py/careconnect/myhealthlondon/survey/y/REDACTED',
 'QUERY_STRING': '',
 'REMOTE_ADDR': 'REDACTED',
 'REMOTE_PORT': '58771',
 'REQUEST_METHOD': 'GET',
 'REQUEST_URI': '/careconnect/myhealthlondon/survey/y/REDACTED',
 'SCRIPT_FILENAME': '/data/vhost/citizenconnect.mysociety.org/citizenconnect/citizenconnect/wsgi.py',
 'SCRIPT_NAME': u'',
 'SCRIPT_URI': 'http://citizenconnect.mysociety.org/careconnect/myhealthlondon/survey/y/REDACTED',
 'SCRIPT_URL': '/careconnect/myhealthlondon/survey/y/REDACTED',
 'SERVER_ADDR': '127.0.0.1',
 'SERVER_ADMIN': 'webmaster@mysociety.org',
 'SERVER_NAME': 'citizenconnect.mysociety.org',
 'SERVER_PORT': '80',
 'SERVER_PROTOCOL': 'HTTP/1.0',
 'SERVER_SIGNATURE': '',
 'SERVER_SOFTWARE': 'Apache',
 'mod_wsgi.application_group': 'citizenconnect.mysociety.org|',
 'mod_wsgi.callable_object': 'application',
 'mod_wsgi.handler_script': '',
 'mod_wsgi.input_chunked': '0',
 'mod_wsgi.listener_host': '127.0.0.1',
 'mod_wsgi.listener_port': '80',
 'mod_wsgi.process_group': 'citizenconnect.mysociety.org',
 'mod_wsgi.request_handler': 'wsgi-script',
 'mod_wsgi.script_reloading': '1',
 'mod_wsgi.version': (3, 3),
 'wsgi.errors': <mod_wsgi.Log object at 0x7f3376b51e70>,
 'wsgi.file_wrapper': <built-in method file_wrapper of mod_wsgi.Adapter object at 0x7f33766ffaf8>,
 'wsgi.input': <mod_wsgi.Input object at 0x7f3376a2fe70>,
 'wsgi.multiprocess': True,
 'wsgi.multithread': False,
 'wsgi.run_once': False,
 'wsgi.url_scheme': 'http',
 'wsgi.version': (1, 1)}>