filelocker traceback during db upgrade r918

gistfile1.txt

2012-06-12 11:13:40,831 INFO sqlalchemy.engine.base.Engine.0x...ca90 BEGIN
2012-06-12 11:13:40,834 INFO sqlalchemy.engine.base.Engine.0x...ca90 INSERT INTO files (id, name, type, size, notes, date_uploaded, owner_id, role_owner_id, date_expires, passed_avscan, encryption_key, status, notify_on_download, md5, upload_request_id) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
2012-06-12 11:13:40,834 INFO sqlalchemy.engine.base.Engine.0x...ca90 [u'184', u'DSET_Report_for_[pantheon-po51.its.yale.edu-SvcTag--]-on-02-21-2012-at-11-31-AM.zip', u'Zip archive data, at least v1.0 to extract', 2287889L, '', u'2012-06-12 11:10:40', u'rs253', None, u'2012-06-22 00:00:00', True, u'DwQRNm0Ucl2VEAGDSomkbU5cvbNYyftH', u'Checked In', 0, u'', u'']
2012-06-12 11:13:40,839 INFO sqlalchemy.engine.base.Engine.0x...ca90 ROLLBACK
Traceback (most recent call last):
  File "setup.py", line 141, in <module>
    restore_from_backup(dburi, options.datafile)
  File "setup.py", line 78, in restore_from_backup
    import_db(infile, dburi)
  File "/misc/filesw01/filelocker/172/lib/DBTools.py", line 109, in import_db
    session.commit()
  File "/usr/lib/python2.6/site-packages/sqlalchemy/orm/session.py", line 673, in commit
    self.transaction.commit()
  File "/usr/lib/python2.6/site-packages/sqlalchemy/orm/session.py", line 378, in commit
    self._prepare_impl()
  File "/usr/lib/python2.6/site-packages/sqlalchemy/orm/session.py", line 362, in _prepare_impl
    self.session.flush()
  File "/usr/lib/python2.6/site-packages/sqlalchemy/orm/session.py", line 1354, in flush
    self._flush(objects)
  File "/usr/lib/python2.6/site-packages/sqlalchemy/orm/session.py", line 1432, in _flush
    flush_context.execute()
  File "/usr/lib/python2.6/site-packages/sqlalchemy/orm/unitofwork.py", line 257, in execute
    UOWExecutor().execute(self, tasks)
  File "/usr/lib/python2.6/site-packages/sqlalchemy/orm/unitofwork.py", line 720, in execute
    self.execute_save_steps(trans, task)
  File "/usr/lib/python2.6/site-packages/sqlalchemy/orm/unitofwork.py", line 735, in execute_save_steps
    self.save_objects(trans, task)
  File "/usr/lib/python2.6/site-packages/sqlalchemy/orm/unitofwork.py", line 726, in save_objects
    task.mapper._save_obj(task.polymorphic_tosave_objects, trans)
  File "/usr/lib/python2.6/site-packages/sqlalchemy/orm/mapper.py", line 1387, in _save_obj
    c = connection.execute(statement.values(value_params), params)
  File "/usr/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 824, in execute
    return Connection.executors[c](self, object, multiparams, params)
  File "/usr/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 874, in _execute_clauseelement
    return self.__execute_context(context)
  File "/usr/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 896, in __execute_context
    self._cursor_execute(context.cursor, context.statement, context.parameters[0], context=context)
  File "/usr/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 950, in _cursor_execute
    self._handle_dbapi_exception(e, statement, parameters, cursor, context)
  File "/usr/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 931, in _handle_dbapi_exception
    raise exc.DBAPIError.instance(statement, parameters, e, connection_invalidated=is_disconnect)
sqlalchemy.exc.IntegrityError: (IntegrityError) (1452, 'Cannot add or update a child row: a foreign key constraint fails (`filesbxdb00`.`files`, CONSTRAINT `files_ibfk_3` FOREIGN KEY (`upload_request_id`) REFERENCES `upload_requests` (`id`))') u'INSERT INTO files (id, name, type, size, notes, date_uploaded, owner_id, role_owner_id, date_expires, passed_avscan, encryption_key, status, notify_on_download, md5, upload_request_id) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)' [u'184', u'DSET_Report_for_[pantheon-po51.its.yale.edu-SvcTag--]-on-02-21-2012-at-11-31-AM.zip', u'Zip archive data, at least v1.0 to extract', 2287889L, '', u'2012-06-12 11:10:40', u'rs253', None, u'2012-06-22 00:00:00', True, u'DwQRNm0Ucl2VEAGDSomkbU5cvbNYyftH', u'Checked In', 0, u'', u'']