[Pidgin] #2001: Trac detected an internal error: duplicate key constraint "ticket_change_pk"

Pidgin trac at pidgin.im
Sun Jul 1 20:18:33 EDT 2007


#2001: Trac detected an internal error: duplicate key constraint
"ticket_change_pk"
---------------------+------------------------------------------------------
 Reporter:  jeff     |       Owner:       
     Type:  defect   |      Status:  new  
 Priority:  blocker  |   Milestone:       
Component:  webpage  |     Version:  2.0.2
 Keywords:  trac     |     Pending:  0    
---------------------+------------------------------------------------------
 I'm trying to reply to #1996. I entered a comment, checked pending, and
 hit ''Submit Changes''. This came up:

 {{{
  Trac detected an internal error:

 If you think this really should work and you can reproduce it, you should
 consider reporting this problem to the Pidgin team.

 Go to http://developer.pidgin.im and create a new ticket (if one doesn't
 already exist) where you describe the problem, how to reproduce it. Don't
 forget to include the Python traceback found below.

 TracGuide — The Trac User and Administration Guide
 Python Traceback

 Traceback (most recent call last):
   File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line
 406, in dispatch_request
     dispatcher.dispatch(req)
   File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line
 237, in dispatch
     resp = chosen_handler.process_request(req)
   File "/usr/local/lib/python2.4/site-packages/trac/ticket/web_ui.py",
 line 290, in process_request
     self._do_save(req, db, ticket)
   File "/usr/local/lib/python2.4/site-packages/trac/ticket/web_ui.py",
 line 557, in _do_save
     cnum=internal_cnum):
   File "/usr/local/lib/python2.4/site-packages/trac/ticket/model.py", line
 262, in save_changes
     listener.ticket_changed(self, comment, author, old_values)
   File "build/bdist.linux-x86_64/egg/removepending/remove_pending.py",
 line 27, in ticket_changed
   File "/usr/local/lib/python2.4/site-packages/trac/db/util.py", line 50,
 in execute
     return self.cursor.execute(sql_escape_percent(sql), args)
   File "/usr/local/lib/python2.4/site-packages/trac/db/util.py", line 50,
 in execute
     return self.cursor.execute(sql_escape_percent(sql), args)
 IntegrityError: duplicate key violates unique constraint
 "ticket_change_pk"

 }}}

 I repeated my submission and got the same error back 14 times in a row. On
 the 15th time, Trac did not report an error but did not record my comment
 or addition of pending. Instead, an entry in the change history said
 "<b>pending</b> deleted". This happened twice (as you can see in the
 change history - pending was deleted twice).

 I continued submitting the comment, trying various things including
 reloading the page and recopying my comment, and going back and hitting
 Submit Changes again. All form submissions were met with the error above,
 except on the 7th time my changes went through.

-- 
Ticket URL: <http://developer.pidgin.im/ticket/2001>
Pidgin <http://pidgin.im>
Pidgin


More information about the Tracker mailing list