DatabaseError: database disk image is malformed

[sdohmen]

How to Reproduce

While doing a GET operation on /prefs, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'panel_id': None}

User agent: Mozilla/5.0 (Windows NT 6.1; rv:8.0) Gecko/20100101 Firefox/8.0

System Information

System information not available

Enabled Plugins

Plugin information not available

Python Traceback

Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 511, in _dispatch_request
    dispatcher.dispatch(req)
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.linux-x86_64/egg/trac/prefs/web_ui.py", line 69, in process_request
    for name, label in provider.get_preference_panels(req) or []:
  File "build/bdist.linux-x86_64/egg/acct_mgr/web_ui.py", line 220, in get_preference_panels
    user_store = self.acctmgr.find_user_store(req.authname)
  File "build/bdist.linux-x86_64/egg/acct_mgr/api.py", line 404, in find_user_store
    if user in store[1]:
  File "build/bdist.linux-x86_64/egg/acct_mgr/db.py", line 38, in get_users
    """, (self.key,))
  File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "build/bdist.linux-x86_64/egg/trac/db/sqlite_backend.py", line 79, in execute
    self.rows = PyFormatCursor.fetchall(self)
DatabaseError: database disk image is malformed

[mickem]

Unfortunately this seems to be related to various design issues inside trac, seems someone doesn't understand multi threaded programming and the entire session processing is prone to race conditions which ends up corrupting the database...