id summary reporter owner description type status priority component severity resolution keywords cc release 12191 "IntegrityError: duplicate key value violates unique constraint ""report_pkey"" DETAIL: Key (id)=(10) already exists." massimo.b@… Russ Tyndall "Coming from http://trac.edgewall.org/ticket/11958 I have this issue, when I try to save a new ticket query. This is a fresh 1.0.3 installation with Postgres, never migrated that database. The issue is reproducible on a separate test project using the same plugins and configuration. Attached you find the configuration. {{{ Most recent call last: File ""/usr/lib64/python2.7/site-packages/trac/web/main.py"", line 513, in _dispatch_request dispatcher.dispatch(req) File ""/usr/lib64/python2.7/site-packages/trac/web/main.py"", line 222, in dispatch resp = chosen_handler.process_request(req) File ""/usr/lib64/python2.7/site-packages/trac/ticket/report.py"", line 163, in process_request self._do_create(req) File ""/usr/lib64/python2.7/site-packages/trac/ticket/report.py"", line 226, in _do_create """""", (title, query, description)) File ""/usr/lib64/python2.7/site-packages/trac/db/util.py"", line 72, in execute return self.cursor.execute(sql_escape_percent(sql), args) }}} The query expression: {{{ query:?status=accepted & status=assigned & status=new & status=reopened & component=GUI & col=id & col=summary & col=component & col=status & col=owner & col=type & col=priority & col=milestone & col=time & col=reporter & order=priority }}} {{{ System Information: User Agent: Mozilla/5.0 (X11; Linux x86_64; rv:35.0) Gecko/20100101 Firefox/35.0 Trac 1.0.4 Docutils 0.12 FullBlog 0.1.1-r0 Genshi 0.7 (with speedups) GIT 2.0.5 psycopg2 2.5.3 Pygments 2.0predev-20150123 Python 2.7.9 (default, Jan 23 2015, 15:27:02) [GCC 4.8.3] pytz 2014.10 setuptools 7.0 jQuery 1.7.2 jQuery UI 1.8.21 jQuery Timepicker 1.0.1 Enabled Plugins: acct-mgr.admin N/A /usr/lib64/python2.7/site-packages/acct_mgr/admin.pyc acct-mgr.api N/A /usr/lib64/python2.7/site-packages/acct_mgr/api.pyc acct-mgr.db N/A /usr/lib64/python2.7/site-packages/acct_mgr/db.pyc acct-mgr.htfile N/A /usr/lib64/python2.7/site-packages/acct_mgr/htfile.pyc acct-mgr.http N/A /usr/lib64/python2.7/site-packages/acct_mgr/http.pyc acct-mgr.macros N/A /usr/lib64/python2.7/site-packages/acct_mgr/macros.pyc acct-mgr.notification N/A /usr/lib64/python2.7/site-packages/acct_mgr/notification.pyc acct-mgr.pwhash N/A /usr/lib64/python2.7/site-packages/acct_mgr/pwhash.pyc acct-mgr.register N/A /usr/lib64/python2.7/site-packages/acct_mgr/register.pyc acct-mgr.svnserve N/A /usr/lib64/python2.7/site-packages/acct_mgr/svnserve.pyc acct-mgr.web-ui N/A /usr/lib64/python2.7/site-packages/acct_mgr/web_ui.pyc RoadmapHours 0.5 /mnt/data/trac/projects/trac-pmp/plugins/RoadmapHours-0.5-py2.7.egg SimpleMultiProject 0.0.4dev-r14359 /mnt/data/trac/projects/trac-pmp/plugins/SimpleMultiProject-0.0.4dev_r14359-py2.7.egg timingandestimationplugin 1.3.7 /mnt/data/trac/projects/trac-pmp/plugins/timingandestimationplugin-1.3.7-py2.7.egg TracAnnouncer 1.0dev-r13984 /mnt/data/trac/projects/trac-pmp/plugins/TracAnnouncer-1.0dev_r13984-py2.7.egg TracAutocompleteUsersPlugin 0.4.3dev-r14213 /mnt/data/trac/projects/trac-pmp/plugins/TracAutocompleteUsersPlugin-0.4.3dev_r14213-py2.7.egg TracDiscussion 0.9dev-r14140 /mnt/data/trac/projects/trac-pmp/plugins/TracDiscussion-0.9dev_r14140-py2.7.egg TracFullBlogPlugin 0.1.1-r0 /mnt/data/trac/projects/trac-pmp/plugins/TracFullBlogPlugin-0.1.1_r0-py2.7.egg TracGanttCalendarPlugin 0.6.4-r859 /mnt/data/trac/projects/trac-pmp/plugins/TracGanttCalendarPlugin-0.6.4_r859-py2.7.egg TracMasterTickets 3.0.5dev-r14323 /mnt/data/trac/projects/trac-pmp/plugins/TracMasterTickets-3.0.5dev_r14323-py2.7.egg TracWatchlistPlugin 1.0.1 /mnt/data/trac/projects/trac-pmp/plugins/TracWatchlistPlugin-1.0.1-patched_py2.7.egg TracWorkflowAdmin 0.12.0.2 /mnt/data/trac/projects/trac-pmp/plugins/TracWorkflowAdmin-0.12.0.2-py2.7.egg WikiAutoComplete 1.0 /mnt/data/trac/projects/trac-pmp/plugins/WikiAutoComplete-1.0-py2.7.egg WorkLog 0.4dev-r13835 /mnt/data/trac/projects/trac-pmp/plugins/WorkLog-0.4dev_r13835-py2.7.egg }}}" defect closed normal TimingAndEstimationPlugin normal fixed 1.0