Intermittent break on trac site

[ujjwaltrivedi@…]

Here is the python trace-back:

Traceback (most recent call last):
  File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line 406, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/local/lib/python2.4/site-packages/trac/wiki/web_ui.py", line 135, in process_request
    self._render_view(req, db, page)
  File "/usr/local/lib/python2.4/site-packages/trac/wiki/web_ui.py", line 443, in _render_view
    req.hdf['wiki'] = {
  File "/usr/local/lib/python2.4/site-packages/trac/wiki/formatter.py", line 1001, in wiki_to_html
    Formatter(env, req, absurls, db).format(wikitext, out, escape_newlines)
  File "/usr/local/lib/python2.4/site-packages/trac/wiki/formatter.py", line 824, in format
    result = re.sub(self.wiki.rules, self.replace, line)
  File "/usr/local/lib/python2.4/sre.py", line 142, in sub
    return _compile(pattern, 0).sub(repl, string, count)
  File "/usr/local/lib/python2.4/site-packages/trac/wiki/formatter.py", line 770, in replace
    replacement = self.handle_match(fullmatch)
  File "/usr/local/lib/python2.4/site-packages/trac/wiki/formatter.py", line 766, in handle_match
    return internal_handler(match, fullmatch)
  File "/usr/local/lib/python2.4/site-packages/trac/wiki/formatter.py", line 364, in _lhref_formatter
    return self._make_link(ns, target, match, label)
  File "/usr/local/lib/python2.4/site-packages/trac/wiki/formatter.py", line 371, in _make_link
    escape(label, False))
  File "/usr/local/lib/python2.4/site-packages/trac/wiki/api.py", line 283, in link_resolver
    return self._format_link(formatter, ns, target, label, False)
  File "/usr/local/lib/python2.4/site-packages/trac/wiki/api.py", line 289, in _format_link
    if not self.has_page(page):
  File "/usr/local/lib/python2.4/site-packages/trac/wiki/api.py", line 172, in has_page
    self._update_index()
  File "/usr/local/lib/python2.4/site-packages/trac/wiki/api.py", line 149, in _update_index
    cursor.execute("SELECT DISTINCT name FROM wiki")
  File "/usr/local/lib/python2.4/site-packages/trac/db/util.py", line 51, in execute
    return self.cursor.execute(sql)
  File "/usr/local/lib/python2.4/site-packages/trac/db/util.py", line 51, in execute
    return self.cursor.execute(sql)
  File "build/bdist.linux-i686/egg/MySQLdb/cursors.py", line 166, in execute
  File "build/bdist.linux-i686/egg/MySQLdb/connections.py", line 35, in defaulterrorhandler
InternalError: (126, "Incorrect key file for table '/tmp/#sql_17c3_0.MYI'; try to repair it")

[Christian Boos]

Incorrect key file for table '/tmp/#sql_17c3_0.MYI'; try to repair it

As the error message says… this is a MySQL database problem, which we can not solve for you.

Either:

• upgrade your MySQL software to a more recent / stable version
• migrate to PostgreSQL, which seems to raise less concerns among Trac users