Unable to upload file - TransactionRollbackError at /upload/

[Kevin Gibbs]

Using the web interface, I browse to a file for uploading and then click on the "upload" button.
The first time I tried this it seemed to timed out (sorry, but I didn't capture the message)

I retired the operation and, after a while, the following message appears:

TransactionRollbackError at /upload/

deadlock detected
DETAIL: Process 16864 waits for ExclusiveLock on tuple (10202,18) of relation 26795 of database 26735; blocked by process 12322.
Process 12322 waits for ShareLock on transaction 3330764; blocked by process 16864.

Request Method: POST
Request URL: https://domU-12-31-38-00-38-E6.compute-1.internal/upload/
Exception Type: TransactionRollbackError
Exception Value:

deadlock detected
DETAIL: Process 16864 waits for ExclusiveLock on tuple (10202,18) of relation 26795 of database 26735; blocked by process 12322.
Process 12322 waits for ShareLock on transaction 3330764; blocked by process 16864.

Exception Location: /srv/ubuntuone.com/ubunet/utilities/../lib/storm/database.py in _check_disconnect, line 325
Python Executable: /usr/bin/python
Python Version: 2.5.2
Python Path: ['/srv/ubuntuone.com/ubunet/utilities/../lib', '/srv/ubuntuone.com/ubunet/utilities', '/srv/ubuntuone.com/ubunet/lib', '/usr/lib/python25.zip', '/usr/lib/python2.5', '/usr/lib/python2.5/plat-linux2', '/usr/lib/python2.5/lib-tk', '/usr/lib/python2.5/lib-dynload', '/usr/local/lib/python2.5/site-packages', '/usr/lib/python2.5/site-packages', '/usr/lib/python2.5/site-packages/PIL', '/var/lib/python-support/python2.5']
Server time: Wed, 1 Jul 2009 13:30:03 +0530

Traceback is as follows:
Environment:

Request Method: POST
Request URL: https://domU-12-31-38-00-38-E6.compute-1.internal/upload/
Django Version: 1.1 pre-alpha
Python Version: 2.5.2
Installed Applications:
['django.contrib.auth', 'django.contrib.sessions', 'django_openid_auth']
Installed Middleware:
('django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.http.SetRemoteAddrFromForwardedFor',
 'storm.django.middleware.ZopeTransactionMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware')

Traceback:
File "/srv/ubuntuone.com/ubunet/utilities/../lib/django/core/handlers/base.py" in get_response
  86. response = callback(request, *callback_args, **callback_kwargs)
File "/srv/ubuntuone.com/ubunet/utilities/../lib/ubuntuone/updown/views.py" in wrapper
  369. return func(*args, **kwargs)
File "/srv/ubuntuone.com/ubunet/utilities/../lib/ubuntuone/updown/views.py" in deco
  97. return func(req, *args, **kwargs)
File "/srv/ubuntuone.com/ubunet/utilities/../lib/django/contrib/auth/decorators.py" in __call__
  67. return self.view_func(request, *args, **kwargs)
File "/srv/ubuntuone.com/ubunet/utilities/../lib/ubuntuone/updown/views.py" in upload_view
  573. uploader.store_file(upload)
File "/srv/ubuntuone.com/ubunet/utilities/../lib/ubuntuone/updown/views.py" in store_file
  487. new_node.set_mimetype(unicode(upload.content_type))
File "/srv/ubuntuone.com/ubunet/utilities/../lib/ubuntuone/storage/model/model.py" in set_mimetype
  445. MimeTypeLookup.provided_mime_type==provided_mimetype).one()
File "/srv/ubuntuone.com/ubunet/utilities/../lib/storm/store.py" in find
  206. self.flush()
File "/srv/ubuntuone.com/ubunet/utilities/../lib/storm/store.py" in flush
  486. self._flush_one(obj_info)
File "/srv/ubuntuone.com/ubunet/utilities/../lib/storm/store.py" in _flush_one
  548. self._connection.execute(expr, noresult=True)
File "/srv/ubuntuone.com/ubunet/utilities/../lib/storm/databases/postgres.py" in execute
  257. return Connection.execute(self, statement, params, noresult)
File "/srv/ubuntuone.com/ubunet/utilities/../lib/storm/database.py" in execute
  203. raw_cursor = self.raw_execute(statement, params)
File "/srv/ubuntuone.com/ubunet/utilities/../lib/storm/databases/postgres.py" in raw_execute
  267. return Connection.raw_execute(self, statement, params)
File "/srv/ubuntuone.com/ubunet/utilities/../lib/storm/database.py" in raw_execute
  284. self._check_disconnect(raw_cursor.execute, *args)
File "/srv/ubuntuone.com/ubunet/utilities/../lib/storm/database.py" in _check_disconnect
  325. return function(*args, **kwargs)

Exception Type: TransactionRollbackError at /upload/
Exception Value: deadlock detected
DETAIL: Process 16864 waits for ExclusiveLock on tuple (10202,18) of relation 26795 of database 26735; blocked by process 12322.
Process 12322 waits for ShareLock on transaction 3330764; blocked by process 16864.

[Kevin Gibbs (kevin-kgibbs)]

.home.kevin..cache.ubuntuone.log.syncdaemon.exceptions.log:
 2009-07-01 08:58:20,565 - ubuntuone.SyncDaemon.ActionQueue - ERROR - MakeFile share:'' node:'61eaad34-e195-4489-a306-02890351c3d5' MakeFile(marker="'61eaad34-e195-4489-a306-02890351c3d5'", share="''", name="'MyNokia6233-080653.backup'", parent="'f6b1308a-d6e0-4f36-b7be-b5188da32a4e'") failure INTERNAL_ERROR
 2009-07-01 08:58:20,576 - ubuntuone.SyncDaemon.ActionQueue - ERROR - upload share:'' node:'61eaad34-e195-4489-a306-02890351c3d5' upload(node="'61eaad34-e195-4489-a306-02890351c3d5'", hash="'sha1:6aaed8251e4abf5e8c54ef7c7006262c53d1866b'", fileobj_factory='<bound method FSKey.open_file of <canonical.ubuntuone.storage.syncdaemon.sync.FSKey object at 0x91063ac>>', share="''", crc32='2521887821L', previous_hash="'sha1:da39a3ee5e6b4b0d3255bfef95601890afd80709'", size='97892') failed 61eaad34-e195-4489-a306-02890351c3d5
Architecture: i386
DistroRelease: Ubuntu 9.04
NonfreeKernelModules: nvidia
Package: ubuntuone-client 0.90.2.1+r55-0ubuntu1~ppa1~jaunty
PackageArchitecture: i386
ProcEnviron:
 SHELL=/bin/bash
 PATH=(custom, user)
 LANG=en_GB.UTF-8
UbuntuoneClientPackages:
 ubuntuone-client 0.90.2.1+r55-0ubuntu1~ppa1~jaunty
 ubuntuone-storage-protocol 0.90.2+r45-0ubuntu1~ppa1~jaunty
 ubuntuone-ppa N/A
Uname: Linux 2.6.28-13-generic i686
UserGroups: adm admin audio cdrom dialout fuse lpadmin netdev plugdev sambashare video

[Kevin Gibbs (kevin-kgibbs)]

Oops, sorry - the line:
"I retired the operation ..."

Should read:
"I *retried* the operation ..."

Sorry for the confusion

[Guillermo Gonzalez (verterok)]

Hi Kevin,
Thanks for testing Ubuntu One.

This looks like a problem in the updown server.