Modify

Opened 7 years ago

Closed 7 years ago

#1715 closed defect (worksforme)

IntegrityError: duplicate key violates unique constraint "message_pkey"

Reported by: bewst Owned by: 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 (2)

discussion-backtrace (1023 bytes) - added by bewst 7 years ago.
Backtrace
trac.log.bz2 (589.3 KB) - added by bewst 7 years ago.
BZipped log file

Download all attachments as: .zip

Change History (9)

comment:1 Changed 7 years ago by bewst

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

comment:2 Changed 7 years ago by bewst

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

Changed 7 years ago by bewst

Backtrace

comment:3 Changed 7 years ago 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.

Changed 7 years ago by bewst

BZipped log file

comment:4 Changed 7 years ago by bewst

  • Trac 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

comment:5 Changed 7 years ago 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.

comment:6 Changed 7 years ago by Blackhex

  • Priority changed from high to normal

Still experiencing this?

comment:7 Changed 7 years ago by Blackhex

  • Resolution set to worksforme
  • Status changed from assigned to closed

Add Comment

Modify Ticket

Action
as closed The owner will remain Blackhex.
The resolution will be deleted. Next status will be 'reopened'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.