[vlc-devel] Trac sucks again

[Rémi Denis-Courmont]

	Hello,

Trac is as unusable as usual. From the error message, it would seem that it 
tries to fetch the entire user database for each query (a pretty damn stupid 
thing to do). But it could be that the SQL query is abbreviated in the log.

In any case, is SQLite 3 really a good idea for a 200+Mb database with lots of 
concurrent access?

Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/trac/web/api.py", line 339, in 
send_error
    'text/html')
  File "/usr/lib/python2.5/site-packages/trac/web/chrome.py", line 684, in 
render_template
    data = self.populate_data(req, data)
  File "/usr/lib/python2.5/site-packages/trac/web/chrome.py", line 592, in 
populate_data
    d['chrome'].update(req.chrome)
  File "/usr/lib/python2.5/site-packages/trac/web/api.py", line 169, in 
__getattr__
    value = self.callbacks[name](self)
  File "/usr/lib/python2.5/site-packages/trac/web/chrome.py", line 460, in 
prepare_request
    for category, name, text in contributor.get_navigation_items(req):
  File "/usr/lib/python2.5/site-
packages/trac/versioncontrol/web_ui/browser.py", line 295, in 
get_navigation_items
    if 'BROWSER_VIEW' in req.perm:
  File "/usr/lib/python2.5/site-packages/trac/perm.py", line 523, in 
has_permission
    return self._has_permission(action, resource)
  File "/usr/lib/python2.5/site-packages/trac/perm.py", line 537, in 
_has_permission
    check_permission(action, perm.username, resource, perm)
  File "/usr/lib/python2.5/site-packages/trac/perm.py", line 424, in 
check_permission
    perm)
  File "/usr/lib/python2.5/site-packages/trac/perm.py", line 282, in 
check_permission
    get_user_permissions(username)
  File "/usr/lib/python2.5/site-packages/trac/perm.py", line 357, in 
get_user_permissions
    for perm in self.store.get_user_permissions(username):
  File "/usr/lib/python2.5/site-packages/trac/perm.py", line 175, in 
get_user_permissions
    cursor.execute("SELECT username,action FROM permission")
  File "/usr/lib/python2.5/site-packages/trac/db/util.py", line 51, in execute
    return self.cursor.execute(sql)
  File "/usr/lib/python2.5/site-packages/trac/db/util.py", line 51, in execute
    return self.cursor.execute(sql)
InternalError: current transaction is aborted, commands ignored until end of 
transaction block


-- 
Rémi Denis-Courmont
http://www.remlab.net/