Search and Top Navigation
#2973 closed bug (fixed)
Opened June 08, 2008 08:59AM UTC
Closed May 08, 2010 06:59PM UTC
Last modified August 04, 2010 01:16AM UTC
IntegrityError: (1062, "Duplicate entry 'usd2-1-timeline.daysba' for key 1")
Reported by: | usd2 | Owned by: | |
---|---|---|---|
Priority: | critical | Milestone: | 1.8.3 |
Component: | [meta] ui.site | Version: | |
Keywords: | Cc: | ||
Blocked by: | Blocking: |
Description
How to Reproduce
While doing a GET operation on /timeline
, Trac issued an internal error.
''(please provide additional details here)''
Request parameters:
{'changeset': u'on', 'daysback': u'30', 'from': u'06/08/2008', 'update': u'Update'}
System Information
|| Trac || 0.11rc1
||
|| Python || 2.4.4 (#2, Apr 26 2007, 00:02:45)
[GCC 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)]
||
|| setuptools || 0.6c8
||
|| MySQL || server: "5.0.51a-3-log", client: "5.0.51a", thread-safe: 1
||
|| MySQLdb || 1.2.2
||
|| Genshi || 0.4.4
||
|| Pygments || 0.9
||
|| Subversion || 1.4.4 (r25188)
||
Python Traceback
Traceback (most recent call last): File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/web/main.py", line 417, in _dispatch_request dispatcher.dispatch(req) File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/web/main.py", line 222, in dispatch req.session.save() File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/web/session.py", line 93, in save "VALUES(%s,%s,%s,%s)", attrs) File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/db/util.py", line 57, in executemany return self.cursor.executemany(sql_escape_percent(sql), args) File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/db/util.py", line 57, in executemany return self.cursor.executemany(sql_escape_percent(sql), args) File "/var/lib/python-support/python2.4/MySQLdb/cursors.py", line 218, in executemany r = self._query('\\n'.join([query[:p], ',\\n'.join(q), query[e:]])) File "/var/lib/python-support/python2.4/MySQLdb/cursors.py", line 312, in _query rowcount = self._do_query(q) File "/var/lib/python-support/python2.4/MySQLdb/cursors.py", line 276, in _do_query db.query(q) IntegrityError: (1062, "Duplicate entry 'usd2-1-timeline.daysba' for key 1")
Attachments (0)
Change History (12)
Changed June 08, 2008 05:23PM UTC by comment:1
owner: | paul → eduardo |
---|---|
status: | new → assigned |
Changed June 09, 2008 07:38AM UTC by comment:2
component: | ui.core → ui.meta (website, demos) |
---|
Changed June 26, 2008 10:16AM UTC by comment:3
resolution: | → fixed |
---|---|
status: | assigned → closed |
Changed February 13, 2009 12:35PM UTC by comment:4
component: | [meta] ui.themeroller → [meta] ui.site |
---|---|
milestone: | 1.5 → 1.6 |
priority: | major → critical |
resolution: | fixed |
status: | closed → reopened |
This error is reproduced by not being logged in. Should not be closed fix until you can run reports and timeline without being logged in to Trac.
Changed February 13, 2009 12:38PM UTC by comment:5
owner: | eduardo |
---|---|
status: | reopened → assigned |
Changed March 08, 2009 02:27PM UTC by comment:6
milestone: | 1.7 → 1.8 |
---|
Changed May 11, 2009 02:38PM UTC by comment:7
Created a ticket on Trac's tracker: http://trac.edgewall.org/ticket/8279
Changed May 12, 2009 09:11AM UTC by comment:8
They suggest to fix the MySQL bindings (to get thread-safe: 1) or switching to InnoDB tables (we are using MyISAM), ala http://www.linux.com/feature/46370
Changed February 01, 2010 06:13PM UTC by comment:9
milestone: | 1.8 → 1.next |
---|
Changed May 08, 2010 06:59PM UTC by comment:10
resolution: | → fixed |
---|---|
status: | assigned → closed |
Upgraded to latest stable Trac 0.11.7. Seems to have fixed this issue, finally.
Changed May 08, 2010 06:59PM UTC by comment:11
milestone: | 1.next → 1.9 |
---|
Changed August 04, 2010 01:16AM UTC by comment:12
milestone: | 1.9 → 1.8.3 |
---|