[SAC] [OSGeo] #508: PostGIS trac is corrupted

#508: PostGIS trac is corrupted
-------------------+--------------------------------------------------------
Reporter: robe | Owner: sac@lists.osgeo.org
    Type: defect | Status: new
Priority: normal | Component: SAC
Keywords: |
-------------------+--------------------------------------------------------
Getting a primary key violation. It might have been the last merge I did
that did it.

{{{
Traceback (most recent call last):
   File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 387, in
dispatch_request
     dispatcher.dispatch(req)
   File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 191, in
dispatch
     chosen_handler = self._pre_process_request(req, chosen_handler)
   File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 263, in
_pre_process_request
     chosen_handler = f.pre_process_request(req, chosen_handler)
   File "/usr/lib/python2.3/site-packages/trac/versioncontrol/api.py", line
73, in pre_process_request
     self.get_repository(req.authname) # triggers a sync if applicable
   File "/usr/lib/python2.3/site-packages/trac/versioncontrol/api.py", line
101, in get_repository
     repos = self._connector.get_repository(rtype, rdir, authname)
   File "/usr/lib/python2.3/site-packages/trac/versioncontrol/svn_fs.py",
line 260, in get_repository
     crepos = CachedRepository(self.env.get_db_cnx(), repos, None,
self.log)
   File "/usr/lib/python2.3/site-packages/trac/versioncontrol/cache.py",
line 34, in __init__
     self.sync()
   File "/usr/lib/python2.3/site-packages/trac/versioncontrol/cache.py",
line 104, in sync
     (str(current_rev), path, kind, action,
   File "/usr/lib/python2.3/site-packages/trac/db/util.py", line 50, in
execute
     return self.cursor.execute(sql_escape_percent(sql), args)
   File "/usr/lib/python2.3/site-packages/trac/db/util.py", line 50, in
execute
     return self.cursor.execute(sql_escape_percent(sql), args)
IntegrityError: duplicate key violates unique constraint "node_change_pk"
}}}

--
Ticket URL: <http://trac.osgeo.org/osgeo/ticket/508&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#508: PostGIS trac is corrupted
---------------------+------------------------------------------------------
  Reporter: robe | Owner: sac@lists.osgeo.org
      Type: defect | Status: new
  Priority: normal | Component: SAC
Resolution: | Keywords:
---------------------+------------------------------------------------------
Comment (by crschmidt):

http://trac.edgewall.org/ticket/4043

Fixed in a later version of trac. Currently resyncing the postgis trac
instance to resolve the issue.

--
Ticket URL: <http://trac.osgeo.org/osgeo/ticket/508#comment:1&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#508: PostGIS trac is corrupted
---------------------+------------------------------------------------------
  Reporter: robe | Owner: sac@lists.osgeo.org
      Type: defect | Status: closed
  Priority: normal | Component: SAC
Resolution: fixed | Keywords:
---------------------+------------------------------------------------------
Changes (by crschmidt):

  * status: new => closed
  * resolution: => fixed

Comment:

This issue appears to have been resolved. If you have any further
problems, please feel free to reopen this ticket.

Best Regards,
Christopher Schmidt
OSGeo Systems Administration Committee

--
Ticket URL: <http://trac.osgeo.org/osgeo/ticket/508#comment:2&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.