2007-10-29 06:07:28,702 cherrypy.msg INFO HTTP: Page handler: <bound method Root.add_json of <hardware.controllers.Root object at 0x15264d0>>
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 611, 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 '94827' for key 1") u'INSERT INTO device (id, 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, %s)' [94827L, u'SEMC DSS SyncStation', u'tty', u'Unknown', 'NONE', <DateTime object for '2007-10-28 23:24:13.52' at 2aaab1b6dad8>, 0, 0, 0, 0]