Skip to main content

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 paul comment:1

owner: pauleduardo
status: newassigned

Changed June 09, 2008 07:38AM UTC by paul comment:2

component: ui.coreui.meta (website, demos)

Changed June 26, 2008 10:16AM UTC by eduardo comment:3

resolution: → fixed
status: assignedclosed

Changed February 13, 2009 12:35PM UTC by rdworth comment:4

component: [meta] ui.themeroller[meta] ui.site
milestone: 1.51.6
priority: majorcritical
resolution: fixed
status: closedreopened

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 rdworth comment:5

owner: eduardo
status: reopenedassigned

Changed March 08, 2009 02:27PM UTC by rdworth comment:6

milestone: 1.71.8

Changed May 11, 2009 02:38PM UTC by jzaefferer comment:7

Created a ticket on Trac's tracker: http://trac.edgewall.org/ticket/8279

Changed May 12, 2009 09:11AM UTC by jzaefferer 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 jzaefferer comment:9

milestone: 1.81.next

Changed May 08, 2010 06:59PM UTC by rdworth comment:10

resolution: → fixed
status: assignedclosed

Upgraded to latest stable Trac 0.11.7. Seems to have fixed this issue, finally.

Changed May 08, 2010 06:59PM UTC by rdworth comment:11

milestone: 1.next1.9

Changed August 04, 2010 01:16AM UTC by scottgonzalez comment:12

milestone: 1.91.8.3