Modify

Opened 3 years ago

Closed 10 months ago

#9858 closed defect (fixed)

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

Reported by: anonymous Owned by: otaku42
Priority: normal Component: TracHacks
Severity: normal Keywords:
Cc: Trac Release: 0.10

Description

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

Attachments (0)

Change History (6)

comment:1 follow-up: Changed 3 years ago by osimons

  • Resolution set to worksforme
  • Status changed from new to closed

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

comment:2 in reply to: ↑ 1 Changed 3 years ago by otaku42

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.

comment:3 follow-up: Changed 3 years ago by 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.

comment:4 in reply to: ↑ 3 Changed 3 years ago by anonymous

  • Resolution worksforme deleted
  • Status changed from closed to reopened

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*

comment:5 Changed 3 years ago by rjollos

  • Trac Release changed from 0.11 to 0.10

comment:6 Changed 10 months ago by rjollos

  • Resolution set to fixed
  • Status changed from reopened to closed

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

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'reopened'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.