Opened 4 years ago

Closed 3 years ago

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

Reported by: Owned by: anonymous otaku42 normal TracHacks normal 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
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


comment:1 follow-up: ↓ 2 Changed 4 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 4 years ago by otaku42

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: ↓ 4 Changed 4 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 4 years ago by anonymous

• Resolution worksforme deleted
• Status changed from closed to reopened

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 4 years ago by rjollos

• Trac Release changed from 0.11 to 0.10

comment:6 Changed 3 years 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.