Modify

Opened 5 years ago

Closed 3 years 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: Michael Renzmann
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 Changed 5 years ago by Odd Simon Simonsen

Resolution: worksforme
Status: newclosed

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

comment:2 in reply to:  1 Changed 5 years ago by 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.

comment:3 Changed 5 years ago by Odd Simon Simonsen

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 5 years ago by anonymous

Resolution: worksforme
Status: closedreopened

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 5 years ago by Ryan J Ollos

Trac Release: 0.110.10

comment:6 Changed 3 years ago by Ryan J Ollos

Resolution: fixed
Status: reopenedclosed

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

Modify Ticket

Action
as closed The owner will remain Michael Renzmann.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment


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

 
Note: See TracTickets for help on using tickets.