IntegrityError: duplicate key value violates unique constraint "forum_userproperty_pkey"

XMLWordPrintable

    • Severity 3 - Minor

      NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.

      Sample stacktrace:

      Traceback (most recent call last):
      
        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/lib/python2.6/site-packages/newrelic-1.11.0.55/newrelic/api/object_wrapper.py", line 216, in __call__
          self._nr_instance, args, kwargs)
      
        File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/newrelic-1.11.0.55/newrelic/hooks/framework_django.py", line 475, in wrapper
          return wrapped(*args, **kwargs)
      
        File "/opt/python/domains/atlassian.com/answers/ADM-35763/forum/modules/decorators.py", line 95, in decorated
          return decoratable(*args, **kwargs)
      
        File "/opt/python/domains/atlassian.com/answers/ADM-35763/forum/modules/decorators.py", line 55, in __call__
          res = self._callable(*args, **kwargs)
      
        File "/opt/python/domains/atlassian.com/answers/ADM-35763/forum/modules/decorators.py", line 30, in <lambda>
          self._callable = lambda *args, **kwargs: fn(origin, *args, **kwargs)
      
        File "/opt/python/domains/atlassian.com/answers/ADM-35763/forum_modules/exporter/mappings.py", line 27, in match_question_slug
          return origin(request, id, slug, answer)
      
        File "/opt/python/domains/atlassian.com/answers/ADM-35763/forum/views/readers.py", line 685, in question
          "type": type,
      
        File "/opt/python/domains/atlassian.com/answers/ADM-35763/forum/utils/pagination.py", line 285, in paginated
          tpl_context[list_name] = _paginated(request, tpl_context[list_name], paginatorInstance)
      
        File "/opt/python/domains/atlassian.com/answers/ADM-35763/forum/utils/pagination.py", line 465, in _paginated
          paginatorContext.set_preferences(request, session_prefs)
      
        File "/opt/python/domains/atlassian.com/answers/ADM-35763/forum/utils/pagination.py", line 144, in set_preferences
          request.user.prop.pagination = all_preferences
      
        File "/opt/python/domains/atlassian.com/answers/ADM-35763/forum/models/user.py", line 544, in __setattr__
          current.save( full_save = True )
      
        File "/opt/python/domains/atlassian.com/answers/ADM-35763/forum/models/base.py", line 174, in save
          super(BaseModel, self).save()
      
        File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/models/base.py", line 458, in save
          self.save_base(using=using, force_insert=force_insert, force_update=force_update)
      
        File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/models/base.py", line 551, in save_base
          result = manager._insert(values, return_id=update_pk, using=using)
      
        File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/models/manager.py", line 195, in _insert
          return insert_query(self.model, values, **kwargs)
      
        File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/models/query.py", line 1524, in insert_query
          return query.get_compiler(using=using).execute_sql(return_id)
      
        File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/django/db/models/sql/compiler.py", line 788, in execute_sql
          cursor = super(SQLInsertCompiler, self).execute_sql(None)
      
        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)
      
        File "/opt/python/domains/atlassian.com/answers/lib/python2.6/site-packages/newrelic-1.11.0.55/newrelic/hooks/database_dbapi2.py", line 36, in execute
          return self._nr_cursor.execute(sql, *args, **kwargs)
      
      IntegrityError: duplicate key value violates unique constraint "forum_userproperty_pkey"
      
      
      
      <WSGIRequest
      GET:<QueryDict: {u'application': [u'aac'], u'continue': [u'http://answers.atlassian.com/questions/39168/jira-startup-failed-you-cannot-access-jira-at-present-look-at-the-table-below-to-identify-the-reasons']}>,
      POST:<QueryDict: {}>,
      COOKIES:{'__ATL_TOKEN': 'db5zH9062nBhSJdVuskXsA00',
       '__utma': '80426056.968451926.1367219940.1367579716.1367584960.9',
       '__utmb': '80426056.27.10.1367584960',
       '__utmc': '80426056',
       '__utmz': '80426056.1367579716.8.5.utmcsr=google|utmccn=(organic)|utmcmd=organic|utmctr=(not%20provided)',
       'optimizelyBuckets': '%7B%22210399100%22%3A%22210218939%22%2C%22218428071%22%3A%22219067318%22%2C%22218983035%22%3A%22218960389%22%7D',
       'optimizelyCustomEvents': '%7B%22oeu1367298386637r0.028462484013289213%22%3A%5B%22clicked_home_hero_1_cta%22%5D%7D',
       'optimizelyEndUserId': 'oeu1367298386637r0.028462484013289213',
       'optimizelySegments': '%7B%22172567725%22%3A%22gc%22%2C%22172648779%22%3A%22false%22%2C%22172668220%22%3A%22search%22%2C%22176560975%22%3A%22search%22%2C%22176875467%22%3A%22gc%22%2C%22176926205%22%3A%22false%22%7D'},
      META:{'CSRF_COOKIE': 'cd3a250f82db9f49fae8b064499d7caf',
       'HTTP_ACCEPT': 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
       'HTTP_ACCEPT_CHARSET': 'ISO-8859-1,utf-8;q=0.7,*;q=0.3',
       'HTTP_ACCEPT_ENCODING': 'gzip,deflate,sdch',
       'HTTP_ACCEPT_LANGUAGE': 'de-DE,de;q=0.8,en-US;q=0.6,en;q=0.4',
       'HTTP_CONNECTION': 'close',
       'HTTP_COOKIE': 'optimizelyEndUserId=oeu1367298386637r0.028462484013289213; optimizelyCustomEvents=%7B%22oeu1367298386637r0.028462484013289213%22%3A%5B%22clicked_home_hero_1_cta%22%5D%7D; __ATL_TOKEN=db5zH9062nBhSJdVuskXsA00; optimizelySegments=%7B%22172567725%22%3A%22gc%22%2C%22172648779%22%3A%22false%22%2C%22172668220%22%3A%22search%22%2C%22176560975%22%3A%22search%22%2C%22176875467%22%3A%22gc%22%2C%22176926205%22%3A%22false%22%7D; optimizelyBuckets=%7B%22210399100%22%3A%22210218939%22%2C%22218428071%22%3A%22219067318%22%2C%22218983035%22%3A%22218960389%22%7D; __utma=80426056.968451926.1367219940.1367579716.1367584960.9; __utmb=80426056.27.10.1367584960; __utmc=80426056; __utmz=80426056.1367579716.8.5.utmcsr=google|utmccn=(organic)|utmcmd=organic|utmctr=(not%20provided)',
       'HTTP_HOST': '127.0.0.1:9080',
       'HTTP_REFERER': 'https://www.google.de/',
       'HTTP_USER_AGENT': 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.64 Safari/537.31',
       'HTTP_X_FORWARDED_FOR': '89.246.237.146, 172.16.1.187, 127.0.0.1',
       'HTTP_X_FORWARDED_HOST': 'answers.atlassian.com',
       'HTTP_X_FORWARDED_SERVER': 'osqa-production.private.atlassian.com',
       'HTTP_X_REAL_IP': '89.246.237.146',
       'HTTP___ATL_DISPLAY_NAME': 'Tobias Hochg\xc3\xbcrtel',
       'HTTP___ATL_FAMILY_NAME': 'Hochg\xc3\xbcrtel',
       'HTTP___ATL_GIVEN_NAME': 'Tobias',
       'HTTP___ATL_GROUP_MEMBERSHIP': '',
       'HTTP___ATL_LOCAL_USER': 'tobias.hochguertel@googlemail.com',
       'HTTP___ATL_USER': 'tobias.hochguertel@googlemail.com',
       'PATH_INFO': u'/questions/39168/jira-startup-failed-you-cannot-access-jira-at-present-look-at-the-table-below-to-identify-the-reasons',
       'QUERY_STRING': 'application=aac&continue=http%3A%2F%2Fanswers.atlassian.com%2Fquestions%2F39168%2Fjira-startup-failed-you-cannot-access-jira-at-present-look-at-the-table-below-to-identify-the-reasons',
       'RAW_URI': '/questions/39168/jira-startup-failed-you-cannot-access-jira-at-present-look-at-the-table-below-to-identify-the-reasons?application=aac&continue=http%3A%2F%2Fanswers.atlassian.com%2Fquestions%2F39168%2Fjira-startup-failed-you-cannot-access-jira-at-present-look-at-the-table-below-to-identify-the-reasons',
       'REMOTE_ADDR': '127.0.0.1',
       'REMOTE_PORT': '80',
       'REQUEST_METHOD': 'GET',
       'SCRIPT_NAME': u'',
       'SERVER_NAME': '127.0.0.1',
       'SERVER_PORT': '9080',
       'SERVER_PROTOCOL': 'HTTP/1.0',
       'SERVER_SOFTWARE': 'gunicorn/0.14.1',
       'gunicorn.socket': <socket._socketobject object at 0x2aaab49c6050>,
       'wsgi.errors': <open file '<stderr>', mode 'w' at 0x2b5e0b49b1e0>,
       'wsgi.file_wrapper': <class gunicorn.http.wsgi.FileWrapper at 0x101b2dd0>,
       'wsgi.input': <newrelic.api.web_transaction.WSGIInputWrapper object at 0x2aaaacefed50>,
       'wsgi.multiprocess': True,
       'wsgi.multithread': False,
       'wsgi.run_once': False,
       'wsgi.url_scheme': 'http',
       'wsgi.version': (1, 0)}>
      

            Assignee:
            eternicode
            Reporter:
            Dennis Kromhout van der Meer (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: