Comment 3 for bug 640179

oops data here:

Oops-Id: 1720appserverZBFacbJCAcAHaEDdJJHfBfEAcaEJJcGaf29485
Exception-Type: IntegrityError
Exception-Value: duplicate key value violates unique constraint "share_shared_to_key"
Date: 2010-09-16T04:26:10.479708+00:00
Branch: ubunet-rev-3160
Revision: 3160
Last-Update: 2010-09-07 15:16:56 +0100
URL: /files/shareoffer/0eb1b1d3-eaed-40cf-8f56-95422383c551/claim/
HTTP-Status: 500
Duration: 0.424609899521

HTTP_REFERER=https://one.ubuntu.com/files/shareoffer/0eb1b1d3-eaed-40cf-8f56-95422383c551/
request-end=1284611170.48
SCRIPT_NAME=
REQUEST_METHOD=POST
PATH_INFO=/files/shareoffer/0eb1b1d3-eaed-40cf-8f56-95422383c551/claim/
HTTP_ORIGIN=https://one.ubuntu.com
SERVER_PROTOCOL=HTTP/1.1
QUERY_STRING=
CONTENT_LENGTH=52
HTTP_ACCEPT_CHARSET=ISO-8859-1,utf-8;q=0.7,*;q=0.3
HTTP_USER_AGENT=Mozilla/5.0 (X11; U; Linux x86_64; en-US) AppleWebKit/534.3 (KHTML, like Gecko) Ubuntu/10.10 Chromium/6.0.472.53 Chrome/6.0.472.53 Safari/534.3
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=__utmz=78170954.1284578682.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); currency=USD; sessionid=7905fdee806223836c5d71d9056e0690; __utma=78170954.794566597.1284611138.1284611138.1284611138.1; __utmc=78170954; __utmb=78170954.1.10.1284611138
SERVER_NAME=one.ubuntu.com
REMOTE_ADDR=190.190.97.66
wsgi.url_scheme=https
HTTP_VIA=1.1 one.ubuntu.com
SERVER_PORT=9003
HTTP_HOST=one.ubuntu.com
HTTP_CACHE_CONTROL=max-age=0
HTTP_ACCEPT=application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
http-code=500
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.8
request-start=1284611170.05
CONTENT_TYPE=application/x-www-form-urlencoded
HTTP_ACCEPT_ENCODING=gzip,deflate,sdch

0000-0025 SELECT auth_user.date_joined, auth_user.last_login, auth_user.email, auth_user.first_name, auth_user.id, auth_user.is_active, auth_user.is_staff, auth_user.is_superuser, auth_user.last_name, auth_user.password, auth_user.username FROM auth_user WHERE auth_user.id = %s LIMIT 1
0025-0106 SELECT Share.accepted, Share.access, Share.email, Share.id, Share.name, Share.shared_by, Share.shared_to, Share.status, Share.subtree, Share.when_last_changed, Share.when_shared, StorageUser.id, StorageUser.root_volume_id, StorageUser.shard_id, StorageUser.status, StorageUser.subscription_status, StorageUser.username, StorageUser.visible_name FROM Share, StorageUser WHERE Share.shared_by = StorageUser.id AND Share.id = %s AND Share.status = %s
0106-0116 SELECT StorageUser.id, StorageUser.root_volume_id, StorageUser.shard_id, StorageUser.status, StorageUser.subscription_status, StorageUser.username, StorageUser.visible_name FROM StorageUser WHERE StorageUser.id = %s LIMIT 1
0116-0127 SELECT Share.accepted, Share.access, Share.email, Share.id, Share.name, Share.shared_by, Share.shared_to, Share.status, Share.subtree, Share.when_last_changed, Share.when_shared FROM Share WHERE Share.shared_by = %s AND Share.shared_to = %s AND Share.status = %s AND Share.subtree = %s
0127-0146 UPDATE Share SET accepted=%s, shared_to=%s WHERE Share.id = %s

Traceback (most recent call last):
  Module /srv/ubuntuone.com/production/ubunet-rev-3160/utilities/../lib/storm/database.py, line 366, in _check_disconnect
    return function(*args, **kwargs)
  Module /srv/ubuntuone.com/production/ubunet-rev-3160/utilities/../lib/storm/database.py, line 321, in raw_execute
    self._check_disconnect(raw_cursor.execute, *args)
  Module /srv/ubuntuone.com/production/ubunet-rev-3160/utilities/../lib/storm/databases/postgres.py, line 259, in raw_execute
    return Connection.raw_execute(self, statement, params)

