Ticket #1715 (closed defect: worksforme)

Opened 2 years ago

Last modified 1 year ago

IntegrityError: duplicate key violates unique constraint "message_pkey"

Reported by: bewst Assigned to: Blackhex
Priority: normal Component: DiscussionPlugin
Severity: blocker Keywords:
Cc: Trac Release: 0.11

Description 

File "/usr/local/lib/python2.4/site-packages/Trac-0.11dev_r5790-py2.4.egg/trac/web/main.py", line 436, in dispatch_request
  dispatcher.dispatch(req)
File "/usr/local/lib/python2.4/site-packages/Trac-0.11dev_r5790-py2.4.egg/trac/web/main.py", line 221, in dispatch
  resp = chosen_handler.process_request(req)
File "build/bdist.freebsd-6.1-RELEASE-i386/egg/tracdiscussion/core.py", line 74, in process_requestFile "build/bdist.freebsd-6.1-RELEASE-i386/egg/tracdiscussion/api.py", line 51, in process_discussionFile "build/bdist.freebsd-6.1-RELEASE-i386/egg/tracdiscussion/api.py", line 593, in _do_actionFile "build/bdist.freebsd-6.1-RELEASE-i386/egg/tracdiscussion/api.py", line 972, in add_messageFile "/usr/local/lib/python2.4/site-packages/Trac-0.11dev_r5790-py2.4.egg/trac/db/util.py", line 70, in execute
  return c.execute(sql_escape_percent(sql), args)
File "/usr/local/lib/python2.4/site-packages/Trac-0.11dev_r5790-py2.4.egg/trac/db/util.py", line 70, in execute
  return c.execute(sql_escape_percent(sql), args)

Attachments

discussion-backtrace (1.0 kB) - added by bewst on 07/01/07 15:15:07.
Backtrace
trac.log.bz2 (0.6 MB) - added by bewst on 07/03/07 10:40:43.
BZipped log file

Change History

07/01/07 15:12:18 changed by bewst

This was the first thing I tried with the 0.11 port -- just submitting a quoted reply to an existing message.

07/01/07 15:13:47 changed by bewst

Umm, looks like I gave you the wrong backtrace somehow. Please see the attachment.

07/01/07 15:15:07 changed by bewst

  • attachment discussion-backtrace added.

Backtrace

07/02/07 14:49:25 changed by Blackhex

  • status changed from new to assigned.

I didn't evoke this error with PosgreSQL. Could you please checkout lastest DiscussionPlugin revision with debug outputs and post me here debug log and info about your system (Trac version, webserver, etc. See BugReporting for more details) Thank you.

07/03/07 10:40:43 changed by bewst

  • attachment trac.log.bz2 added.

BZipped log file

07/03/07 10:44:11 changed by bewst

  • release changed from 0.10 to 0.11.

That version is much more broken that the previous one.

DiscussionPlugin: http://trac-hacks.org/svn/discussionplugin/0.11 (r2358) Trac: 0.11-dev (r5790) Server: lighttpd + fastcgi proxied through apache 2 Database: postgresql 8.2 OS: FreeBSD

07/03/07 15:33:24 changed by Blackhex

OK, I was checking if there is needed ending comas in one-item tuples when passing arguments to SQL queries. Apparently they are on some systems (nor on mine). Never mind, please try it with r2374 aggain and post me relevant part of debug log. It is not needed to post 16.5 MB log when relevant are last 2 kB.

09/06/07 14:38:35 changed by Blackhex

  • priority changed from high to normal.

Still experiencing this?

01/30/08 08:01:14 changed by Blackhex

  • status changed from assigned to closed.
  • resolution set to worksforme.

Add/Change #1715 (IntegrityError: duplicate key violates unique constraint "message_pkey")




Change Properties
Action