[Trac-tickets] Re: [The Trac Project] #2170: Crash while doing a login/logout in the Timeline

[The Trac Project]

#2170: Crash while doing a login/logout in the Timeline
----------------------+-----------------------------------------------------
 Reporter:  cboos     |        Owner:  cboos   
     Type:  defect    |       Status:  assigned
 Priority:  high      |    Milestone:  0.9     
Component:  general   |      Version:  devel   
 Severity:  critical  |   Resolution:          
 Keywords:            |  
----------------------+-----------------------------------------------------
Comment (by cboos):

 I reverted to pysqlite-1.1.6, but I still manage to have persistent
 database
 locks, as soon as Trac needs to `COMMIT` anything:
 {{{
 Traceback (most recent call last):
   File "/opt/trac/stable-bct-trac/lib/python2.3/site-
 packages/trac/web/standalone.py", line 235, in _do_trac_req
     dispatch_request(path_info, req, env)
   File "/opt/trac/stable-bct-trac/lib/python2.3/site-
 packages/trac/web/main.py", line 139, in dispatch_request
     dispatcher.dispatch(req)
   File "/opt/trac/stable-bct-trac/lib/python2.3/site-
 packages/trac/web/main.py", line 107, in dispatch
     resp = chosen_handler.process_request(req)
   File "/opt/trac/stable-bct-trac/lib/python2.3/site-
 packages/trac/versioncontrol/web_ui/browser.py", line 122, in
 process_request
     self._render_directory(req, repos, node, rev)
   File "/opt/trac/stable-bct-trac/lib/python2.3/site-
 packages/trac/versioncontrol/web_ui/browser.py", line 154, in
 _render_directory
     changes = get_changes(self.env, repos, [i['rev'] for i in info])
   File "/opt/trac/stable-bct-trac/lib/python2.3/site-
 packages/trac/versioncontrol/web_ui/util.py", line 30, in get_changes
     changeset = repos.get_changeset(rev)
   File "/opt/trac/stable-bct-trac/lib/python2.3/site-
 packages/trac/versioncontrol/cache.py", line 42, in get_changeset
     self.sync()
   File "/opt/trac/stable-bct-trac/lib/python2.3/site-
 packages/trac/versioncontrol/cache.py", line 81, in sync
     self.db.commit()
   File "/opt/trac/stable-bct-trac/lib/python2.3/site-packages/trac/db.py",
 line 131, in commit
     self.cnx.commit()
   File "/usr/lib/python2.3/site-packages/sqlite/main.py", line 539, in
 commit
     self.db.execute("COMMIT")
 OperationalError: database is locked
 }}}

 Read access is OK, which is a little bit better than with 2.0.4 ...

-- 
Ticket URL: <http://projects.edgewall.com/trac/ticket/2170>
The Trac Project <http://trac.edgewall.com/>