Module /srv/ubuntuone.com/production/ubunet-rev-3160/utilities/../lib/storm/database.py, line 237, in execute
    raw_cursor = self.raw_execute(statement, params)
  Module /srv/ubuntuone.com/production/ubunet-rev-3160/utilities/../lib/storm/databases/postgres.py, line 249, in execute
    return Connection.execute(self, statement, params, noresult)
  Module /srv/ubuntuone.com/production/ubunet-rev-3160/utilities/../lib/storm/store.py, line 549, in _flush_one
    self._connection.execute(expr, noresult=True)
  Module /srv/ubuntuone.com/production/ubunet-rev-3160/utilities/../lib/storm/store.py, line 489, in flush
    self._flush_one(obj_info)
  Module /srv/ubuntuone.com/production/ubunet-rev-3160/utilities/../lib/storm/zope/zstorm.py, line 251, in tpc_begin
    self._store.flush()
  Module /srv/ubuntuone.com/production/ubunet-rev-3160/utilities/../lib/transaction/_transaction.py, line 414, in _commitResources
    rm.tpc_begin(self)
  Module /srv/ubuntuone.com/production/ubunet-rev-3160/utilities/../lib/transaction/_transaction.py, line 322, in commit
    self._commitResources()
  Module /srv/ubuntuone.com/production/ubunet-rev-3160/utilities/../lib/transaction/_manager.py, line 93, in commit
    return self.get().commit()
  Module /srv/ubuntuone.com/production/ubunet-rev-3160/utilities/../lib/ubuntuone/storage/data/stormutil.py, line 158, in decorated
    tx_manager.commit()
  Module /srv/ubuntuone.com/production/ubunet-rev-3160/utilities/../lib/ubuntuone/storage/data/stormutil.py, line 67, in decorated
    value = function(*args, **kwargs)
  Module /srv/ubuntuone.com/production/ubunet-rev-3160/utilities/../lib/ubuntuone/web/files/views.py, line 597, in claim_share_offer
    str(shareofferid))
  Module /srv/ubuntuone.com/production/ubunet-rev-3160/utilities/../lib/django/views/decorators/http.py, line 31, in inner
    return func(request, *args, **kwargs)
  Module /srv/ubuntuone.com/production/ubunet-rev-3160/utilities/../lib/django/contrib/auth/decorators.py, line 67, in __call__
    return self.view_func(request, *args, **kwargs)
  Module /srv/ubuntuone.com/production/ubunet-rev-3160/utilities/../lib/django/core/handlers/base.py, line 86, in get_response
    response = callback(request, *callback_args, **callback_kwargs)
  Module /srv/ubuntuone.com/production/ubunet-rev-3160/utilities/../lib/django/core/handlers/wsgi.py, line 239, in __call__
    response = self.get_response(request)
  Module /usr/lib/pymodules/python2.6/paste/translogger.py, line 68, in __call__
    return self.application(environ, replacement_start_response)
IntegrityError: ' duplicate key value violates unique constraint "share_shared_to_key"'

== EXTRA DATA ==
{'log': {'records': [{'created': 1284611170.4387231,
                      'filename': 'handlers.py',
                      'funcName': 'handle_uncaught_exception',
                      'levelname': 'ERROR',
                      'levelno': 40,
                      'lineno': 48,
                      'message': 'WSGI Handled Exception (OOPSID 1720appserverZBFacbJCAcAHaEDdJJHfBfEAcaEJJcGaf29485)',
                      'module': 'handlers',
                      'msecs': 438.72308731079102,
                      'msg': 'WSGI Handled Exception (OOPSID 1720appserverZBFacbJCAcAHaEDdJJHfBfEAcaEJJcGaf29485)',
                      'name': 'root',
                      'pathname': '/srv/ubuntuone.com/production/ubunet-rev-3160/utilities/../lib/ubuntuone/wsgi/handlers.py',
                      'process': 32224,
                      'processName': 'MainProcess',
                      'relativeCreated': 75022372.734069824,
                      'thread': 140442167383824,
                      'threadName': 'Thread-164578'}]},
 'version': {'version': 'log 1\nmetadata 1\noops 1\nserializer 2\nstorm 1\n'}}