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 owner will remain otaku42.
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.