INSERT INTO device (description, bus, driver, class, date_added, device_id, vendor_id, subsys_device_id, subsys_vendor_id) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)
[u'USB 2.0', u'pci', u'ehci_hcd', 'USB', <DateTime object for '2007-10-21 21:21:30.59' at 2aaace561450>, u'12548', 4358, 8483, 4121]
ROLLBACK
2007-10-22 07:32:04,432 cherrypy.msg INFO HTTP: Page handler: <bound method Root.add_json of <hardware.controllers.Root object at 0x1524710>>
Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/cherrypy/_cphttptools.py", line 105, in _run
    self.main()
  File "/usr/lib/python2.4/site-packages/cherrypy/_cphttptools.py", line 254, in main
    body = page_handler(*virtual_path, **self.params)
  File "<string>", line 3, in add_json
  File "/usr/lib/python2.4/site-packages/turbogears/controllers.py", line 334, in expose
    output = database.run_with_transaction(
  File "<string>", line 5, in run_with_transaction
  File "/usr/lib/python2.4/site-packages/turbogears/database.py", line 352, in sa_rwt
    retval = dispatch_exception(e,args,kw)
  File "/usr/lib/python2.4/site-packages/turbogears/database.py", line 341, in sa_rwt
    retval = func(*args, **kw)
  File "<string>", line 5, in _expose
  File "/usr/lib/python2.4/site-packages/turbogears/controllers.py", line 351, in <lambda>
    mapping, fragment, args, kw)))
  File "/usr/lib/python2.4/site-packages/turbogears/controllers.py", line 378, in _execute_func
    output = errorhandling.try_call(func, *args, **kw)
  File "/usr/lib/python2.4/site-packages/turbogears/errorhandling.py", line 73, in try_call
    return func(self, *args, **kw)
  File "/usr/share/smolt/smoon/hardware/controllers.py", line 557, in add_json
    ctx.current.flush()
  File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/session.py", line 319, in flush
    self.uow.flush(self, objects)
  File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/unitofwork.py", line 210, in flush
    flush_context.execute()
  File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/unitofwork.py", line 400, in execute
    UOWExecutor().execute(self, head)
  File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/unitofwork.py", line 1018, in execute
    self.execute_save_steps(trans, task)
  File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/unitofwork.py", line 1037, in execute_save_steps
    self.execute_childtasks(trans, task, False)
  File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/unitofwork.py", line 1055, in execute_childtasks
    self.execute(trans, child, isdelete)
  File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/unitofwork.py", line 1018, in execute
    self.execute_save_steps(trans, task)
  File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/unitofwork.py", line 1032, in execute_save_steps
    self.save_objects(trans, task)
  File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/unitofwork.py", line 1023, in save_objects
    task.mapper.save_obj(task.polymorphic_tosave_objects, trans)
  File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/mapper.py", line 1210, in save_obj
    c = connection.execute(statement, params)
  File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py", line 517, in execute
    return Connection.executors[c](self, object, *multiparams, **params)
  File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py", line 557, in execute_clauseelement
    return self.execute_compiled(elem.compile(dialect=self.dialect, parameters=param), *multiparams, **params)
  File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py", line 568, in execute_compiled
    self._execute_raw(context)
  File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py", line 581, in _execute_raw
    self._execute(context)
  File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py", line 599, in _execute
    raise exceptions.SQLError(context.statement, context.parameters, e)
SQLError: (IntegrityError) (1062, "Duplicate entry 'USB 2.0-12548-4358-8483-4121' for key 2") u'INSERT INTO device (description, bus, driver, class, date_added, device_id, vendor_id, subsys_device_id, subsys_vendor_id) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)' [u'USB 2.0', u'pci', u'ehci_hcd', 'USB', <DateTime object for '2007-10-21 21:21:30.59' at 2aaace561450>, u'12548', 4358, 8483, 4121]