Edgewall Software

Ticket #7454 (new defect)

Opened 3 months ago

Last modified 3 months ago

Query timeouts with PG result in traceback

Reported by: anonymous Owned by:
Priority: normal Milestone: 0.11.3
Component: search system Version: 0.10.5
Severity: minor Keywords: postgres
Cc:

Description (last modified by thatch) (diff)

In trac.adiumx.com search select :tickets, wikis, and changesets; search for "tor" (without the quotes). This is the effect:

If you think this really should work and you can reproduce it, you should consider reporting this problem to the Trac team.

Go to http://trac.edgewall.org/ and create a new ticket where you describe the problem, how to reproduce it. Don't forget to include the Python traceback found below.

TracGuide — The Trac User and Administration Guide Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 406, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.4/site-packages/trac/Search.py", line 181, in process_request
    results += list(source.get_search_results(req, terms, filters))
  File "/usr/lib/python2.4/site-packages/trac/ticket/api.py", line 269, in get_search_results
    args + args2)
  File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
ProgrammingError: canceling statement due to statement timeout

Attachments

Change History

Changed 3 months ago by anonymous

This only seems to happen when searching for tor.

Changed 3 months ago by thatch

  • keywords postgres added
  • version set to 0.10.5
  • component changed from general to search system
  • description modified (diff)
  • summary changed from Search on Adium site failed with ERRORs said to report it here. to Query timeouts with PG result in traceback

This is a db timeout, caused (my guess) by too many results. Adium's Trac is using postgres with a query timeout, and the timeout is doing its job...

Searching for other short sequences which appear often in larger words ("are", for example) results in the same error. Should we handle this and give a prettier error?

Changed 3 months ago by cboos

  • priority changed from high to normal
  • severity changed from major to minor
  • milestone set to 0.11.2

Maybe yes, depends on #6348 then.

Add/Change #7454 (Query timeouts with PG result in traceback)

Author



Change Properties
<Author field>
Action
as new
as The resolution will be set. Next status will be 'closed'
to The owner will change from (none). Next status will be 'new'
The owner will change from (none) to anonymous. Next status will be 'assigned'
 
Note: See TracTickets for help on using tickets.