id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release 5868,"""database is locked"" on big repositories",Giacomo.Tenaglia@…,Emmanuel Blot,"Hi, we are hosting about 300 SVN repositories, each one with its trac environment. We would like to use RevTree, but we're experiencing a ""database is locked"" problem when querying for big repositories. The error displayed is: {{{ Traceback (most recent call last): File ""/usr/lib/python2.4/site-packages/trac/web/api.py"", line 377, in send_error 'text/html') File ""/usr/lib/python2.4/site-packages/trac/web/chrome.py"", line 725, in render_template req.chrome[type_].append( File ""/usr/lib/python2.4/site-packages/trac/web/api.py"", line 195, in __getattr__ value = self.callbacks[name](self) File ""/usr/lib/python2.4/site-packages/trac/util/compat.py"", line 135, in newfunc return func_(*(args + fargs), **dict(kwargs, **fkwargs)) File ""/usr/lib/python2.4/site-packages/trac/web/chrome.py"", line 489, in prepare_request for category, name, text in contributor.get_navigation_items(req): File ""/usr/lib/python2.4/site-packages/trac/ticket/query.py"", line 748, in get_navigation_items if 'TICKET_VIEW' in req.perm and \ File ""/usr/lib/python2.4/site-packages/trac/perm.py"", line 524, in has_permission return self._has_permission(action, resource) File ""/usr/lib/python2.4/site-packages/trac/perm.py"", line 537, in _has_permission decision = PermissionSystem(self.env). \ File ""/usr/lib/python2.4/site-packages/trac/perm.py"", line 425, in check_permission perm) File ""/usr/lib/python2.4/site-packages/trac/perm.py"", line 281, in check_permission permissions = PermissionSystem(self.env). \ File ""/usr/lib/python2.4/site-packages/trac/perm.py"", line 357, in get_user_permissions for perm in self.store.get_user_permissions(username): File ""/usr/lib/python2.4/site-packages/trac/perm.py"", line 175, in get_user_permissions cursor.execute(""SELECT username,action FROM permission"") File ""/usr/lib/python2.4/site-packages/trac/db/util.py"", line 60, in execute return self.cursor.execute(sql) File ""/usr/lib/python2.4/site-packages/trac/db/sqlite_backend.py"", line 58, in execute args or []) File ""/usr/lib/python2.4/site-packages/trac/db/sqlite_backend.py"", line 50, in _rollback_on_error return function(self, *args, **kwargs) OperationalError: database is locked }}} Do you know how we can fix it ? Thanks, giacomo",defect,closed,normal,RevtreePlugin,blocker,invalid,,,0.11