clicking of link on http://trac-hacks.org/tags gives "SQL logic error or missing database"

[anonymous]

​http://trac-hacks.org/tags has a link "Note: See TracTags for information about using tag expressions". Clicking on it reveals:

Traceback (most recent call last):
  File "/usr/local/lib/python2.4/site-packages/trac/web/standalone.py", line 303, in _do_trac_req
    dispatch_request(path_info, req, env)
  File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line 139, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line 107, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.freebsd-5.5-PRERELEASE-i386/egg/tractags/web_ui.py", line 64, in process_request
  File "/usr/local/lib/python2.4/site-packages/trac/wiki/web_ui.py", line 116, in process_request
    self._render_view(req, db, page)
  File "/usr/local/lib/python2.4/site-packages/trac/wiki/web_ui.py", line 364, in _render_view
    req.hdf['wiki.page_html'] = wiki_to_html(page.text, self.env, req)
  File "/usr/local/lib/python2.4/site-packages/trac/wiki/formatter.py", line 747, 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 599, in format
    result = re.sub(self.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 221, in replace
    return getattr(self, '_' + itype + '_formatter')(match, fullmatch)
  File "/usr/local/lib/python2.4/site-packages/trac/wiki/formatter.py", line 290, in _lhref_formatter
    return self._make_link(ns, target, match, label)
  File "/usr/local/lib/python2.4/site-packages/trac/wiki/formatter.py", line 295, in _make_link
    util.escape(label, False))
  File "/usr/local/lib/python2.4/site-packages/trac/wiki/api.py", line 198, in _format_fancy_link
    return self._format_link(f, n, p, l, False)
  File "/usr/local/lib/python2.4/site-packages/trac/wiki/api.py", line 208, in _format_link
    if not self.has_page(page):
  File "/usr/local/lib/python2.4/site-packages/trac/wiki/api.py", line 121, in has_page
    self._update_index()
  File "/usr/local/lib/python2.4/site-packages/trac/wiki/api.py", line 100, in _update_index
    for (name,) in cursor:
  File "/usr/local/lib/python2.4/site-packages/trac/db.py", line 83, in __iter__
    row = self.cursor.fetchone()
  File "/usr/local/lib/python2.4/site-packages/trac/db.py", line 229, in fetchone
    row = sqlite.Cursor.fetchone(self)
OperationalError: SQL logic error or missing database

[osimons]

Works now. No doubt a temporary db connection error at the site (which is not uncommon, unfortunately).

[Michael Renzmann]

Replying to osimons:

Works now. No doubt a temporary db connection error at the site (which is not uncommon, unfortunately).

Not exactly. I had to restart the server yesterday due to a malfunction. After the server came back up the database container needed another friendly kick in the butt, before things worked nicely again.

[osimons]

OK, so that specific error is perhaps not so common. I suppose it is usually timeout errors that I see at various times throughout the day.

[anonymous]

Replying to osimons:

OK, so that specific error is perhaps not so common. I suppose it is usually timeout errors that I see at various times throughout the day.

No, before I created the ticket I've tried it about 10 times during 3 days. No success at all.

Now it still happens *always*

[Ryan J Ollos]

Seems to be resolved at least since the upgrade. Please reopen if you continue to see issues.